stockcollection

0 rows


Description

The lab or stock center distributing the stocks in their collection.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stockcollection_id serial 10 nextval('stockcollection_stockcollection_id_seq'::regclass)
stockcollection_stock.stockcollection_id stockcollection_stock_stockcollection_id_fkey C
stockcollectionprop.stockcollection_id stockcollectionprop_stockcollection_id_fkey C
type_id int4 10 null
cvterm.cvterm_id stockcollection_type_id_fkey C

type_id is the collection type cv.

contact_id int4 10 null
contact.contact_id stockcollection_contact_id_fkey N

contact_id links to the contact information for the collection.

name varchar 255 null

name is the collection.

uniquename text 2147483647 null

uniqename is the value of the collection cv.

Indexes

Constraint Name Type Sort Column(s)
stockcollection_pkey Primary key Asc stockcollection_id
stockcollection_c1 Must be unique Asc/Asc uniquename + type_id
stockcollection_idx1 Performance Asc contact_id
stockcollection_idx2 Performance Asc type_id
stockcollection_idx3 Performance Asc uniquename
stockcollection_name_ind1 Performance Asc name

Relationships