Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
galley_id | bigserial | 19 | √ | nextval('publication_galleys_galley_id_seq'::regclass) |
|
|
||||||||||||
locale | varchar | 14 | √ | null |
|
|
||||||||||||
publication_id | int8 | 19 | null |
|
|
|||||||||||||
label | varchar | 255 | √ | null |
|
|
||||||||||||
submission_file_id | int8 | 19 | √ | null |
|
|
||||||||||||
seq | float8 | 17,17 | '0'::double precision |
|
|
|||||||||||||
remote_url | varchar | 2047 | √ | null |
|
|
||||||||||||
is_approved | int2 | 5 | '0'::smallint |
|
|
|||||||||||||
url_path | varchar | 64 | √ | null |
|
|
||||||||||||
doi_id | int8 | 19 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
publication_galleys_pkey | Primary key | Asc | galley_id |
publication_galleys_doi_id | Performance | Asc | doi_id |
publication_galleys_publication_id | Performance | Asc | publication_id |
publication_galleys_submission_file_id | Performance | Asc | submission_file_id |
publication_galleys_url_path | Performance | Asc | url_path |