journals


Description

A list of all journals in the installation of OJS.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
journal_id BIGINT 19 √ null
announcement_types.context_id announcement_types_context_id_foreignC
categories.context_id categories_context_id_foreignC
completed_payments.context_id completed_payments_context_idC
custom_issue_orders.journal_id custom_issue_orders_journal_idC
dois.context_id dois_context_id_foreignC
email_templates.context_id email_templates_context_id_foreignC
genres.context_id genres_context_id_foreignC
institutions.context_id institutions_context_id_foreignC
issues.journal_id issues_journal_idC
journal_settings.journal_id journal_settings_journal_idC
library_files.context_id library_files_context_idC
metrics_context.context_id metrics_context_context_id_foreignC
metrics_counter_submission_daily.context_id msd_context_id_foreignC
metrics_counter_submission_institution_daily.context_id msid_context_id_foreignC
metrics_counter_submission_institution_monthly.context_id msim_context_id_foreignC
metrics_counter_submission_monthly.context_id msm_context_id_foreignC
metrics_issue.context_id metrics_issue_context_id_foreignC
metrics_submission.context_id metrics_submission_context_id_foreignC
metrics_submission_geo_daily.context_id msgd_context_id_foreignC
metrics_submission_geo_monthly.context_id msgm_context_id_foreignC
notification_subscription_settings.context notification_subscription_settings_context_foreignC
notifications.context_id notifications_context_id_foreignC
sections.journal_id sections_journal_idC
static_pages.context_id static_pages_context_idC
subeditor_submission_group.context_id section_editors_context_idC
submissions.context_id submissions_context_idC
subscription_types.journal_id subscription_types_journal_idC
subscriptions.journal_id subscriptions_journal_idC
usage_stats_total_temporary_records.context_id ust_context_id_foreignC
usage_stats_unique_item_investigations_temporary_records.context_id usii_context_id_foreignC
usage_stats_unique_item_requests_temporary_records.context_id usir_context_id_foreignC
user_group_stage.context_id user_group_stage_context_idC
path VARCHAR 32 null
seq DOUBLE 8,2 0.00

Used to order lists of journals
primary_locale VARCHAR 14 null
enabled SMALLINT 5 1

Controls whether or not the journal is considered “live” and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.)
current_issue_id BIGINT 19 √ NULL
issues.issue_id journals_current_issue_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc journal_id
journals_issue_id Performance Asc current_issue_id
journals_path Must be unique Asc path

Relationships

Close relationships within degrees of separation