Table cxgn.public.pubauthor

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.

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
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
pubauthor_id serial 10  √  nextval('pubauthor_pubauthor_id_seq'::regclass)
pub_id int4 10
pub.pub_id pubauthor_pub_id_fkey
rank int4 10 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
givennames varchar 100  √  null first name, initials
suffix varchar 100  √  null Jr., Sr., etc

Table contained 54,885 rows at Wed May 20 01:40 EDT 2009

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

Close relationships  within one two degrees of separation :