22 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| tbl_office_time_sheet_staffrefid_fkey |
|
|
Restrict delete | ||
| office_time_sheet_entry_officetimesheetrefid_fkey |
|
|
Cascade on delete | ||
| tbl_office_time_sheet_entry_invoicecoderefid_fkey |
|
|
Restrict delete | ||
| tbl_office_time_sheet_entry_taskcoderefid_fkey |
|
|
Restrict delete | ||
| tbl_staff_preferences_staff_refid_fkey |
|
|
Cascade on delete | ||
| tbl_task_group_matrix_taskcoderefid_fkey |
|
|
Restrict delete | ||
| tbl_task_group_matrix_groupnamerefid_fkey |
|
|
Restrict delete | ||
| tbl_invoice_code_lookup_projectmanager_fkey |
|
|
Restrict delete | ||
| tbl_invoice_code_lookup_supervisor_fkey |
|
|
Restrict delete | ||
| tbl_staff_toil_adjustment_log_source_time_sheet_fkey |
|
|
Null on delete | ||
| tbl_staff_toil_adjustment_log_time_sheet_refid_fkey |
|
|
Cascade on delete | ||
| tbl_staff_toil_adjustment_log_author_refid_fkey |
|
|
Null on delete | ||
| tbl_staff_toil_adjustment_log_staff_refid_fkey |
|
|
Cascade on delete | ||
| tbl_staff_lookup_linemanager_fkey |
|
|
Restrict delete | ||
| tbl_staff_hols_adjustment_added_by_fkey |
|
|
Restrict delete | ||
| tbl_staff_hols_adjustment_staff_refid_fkey |
|
|
Restrict delete | ||
| office_time_sheet_entry_details_officetimesheetentryrefid_fkey |
|
|
Cascade on delete | ||
| tbl_invoice_group_matrix_groupnamerefid_fkey |
|
|
Restrict delete | ||
| tbl_invoice_group_matrix_invoicecoderefid_fkey |
|
|
Cascade on delete | ||
| tbl_staff_toil_adjustment_added_by_fkey |
|
|
Restrict delete | ||
| tbl_staff_toil_adjustment_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_toil_adjustment_source_time_sheet_fkey |
|
|
Null on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|