Schema Version: 1.3 Module: chado

featuremapprop


Description

A featuremap can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible.

Columns

Column Type Size Foreign Key Nullable Default Comments
featuremapprop_id bigserial 19
nextval('map.featuremapprop_featuremapprop_id_seq'::regclass)
featuremap_id int8 19
featuremap.featuremap_id featuremapprop_featuremap_id_fkey C
null
type_id int8 19
cvterm.cvterm_id featuremapprop_type_id_fkey C
null
value text 2147483647
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
featuremapprop_pkey Primary key Asc featuremapprop_id
featuremapprop_c1 Must be unique Asc/Asc/Asc featuremap_id + type_id + rank
featuremapprop_idx1 Performance Asc featuremap_id
featuremapprop_idx2 Performance Asc type_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the featuremapprop 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