Columns
| Table | Type | Column | Type | Size | Nulls | Default | Comments |
|---|---|---|---|---|---|---|---|
| pub_relationship | Table | pub_relationship_id | bigserial | 19 | nextval('pub.pub_relationship_pub_relationship_id_seq'::regclass) | ||
| pubauthor | Table | givennames | varchar | 100 | √ | null | First name, initials |
| pubprop | Table | rank | int4 | 10 | √ | null | |
| pub | Table | volumetitle | text | 2147483647 | √ | null | Title of part if one of a series. |
| pub_dbxref | Table | dbxref_id | int8 | 19 | null | ||
| pub | Table | pub_id | bigserial | 19 | nextval('pub.pub_pub_id_seq'::regclass) | ||
| pub_dbxref | Table | pub_dbxref_id | bigserial | 19 | nextval('pub.pub_dbxref_pub_dbxref_id_seq'::regclass) | ||
| pubauthor | Table | suffix | varchar | 100 | √ | null | Jr., Sr., etc |
| pubauthor | Table | pub_id | int8 | 19 | null | ||
| pub | Table | pages | varchar | 255 | √ | null | Page number ranges, e.g. 457--459, viii + 664pp, lv--lvii. |
| pub | Table | publisher | varchar | 255 | √ | null | |
| pubauthor_contact | Table | contact_id | int8 | 19 | null | ||
| pub | Table | pubplace | varchar | 255 | √ | null | |
| pub | Table | issue | varchar | 255 | √ | null | |
| pubauthor | Table | rank | int4 | 10 | null | Order of author in author list for this pub - order is important. |
|
| pub | Table | miniref | varchar | 255 | √ | null | |
| pub | Table | type_id | int8 | 19 | null | The type of the publication (book, journal, poem, graffiti, etc). Uses pub cv. |
|
| pub_dbxref | Table | pub_id | int8 | 19 | null | ||
| pubauthor | Table | 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. |
| pub_relationship | Table | type_id | int8 | 19 | null | ||
| pub | Table | is_obsolete | bool | 1 | √ | false | |
| pubauthor_contact | Table | pubauthor_id | int8 | 19 | null | ||
| pubprop | Table | value | text | 2147483647 | null | ||
| pub | Table | series_name | varchar | 255 | √ | null | Full name of (journal) series. |
| pubauthor_contact | Table | pubauthor_contact_id | bigserial | 19 | nextval('pub.pubauthor_contact_pubauthor_contact_id_seq'::regclass) | ||
| pub_relationship | Table | object_id | int8 | 19 | null | ||
| pub | Table | title | text | 2147483647 | √ | null | Descriptive general heading. |
| pub_relationship | Table | subject_id | int8 | 19 | null | ||
| pubprop | Table | pub_id | int8 | 19 | null | ||
| pub | Table | pyear | varchar | 255 | √ | null | |
| pub_dbxref | Table | is_current | bool | 1 | true | ||
| pubauthor | Table | pubauthor_id | bigserial | 19 | nextval('pub.pubauthor_pubauthor_id_seq'::regclass) | ||
| pub | Table | uniquename | text | 2147483647 | null | ||
| pubprop | Table | type_id | int8 | 19 | null | ||
| pubauthor | Table | surname | varchar | 100 | null | ||
| pubprop | Table | pubprop_id | bigserial | 19 | nextval('pub.pubprop_pubprop_id_seq'::regclass) | ||
| pub | Table | volume | varchar | 255 | √ | null |