Constraints

12 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
vouchers__t_invoice_id_fkey1
vouchers__t.invoice_id
invoices__t.id
Restrict delete
vouchers__t_batch_group_id_fkey
vouchers__t.batch_group_id
batch_groups__t.id
Restrict delete
vouchers__t_vendor_id_fkey
vouchers__t.vendor_id
organizations__t.id
Restrict delete
vouchers__t_invoice_id_fkey
vouchers__t.invoice_id
invoice_transaction_summaries__t.id
Restrict delete
batch_voucher_export_configs__t_batch_group_id_fkey
batch_voucher_export_configs__t.batch_group_id
batch_groups__t.id
Restrict delete
documents__t_invoice_id_fkey
documents__t.invoice_id
invoices__t.id
Restrict delete
invoice_lines__t_invoice_id_fkey
invoice_lines__t.invoice_id
invoices__t.id
Restrict delete
invoices__t_vendor_id_fkey
invoices__t.vendor_id
organizations__t.id
Restrict delete
invoices__t_approved_by_fkey
invoices__t.approved_by
users__t.id
Restrict delete
invoices__t_bill_to_fkey
invoices__t.bill_to
config_data__t.id
Restrict delete
invoices__t_batch_group_id_fkey
invoices__t.batch_group_id
batch_groups__t.id
Restrict delete
voucher_lines__t_voucher_id_fkey
voucher_lines__t.voucher_id
vouchers__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint