sp_order

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sp_order_id serial 10 √ nextval('sgn_people.sp_order_sp_order_id_seq'::regclass)
sp_orderprop.sp_order_id sp_orderprop_sp_order_id_fkey R
order_from_id int8 19 √ null
sp_person.sp_person_id sp_order_order_from_id_fkey R
order_to_id int8 19 √ null
sp_person.sp_person_id sp_order_order_to_id_fkey R
order_status varchar 100 √ null
comments text 2147483647 √ null
create_date varchar 100 √ null
completion_date varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
sp_order_pkey Primary key Asc sp_order_id

Relationships

Close relationships within degrees of separation