feature_cvterm_pub

0 rows


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 Nulls Auto Default Children Parents Comments
feature_cvterm_pub_id serial 10 √ nextval('feature_cvterm_pub_feature_cvterm_pub_id_seq'::regclass)
feature_cvterm_id int4 10 null
feature_cvterm.feature_cvterm_id feature_cvterm_pub_feature_cvterm_id_fkey C
pub_id int4 10 null
pub.pub_id feature_cvterm_pub_pub_id_fkey C

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

Close relationships within degrees of separation