Schema Version: 1.3

stock_relationship_cvterm


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 Foreign Key Nullable Default Comments
stock_relationship_cvterm_id bigserial 19
nextval('chado.stock_relationship_cvterm_stock_relationship_cvterm_id_seq'::regclass)
stock_relationship_id int8 19
stock_relationship.stock_relationship_id stock_relationship_cvterm_stock_relationship_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id stock_relationship_cvterm_cvterm_id_fkey R
null
pub_id int8 19
pub.pub_id stock_relationship_cvterm_pub_id_fkey R
√ null

Table contained -1 rows

Indexes

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

Relationships

The following entity relationship (ER) diagram shows the relationships involving the stock_relationship_cvterm table.

Show relationships within degrees of separation