Template:ChadoTable expression cvtermprop
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:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- 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.
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.