chado Module

Columns

Table	Type	Column	Type	Size	Nulls	Default	Comments
stock_cvterm	Table	pub_id	int8	19		null
stockcollectionprop	Table	rank	int4	10		0
stock	Table	is_obsolete	bool	1		false
stockcollection	Table	stockcollection_id	bigserial	19		nextval('stock.stockcollection_stockcollection_id_seq'::regclass)
stockcollection_stock	Table	stockcollection_stock_id	bigserial	19		nextval('stock.stockcollection_stock_stockcollection_stock_id_seq'::regclass)
stock_relationship_pub	Table	stock_relationship_pub_id	bigserial	19		nextval('stock.stock_relationship_pub_stock_relationship_pub_id_seq'::regclass)
stock	Table	organism_id	int8	19	√	null	The organism_id is the organism to which the stock belongs. This column should only be left blank if the organism cannot be determined.
stockcollection	Table	uniquename	text	2147483647		null	uniqename is the value of the collection cv.
stock_cvterm	Table	cvterm_id	int8	19		null
stock_library	Table	stock_id	int8	19		null
stock_cvtermprop	Table	stock_cvtermprop_id	bigserial	19		nextval('stock.stock_cvtermprop_stock_cvtermprop_id_seq'::regclass)
stockprop_pub	Table	pub_id	int8	19		null
stockcollection	Table	name	varchar	255	√	null	name is the collection.
stock_relationship_cvterm	Table	pub_id	int8	19	√	null
stock_relationship_cvterm	Table	cvterm_id	int8	19		null
stockcollection_db	Table	stockcollection_id	int8	19		null
stock_genotype	Table	stock_id	int8	19		null
stock_dbxrefprop	Table	rank	int4	10		0
stock_genotype	Table	stock_genotype_id	bigserial	19		nextval('stock.stock_genotype_stock_genotype_id_seq'::regclass)
stock_relationship_pub	Table	stock_relationship_id	int8	19		null
stock_cvterm	Table	rank	int4	10		0
stock_relationship_cvterm	Table	stock_relationship_id	int8	19		null
stockcollectionprop	Table	stockcollectionprop_id	bigserial	19		nextval('stock.stockcollectionprop_stockcollectionprop_id_seq'::regclass)
stockprop	Table	rank	int4	10		0
stock_relationship	Table	rank	int4	10		0	stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero.
stock	Table	type_id	int8	19		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.
stock_genotype	Table	genotype_id	int8	19		null
stock_pub	Table	stock_pub_id	bigserial	19		nextval('stock.stock_pub_stock_pub_id_seq'::regclass)
stock_dbxrefprop	Table	value	text	2147483647	√	null
stockprop_pub	Table	stockprop_id	int8	19		null
stock_relationship	Table	subject_id	int8	19		null	stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock.
stockprop	Table	value	text	2147483647	√	null
stock_cvtermprop	Table	type_id	int8	19		null	The name of the property/slot is a cvterm. The meaning of the property is defined in that cvterm. cvterms may come from the OBO evidence code cv.
stock_relationship	Table	object_id	int8	19		null	stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock.
stock_pub	Table	pub_id	int8	19		null
stock_library	Table	stock_library_id	bigserial	19		nextval('stock.stock_library_stock_library_id_seq'::regclass)
stock	Table	dbxref_id	int8	19	√	null	The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref.
stock_feature	Table	type_id	int8	19		null
stock_relationship_cvterm	Table	stock_relationship_cvterm_id	bigserial	19		nextval('stock.stock_relationship_cvterm_stock_relationship_cvterm_id_seq'::regclass)
stock_featuremap	Table	featuremap_id	int8	19		null
stock	Table	uniquename	text	2147483647		null
stock_feature	Table	rank	int4	10		0
stock_cvtermprop	Table	value	text	2147483647	√	null	The value of the property, represented as text. Numeric values are converted to their text representation. This is less efficient than using native database types, but is easier to query.
stock_feature	Table	feature_id	int8	19		null
stockcollection_db	Table	stockcollection_db_id	bigserial	19		nextval('stock.stockcollection_db_stockcollection_db_id_seq'::regclass)
stock_cvterm	Table	stock_cvterm_id	bigserial	19		nextval('stock.stock_cvterm_stock_cvterm_id_seq'::regclass)
stock_feature	Table	stock_feature_id	bigserial	19		nextval('stock.stock_feature_stock_feature_id_seq'::regclass)
stock_relationship_pub	Table	pub_id	int8	19		null
stockcollectionprop	Table	stockcollection_id	int8	19		null
stockprop_pub	Table	stockprop_pub_id	bigserial	19		nextval('stock.stockprop_pub_stockprop_pub_id_seq'::regclass)
stock_dbxref	Table	stock_dbxref_id	bigserial	19		nextval('stock.stock_dbxref_stock_dbxref_id_seq'::regclass)
stock_cvterm	Table	stock_id	int8	19		null
stock_dbxrefprop	Table	stock_dbxref_id	int8	19		null
stockcollectionprop	Table	type_id	int8	19		null	The cv for the type_id is "stockcollection property type".
stock_featuremap	Table	stock_featuremap_id	bigserial	19		nextval('stock.stock_featuremap_stock_featuremap_id_seq'::regclass)
stock_dbxref	Table	stock_id	int8	19		null
stockprop	Table	stock_id	int8	19		null
stock_featuremap	Table	stock_id	int8	19		null
stockprop	Table	stockprop_id	bigserial	19		nextval('stock.stockprop_stockprop_id_seq'::regclass)
stock_cvterm	Table	is_not	bool	1		false
stock_library	Table	library_id	int8	19		null
stock	Table	name	varchar	255	√	null	The name is a human-readable local name for a stock.
stockcollectionprop	Table	value	text	2147483647	√	null
stock_featuremap	Table	type_id	int8	19	√	null
stock_cvtermprop	Table	rank	int4	10		0	Property-Value ordering. Any stock_cvterm can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used.
stockprop	Table	type_id	int8	19		null
stock_relationship	Table	value	text	2147483647	√	null	stock_relationship.value is for additional notes or comments.
stock_dbxref	Table	dbxref_id	int8	19		null
stock_pub	Table	stock_id	int8	19		null
stock_relationship	Table	type_id	int8	19		null	stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.
stockcollection_stock	Table	stock_id	int8	19		null
stock_relationship	Table	stock_relationship_id	bigserial	19		nextval('stock.stock_relationship_stock_relationship_id_seq'::regclass)
stock_dbxrefprop	Table	stock_dbxrefprop_id	bigserial	19		nextval('stock.stock_dbxrefprop_stock_dbxrefprop_id_seq'::regclass)
stock	Table	description	text	2147483647	√	null	The description is the genetic description provided in the stock list.
stockcollection_db	Table	db_id	int8	19		null
stockcollection	Table	contact_id	int8	19	√	null	contact_id links to the contact information for the collection.
stockcollection_stock	Table	stockcollection_id	int8	19		null
stock_cvtermprop	Table	stock_cvterm_id	int8	19		null
stock_feature	Table	stock_id	int8	19		null
stock	Table	stock_id	bigserial	19		nextval('stock.stock_stock_id_seq'::regclass)
stockcollection	Table	type_id	int8	19		null	type_id is the collection type cv.
stock_dbxrefprop	Table	type_id	int8	19		null
stock_dbxref	Table	is_current	bool	1		true	The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock.