Constraints

25 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
group_fund_fiscal_year__t_budget_id_fkey
group_fund_fiscal_year__t.budget_id
budget__t.id
Restrict delete
group_fund_fiscal_year__t_group_id_fkey
group_fund_fiscal_year__t.group_id
groups__t.id
Restrict delete
group_fund_fiscal_year__t_fiscal_year_id_fkey
group_fund_fiscal_year__t.fiscal_year_id
fiscal_year__t.id
Restrict delete
group_fund_fiscal_year__t_fund_id_fkey
group_fund_fiscal_year__t.fund_id
fund__t.id
Restrict delete
budget__t_fiscal_year_id_fkey
budget__t.fiscal_year_id
fiscal_year__t.id
Restrict delete
budget__t_fund_id_fkey
budget__t.fund_id
fund__t.id
Restrict delete
fund__t_fund_type_id_fkey
fund__t.fund_type_id
fund_type__t.id
Restrict delete
fund__t_ledger_id_fkey
fund__t.ledger_id
ledger__t.id
Restrict delete
ledger__t_fiscal_year_one_id_fkey
ledger__t.fiscal_year_one_id
fiscal_year__t.id
Restrict delete
budget_expense_class__t_budget_id_fkey
budget_expense_class__t.budget_id
budget__t.id
Restrict delete
budget_expense_class__t_expense_class_id_fkey
budget_expense_class__t.expense_class_id
expense_class__t.id
Restrict delete
transaction__t_to_fund_id_fkey
transaction__t.to_fund_id
fund__t.id
Restrict delete
transaction__t_source_invoice_id_fkey
transaction__t.source_invoice_id
invoice_transaction_summaries__t.id
Restrict delete
transaction__t_from_fund_id_fkey
transaction__t.from_fund_id
fund__t.id
Restrict delete
transaction__t_expense_class_id_fkey
transaction__t.expense_class_id
expense_class__t.id
Restrict delete
transaction__t_fiscal_year_id_fkey
transaction__t.fiscal_year_id
fiscal_year__t.id
Restrict delete
temporary_invoice_transactions__t_source_invoice_id_fkey
temporary_invoice_transactions__t.source_invoice_id
invoice_transaction_summaries__t.id
Restrict delete
temporary_invoice_transactions__t_to_fund_id_fkey
temporary_invoice_transactions__t.to_fund_id
fund__t.id
Restrict delete
temporary_invoice_transactions__t_expense_class_id_fkey
temporary_invoice_transactions__t.expense_class_id
expense_class__t.id
Restrict delete
temporary_invoice_transactions__t_payment_encumbrance_id_fkey
temporary_invoice_transactions__t.payment_encumbrance_id
transaction__t.id
Restrict delete
temporary_invoice_transactions__t_from_fund_id_fkey
temporary_invoice_transactions__t.from_fund_id
fund__t.id
Restrict delete
temporary_invoice_transactions__t_fiscal_year_id_fkey
temporary_invoice_transactions__t.fiscal_year_id
fiscal_year__t.id
Restrict delete
temporary_order_transactions__t_expense_class_id_fkey
temporary_order_transactions__t.expense_class_id
expense_class__t.id
Restrict delete
temporary_order_transactions__t_from_fund_id_fkey
temporary_order_transactions__t.from_fund_id
fund__t.id
Restrict delete
temporary_order_transactions__t_fiscal_year_id_fkey
temporary_order_transactions__t.fiscal_year_id
fiscal_year__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint