featureprop

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Foreign Key

Nullable

Default

Comments

featureprop_id

bigserial

19

nextval('sequence.featureprop_featureprop_id_seq'::regclass)

feature_id

int8

19

feature.feature_id

featureprop_feature_id_fkey C

null

type_id

int8

19

cvterm.cvterm_id

featureprop_type_id_fkey C

null

The name of the property/slot is a cvterm. The meaning of the property is defined in that cvterm. Certain property types will only apply to certain feature types (e.g. the anticodon property will only apply to tRNA features) ; the types here come from the sequence feature property ontology.

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

10

0

Property-Value ordering. Any feature 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

Showing 1 to 5 of 5 entries

Table contained -1 rows

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
featureprop_pkey	Primary key	Asc	featureprop_id
featureprop_c1	Must be unique	Asc/Asc/Asc	feature_id + type_id + rank
featureprop_idx1	Performance	Asc	feature_id
featureprop_idx2	Performance	Asc	type_id

Showing 1 to 4 of 4 entries

Relationships

The following entity relationship (ER) diagram shows the relationships involving the featureprop table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Show relationships within degrees of separation