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

Close relationships within degrees of separation