publication_galleys

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
galley_id bigserial 19 √ nextval('publication_galleys_galley_id_seq'::regclass)
metrics_submission.representation_id metrics_submission_representation_id_foreignC
publication_galley_settings.galley_id publication_galley_settings_galley_id_foreignR
usage_stats_total_temporary_records.representation_id ust_representation_id_foreignC
usage_stats_unique_item_investigations_temporary_records.representation_id usii_representation_id_foreignC
usage_stats_unique_item_requests_temporary_records.representation_id usir_representation_id_foreignC
locale varchar 14 √ null
publication_id int8 19 null
publications.publication_id publication_galleys_publication_idC
label varchar 255 √ null
submission_file_id int8 19 √ null
submission_files.submission_file_id publication_galleys_submission_file_id_foreignN
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
dois.doi_id publication_galleys_doi_id_foreignN

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

Relationships

Close relationships within degrees of separation