Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
publication_id | bigserial | 19 | √ | nextval('publications_publication_id_seq'::regclass) |
|
|
||||||||||||||||
date_published | date | 13 | √ | null |
|
|
||||||||||||||||
last_modified | timestamp | 22 | √ | null |
|
|
||||||||||||||||
primary_contact_id | int8 | 19 | √ | null |
|
|
||||||||||||||||
publication_date_type | varchar | 32 | √ | 'pub'::character varying |
|
|
||||||||||||||||
publication_type | varchar | 32 | √ | 'publication'::character varying |
|
|
||||||||||||||||
seq | float8 | 17,17 | '0'::double precision |
|
|
|||||||||||||||||
series_id | int8 | 19 | √ | null |
|
|
||||||||||||||||
series_position | varchar | 255 | √ | null |
|
|
||||||||||||||||
submission_id | int8 | 19 | null |
|
|
|||||||||||||||||
status | int2 | 5 | '1'::smallint |
|
|
|||||||||||||||||
url_path | varchar | 64 | √ | null |
|
|
||||||||||||||||
version | int8 | 19 | √ | null |
|
|
||||||||||||||||
doi_id | int8 | 19 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
publications_pkey | Primary key | Asc | publication_id |
publications_doi_id | Performance | Asc | doi_id |
publications_primary_contact_id | Performance | Asc | primary_contact_id |
publications_section_id | Performance | Asc | series_id |
publications_submission_id | Performance | Asc | submission_id |