{"success":true,"message":"./application/models/tables/ap_data_maintenance_request.js","body":{},"params":{"tbl_name":"ap_data_maintenance_request"},"queries":{},"data":[{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"maintenance_request_id","ORDINAL_POSITION":1,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10) unsigned","COLUMN_KEY":"PRI","EXTRA":"auto_increment","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"equipment_id","ORDINAL_POSITION":2,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10) unsigned","COLUMN_KEY":"MUL","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"driver_id","ORDINAL_POSITION":3,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10) unsigned","COLUMN_KEY":"MUL","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"worker_id","ORDINAL_POSITION":4,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(30) unsigned","COLUMN_KEY":"MUL","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_no","ORDINAL_POSITION":5,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":20,"CHARACTER_OCTET_LENGTH":80,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(20)","COLUMN_KEY":"UNI","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_date","ORDINAL_POSITION":6,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"datetime","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"datetime","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_time","ORDINAL_POSITION":7,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"time","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"time","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_type","ORDINAL_POSITION":8,"COLUMN_DEFAULT":"0","IS_NULLABLE":"NO","DATA_TYPE":"tinyint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":3,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_type_check","ORDINAL_POSITION":9,"COLUMN_DEFAULT":"0","IS_NULLABLE":"YES","DATA_TYPE":"tinyint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":3,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"mileage","ORDINAL_POSITION":10,"COLUMN_DEFAULT":"0","IS_NULLABLE":"NO","DATA_TYPE":"mediumint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":8,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"mediumint(8) unsigned","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"remarks","ORDINAL_POSITION":11,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":5000,"CHARACTER_OCTET_LENGTH":20000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(5000)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"remarks_monitoring","ORDINAL_POSITION":12,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":500,"CHARACTER_OCTET_LENGTH":2000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"note","ORDINAL_POSITION":13,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":500,"CHARACTER_OCTET_LENGTH":2000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"status_id","ORDINAL_POSITION":14,"COLUMN_DEFAULT":"0","IS_NULLABLE":"NO","DATA_TYPE":"tinyint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":3,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4) unsigned","COLUMN_KEY":"MUL","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"ins_timestamp","ORDINAL_POSITION":15,"COLUMN_DEFAULT":"current_timestamp()","IS_NULLABLE":"NO","DATA_TYPE":"timestamp","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"ins_user_id","ORDINAL_POSITION":16,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10) unsigned","COLUMN_KEY":"MUL","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"upd_timestamp","ORDINAL_POSITION":17,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"timestamp","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"upd_user_id","ORDINAL_POSITION":18,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10) unsigned","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"mileage_before","ORDINAL_POSITION":19,"COLUMN_DEFAULT":"0","IS_NULLABLE":"YES","DATA_TYPE":"mediumint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":8,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"mediumint(8) unsigned","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"mileage_maintenance","ORDINAL_POSITION":20,"COLUMN_DEFAULT":"0","IS_NULLABLE":"YES","DATA_TYPE":"mediumint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":8,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"mediumint(8) unsigned","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"schedule_date","ORDINAL_POSITION":21,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"date","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"date","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"schedule_time_from","ORDINAL_POSITION":22,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"time","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"time","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"schedule_time_to","ORDINAL_POSITION":23,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"time","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"time","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"remarks_checker","ORDINAL_POSITION":24,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":5000,"CHARACTER_OCTET_LENGTH":20000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(5000)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"check_timestamp","ORDINAL_POSITION":25,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"timestamp","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"confirm_timestamp","ORDINAL_POSITION":26,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"timestamp","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"check_user_id","ORDINAL_POSITION":27,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"remarks_assign_worker","ORDINAL_POSITION":28,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":500,"CHARACTER_OCTET_LENGTH":2000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"source_type","ORDINAL_POSITION":29,"COLUMN_DEFAULT":"''","IS_NULLABLE":"NO","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":30,"CHARACTER_OCTET_LENGTH":120,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(30)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"maintenance_order_type","ORDINAL_POSITION":30,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":500,"CHARACTER_OCTET_LENGTH":2000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"request_priority","ORDINAL_POSITION":31,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":30,"CHARACTER_OCTET_LENGTH":120,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(30)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"order_type","ORDINAL_POSITION":32,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":50,"CHARACTER_OCTET_LENGTH":200,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(50)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"status_unit","ORDINAL_POSITION":33,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":20,"CHARACTER_OCTET_LENGTH":80,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(20)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"maintenance_inspection_id","ORDINAL_POSITION":34,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(10)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"form_mode","ORDINAL_POSITION":35,"COLUMN_DEFAULT":"'Equipment'","IS_NULLABLE":"NO","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":50,"CHARACTER_OCTET_LENGTH":200,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(50)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"general_title","ORDINAL_POSITION":36,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":500,"CHARACTER_OCTET_LENGTH":2000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"location","ORDINAL_POSITION":37,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":50,"CHARACTER_OCTET_LENGTH":200,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(50)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"location_storing_id","ORDINAL_POSITION":38,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"location_others","ORDINAL_POSITION":39,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":100,"CHARACTER_OCTET_LENGTH":400,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(100)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"classification_accident","ORDINAL_POSITION":40,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":1020,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"classification_unit","ORDINAL_POSITION":41,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":1020,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"accident_date","ORDINAL_POSITION":42,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"datetime","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"datetime","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"accident_time","ORDINAL_POSITION":43,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"time","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"time","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"accident_location","ORDINAL_POSITION":44,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":1020,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"chronology","ORDINAL_POSITION":45,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":1000,"CHARACTER_OCTET_LENGTH":4000,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_maintenance_request","COLUMN_NAME":"location_storing","ORDINAL_POSITION":46,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":1020,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null}]}