stock_relationship_cvterm

0 rows


Description

For germplasm maintenance and pedigree data, stock_relationship. type_id will record cvterms such as “is a female parent of”, “a parent for mutation”, “is a group_id of”, “is a source_id of”, etc The cvterms for higher categories such as “generative”, “derivative” or “maintenance” can be stored in table stock_relationship_cvterm

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stock_relationship_cvterm_id serial 10 √ nextval('stock_relationship_cvterm_stock_relationship_cvterm_id_seq'::regclass)
stock_relationship_id int4 10 null
stock_relationship.stock_relationship_id stock_relationship_cvterm_stock_relationship_id_fkey C
cvterm_id int4 10 null
cvterm.cvterm_id stock_relationship_cvterm_cvterm_id_fkey R
pub_id int4 10 √ null
pub.pub_id stock_relationship_cvterm_pub_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
stock_relationship_cvterm_pkey Primary key Asc stock_relationship_cvterm_id

Relationships

Close relationships within degrees of separation