89 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| tbl_cost_rates_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_cost_rates_currency_fkey |
|
|
Restrict delete | ||||
| tbl_cost_rates_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_invoice_exchange_lookup_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_currency_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_payroll_centre_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_location_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_invoice_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_invoice_tl_currency_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_summary_invoice_code_fkey |
|
|
Cascade on delete | ||||
| tbl_finance_project_monitor_subscriptions_staff_refid_fkey |
|
|
Cascade on delete | ||||
| tbl_slip_exp_currency_translation_refid_fkey |
|
|
Cascade on delete | ||||
| tbl_slip_exp_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_spinal_points_currency_fkey |
|
|
Restrict delete | ||||
| tbl_staff_positions_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_staff_positions_position_fkey |
|
|
Restrict delete | ||||
| tbl_project_monitor_reports_invoice_code_fkey |
|
|
Cascade on delete | ||||
| tbl_project_monitor_reports_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_payroll_currency_fkey |
|
|
Restrict delete | ||||
| tbl_sales_exchange_lookup_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_sales_tl_currency_fkey |
|
|
Restrict delete | ||||
| tbl_sales_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_work_in_progress_exchange_rate_fkey |
|
|
Restrict delete | ||||
| tbl_work_in_progress_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_work_in_progress_tl_currency_fkey |
|
|
Restrict delete | ||||
| tbl_staff_payroll_centre_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_staff_payroll_centre_payroll_centre_fkey |
|
|
Restrict delete | ||||
| tbl_markup_values_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_markup_values_markup_fkey |
|
|
Restrict delete | ||||
| tbl_charge_group_project_invoice_fkey |
|
|
Cascade on delete | ||||
| tbl_charge_group_project_groupid_fkey |
|
|
Cascade on delete | ||||
| tbl_orders_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_orders_currency_translation_refid_fkey |
|
|
Cascade on delete | ||||
| tbl_charge_rates_currency_fkey |
|
|
Restrict delete | ||||
| tbl_charge_rates_groupid_fkey |
|
|
Cascade on delete | ||||
| tbl_charge_rates_position_fkey |
|
|
Cascade on delete | ||||
| tbl_project_defer_income_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_project_defer_income_invoice_code_fkey |
|
|
Cascade on delete | ||||
| tbl_percentage_markup_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_percentage_markup_invoice_code_fkey |
|
|
Restrict delete | ||||
| ManAccs_Comments_cost_centre_fkey |
|
|
Restrict delete | ||||
| ManAccs_Comments_invoice_code_fkey |
|
|
Restrict delete | ||||
| tbl_wip_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_wip_currency_translation_folio_fkey |
|
|
Cascade on delete | ||||
| tbl_invoice_currency_translation_folio_fkey |
|
|
Cascade on delete | ||||
| tbl_invoice_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_financial_details_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_financial_details_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_staff_location_location_fkey |
|
|
Restrict delete | ||||
| tbl_staff_location_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_subs_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_subs_currency_translation_refid_fkey |
|
|
Cascade on delete | ||||
| tbl_finance_project_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_currency_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_invoice_type_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_department_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_manager_fkey |
|
|
Restrict delete | ||||
| tbl_charge_rates_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_charge_groups_cost_center_fkey |
|
|
Cascade on delete | ||||
| tbl_finance_project_summary_invoice_code_fkey |
|
|
Restrict delete | ||||
| tbl_finance_project_summary_currency_fkey |
|
|
Restrict delete | ||||
| tbl_staff_cost_centre_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_staff_cost_centre_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_exchange_reference_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_exchange_rates_currency_from_fkey |
|
|
Restrict delete | ||||
| tbl_exchange_rates_currency_to_fkey |
|
|
Restrict delete | ||||
| tbl_exchange_rates_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_orders_tl_currency_fkey |
|
|
Restrict delete | ||||
| tbl_orders_exchange_rate_fkey |
|
|
Restrict delete | ||||
| tbl_orders_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_subs_currency_fkey |
|
|
Restrict delete | ||||
| tbl_subs_location_fkey |
|
|
Restrict delete | ||||
| tbl_subs_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_subs_cost_centre_fkey |
|
|
Restrict delete | ||||
| tbl_subs_exchange_reference_fkey |
|
|
Restrict delete | ||||
| tbl_subs_payroll_centre_fkey |
|
|
Restrict delete | ||||
| tbl_weighted_markup_entered_by_fkey |
|
|
Restrict delete | ||||
| tbl_weighted_markup_invoice_code_fkey |
|
|
Restrict delete | ||||
| tbl_weighted_markup_markup_fkey |
|
|
Restrict delete | ||||
| tbl_sales_currency_translation_currency_fkey |
|
|
Restrict delete | ||||
| tbl_sales_currency_translation_folio_fkey |
|
|
Cascade on delete | ||||
| tbl_slip_exp_currency_translation_charge_rates_currency_fkey |
|
|
Restrict delete | ||||
| tbl_slip_exp_currency_translation_charge_rates_refid_fkey |
|
|
Cascade on delete | ||||
| tbl_subs_hist_staff_refid_fkey |
|
|
Restrict delete | ||||
| tbl_subs_input_staff_refid_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|