Schema Version: 1.3

stock_cvterm


Description

stock_cvterm links a stock to cvterms. This is for secondary cvterms; primary cvterms should use stock.type_id.

Columns

Column Type Size Foreign Key Nullable Default Comments
stock_cvterm_id bigserial 19
nextval('chado.stock_cvterm_stock_cvterm_id_seq'::regclass)
stock_id int8 19
stock.stock_id stock_cvterm_stock_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id stock_cvterm_cvterm_id_fkey C
null
pub_id int8 19
pub.pub_id stock_cvterm_pub_id_fkey C
null
is_not bool 1
false
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
stock_cvterm_pkey Primary key Asc stock_cvterm_id
stock_cvterm_c1 Must be unique Asc/Asc/Asc/Asc stock_id + cvterm_id + pub_id + rank
stock_cvterm_idx1 Performance Asc stock_id
stock_cvterm_idx2 Performance Asc cvterm_id
stock_cvterm_idx3 Performance Asc pub_id

Relationships

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

Show relationships within degrees of separation