26 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| tbl_staff_payroll_centre_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_payroll_centre_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_staff_payroll_centre_payroll_centre_fkey |
|
|
Restrict delete | ||
| tbl_staff_location_location_fkey |
|
|
Restrict delete | ||
| tbl_staff_location_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_location_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_staff_line_manager_fkey |
|
|
Restrict delete | ||
| tbl_staff_spinal_type_fkey |
|
|
Restrict delete | ||
| tbl_staff_department_fkey |
|
|
Restrict delete | ||
| tbl_foreign_experience_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_cost_centre_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_cost_centre_cost_centre_fkey |
|
|
Restrict delete | ||
| tbl_staff_cost_centre_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_contact_details_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_employment_history_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_employment_history_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_employment_history_cost_centre_fkey |
|
|
Restrict delete | ||
| tbl_employment_history_payroll_centre_fkey |
|
|
Restrict delete | ||
| tbl_skills_entry_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_skills_entry_skill_code_fkey |
|
|
Restrict delete | ||
| tbl_skills_entry_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_positions_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_staff_positions_position_fkey |
|
|
Restrict delete | ||
| tbl_staff_positions_entered_by_fkey |
|
|
Restrict delete | ||
| tbl_hr_details_staff_refid_fkey |
|
|
Restrict delete | ||
| tbl_skills_breakdown_skill_class_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|