{"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#archived_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_archived_user","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"archived_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#coordinator_id#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_training_course_coordinator","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"coordinator_id","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#created_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_created_user","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"created_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#currency_id#VALUE_SEPARATOR#hs_hr_currency_type#VALUE_SEPARATOR#currency_id","CONSTRAINT_NAME":"ohrm_training_course_currency","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"currency_id","REFERENCED_TABLE_NAME":"hs_hr_currency_type","REFERENCED_COLUMN_NAME":"currency_id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#status#VALUE_SEPARATOR#ohrm_training_course_status#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_status","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"status","REFERENCED_TABLE_NAME":"ohrm_training_course_status","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course#VALUE_SEPARATOR#subunit_id#VALUE_SEPARATOR#ohrm_subunit#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_subunit","TABLE_NAME":"ohrm_training_course","COLUMN_NAME":"subunit_id","REFERENCED_TABLE_NAME":"ohrm_subunit","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course_package#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_training_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_package_course_id","TABLE_NAME":"ohrm_training_course_package","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_training_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course_package#VALUE_SEPARATOR#package_id#VALUE_SEPARATOR#ohrm_training_package#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_package_package","TABLE_NAME":"ohrm_training_course_package","COLUMN_NAME":"package_id","REFERENCED_TABLE_NAME":"ohrm_training_package","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course_student#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_training_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_course_student_course_id","TABLE_NAME":"ohrm_training_course_student","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_training_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_course_student#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_training_course_student_emp_number","TABLE_NAME":"ohrm_training_course_student","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_package#VALUE_SEPARATOR#archived_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_package_archived_user","TABLE_NAME":"ohrm_training_package","COLUMN_NAME":"archived_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_package#VALUE_SEPARATOR#created_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_package_created_user","TABLE_NAME":"ohrm_training_package","COLUMN_NAME":"created_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_package_student#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_training_package_student_course_id","TABLE_NAME":"ohrm_training_package_student","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_package_student#VALUE_SEPARATOR#package_id#VALUE_SEPARATOR#ohrm_training_package#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_package_student_package","TABLE_NAME":"ohrm_training_package_student","COLUMN_NAME":"package_id","REFERENCED_TABLE_NAME":"ohrm_training_package","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_package_student#VALUE_SEPARATOR#status#VALUE_SEPARATOR#ohrm_training_package_student_status#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_package_student_status","TABLE_NAME":"ohrm_training_package_student","COLUMN_NAME":"status","REFERENCED_TABLE_NAME":"ohrm_training_package_student_status","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session#VALUE_SEPARATOR#course_id#VALUE_SEPARATOR#ohrm_training_course#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_course","TABLE_NAME":"ohrm_training_session","COLUMN_NAME":"course_id","REFERENCED_TABLE_NAME":"ohrm_training_course","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session#VALUE_SEPARATOR#created_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_created_user","TABLE_NAME":"ohrm_training_session","COLUMN_NAME":"created_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session#VALUE_SEPARATOR#delivery_method#VALUE_SEPARATOR#ohrm_training_session_delivery_method#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_delivery_method","TABLE_NAME":"ohrm_training_session","COLUMN_NAME":"delivery_method","REFERENCED_TABLE_NAME":"ohrm_training_session_delivery_method","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session#VALUE_SEPARATOR#status#VALUE_SEPARATOR#ohrm_training_session_status#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_status","TABLE_NAME":"ohrm_training_session","COLUMN_NAME":"status","REFERENCED_TABLE_NAME":"ohrm_training_session_status","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session#VALUE_SEPARATOR#updated_user_id#VALUE_SEPARATOR#ohrm_user#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_updated_user","TABLE_NAME":"ohrm_training_session","COLUMN_NAME":"updated_user_id","REFERENCED_TABLE_NAME":"ohrm_user","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_student#VALUE_SEPARATOR#attendance#VALUE_SEPARATOR#ohrm_training_session_student_attendance#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_student_attendance","TABLE_NAME":"ohrm_training_session_student","COLUMN_NAME":"attendance","REFERENCED_TABLE_NAME":"ohrm_training_session_student_attendance","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_student#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_training_session_student_employee","TABLE_NAME":"ohrm_training_session_student","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_student#VALUE_SEPARATOR#rating#VALUE_SEPARATOR#ohrm_training_session_student_rating#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_student_rating","TABLE_NAME":"ohrm_training_session_student","COLUMN_NAME":"rating","REFERENCED_TABLE_NAME":"ohrm_training_session_student_rating","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_student#VALUE_SEPARATOR#session_id#VALUE_SEPARATOR#ohrm_training_session#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_student_session","TABLE_NAME":"ohrm_training_session_student","COLUMN_NAME":"session_id","REFERENCED_TABLE_NAME":"ohrm_training_session","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_trainer#VALUE_SEPARATOR#attendance#VALUE_SEPARATOR#ohrm_training_session_trainer_attendance#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_trainer_attendance","TABLE_NAME":"ohrm_training_session_trainer","COLUMN_NAME":"attendance","REFERENCED_TABLE_NAME":"ohrm_training_session_trainer_attendance","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_trainer#VALUE_SEPARATOR#emp_number#VALUE_SEPARATOR#hs_hr_employee#VALUE_SEPARATOR#emp_number","CONSTRAINT_NAME":"ohrm_training_session_trainer_employee","TABLE_NAME":"ohrm_training_session_trainer","COLUMN_NAME":"emp_number","REFERENCED_TABLE_NAME":"hs_hr_employee","REFERENCED_COLUMN_NAME":"emp_number","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_trainer#VALUE_SEPARATOR#rating#VALUE_SEPARATOR#ohrm_training_session_trainer_rating#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_trainer_rating","TABLE_NAME":"ohrm_training_session_trainer","COLUMN_NAME":"rating","REFERENCED_TABLE_NAME":"ohrm_training_session_trainer_rating","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"} {"CONSTRAINT_KEY":"ohrm_training_session_trainer#VALUE_SEPARATOR#session_id#VALUE_SEPARATOR#ohrm_training_session#VALUE_SEPARATOR#id","CONSTRAINT_NAME":"ohrm_training_session_trainer_session","TABLE_NAME":"ohrm_training_session_trainer","COLUMN_NAME":"session_id","REFERENCED_TABLE_NAME":"ohrm_training_session","REFERENCED_COLUMN_NAME":"id","UPDATE_RULE":"CASCADE","DELETE_RULE":"CASCADE"}