{"TABLE_NAME":"ohrm_course_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_course_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_course_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_course_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_course_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_course_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_course_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_course_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_course_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_course_attachment","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_course_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_session_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_session_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_session_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_session_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_session_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_session_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_session_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_session_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_session_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_session_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_session_attachment","ENGINE":"InnoDB","COLUMN_NAME":"session_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"archived_time","DATA_TYPE":"timestamp","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":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_course","ENGINE":"InnoDB","COLUMN_NAME":"archived_user_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"company","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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"coordinator_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"cost","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_training_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"created_user_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"currency_id","DATA_TYPE":"char","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"3","CHARACTER_OCTET_LENGTH":"9","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"char(3)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_course","ENGINE":"InnoDB","COLUMN_NAME":"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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"duration","DATA_TYPE":"time","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":"time","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"status","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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"subunit_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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"title","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_training_course","ENGINE":"InnoDB","COLUMN_NAME":"version","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"45","CHARACTER_OCTET_LENGTH":"135","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(45)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_course_package","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_training_course_package","ENGINE":"InnoDB","COLUMN_NAME":"package_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_training_course_status","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_training_course_status","ENGINE":"InnoDB","COLUMN_NAME":"name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"45","CHARACTER_OCTET_LENGTH":"135","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(45)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_course_student","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_training_course_student","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":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_package","ENGINE":"InnoDB","COLUMN_NAME":"archived_time","DATA_TYPE":"timestamp","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":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_package","ENGINE":"InnoDB","COLUMN_NAME":"archived_user_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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"code","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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"company","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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"cost","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_training_package","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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"created_user_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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"currency_id","DATA_TYPE":"char","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"3","CHARACTER_OCTET_LENGTH":"9","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"char(3)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_package","ENGINE":"InnoDB","COLUMN_NAME":"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_training_package","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_training_package","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_training_package","ENGINE":"InnoDB","COLUMN_NAME":"status","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_training_package_status","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_training_package_status","ENGINE":"InnoDB","COLUMN_NAME":"name","DATA_TYPE":"varchar","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","CHARACTER_MAXIMUM_LENGTH":"45","CHARACTER_OCTET_LENGTH":"135","NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"CHARACTER_SET_NAME":"utf8","COLLATION_NAME":"utf8_general_ci","COLUMN_TYPE":"varchar(45)","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_package_student","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_training_package_student","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":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_package_student","ENGINE":"InnoDB","COLUMN_NAME":"package_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_training_package_student","ENGINE":"InnoDB","COLUMN_NAME":"status","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_training_package_student_status","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_training_package_student_status","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_training_report","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_training_report","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_training_session","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_training_session","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"created_user_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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"delivery_location","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"delivery_method","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"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_training_session","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"duration","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_training_session","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_training_session","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"scheduled_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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"status","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_training_session","ENGINE":"InnoDB","COLUMN_NAME":"updated_time","DATA_TYPE":"timestamp","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":"timestamp","COLUMN_KEY":"","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_session","ENGINE":"InnoDB","COLUMN_NAME":"updated_user_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_training_session_delivery_method","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_training_session_delivery_method","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_training_session_status","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_training_session_status","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_training_session_student","ENGINE":"InnoDB","COLUMN_NAME":"attend_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_training_session_student","ENGINE":"InnoDB","COLUMN_NAME":"attendance","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(1)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_session_student","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_training_session_student","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":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_session_student","ENGINE":"InnoDB","COLUMN_NAME":"rating","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_training_session_student","ENGINE":"InnoDB","COLUMN_NAME":"score","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_training_session_student","ENGINE":"InnoDB","COLUMN_NAME":"session_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_training_session_student_attendance","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_training_session_student_attendance","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_training_session_student_rating","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_training_session_student_rating","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_training_session_trainer","ENGINE":"InnoDB","COLUMN_NAME":"attend_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_training_session_trainer","ENGINE":"InnoDB","COLUMN_NAME":"attendance","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(1)","COLUMN_KEY":"MUL","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_session_trainer","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_training_session_trainer","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":"PRI","EXTRA":"","IS_VIEW":"0"}
{"TABLE_NAME":"ohrm_training_session_trainer","ENGINE":"InnoDB","COLUMN_NAME":"rating","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_training_session_trainer","ENGINE":"InnoDB","COLUMN_NAME":"session_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_training_session_trainer_attendance","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_training_session_trainer_attendance","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_training_session_trainer_rating","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_training_session_trainer_rating","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"}