Schema Version: 1.3

pubauthor_contact


Description

An author on a publication may have a corresponding entry in the contact table and this table can link the two.

Columns

Column Type Size Foreign Key Nullable Default Comments
pubauthor_contact_id bigserial 19
nextval('chado.pubauthor_contact_pubauthor_contact_id_seq'::regclass)
contact_id int8 19
contact.contact_id pubauthor_contact_contact_id_fkey C
null
pubauthor_id int8 19
pubauthor.pubauthor_id pubauthor_contact_pubauthor_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
pubauthor_contact_pkey Primary key Asc pubauthor_contact_id
pubauthor_contact_c1 Must be unique Asc/Asc contact_id + pubauthor_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the pubauthor_contact table.

Show relationships within degrees of separation