{"CONSTRAINT_KEY":"ohrm_online_assessment#VALUE_SEPARATOR#question_form_id#VALUE_SEPARATOR#ohrm_question_form#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_assessment_ibfk_1","TABLE_NAME":"ohrm_online_assessment","COLUMN_NAME":"question_form_id","REFERENCED_TABLE_NAME":"ohrm_question_form","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_course#VALUE_SEPARATOR#workflow_request_id#VALUE_SEPARATOR#ohrm_advanced_workflow_request#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_ibfk1","TABLE_NAME":"ohrm_online_course","COLUMN_NAME":"workflow_request_id","REFERENCED_TABLE_NAME":"ohrm_advanced_workflow_request","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_course_assessment#VALUE_SEPARATOR#assessment_id#VALUE_SEPARATOR#ohrm_online_assessment#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_assessment_ibfk_2","TABLE_NAME":"ohrm_online_course_assessment","COLUMN_NAME":"assessment_id","REFERENCED_TABLE_NAME":"ohrm_online_assessment","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_assessment#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_assessment_ibfk_1","TABLE_NAME":"ohrm_online_course_assessment","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_certificate#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_certificate_ibfk_1","TABLE_NAME":"ohrm_online_course_certificate","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_custom_field_value#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_custom_field_value_ibfk_1","TABLE_NAME":"ohrm_online_course_custom_field_value","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_custom_field_value#VALUE_SEPARATOR#custom_field_id#VALUE_SEPARATOR#ohrm_custom_field#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_custom_field_value_ibfk_2","TABLE_NAME":"ohrm_online_course_custom_field_value","COLUMN_NAME":"custom_field_id","REFERENCED_TABLE_NAME":"ohrm_custom_field","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_employee#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_employee_ibfk_1","TABLE_NAME":"ohrm_online_course_employee","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_employee#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_online_course_employee_ibfk_2","TABLE_NAME":"ohrm_online_course_employee","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_job_title#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_job_title_ibfk_1","TABLE_NAME":"ohrm_online_course_job_title","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_job_title#VALUE_SEPARATOR#job_title_id#VALUE_SEPARATOR#ohrm_job_title#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_job_title_ibfk_2","TABLE_NAME":"ohrm_online_course_job_title","COLUMN_NAME":"job_title_id","REFERENCED_TABLE_NAME":"ohrm_job_title","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_link#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_link_ibfk_1","TABLE_NAME":"ohrm_online_course_link","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_link_acknowledgement_comment#VALUE_SEPARATOR#process_actor_id#VALUE_SEPARATOR#ohrm_advanced_workflow_request_process_actor#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"online_course_link_ack_actor_id_fk","TABLE_NAME":"ohrm_online_course_link_acknowledgement_comment","COLUMN_NAME":"process_actor_id","REFERENCED_TABLE_NAME":"ohrm_advanced_workflow_request_process_actor","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_location#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_location_ibfk_1","TABLE_NAME":"ohrm_online_course_location","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_location#VALUE_SEPARATOR#location_id#VALUE_SEPARATOR#ohrm_location#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_location_ibfk_2","TABLE_NAME":"ohrm_online_course_location","COLUMN_NAME":"location_id","REFERENCED_TABLE_NAME":"ohrm_location","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_subunit#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_online_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_subunit_ibfk_1","TABLE_NAME":"ohrm_online_course_subunit","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_online_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_course_subunit#VALUE_SEPARATOR#sub_unit_id#VALUE_SEPARATOR#ohrm_subunit#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_course_subunit_ibfk_2","TABLE_NAME":"ohrm_online_course_subunit","COLUMN_NAME":"sub_unit_id","REFERENCED_TABLE_NAME":"ohrm_subunit","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_employee_course_certificate#VALUE_SEPARATOR#certificate_id#VALUE_SEPARATOR#ohrm_online_course_certificate#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_employee_course_certificate_ibfk_2","TABLE_NAME":"ohrm_online_employee_course_certificate","COLUMN_NAME":"certificate_id","REFERENCED_TABLE_NAME":"ohrm_online_course_certificate","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_employee_course_certificate#VALUE_SEPARATOR#course_emp_id#VALUE_SEPARATOR#ohrm_online_course_employee#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_employee_course_certificate_ibfk_4","TABLE_NAME":"ohrm_online_employee_course_certificate","COLUMN_NAME":"course_emp_id","REFERENCED_TABLE_NAME":"ohrm_online_course_employee","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_employee_course_certificate#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_online_employee_course_certificate_ibfk_1","TABLE_NAME":"ohrm_online_employee_course_certificate","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_employee_course_certificate#VALUE_SEPARATOR#template_id#VALUE_SEPARATOR#ohrm_online_course_certificate_template#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_employee_course_certificate_ibfk_5","TABLE_NAME":"ohrm_online_employee_course_certificate","COLUMN_NAME":"template_id","REFERENCED_TABLE_NAME":"ohrm_online_course_certificate_template","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_employee_course_certificate#VALUE_SEPARATOR#trainee_assessment_id#VALUE_SEPARATOR#ohrm_online_trainee_assessment#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_employee_course_certificate_ibfk_3","TABLE_NAME":"ohrm_online_employee_course_certificate","COLUMN_NAME":"trainee_assessment_id","REFERENCED_TABLE_NAME":"ohrm_online_trainee_assessment","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_answer#VALUE_SEPARATOR#answer_id#VALUE_SEPARATOR#ohrm_answer#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_trainee_answer_ibfk_1","TABLE_NAME":"ohrm_online_trainee_answer","COLUMN_NAME":"answer_id","REFERENCED_TABLE_NAME":"ohrm_answer","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_answer#VALUE_SEPARATOR#trainee_assessment_attempt_id#VALUE_SEPARATOR#ohrm_online_trainee_assessment_attempt#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_trainee_answer_ibfk_2","TABLE_NAME":"ohrm_online_trainee_answer","COLUMN_NAME":"trainee_assessment_attempt_id","REFERENCED_TABLE_NAME":"ohrm_online_trainee_assessment_attempt","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_assessment#VALUE_SEPARATOR#assessment_id#VALUE_SEPARATOR#ohrm_online_assessment#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_trainee_assessment_ibfk_1","TABLE_NAME":"ohrm_online_trainee_assessment","COLUMN_NAME":"assessment_id","REFERENCED_TABLE_NAME":"ohrm_online_assessment","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_assessment#VALUE_SEPARATOR#course_emp_id#VALUE_SEPARATOR#ohrm_online_course_employee#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_trainee_assessment_ibfk_2","TABLE_NAME":"ohrm_online_trainee_assessment","COLUMN_NAME":"course_emp_id","REFERENCED_TABLE_NAME":"ohrm_online_course_employee","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"SET NULL"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_assessment_attempt#VALUE_SEPARATOR#trainee_assessment_id#VALUE_SEPARATOR#ohrm_online_trainee_assessment#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_online_trainee_assessment_attempt_ibfk_1","TABLE_NAME":"ohrm_online_trainee_assessment_attempt","COLUMN_NAME":"trainee_assessment_id","REFERENCED_TABLE_NAME":"ohrm_online_trainee_assessment","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"RESTRICT","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_course_link_view_acknowledgement#VALUE_SEPARATOR#course_emp_id#VALUE_SEPARATOR#ohrm_online_course_employee#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"trainee_course_link_view_ack_course_emp_id_fk","TABLE_NAME":"ohrm_online_trainee_course_link_view_acknowledgement","COLUMN_NAME":"course_emp_id","REFERENCED_TABLE_NAME":"ohrm_online_course_employee","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"}
{"CONSTRAINT_KEY":"ohrm_online_trainee_course_link_view_acknowledgement#VALUE_SEPARATOR#course_link_id#VALUE_SEPARATOR#ohrm_online_course_link#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"trainee_course_link_view_ack_course_link_id_fk","TABLE_NAME":"ohrm_online_trainee_course_link_view_acknowledgement","COLUMN_NAME":"course_link_id","REFERENCED_TABLE_NAME":"ohrm_online_course_link","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"}