Constraints

13 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
titles__t_po_line_id_fkey
titles__t.po_line_id
po_line__t.id
Restrict delete
pieces__t_title_id_fkey
pieces__t.title_id
titles__t.id
Restrict delete
pieces__t_po_line_id_fkey
pieces__t.po_line_id
po_line__t.id
Restrict delete
pieces__t_location_id_fkey
pieces__t.location_id
location__t.id
Restrict delete
order_invoice_relationship__t_purchase_order_id_fkey
order_invoice_relationship__t.purchase_order_id
purchase_order__t.id
Restrict delete
order_templates__t_bill_to_fkey
order_templates__t.bill_to
config_data__t.id
Restrict delete
order_templates__t_ship_to_fkey
order_templates__t.ship_to
config_data__t.id
Restrict delete
order_templates__t_vendor_fkey
order_templates__t.vendor
organizations__t.id
Restrict delete
po_line__t_purchase_order_id_fkey
po_line__t.purchase_order_id
purchase_order__t.id
Restrict delete
purchase_order__t_approved_by_id_fkey
purchase_order__t.approved_by_id
users__t.id
Restrict delete
purchase_order__t_template_fkey
purchase_order__t.template
order_templates__t.id
Restrict delete
purchase_order__t_bill_to_fkey
purchase_order__t.bill_to
config_data__t.id
Restrict delete
purchase_order__t_ship_to_fkey
purchase_order__t.ship_to
config_data__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint