Template:ChadoTable stock

Jump to: navigation, search

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.

Table: stock
Module: Stock

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.

stock columns
FK Name Type Description
stock_id serial PRIMARY KEY
dbxref dbxref_id integer The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref.
organism organism_id integer UNIQUE#1

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 character varying(255) The name is a human-readable local name for a stock.
uniquename text UNIQUE#1


description text The description is the genetic description provided in the stock list.
cvterm type_id integer UNIQUE#1

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 boolean NOT NULL


Tables referencing stock via foreign key constraints: