Table jdahlin.public.purchase_order

Generated by SchemaSpy

Related columns Constraint names Comments Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents Comments id bigserial 19  √  nextval('purchase_order_id_seq'::regclass) purchase_item.order_id purchase_item_order_id_fkey quotation.purchase_id quotation_purchase_id_fkey receiving_order.purchase_id receiving_order_purchase_id_fkey te_created_id int8 19  √  null transaction_entry.id purchase_order_te_created_id_fkey te_modified_id int8 19  √  null transaction_entry.id purchase_order_te_modified_id_fkey status int4 10  √  null open_date timestamp 29,6  √  null quote_deadline timestamp 29,6  √  null expected_receival_date timestamp 29,6  √  null expected_pay_date timestamp 29,6  √  null receival_date timestamp 29,6  √  null confirm_date timestamp 29,6  √  null notes text 2147483647  √  null salesperson_name text 2147483647  √  null freight_type int4 10  √  null expected_freight numeric 10,2  √  null surcharge_value numeric 10,2  √  null discount_value numeric 10,2  √  null supplier_id int8 19  √  null person_adapt_to_supplier.id purchase_order_supplier_id_fkey branch_id int8 19  √  null person_adapt_to_branch.id purchase_order_branch_id_fkey transporter_id int8 19  √  null person_adapt_to_transporter.id purchase_order_transporter_id_fkey responsible_id int8 19  √  null person_adapt_to_user.id purchase_order_responsible_id_fkey group_id int8 19  √  null payment_group.id purchase_order_group_id_fkey consigned bool 1  √  false Table contained 1 rows at Sex Jun 10 16:28 BRT 2011

SchemaSpy was unable to generate a graphical representation of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.