Table cxgn.public.pub_relationship

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)

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

pub_relationship_id

serial

√

nextval('pub_relationship_pub_relationship_id_seq'::regclass)

subject_id

int4

pub.pub_id

pub_relationship_subject_id_fkey

object_id

int4

pub.pub_id

pub_relationship_object_id_fkey

type_id

int4

cvterm.cvterm_id

pub_relationship_type_id_fkey

Table contained 0 rows at Wed May 20 01:40 EDT 2009

Indexes:

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