pubauthor

0 rows


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 Nulls Auto Default Children Parents Comments
pubauthor_id serial 10 nextval('pubauthor_pubauthor_id_seq'::regclass)
pub_id int4 10 null
pub.pub_id pubauthor_pub_id_fkey C
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

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_idx2 Performance Asc pub_id

Relationships