stock_cvtermprop

0 rows


Description

Extensible properties for stock to cvterm associations. Examples: GO evidence codes; qualifiers; metadata such as the date on which the entry was curated and the source of the association. See the stockprop table for meanings of type_id, value and rank.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
stock_cvtermprop_id serial 10 nextval('stock_cvtermprop_stock_cvtermprop_id_seq'::regclass)
stock_cvterm_id int4 10 null
stock_cvterm.stock_cvterm_id stock_cvtermprop_stock_cvterm_id_fkey C
type_id int4 10 null
cvterm.cvterm_id stock_cvtermprop_type_id_fkey C

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.

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.

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.

Indexes

Constraint Name Type Sort Column(s)
stock_cvtermprop_pkey Primary key Asc stock_cvtermprop_id
stock_cvtermprop_c1 Must be unique Asc/Asc/Asc stock_cvterm_id + type_id + rank
stock_cvtermprop_idx1 Performance Asc stock_cvterm_id
stock_cvtermprop_idx2 Performance Asc type_id

Relationships