Template:ChadoTable feature relationshipprop

From GMOD
Revision as of 19:23, 24 November 2010 by Clements (Talk | contribs)

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_relationshipprop
Module: Sequence

Extensible properties for feature_relationships. Analagous structure to featureprop. This table is largely optional and not used with a high frequency. Typical scenarios may be if one wishes to attach additional data to a feature_relationship - for example to say that the feature_relationship is only true in certain contexts.

feature_relationshipprop columns
FK Name Type Description
feature_relationshipprop_id serial PRIMARY KEY
feature_relationship feature_relationship_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. Currently there is no standard ontology for feature_relationship property types.

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_relationship 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_relationshipprop via foreign key constraints: