Schema Version: 1.3

pubauthor


Description

An author for a publication. Note the denormalisation (hence lack of _ in table name) - this is deliberate as it is in general too hard to assign IDs to authors.

Columns

Column Type Size Foreign Key Nullable Default Comments
pubauthor_id bigserial 19
nextval('chado.pubauthor_pubauthor_id_seq'::regclass)
pub_id int8 19
pub.pub_id pubauthor_pub_id_fkey C
null
rank int4 10
null

Order of author in author list for this pub - order is important.
editor bool 1
√ false

Indicates whether the author is an editor for linked publication. Note: this is a boolean field but does not follow the normal chado convention for naming booleans.
surname varchar 100
null
givennames varchar 100
√ null

First name, initials
suffix varchar 100
√ null

Jr., Sr., etc

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
pubauthor_pkey Primary key Asc pubauthor_id
pubauthor_c1 Must be unique Asc/Asc pub_id + rank
pubauthor_contact_idx1 Performance Asc pubauthor_id
pubauthor_idx2 Performance Asc pub_id

Relationships

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

Show relationships within degrees of separation