stock_cvterm

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stock_cvterm_id serial 10 √ nextval('stock_cvterm_stock_cvterm_id_seq'::regclass)
stock_cvtermprop.stock_cvterm_id stock_cvtermprop_stock_cvterm_id_fkey C
stock_id int4 10 null
stock.stock_id stock_cvterm_stock_id_fkey C
cvterm_id int4 10 null
cvterm.cvterm_id stock_cvterm_cvterm_id_fkey C
pub_id int4 10 null
pub.pub_id stock_cvterm_pub_id_fkey C
rank int4 10 0
is_not bool 1 false

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

Close relationships within degrees of separation