Any stock can be globally identified by the combination of organism, uniquename and stock type. A stock is the physical entities, either living or preserved, held by collections. Stocks belong to a collection; they have IDs, type, organism, description and may have a genotype.
The type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Secondary cvterms for stocks would go in stock_cvterm.
is_obsolete
bool
1
false
Showing 1 to 8 of 8 entries
Table contained -1 rows
Indexes
Constraint Name
Type
Sort
Column(s)
stock_pkey
Primary key
Asc
stock_id
stock_c1
Must be unique
Asc/Asc/Asc
organism_id + uniquename + type_id
stock_idx1
Performance
Asc
dbxref_id
stock_idx2
Performance
Asc
organism_id
stock_idx3
Performance
Asc
type_id
stock_idx4
Performance
Asc
uniquename
stock_name_ind1
Performance
Asc
name
Showing 1 to 7 of 7 entries
Relationships
The following entity relationship (ER) diagram shows the relationships involving the stock table.
