Template:ChadoTable feature cvtermprop

From GMOD
Jump to: navigation, search

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.


Table: feature_cvtermprop
Module: Sequence

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.

feature_cvtermprop columns
FK Name Type Description
feature_cvtermprop_id serial PRIMARY KEY
feature_cvterm feature_cvterm_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT 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 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 integer UNIQUE#1

NOT NULL
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.

Tables referencing feature_cvtermprop via foreign key constraints:

  • None.