Schema Version: 1.3

stockcollection


Description

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

Columns

Column Type Size Foreign Key Nullable Default Comments
stockcollection_id bigserial 19
nextval('chado.stockcollection_stockcollection_id_seq'::regclass)
type_id int8 19
cvterm.cvterm_id stockcollection_type_id_fkey C
null

type_id is the collection type cv.
contact_id int8 19
contact.contact_id stockcollection_contact_id_fkey N
√ null

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.

Table contained -1 rows

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

The following entity relationship (ER) diagram shows the relationships involving the stockcollection table.

Show relationships within degrees of separation