{"TABLE_NAME":"ohrm_audittrail_online_training_approver_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_online_training_approver_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_online_training_approver_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_online_training_approver_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_approver_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_online_training_approver_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_online_training_approver_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_approver_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_approver_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_approver_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_online_training_approver_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_approver_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_online_training_assessment_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_online_training_assessment_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_online_training_assessment_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_online_training_assessment_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_assessment_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_online_training_assessment_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_online_training_assessment_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_assessment_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_assessment_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_assessment_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_online_training_assessment_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_assessment_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_online_training_course_detail_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_online_training_course_detail_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_online_training_course_detail_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_online_training_course_detail_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_course_detail_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_online_training_course_detail_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_online_training_course_detail_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_course_detail_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_course_detail_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_course_detail_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_online_training_course_detail_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_course_detail_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_online_training_course_employee_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_online_training_course_employee_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_online_training_course_employee_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_online_training_course_employee_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_course_employee_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_online_training_course_employee_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_online_training_course_employee_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_course_employee_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_course_employee_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_course_employee_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_online_training_course_employee_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_course_employee_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_online_training_my_course_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_online_training_my_course_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_online_training_my_course_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_online_training_my_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_my_course_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_online_training_my_course_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_online_training_my_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_my_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_my_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_my_course_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_online_training_my_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_my_course_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_online_training_resource_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_online_training_resource_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_online_training_resource_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_online_training_resource_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_resource_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_online_training_resource_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_online_training_resource_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_resource_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_resource_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_resource_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_online_training_resource_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_resource_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_online_training_reviewer_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_online_training_reviewer_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_online_training_reviewer_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_online_training_reviewer_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_owner_name","DATA_TYPE":"varchar","IS_NULLABLE":"NO","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_online_training_reviewer_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_online_training_reviewer_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_online_training_reviewer_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_name","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_online_training_reviewer_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_online_training_reviewer_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_reviewer_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_online_training_reviewer_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_online_training_reviewer_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_training_online_course_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_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"action_description","DATA_TYPE":"mediumtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"16777215","CHARACTER_OCTET_LENGTH":"16777215","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"mediumtext","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_training_online_course_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_training_online_course_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_training_online_course_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_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"affected_entity_id","DATA_TYPE":"varchar","IS_NULLABLE":"NO","COLUMN_DEFAULT":"''","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_training_online_course_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_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_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_audittrail_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"app_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_training_online_course_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_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"ip_address","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_audittrail_training_online_course_trail","ENGINE":"InnoDB","COLUMN_NAME":"screen_name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_audittrail_training_online_course_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_employee_job_role","ENGINE":"InnoDB","COLUMN_NAME":"employee_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(4)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_employee_job_role","ENGINE":"InnoDB","COLUMN_NAME":"jobrole_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(4)","COLUMN_KEY":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"added_by","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"350","CHARACTER_OCTET_LENGTH":"1050","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(350)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"attempts","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(7)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","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_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"is_random_question_enabled","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_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"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_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"pass_grade","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"10","CHARACTER_OCTET_LENGTH":"30","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"question_form_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_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"random_question_limit","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(7)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"time_limit_type","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"10","CHARACTER_OCTET_LENGTH":"30","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_assessment","ENGINE":"InnoDB","COLUMN_NAME":"time_limit_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"'0'","CHARACTER_MAXIMUM_LENGTH":"10","CHARACTER_OCTET_LENGTH":"30","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"added_by","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"350","CHARACTER_OCTET_LENGTH":"1050","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(350)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"approval_required","DATA_TYPE":"tinyint","IS_NULLABLE":"YES","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"assessment_required","DATA_TYPE":"tinyint","IS_NULLABLE":"YES","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"created_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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"duration_type","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"10","CHARACTER_OCTET_LENGTH":"30","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"duration_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"30","CHARACTER_OCTET_LENGTH":"90","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(30)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"is_deleted","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(2)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"is_expired","DATA_TYPE":"tinyint","IS_NULLABLE":"YES","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"name","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"resource_acknowledgement_required","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_online_course","ENGINE":"InnoDB","COLUMN_NAME":"validity_length_type","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"10","CHARACTER_OCTET_LENGTH":"30","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"validity_length_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"30","CHARACTER_OCTET_LENGTH":"90","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(30)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course","ENGINE":"InnoDB","COLUMN_NAME":"video_id","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_online_course","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_online_course_assessment","ENGINE":"InnoDB","COLUMN_NAME":"assessment_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_online_course_assessment","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_certificate","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_online_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"body","DATA_TYPE":"mediumtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"16777215","CHARACTER_OCTET_LENGTH":"16777215","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"mediumtext","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_certificate_template","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"is_disabled","DATA_TYPE":"smallint","IS_NULLABLE":"YES","COLUMN_DEFAULT":"0","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"5","NUMERIC_SCALE":"0","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"smallint(6)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"margin_bottom","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"margin_left","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"margin_right","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"margin_top","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"name","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"page_orientation","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"page_size","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"processor_class","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_online_course_certificate_template","ENGINE":"InnoDB","COLUMN_NAME":"style_sheet","DATA_TYPE":"mediumtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"16777215","CHARACTER_OCTET_LENGTH":"16777215","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"mediumtext","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_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_online_course_custom_field_value","ENGINE":"InnoDB","COLUMN_NAME":"custom_field_value","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"assign_notification_sent","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(4)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"assigned_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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"completion_date_time","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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"due_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_online_course_employee","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_online_course_employee","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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"is_deleted","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(2)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"pass_mark","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_online_course_employee","ENGINE":"InnoDB","COLUMN_NAME":"status","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_online_course_job_title","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_job_title","ENGINE":"InnoDB","COLUMN_NAME":"job_title_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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"1000","CHARACTER_OCTET_LENGTH":"3000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(1000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_course_link","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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"link_id","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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"name","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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"resource_order","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_online_course_link","ENGINE":"InnoDB","COLUMN_NAME":"type","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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"acknowledged","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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"acknowledged_at","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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"assessment_acknowledged","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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"assessment_acknowledged_at","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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"comment","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_online_course_link_acknowledgement_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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"process_actor_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_online_course_link_acknowledgement_comment","ENGINE":"InnoDB","COLUMN_NAME":"submitted","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_online_course_location","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_location","ENGINE":"InnoDB","COLUMN_NAME":"location_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_online_course_subunit","ENGINE":"InnoDB","COLUMN_NAME":"course_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_online_course_subunit","ENGINE":"InnoDB","COLUMN_NAME":"sub_unit_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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"certificate_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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"course_emp_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_online_employee_course_certificate","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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"expiry_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_online_employee_course_certificate","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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"is_valid","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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"issued_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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"template_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_online_employee_course_certificate","ENGINE":"InnoDB","COLUMN_NAME":"trainee_assessment_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_online_trainee_answer","ENGINE":"InnoDB","COLUMN_NAME":"answer_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_online_trainee_answer","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_online_trainee_answer","ENGINE":"InnoDB","COLUMN_NAME":"trainee_assessment_attempt_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_online_trainee_assessment","ENGINE":"InnoDB","COLUMN_NAME":"assessment_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_online_trainee_assessment","ENGINE":"InnoDB","COLUMN_NAME":"course_emp_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_online_trainee_assessment","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_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"attempt","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_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"completed_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_online_trainee_assessment_attempt","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_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"is_ongoing","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(2)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"is_passed","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(7)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"result","DATA_TYPE":"decimal","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":"6","NUMERIC_SCALE":"2","CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"decimal(6,2)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_online_trainee_assessment_attempt","ENGINE":"InnoDB","COLUMN_NAME":"trainee_assessment_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_online_trainee_course_link_view_acknowledgement","ENGINE":"InnoDB","COLUMN_NAME":"course_emp_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_online_trainee_course_link_view_acknowledgement","ENGINE":"InnoDB","COLUMN_NAME":"course_link_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_online_trainee_course_link_view_acknowledgement","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_online_trainee_course_link_view_acknowledgement","ENGINE":"InnoDB","COLUMN_NAME":"view_acknowledged_at","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_online_trainee_course_link_view_acknowledgement","ENGINE":"InnoDB","COLUMN_NAME":"viewed_at","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_email_queue","ENGINE":"InnoDB","COLUMN_NAME":"sender_name","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_question","ENGINE":"InnoDB","COLUMN_NAME":"question_description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"4000","CHARACTER_OCTET_LENGTH":"12000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(4000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_question_form_question","ENGINE":"InnoDB","COLUMN_NAME":"question_description","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"4000","CHARACTER_OCTET_LENGTH":"12000","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(4000)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}