Template:ChadoTable stock

From GMOD

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 NOT NULL
	description	text	The description is the genetic description provided in the stock list.
cvterm	type_id	integer	UNIQUE#1 NOT NULL 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 DEFAULT false

Tables referencing stock via foreign key constraints:

• nd_experiment_stock
• stock_cvterm
• stock_dbxref
• stock_genotype
• stock_pub
• stock_relationship
• stockcollection_stock
• stockprop