Schema Version: 1.3

pub_relationship


Description

Handle relationships between publications, e.g. when one publication makes others obsolete, when one publication contains errata with respect to other publication(s), or when one publication also appears in another pub.

Columns

Column Type Size Foreign Key Nullable Default Comments
pub_relationship_id bigserial 19
nextval('chado.pub_relationship_pub_relationship_id_seq'::regclass)
subject_id int8 19
pub.pub_id pub_relationship_subject_id_fkey C
null
object_id int8 19
pub.pub_id pub_relationship_object_id_fkey C
null
type_id int8 19
cvterm.cvterm_id pub_relationship_type_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
pub_relationship_pkey Primary key Asc pub_relationship_id
pub_relationship_c1 Must be unique Asc/Asc/Asc subject_id + object_id + type_id
pub_relationship_idx1 Performance Asc subject_id
pub_relationship_idx2 Performance Asc object_id
pub_relationship_idx3 Performance Asc type_id

Relationships