Schema Version: 1.3 Module: chado

feature_cvterm_pub


Description

Secondary pubs for an association. Each feature_cvterm association is supported by a single primary publication. Additional secondary pubs can be added using this linking table (in a GO gene association file, these corresponding to any IDs after the pipe symbol in the publications column.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_cvterm_pub_id bigserial 19
nextval('sequence.feature_cvterm_pub_feature_cvterm_pub_id_seq'::regclass)
feature_cvterm_id int8 19
feature_cvterm.feature_cvterm_id feature_cvterm_pub_feature_cvterm_id_fkey C
null
pub_id int8 19
pub.pub_id feature_cvterm_pub_pub_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_cvterm_pub_pkey Primary key Asc feature_cvterm_pub_id
feature_cvterm_pub_c1 Must be unique Asc/Asc feature_cvterm_id + pub_id
feature_cvterm_pub_idx1 Performance Asc feature_cvterm_id
feature_cvterm_pub_idx2 Performance Asc pub_id

Relationships

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