Table cxgn.public.feature_cvtermprop

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

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

feature_cvtermprop_id

serial

√

nextval('feature_cvtermprop_feature_cvtermprop_id_seq'::regclass)

feature_cvterm_id

int4

feature_cvterm.feature_cvterm_id

feature_cvtermprop_feature_cvterm_id_fkey

type_id

int4

cvterm.cvterm_id

feature_cvtermprop_type_id_fkey

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

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 0 rows at Fri Sep 05 01:31 EDT 2008

Indexes:

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