Schema Version: 1.3 Module: chado

feature_pubprop


Description

Property or attribute of a feature_pub link.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_pubprop_id bigserial 19
nextval('sequence.feature_pubprop_feature_pubprop_id_seq'::regclass)
feature_pub_id int8 19
feature_pub.feature_pub_id feature_pubprop_feature_pub_id_fkey C
null
type_id int8 19
cvterm.cvterm_id feature_pubprop_type_id_fkey C
null
value text 2147483647
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_pubprop_pkey Primary key Asc feature_pubprop_id
feature_pubprop_c1 Must be unique Asc/Asc/Asc feature_pub_id + type_id + rank
feature_pubprop_idx1 Performance Asc feature_pub_id

Relationships

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