sp_order - cxgn_breedbase.sgn

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees