Columns
Column | Type | Size | Foreign Key | Nullable | Default | Comments | ||
---|---|---|---|---|---|---|---|---|
pub_id | bigserial | 19 |
|
nextval('pub.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 |