issues


Description

A list of all journal issues, with identifying information like year, number, volume, etc.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
issue_id BIGINT 19 √ null
custom_issue_orders.issue_id custom_issue_orders_issue_idC
custom_section_orders.issue_id custom_section_orders_issue_idC
issue_files.issue_id issue_files_issue_idC
issue_galleys.issue_id issue_galleys_issue_idC
issue_settings.issue_id issue_settings_issue_idC
journals.current_issue_id journals_current_issue_id_foreignN
metrics_issue.issue_id metrics_issue_issue_id_foreignC
usage_stats_total_temporary_records.issue_id ust_issue_id_foreignC
journal_id BIGINT 19 null
journals.journal_id issues_journal_idC
volume SMALLINT 5 √ NULL
number VARCHAR 40 √ NULL
year SMALLINT 5 √ NULL
published SMALLINT 5 0
date_published DATETIME 19 √ NULL
date_notified DATETIME 19 √ NULL
last_modified DATETIME 19 √ NULL
access_status SMALLINT 5 1
open_access_date DATETIME 19 √ NULL
show_volume SMALLINT 5 0
show_number SMALLINT 5 0
show_year SMALLINT 5 0
show_title SMALLINT 5 0
style_file_name VARCHAR 90 √ NULL
original_style_file_name VARCHAR 255 √ NULL
url_path VARCHAR 64 √ NULL
doi_id BIGINT 19 √ NULL
dois.doi_id issues_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc issue_id
issues_doi_id Performance Asc doi_id
issues_journal_id Performance Asc journal_id
issues_url_path Performance Asc url_path

Relationships

Close relationships within degrees of separation