issues

110 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
issue_id BIGINT 19 √ null
custom_issue_orders.issue_id Implied Constraint R
custom_section_orders.issue_id Implied Constraint R
issue_files.issue_id Implied Constraint R
issue_galleys.issue_id Implied Constraint R
issue_settings.issue_id Implied Constraint R
journal_id BIGINT 19 null
journals.journal_id Implied Constraint R
volume SMALLINT 5 √ NULL
number VARCHAR 40 √ NULL
year SMALLINT 5 √ NULL
published SMALLINT 5 0
current 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

Indexes

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

Relationships

Close relationships within degrees of separation