publication_galleys


Description

Publication galleys are representations of a publication in a specific format, e.g. a PDF.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
galley_id BIGINT 19 √ null
metrics_submission.representation_id metrics_submission_representation_id_foreignC
publication_galley_settings.galley_id publication_galley_settings_galley_idC
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 BIGINT 19 null
publications.publication_id publication_galleys_publication_idC
label VARCHAR 255 √ NULL
submission_file_id BIGINT UNSIGNED 20 √ NULL
submission_files.submission_file_id publication_galleys_submission_file_id_foreignR
seq DOUBLE 8,2 0.00
remote_url VARCHAR 2047 √ NULL
is_approved SMALLINT 5 0
url_path VARCHAR 64 √ NULL
doi_id BIGINT 19 √ NULL
dois.doi_id publication_galleys_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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