{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"archived","DATA_TYPE":"tinyint","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(1)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6000","CHARACTER_OCTET_LENGTH":"18000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"emp_number","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"extra_details","DATA_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"65535","CHARACTER_OCTET_LENGTH":"65535","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"text","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"modified_date","DATA_TYPE":"datetime","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"datetime","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"owner_id","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"pending_with_employee_id","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"priority","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(2)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"request_type_id","DATA_TYPE":"bigint","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"19","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"bigint(20)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"resolution","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6000","CHARACTER_OCTET_LENGTH":"18000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"resolution_date","DATA_TYPE":"date","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"date","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"submitted_date","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"title","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"500","CHARACTER_OCTET_LENGTH":"1500","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(500)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request","ENGINE":"InnoDB","COLUMN_NAME":"workflow_request_id","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_attachment","DATA_TYPE":"longblob","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"4294967295","CHARACTER_OCTET_LENGTH":"4294967295","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"longblob","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_desc","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"200","CHARACTER_OCTET_LENGTH":"600","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(200)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_filename","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_id","DATA_TYPE":"bigint","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"19","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"bigint(20)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_size","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attach_type","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"200","CHARACTER_OCTET_LENGTH":"600","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(200)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attached_by","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attached_by_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"200","CHARACTER_OCTET_LENGTH":"600","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(200)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"attached_time","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"request_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_attachment","ENGINE":"InnoDB","COLUMN_NAME":"screen","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"100","CHARACTER_OCTET_LENGTH":"300","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(100)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"comment","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6000","CHARACTER_OCTET_LENGTH":"18000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"created_date","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"emp_number","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"is_private","DATA_TYPE":"tinyint","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(1)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"modified_by","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"modified_date","DATA_TYPE":"datetime","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"datetime","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"request_id","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_comment","ENGINE":"InnoDB","COLUMN_NAME":"visible_to","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"150","CHARACTER_OCTET_LENGTH":"450","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(150)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"content","DATA_TYPE":"longblob","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"4294967295","CHARACTER_OCTET_LENGTH":"4294967295","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"longblob","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"custom_field_value_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"file_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"file_size","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"file_type","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_attachment","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"custom_field_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"date_value","DATA_TYPE":"date","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"date","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"number_value","DATA_TYPE":"double","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"22","NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"request_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"sequence_number","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"string_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"text_value","DATA_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"65535","CHARACTER_OCTET_LENGTH":"65535","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"text","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"value_type","DATA_TYPE":"tinyint","IS_NULLABLE":"NO","COLUMN_DEFAULT":"1","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"version","DATA_TYPE":"bigint","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"19","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"bigint(20)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"custom_field_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"date_value","DATA_TYPE":"date","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"date","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"number_value","DATA_TYPE":"double","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"22","NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"request_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"sequence_number","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"string_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"text_value","DATA_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"65535","CHARACTER_OCTET_LENGTH":"65535","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"text","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"value_type","DATA_TYPE":"tinyint","IS_NULLABLE":"NO","COLUMN_DEFAULT":"1","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_request_custom_field_value_history","ENGINE":"InnoDB","COLUMN_NAME":"version","DATA_TYPE":"bigint","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"19","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"bigint(20)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"allow_multiple","DATA_TYPE":"tinyint","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(1)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"display_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"entity","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"id_field","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_advance_type_map","ENGINE":"InnoDB","COLUMN_NAME":"name_field","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_field_display_condition","ENGINE":"InnoDB","COLUMN_NAME":"customfieldid","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_field_display_condition","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_field_display_condition","ENGINE":"InnoDB","COLUMN_NAME":"parentcustomfieldId","DATA_TYPE":"int","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_field_display_condition","ENGINE":"InnoDB","COLUMN_NAME":"parentcustomfieldvalue","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_vas_custom_field_display_condition","ENGINE":"InnoDB","COLUMN_NAME":"required","DATA_TYPE":"tinyint","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"3","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"tinyint(4)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"action","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"3000","CHARACTER_OCTET_LENGTH":"9000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(3000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6","CHARACTER_OCTET_LENGTH":"18","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_time","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"20","CHARACTER_OCTET_LENGTH":"60","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(20)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":"''","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_custom_field_trail","ENGINE":"InnoDB","COLUMN_NAME":"version_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"action","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_description","DATA_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"65535","CHARACTER_OCTET_LENGTH":"65535","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"text","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6","CHARACTER_OCTET_LENGTH":"18","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_time","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"20","CHARACTER_OCTET_LENGTH":"60","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(20)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":"''","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_details_trail","ENGINE":"InnoDB","COLUMN_NAME":"version_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"action","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":"255","CHARACTER_OCTET_LENGTH":"765","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"action_description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"3000","CHARACTER_OCTET_LENGTH":"9000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(3000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"6","CHARACTER_OCTET_LENGTH":"18","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(6)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"action_time","DATA_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_id","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"20","CHARACTER_OCTET_LENGTH":"60","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(20)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":"''","CHARACTER_MAXIMUM_LENGTH":"300","CHARACTER_OCTET_LENGTH":"900","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(300)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_request_types","ENGINE":"InnoDB","COLUMN_NAME":"version_id","DATA_TYPE":"int","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"10","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}