pub_relationship

0 rows


Description

Handle relationships between publications, eg, 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 (I think these three are it - at least for fb)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pub_relationship_id serial 10 √ nextval('pub_relationship_pub_relationship_id_seq'::regclass)
subject_id int4 10 null
pub.pub_id pub_relationship_subject_id_fkey C
object_id int4 10 null
pub.pub_id pub_relationship_object_id_fkey C
type_id int4 10 null
cvterm.cvterm_id pub_relationship_type_id_fkey C

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

Close relationships within degrees of separation