186 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_tbl_holidayallocationdetailshistory_holidayallocationdetails |
|
|
Restrict delete | ||
| fk_tbl_holidayallocationdetailshistory_holidayid |
|
|
Restrict delete | ||
| fk__tbl_pmskr__pmsgo__673f7ccf |
|
|
Restrict delete | ||
| fk_tbl_financialyear_tbl_financialyear |
|
|
Restrict delete | ||
| fk_employee_sbu |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicyconfig_leavecodeid |
|
|
Restrict delete | ||
| fk__tbl_inact__emplo__338937f1 |
|
|
Restrict delete | ||
| fk_tbl_employeebankdetailhistory_employeeid |
|
|
Restrict delete | ||
| fk_tbl_geofencingrulenotification_geofencingruleid |
|
|
Restrict delete | ||
| fk_tbl_geofencingrulenotification_employeeid |
|
|
Restrict delete | ||
| fk__tbl_emplo__lette__61a69f0a |
|
|
Restrict delete | ||
| fk_tbl_employeereferenceshistory |
|
|
Restrict delete | ||
| fk__tbl_userro__ulid__54752a70 |
|
|
Restrict delete | ||
| fk__tbl_userr__rolei__53810637 |
|
|
Restrict delete | ||
| fk_tds_employee |
|
|
Restrict delete | ||
| fk__tbl_emplo__equal__3a1639ef |
|
|
Restrict delete | ||
| fk_tbl_employeelocation_statusby |
|
|
Restrict delete | ||
| fk_tbl_employeelocation_employeeid |
|
|
Restrict delete | ||
| fk_leave_employee |
|
|
Restrict delete | ||
| fk_tbl_bankaccountallocation_bankaccountmasterid |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_employeeid |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_statusby |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_department |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_reportingperson2 |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_subcategory |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_reportingperson1 |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_companyid |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_branch |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_subdepartment |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_fromposition |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_sbuid |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_category |
|
|
Restrict delete | ||
| fk_tbl_transferrequisitionmaster_state |
|
|
Restrict delete | ||
| fk_ao_employee |
|
|
Restrict delete | ||
| fk_tbl_regenerateapplicablecriteria_employeeid |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicycounton_leavecodepolicyid |
|
|
Restrict delete | ||
| fk__tbl_emplo__eexpe__3645a90b |
|
|
Restrict delete | ||
| fk_tbl_bankaccountallocationhistory_bankaccountmasterhistoryid |
|
|
Restrict delete | ||
| fk_tbl_bankaccountallocationhistory_bankaccountmasterid |
|
|
Restrict delete | ||
| fknnossp3hywub4wrty44i1sb9b |
|
|
Restrict delete | ||
| fkcjorgrjn0ntyg8xgoigijjepg |
|
|
Restrict delete | ||
| fk_dt_employee |
|
|
Restrict delete | ||
| fk_tbl_leaveapplicationline_leaveapplicationid |
|
|
Restrict delete | ||
| fk_tbl_resignationclearanceemployee_departmentid |
|
|
Restrict delete | ||
| fk_tbl_resignationclearanceemployee_rclearanceid |
|
|
Restrict delete | ||
| fk_tbl_bankaccountmaster_bankmasterid |
|
|
Restrict delete | ||
| fk_tbl_employeecontactinfohistory_employeeid |
|
|
Restrict delete | ||
| fk__tbl_email__compa__6693daab |
|
|
Restrict delete | ||
| fk_tdssectiontitle_sectionid |
|
|
Restrict delete | ||
| fk__tbl_syste__cmpid__5751971b |
|
|
Restrict delete | ||
| fk_tbl_templeavedetail_leaveapplicationid |
|
|
Restrict delete | ||
| fk_employeetdsdeclarations_employeetdsmasterid |
|
|
Restrict delete | ||
| fk_employeetdsdeclarations_tdssectiontitleid |
|
|
Restrict delete | ||
| fk_tbl_employeecertificationhistory |
|
|
Restrict delete | ||
| tbl_chapter_course_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_candidate_offer_offer_id |
|
|
Restrict delete | ||
| fk_tbl_teamtransfer_statusby |
|
|
Restrict delete | ||
| fk_tbl_teamtransfer_employeeid |
|
|
Restrict delete | ||
| fk_tbl_teamtransfer_companyid |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicyemployeemapping_employeeid |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicyemployeemapping_leavecodepolicyid |
|
|
Restrict delete | ||
| tbl_option_question_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_employeegeofencingrule_geofencingruleid |
|
|
Restrict delete | ||
| fk_tbl_employeegeofencingrule_employeeid |
|
|
Restrict delete | ||
| fk__tbl_depar__cmpid__5c164c38 |
|
|
Restrict delete | ||
| tbl_okr_training_category_id_fkey |
|
|
Cascade on delete | ||
| fk__tbl_state__compa__5939df8d |
|
|
Restrict delete | ||
| fk__tbl_times__times__04ce4908 |
|
|
Restrict delete | ||
| fk__tbl_times__times__05c26d41 |
|
|
Restrict delete | ||
| fk__tbl_emplo__elang__31eb0842 |
|
|
Restrict delete | ||
| tbl_assessment_chapter_id_fkey |
|
|
Cascade on delete | ||
| fk_pms_goal_list_id |
|
|
Restrict delete | ||
| fk__tbl_holid__sbuid__62c349c7 |
|
|
Restrict delete | ||
| fk__tbl_holid__state__63b76e00 |
|
|
Restrict delete | ||
| companyid_fk |
|
|
Restrict delete | ||
| fk_probratingmasterpms_pms_goal_list_id |
|
|
Restrict delete | ||
| fk_tbl_vendorbankaccountmasterhistory_vendorbankaccountmasterid |
|
|
Restrict delete | ||
| fk_tbl_vendorbankaccountmasterhistory_bankmasterid |
|
|
Restrict delete | ||
| fk_tbl_overtimepolicyemployeemapping_employeeid |
|
|
Restrict delete | ||
| fk_tbl_overtimepolicyemployeemapping_overtimepolicyid |
|
|
Restrict delete | ||
| fk_pmsgoallist_pms_goal_list_id |
|
|
Restrict delete | ||
| fk_pmsgoallist_next_pms_goal_list_id |
|
|
Restrict delete | ||
| fk_eh_employee |
|
|
Restrict delete | ||
| fk_tbl_employeeguarantorshistory |
|
|
Restrict delete | ||
| fk__tbl_times__times__7e214b79 |
|
|
Restrict delete | ||
| fk_employeetdsdeclarationdocuments_tdssectiontitleid |
|
|
Restrict delete | ||
| fk_employeetdsdeclarationdocuments_declarationid |
|
|
Restrict delete | ||
| fk_employeetdsdeclarationdocuments_employeetdsmasterid |
|
|
Restrict delete | ||
| fk__tbl_emplo__eimmi__3002bfd0 |
|
|
Restrict delete | ||
| tbl_enrollment_course_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_aboutyourself_employeeid |
|
|
Restrict delete | ||
| fk_review_id |
|
|
Null on delete | ||
| fk_ut_employee |
|
|
Restrict delete | ||
| fk_tbl_holidayemployeemapping_employeeid |
|
|
Restrict delete | ||
| fk_tbl_holidayemployeemapping_holidayallocationid |
|
|
Restrict delete | ||
| fk_tbl_holidayemployeemapping_holidayid |
|
|
Restrict delete | ||
| fk_tbl_geofencingrulelocations_geofencingruleid |
|
|
Restrict delete | ||
| fk_tbl_geofencingrulelocations_employeelocationid |
|
|
Restrict delete | ||
| tbl_assessment_attempt_assessment_id_fkey |
|
|
Cascade on delete | ||
| fk__tbl_userl__rolei__50a4998c |
|
|
Restrict delete | ||
| fk__tbl_userl__login__4bdfe46f |
|
|
Restrict delete | ||
| fk_fe_employee |
|
|
Restrict delete | ||
| fk_tbl_paymentsystembatch_fromaccountid |
|
|
Restrict delete | ||
| tbl_answer_question_id_fkey |
|
|
Cascade on delete | ||
| tbl_answer_attempt_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_vendorbankaccountmaster_bankmasterid |
|
|
Restrict delete | ||
| companyid_fkhm |
|
|
Restrict delete | ||
| fk__tbl_holid__holid__64ab9239 |
|
|
Restrict delete | ||
| fk_tbl_holidayallocationdetails_holidayid |
|
|
Restrict delete | ||
| fk_tbl_paymentbankbatch_paymentsystembatchid |
|
|
Restrict delete | ||
| fk_tbl_paymentsystembankchildbatch_paymentsystembatchid |
|
|
Restrict delete | ||
| fk_tbl_paymentsystembankchildbatch_paymentbankbatchid |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicymonthlyconfig_leavecodepolicyid |
|
|
Restrict delete | ||
| fk__tbl_pms_c__pms_c__000b2a99 |
|
|
Restrict delete | ||
| fk__tbl_pms_c__emplo__7f170660 |
|
|
Restrict delete | ||
| fk_ma_employee |
|
|
Restrict delete | ||
| fk_tbl_employeedocumenthistory |
|
|
Restrict delete | ||
| fk__tbl_fuele__modif__57077e58 |
|
|
Restrict delete | ||
| tbl_rating_scheme_detail_scheme_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_bankaccountmasterhistory_bankaccountmasterid |
|
|
Restrict delete | ||
| fk_tbl_bankaccountmasterhistory_bankmasterid |
|
|
Restrict delete | ||
| fk_tbl_aboutyourselfhistory_employeeid |
|
|
Restrict delete | ||
| fkditxthptyj633l7xt3jqtld4w |
|
|
Restrict delete | ||
| fkpgnmik3fh7s5r2txljwi86of6 |
|
|
Restrict delete | ||
| fk_tbl_travel_expense_expense_type_id |
|
|
Restrict delete | ||
| fk_tbl_travel_expense_travel_request_id |
|
|
Restrict delete | ||
| fk_at_employee |
|
|
Restrict delete | ||
| fk__tbl_tds_d__tdsid__1ca5d299 |
|
|
Restrict delete | ||
| fk__tbl_tds_d__tdsde__1d99f6d2 |
|
|
Restrict delete | ||
| fk__tbl_pms_c__pms_c__7c3a99b5 |
|
|
Restrict delete | ||
| fk__tbl_branc__state__5a2e03c6 |
|
|
Restrict delete | ||
| fk__tbl_branc__compa__5b2227ff |
|
|
Restrict delete | ||
| fk_employeetdsmasterhistory_employeetdsmasterid |
|
|
Restrict delete | ||
| tbl_chapter_progress_enrollment_id_fkey |
|
|
Cascade on delete | ||
| tbl_chapter_progress_chapter_id_fkey |
|
|
Cascade on delete | ||
| fk_empcom_employee |
|
|
Restrict delete | ||
| tbl_course_employee_search_course_id_fkey |
|
|
Cascade on delete | ||
| fk_tbl_overtimepolicyconfighistory_overtimepolicyid |
|
|
Restrict delete | ||
| fk__tbl_emplo__eaddr__345d6099 |
|
|
Restrict delete | ||
| tbl_question_assessment_id_fkey |
|
|
Cascade on delete | ||
| fk_employee |
|
|
Restrict delete | ||
| fk_employeestru_sbu |
|
|
Restrict delete | ||
| fk_tbl_bankaccountkeyvalues_bankaccountmasterid |
|
|
Restrict delete | ||
| fk__tbl_times__daily__01f1dc5d |
|
|
Restrict delete | ||
| fk__tbl_times__times__00fdb824 |
|
|
Restrict delete | ||
| fk_tbl_ticketcategory_companyid |
|
|
Restrict delete | ||
| fk_tbl_ticketcategory_departmentofcompanyid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_assigneeid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_companyid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_priorityid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_ticketid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_ticketstatusid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_ticketcategoryid |
|
|
Restrict delete | ||
| fk_tbl_tickethistory_ratingid |
|
|
Restrict delete | ||
| fk_tbl_overtimepolicyconfigslab_overtimepolicyconfigid |
|
|
Restrict delete | ||
| fk_tbl_okr_objectives |
|
|
Restrict delete | ||
| fk__imagegall__cmpid__659fb672 |
|
|
Restrict delete | ||
| fk_tbl_ticket_priorityid |
|
|
Restrict delete | ||
| fk_tbl_ticket_ticketstatusid |
|
|
Restrict delete | ||
| fk_tbl_ticket_ticketcategoryid |
|
|
Restrict delete | ||
| fk_tbl_ticket_companyid |
|
|
Restrict delete | ||
| fk_tbl_ticket_assigneeid |
|
|
Restrict delete | ||
| fk_tbl_ticket_ratingid |
|
|
Restrict delete | ||
| fk_tniformemployeemaster_pms_goal_list_id |
|
|
Restrict delete | ||
| fk_tbl_leavecodetobalancetransaction |
|
|
Restrict delete | ||
| fk_tbl_holidaydetailshistory_holidayid |
|
|
Restrict delete | ||
| fk_employeetdspreviousemployer_employeetdsmasterid |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_reportingperson1 |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_fromposition |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_employeeid |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_teamtransferid |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_companyid |
|
|
Restrict delete | ||
| fk_tbl_teamtransfermembers_reportingperson2 |
|
|
Restrict delete | ||
| fk_tbl_leavecancellationhistory_leaveappid |
|
|
Restrict delete | ||
| fk_tbl_leavecancellationhistory_employeeid |
|
|
Restrict delete | ||
| fk_da_employee |
|
|
Restrict delete | ||
| fk_employee |
|
|
Restrict delete | ||
| fk_tbl_ticketstatus_companyid |
|
|
Restrict delete | ||
| fk9u5f7egdxmq9loy34jb8wew8x |
|
|
Restrict delete | ||
| fk__tbl_emplo__eemer__355184d2 |
|
|
Restrict delete | ||
| fk_tbl_leavecodepolicyconfighistory_leavecodepolicyid |
|
|
Restrict delete | ||
| fk__systemwor__cmpid__5845bb54 |
|
|
Restrict delete | ||
| fk__tbl_emplo__erela__3b0a5e28 |
|
|
Restrict delete | ||
| tbl_certificate_course_id_fkey |
|
|
Cascade on delete | ||
| fk_tm_employee |
|
|
Restrict delete | ||
| fkdpriafcic8gjhlddr6rpmeilj |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| tbl_enrollment | tbl_enrollment_status_check | (((status)::text = ANY (ARRAY[('ENROLLED'::character varying)::text, ('IN_PROGRESS'::character varying)::text, ('COMPLETED'::character varying)::text, ('FAILED'::character varying)::text]))) |
| tbl_assessment_attempt | tbl_assessment_attempt_status_check | (((status)::text = ANY (ARRAY[('PASSED'::character varying)::text, ('FAILED'::character varying)::text]))) |
| tbl_question | tbl_question_question_type_check | (((question_type)::text = ANY (ARRAY[('MCQ'::character varying)::text, ('SUBJECTIVE'::character varying)::text, ('MULTI_SELECT'::character varying)::text]))) |