Schema Version: 1.3 Module: chado

feature_cvtermprop


Description

Extensible properties for feature 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 featureprop table for meanings of type_id, value and rank.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_cvtermprop_id bigserial 19
nextval('sequence.feature_cvtermprop_feature_cvtermprop_id_seq'::regclass)
feature_cvterm_id int8 19
feature_cvterm.feature_cvterm_id feature_cvtermprop_feature_cvterm_id_fkey C
null
type_id int8 19
cvterm.cvterm_id feature_cvtermprop_type_id_fkey C
null

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 feature_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.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_cvtermprop_pkey Primary key Asc feature_cvtermprop_id
feature_cvtermprop_c1 Must be unique Asc/Asc/Asc feature_cvterm_id + type_id + rank
feature_cvtermprop_idx1 Performance Asc feature_cvterm_id
feature_cvtermprop_idx2 Performance Asc type_id

Relationships

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

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation