stock

2940 rows


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stock_id serial 10 √ nextval('stock_stock_id_seq'::regclass)
stock_allele.stock_id stock_allele_stock_id_fkey C
stock_file.stock_id stock_file_stock_id_fkey C
stock_image.stock_id stock_image_stock_id_fkey R
stock_owner.stock_id stock_owner_stock_id_fkey R
materialized_phenotype_jsonb_table.germplasm_stock_id Implied Constraint R
materialized_phenotype_jsonb_table.observationunit_stock_id Implied Constraint R
materialized_phenotype_jsonb_table.seedlot_stock_id Implied Constraint R
materialized_phenoview.stock_id Implied Constraint R
materialized_stockprop.stock_id Implied Constraint R
nd_experiment_stock.stock_id nd_experiment_stock_stock_id_fkey C
stock_cvterm.stock_id stock_cvterm_stock_id_fkey C
stock_dbxref.stock_id stock_dbxref_stock_id_fkey C
stock_genotype.stock_id stock_genotype_stock_id_fkey C
stock_pub.stock_id stock_pub_stock_id_fkey C
stock_relationship.object_id stock_relationship_object_id_fkey C
stock_relationship.subject_id stock_relationship_subject_id_fkey C
stockcollection_stock.stock_id stockcollection_stock_stock_id_fkey C
stockprop.stock_id stockprop_stock_id_fkey C
map.parent1_stock_id map_parent1_stock_id_fkey R
map.parent2_stock_id map_parent2_stock_id_fkey R
map.population_stock_id map_population_stock_id_fkey R
pcr_exp_accession.stock_id pcr_exp_accession_stock_id_fkey R
pcr_experiment.stock_id pcr_experiment_stock_id_fkey R
snp.reference_stock_id snp_reference_stock_id_fkey R
snp.stock_id snp_stock_id_fkey R
dbxref_id int4 10 √ null
dbxref.dbxref_id stock_dbxref_id_fkey N

The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref.
organism_id int4 10 √ null
organism.organism_id stock_organism_id_fkey C

The organism_id is the organism to which the stock belongs. This column should only be left blank if the organism cannot be determined.
name varchar 255 √ null

The name is a human-readable local name for a stock.
uniquename text 2147483647 null
description text 2147483647 √ null

The description is the genetic description provided in the stock list.
type_id int4 10 null
cvterm.cvterm_id stock_type_id_fkey C

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
create_date timestamp 29,6 √ now()

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

Relationships

Close relationships within degrees of separation