issue_galleys


Description

Issue galleys are representations of the entire issue in a single file, such as a complete issue PDF.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
galley_id BIGINT 19 √ null
issue_galley_settings.galley_id issue_galleys_settings_galley_idC
metrics_issue.issue_galley_id metrics_issue_issue_galley_id_foreignC
usage_stats_total_temporary_records.issue_galley_id ust_issue_galley_id_foreignC
locale VARCHAR 14 √ NULL
issue_id BIGINT 19 null
issues.issue_id issue_galleys_issue_idC
file_id BIGINT 19 null
issue_files.file_id issue_galleys_file_idC
label VARCHAR 255 √ NULL
seq DOUBLE 8,2 0.00
url_path VARCHAR 64 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc galley_id
issue_galleys_file_id Performance Asc file_id
issue_galleys_issue_id Performance Asc issue_id
issue_galleys_url_path Performance Asc url_path

Relationships

Close relationships within degrees of separation