Template:ChadoTable expression cvtermprop

From GMOD
Revision as of 08:36, 22 November 2010 by Clements (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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: expression_cvtermprop
Module: Expression

Extensible properties for expression to cvterm associations. Examples: qualifiers.

expression_cvtermprop columns
FK Name Type Description
expression_cvtermprop_id serial PRIMARY KEY


expression_cvterm expression_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. For example, cvterms may come from the FlyBase miscellaneous 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 expression_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 expression_cvtermprop via foreign key constraints:

  • None.