77 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| srs_records_updated_by_user_id_fkey |
|
|
Restrict delete | ||
| srs_records_created_by_user_id_fkey |
|
|
Restrict delete | ||
| feesfines_accounts_user_id_fkey |
|
|
Restrict delete | ||
| feesfines_accounts_owner_id_fkey |
|
|
Restrict delete | ||
| inventory_campuses_institution_id_fkey |
|
|
Restrict delete | ||
| inventory_locations_campus_id_fkey |
|
|
Restrict delete | ||
| inventory_locations_institution_id_fkey |
|
|
Restrict delete | ||
| inventory_locations_library_id_fkey |
|
|
Restrict delete | ||
| inventory_locations_primary_service_point_fkey |
|
|
Restrict delete | ||
| patron_blocks_user_summary_user_id_fkey |
|
|
Restrict delete | ||
| finance_group_fund_fiscal_years_fiscal_year_id_fkey |
|
|
Restrict delete | ||
| finance_group_fund_fiscal_years_fund_id_fkey |
|
|
Restrict delete | ||
| finance_group_fund_fiscal_years_group_id_fkey |
|
|
Restrict delete | ||
| finance_group_fund_fiscal_years_budget_id_fkey |
|
|
Restrict delete | ||
| po_order_invoice_relns_purchase_order_id_fkey |
|
|
Restrict delete | ||
| po_purchase_orders_bill_to_fkey |
|
|
Restrict delete | ||
| po_purchase_orders_ship_to_fkey |
|
|
Restrict delete | ||
| po_order_templates_ship_to_fkey |
|
|
Restrict delete | ||
| po_order_templates_vendor_fkey |
|
|
Restrict delete | ||
| po_order_templates_bill_to_fkey |
|
|
Restrict delete | ||
| circulation_request_preference_user_id_fkey |
|
|
Restrict delete | ||
| po_lines_purchase_order_id_fkey |
|
|
Restrict delete | ||
| inventory_service_points_users_default_service_point_id_fkey |
|
|
Restrict delete | ||
| inventory_service_points_users_user_id_fkey |
|
|
Restrict delete | ||
| finance_budgets_fiscal_year_id_fkey |
|
|
Restrict delete | ||
| finance_budgets_fund_id_fkey |
|
|
Restrict delete | ||
| invoice_voucher_lines_voucher_id_fkey |
|
|
Restrict delete | ||
| circulation_requests_pickup_service_point_id_fkey |
|
|
Restrict delete | ||
| circulation_requests_requester_id_fkey |
|
|
Restrict delete | ||
| user_proxiesfor_proxy_user_id_fkey |
|
|
Restrict delete | ||
| user_proxiesfor_user_id_fkey |
|
|
Restrict delete | ||
| perm_users_user_id_fkey |
|
|
Restrict delete | ||
| circulation_check_ins_item_location_id_fkey |
|
|
Restrict delete | ||
| circulation_check_ins_service_point_id_fkey |
|
|
Restrict delete | ||
| circulation_check_ins_performed_by_user_id_fkey |
|
|
Restrict delete | ||
| invoice_invoices_approved_by_fkey |
|
|
Restrict delete | ||
| invoice_invoices_vendor_id_fkey |
|
|
Restrict delete | ||
| po_pieces_id_fkey |
|
|
Restrict delete | ||
| po_pieces_po_line_id_fkey |
|
|
Restrict delete | ||
| po_pieces_location_id_fkey |
|
|
Restrict delete | ||
| user_users_patron_group_fkey |
|
|
Restrict delete | ||
| srs_marc_id_fkey |
|
|
Restrict delete | ||
| inventory_libraries_campus_id_fkey |
|
|
Restrict delete | ||
| finance_ledgers_fiscal_year_one_id_fkey |
|
|
Restrict delete | ||
| circulation_loans_overdue_fine_policy_id_fkey |
|
|
Restrict delete | ||
| circulation_loans_item_effective_location_id_at_check_out_fkey |
|
|
Restrict delete | ||
| circulation_loans_lost_item_policy_id_fkey |
|
|
Restrict delete | ||
| circulation_loans_checkout_service_point_id_fkey |
|
|
Restrict delete | ||
| circulation_loans_patron_group_id_at_checkout_fkey |
|
|
Restrict delete | ||
| circulation_loans_checkin_service_point_id_fkey |
|
|
Restrict delete | ||
| circulation_loans_loan_policy_id_fkey |
|
|
Restrict delete | ||
| finance_funds_ledger_id_fkey |
|
|
Restrict delete | ||
| circulation_scheduled_notices_loan_id_fkey |
|
|
Restrict delete | ||
| feesfines_feefineactions_user_id_fkey |
|
|
Restrict delete | ||
| feesfines_feefineactions_account_id_fkey |
|
|
Restrict delete | ||
| inventory_holdings_permanent_location_id_fkey |
|
|
Restrict delete | ||
| inventory_holdings_instance_id_fkey |
|
|
Restrict delete | ||
| inventory_holdings_effective_location_id_fkey |
|
|
Restrict delete | ||
| feesfines_feefines_owner_id_fkey |
|
|
Restrict delete | ||
| srs_error_id_fkey |
|
|
Restrict delete | ||
| inventory_items_permanent_loan_type_id_fkey |
|
|
Restrict delete | ||
| inventory_items_effective_location_id_fkey |
|
|
Restrict delete | ||
| inventory_items_material_type_id_fkey |
|
|
Restrict delete | ||
| inventory_items_holdings_record_id_fkey |
|
|
Restrict delete | ||
| inventory_statistical_codes_statistical_code_type_id_fkey |
|
|
Restrict delete | ||
| invoice_lines_invoice_id_fkey |
|
|
Restrict delete | ||
| invoice_vouchers_invoice_id_fkey |
|
|
Restrict delete | ||
| invoice_vouchers_vendor_id_fkey |
|
|
Restrict delete | ||
| po_receiving_history_id_fkey |
|
|
Restrict delete | ||
| po_receiving_history_po_line_id_fkey |
|
|
Restrict delete | ||
| po_receiving_history_purchase_order_id_fkey |
|
|
Restrict delete | ||
| po_receiving_history_location_id_fkey |
|
|
Restrict delete | ||
| feesfines_payments_owner_id_fkey |
|
|
Restrict delete | ||
| inventory_instances_instance_type_id_fkey |
|
|
Restrict delete | ||
| finance_transactions_to_fund_id_fkey |
|
|
Restrict delete | ||
| finance_transactions_fiscal_year_id_fkey |
|
|
Restrict delete | ||
| feesfines_manualblocks_user_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|