Columns
| Column | Type | Size | Foreign Key | Nullable | Default | Comments | ||
|---|---|---|---|---|---|---|---|---|
| pub_id | bigserial | 19 |
|
nextval('chado.pub_pub_id_seq'::regclass) | ||||
| title | text | 2147483647 |
|
√ | null | Descriptive general heading. |
||
| volumetitle | text | 2147483647 |
|
√ | null | Title of part if one of a series. |
||
| volume | varchar | 255 |
|
√ | null | |||
| series_name | varchar | 255 |
|
√ | null | Full name of (journal) series. |
||
| issue | varchar | 255 |
|
√ | null | |||
| pyear | varchar | 255 |
|
√ | null | |||
| pages | varchar | 255 |
|
√ | null | Page number ranges, e.g. 457--459, viii + 664pp, lv--lvii. |
||
| miniref | varchar | 255 |
|
√ | null | |||
| uniquename | text | 2147483647 |
|
null | ||||
| type_id | int8 | 19 |
|
null | The type of the publication (book, journal, poem, graffiti, etc). Uses pub cv. |
|||
| is_obsolete | bool | 1 |
|
√ | false | |||
| publisher | varchar | 255 |
|
√ | null | |||
| pubplace | varchar | 255 |
|
√ | null |
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pub_pkey | Primary key | Asc | pub_id |
| pub_c1 | Must be unique | Asc | uniquename |
| pub_idx1 | Performance | Asc | type_id |
Relationships
The following entity relationship (ER) diagram shows the relationships involving the pub table.
Show relationships within degrees of separation
