Database Properties
Database Type: MariaDB - 10.3.38-MariaDB-0ubuntu0.20.04.1
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| review_form_element_settings | 0 | 1 | 6 | Table | More data about review form elements, including localized content such as question text. |
| filters | 1 | 1 | 8 | Table | Filters represent a transformation of a supported piece of data from one form to another, such as a PHP object into an XML document. |
| series_categories | 0 | 2 | 2 | Table | A list of relationships between series and category information. |
| notification_settings | 0 | 1 | 6 | Table | More data about notifications, including localized properties. |
| oai_resumption_tokens | 0 | 0 | 5 | Table | OAI resumption tokens are used to allow for pagination of large result sets into manageable pieces. |
| review_round_files | 0 | 3 | 5 | Table | Records the files made available to reviewers for a round of reviews. These can be further customized on a per review basis with review_files. |
| publications | 7 | 4 | 14 | Table | Each publication is one version of a submission. |
| press_settings | 0 | 1 | 5 | Table | More data about presses, including localized properties such as policies. |
| failed_jobs | 0 | 0 | 6 | Table | A log of all failed jobs. |
| spotlight_settings | 0 | 1 | 6 | Table | More data about spotlights, including localized properties. |
| review_rounds | 3 | 1 | 6 | Table | Peer review assignments are organized into multiple rounds on a submission. |
| citations | 1 | 1 | 4 | Table | A citation made by an associated publication. |
| library_files | 1 | 2 | 11 | Table | Library files can be associated with the context (press/server/journal) or with individual submissions, and are typically forms, agreements, and other administrative documents that are not part of the scholarly content. |
| navigation_menu_item_assignments | 1 | 2 | 5 | Table | Links navigation menu items to navigation menus. |
| filter_settings | 0 | 1 | 6 | Table | More data about filters, including localized content. |
| scheduled_tasks | 0 | 0 | 3 | Table | The last time each scheduled task was run. |
| categories | 4 | 2 | 6 | Table | Categories permit the organization of submissions into a heirarchical structure. |
| submission_chapters | 9 | 4 | 6 | Table | A list of chapters for each submission (when submissions are divided into chapters). |
| email_templates_default_data | 0 | 0 | 6 | Table | Default email templates created for every installed locale. |
| email_templates | 1 | 1 | 4 | Table | Custom email templates created by each context, and overrides of the default templates. |
| filter_groups | 1 | 0 | 6 | Table | Filter groups are used to organized filters into named sets, which can be retrieved by the application for invocation. |
| navigation_menu_item_settings | 0 | 1 | 6 | Table | More data about navigation menu items, including localized content such as names. |
| users | 19 | 0 | 21 | Table | All registered users, including authentication data and profile data. |
| submission_files | 11 | 6 | 15 | Table | All files associated with a submission, such as those uploaded during submission, as revisions, or by copyeditors or layout editors for production. |
| metrics_counter_submission_monthly | 0 | 2 | 14 | Table | Monthly statistics matching the COUNTER R5 protocol for views and downloads of published submissions and files. |
| static_pages | 1 | 1 | 3 | Table | |
| markets | 0 | 1 | 17 | Table | ONIX market information for publication formats. |
| genres | 2 | 1 | 9 | Table | The types of submission files configured for each context, such as Article Text, Data Set, Transcript, etc. |
| metrics_counter_submission_institution_daily | 0 | 4 | 16 | Table | Daily statistics matching the COUNTER R5 protocol for views and downloads from institutions. |
| user_group_stage | 0 | 2 | 4 | Table | Which stages of the editorial workflow the user_groups can access. |
| submission_search_objects | 1 | 1 | 4 | Table | A list of all search objects indexed in the search index |
| review_assignments | 2 | 4 | 27 | Table | Data about peer review assignments for all submissions. |
| data_object_tombstone_settings | 0 | 1 | 6 | Table | More data about data object tombstones, including localized content. |
| identification_codes | 0 | 1 | 4 | Table | ONIX identification codes for publication formats. |
| job_batches | 12 | 0 | 10 | Table | Job batches allow jobs to be collected into groups for managed processing. |
| user_groups | 6 | 0 | 7 | Table | All defined user roles in a context, such as Author, Reviewer, Section Editor and Journal Manager. |
| publication_settings | 0 | 1 | 5 | Table | More data about publications, including localized properties such as the title and abstract. |
| announcement_types | 2 | 1 | 2 | Table | Announcement types allow for announcements to optionally be categorized. |
| submission_chapter_settings | 0 | 1 | 6 | Table | More information about submission chapters, including localized properties such as chapter titles. |
| notifications | 1 | 2 | 9 | Table | User notifications created during certain operations. |
| publication_dates | 0 | 1 | 5 | Table | ONIX publication dates for publication formats. |
| announcement_type_settings | 0 | 1 | 6 | Table | More data about announcement types, including localized properties like their names. |
| notification_subscription_settings | 0 | 2 | 6 | Table | Which email notifications a user has chosen to unsubscribe from. |
| site | 0 | 0 | 7 | Table | A singleton table describing basic information about the site. |
| submissions | 26 | 2 | 11 | Table | All submissions submitted to the context, including incomplete, declined and unpublished submissions. |
| user_interests | 0 | 2 | 3 | Table | Associates users with user interests (which are stored in the controlled vocabulary tables). |
| doi_settings | 0 | 1 | 5 | Table | More data about DOIs, including the registration agency. |
| access_keys | 0 | 1 | 6 | Table | Access keys are used to provide pseudo-login functionality for security-minimal tasks. Passkeys can be emailed directly to users, who can use them for a limited time in lieu of standard username and password. |
| review_form_settings | 0 | 1 | 6 | Table | More data about review forms, including localized content such as names. |
| series_settings | 0 | 1 | 5 | Table | More data about series, including localized properties such as series titles. |
| authors | 4 | 2 | 6 | Table | The authors of a publication. |
| metrics_submission_geo_daily | 0 | 3 | 10 | Table | Daily statistics by country, region and city for views and downloads of published submissions and files. |
| metrics_submission_geo_monthly | 0 | 2 | 9 | Table | Monthly statistics by country, region and city for views and downloads of published submissions and files. |
| submission_file_revisions | 0 | 2 | 3 | Table | Revisions map submission_file entries to files on the data store. |
| features | 0 | 1 | 5 | Table | Information about which submissions are featured in the press. |
| email_log | 1 | 0 | 12 | Table | A record of email messages that are sent in relation to an associated entity, such as a submission. |
| usage_stats_institution_temporary_records | 0 | 2 | 4 | Table | Temporary stats by institution. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| review_files | 0 | 2 | 3 | Table | A list of the submission files made available to each assigned reviewer. |
| jobs | 0 | 0 | 7 | Table | All pending or in-progress jobs. |
| user_group_settings | 0 | 1 | 5 | Table | More data about user groups, including localized properties such as the name. |
| category_settings | 0 | 1 | 5 | Table | More data about categories, including localized properties such as names. |
| queued_payments | 0 | 0 | 5 | Table | A list of queued (unfilled) payments, i.e. payments that have not yet been completed via an online payment system. |
| library_file_settings | 0 | 1 | 6 | Table | More data about library files, including localized content such as names. |
| email_templates_settings | 0 | 1 | 5 | Table | More data about custom email templates, including localized properties such as the subject and body. |
| announcements | 1 | 1 | 6 | Table | Announcements are messages that can be presented to users e.g. on the homepage. |
| user_user_groups | 0 | 2 | 3 | Table | Maps users to their assigned user_groups. |
| review_form_elements | 2 | 1 | 6 | Table | Each review form element represents a single question on a review form. |
| metrics_submission | 0 | 6 | 11 | Table | Daily statistics for views and downloads of published submissions and files. |
| submission_chapter_authors | 0 | 2 | 4 | Table | The list of authors associated with each submission chapter. |
| submission_comments | 0 | 2 | 11 | Table | Comments on a submission, e.g. peer review comments |
| static_page_settings | 0 | 1 | 6 | Table | |
| spotlights | 1 | 1 | 4 | Table | Information about which submissions to the press are spotlighted. |
| email_log_users | 0 | 2 | 3 | Table | A record of users associated with an email log entry. |
| institution_settings | 0 | 1 | 5 | Table | More data about institutions, including localized properties like names. |
| queries | 1 | 0 | 8 | Table | Discussions, usually related to a submission, created by editors, authors and other editorial staff. |
| institutions | 5 | 1 | 4 | Table | Institutions for statistics and subscriptions. |
| data_object_tombstones | 2 | 0 | 6 | Table | Entries for published data that has been removed. Usually used in the OAI endpoint. |
| subeditor_submission_group | 0 | 3 | 6 | Table | Subeditor assignments to e.g. sections and categories |
| site_settings | 0 | 0 | 4 | Table | More data about the site, including localized properties such as its name. |
| publication_formats | 11 | 2 | 28 | Table | Publication formats are representations of a publication in a particular format, e.g. PDF, hardcover, etc. Each publication format may contain many chapters. |
| author_settings | 0 | 1 | 5 | Table | More data about authors, including localized properties such as their name and affiliation. |
| controlled_vocab_entries | 2 | 1 | 3 | Table | The order that a word or phrase used in a controlled vocabulary should appear. For example, the order of keywords in a publication. |
| submission_file_settings | 0 | 1 | 5 | Table | Localized data about submission files like published metadata. |
| files | 2 | 0 | 3 | Table | Records information in the database about files tracked by the system, linking them to the local filesystem. |
| event_log_settings | 0 | 1 | 5 | Table | Data about an event log entry. This data is commonly used to display information about an event to a user. |
| metrics_context | 0 | 2 | 5 | Table | Daily statistics for views of the homepage. |
| review_forms | 4 | 0 | 5 | Table | Review forms provide custom templates for peer reviews with several types of questions. |
| publication_format_settings | 0 | 1 | 6 | Table | More data about publication formats, including localized properties. |
| data_object_tombstone_oai_set_objects | 0 | 1 | 4 | Table | Relationships between tombstones and other data that can be collected in OAI sets, e.g. sections. |
| controlled_vocabs | 1 | 0 | 4 | Table | Every word or phrase used in a controlled vocabulary. Controlled vocabularies are used for submission metadata like keywords and subjects, reviewer interests, and wherever a similar dictionary of words or phrases is required. Each entry corresponds to a word or phrase like “cellular reproduction” and a type like “submissionKeyword”. |
| temporary_files | 0 | 1 | 7 | Table | Temporary files, e.g. where files are kept during an upload process before they are moved somewhere more appropriate. |
| review_form_responses | 0 | 2 | 5 | Table | Each review form response records a reviewer’s answer to a review form element associated with a peer review. |
| usage_stats_unique_title_requests_temporary_records | 0 | 6 | 16 | Table | Temporary stats for unique title requests. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| stage_assignments | 0 | 3 | 7 | Table | Who can access a submission while it is in the editorial workflow. Includes all editorial and author assignments. For reviewers, see review_assignments. |
| institution_ip | 0 | 1 | 5 | Table | Records IP address ranges and associates them with institutions. |
| navigation_menu_item_assignment_settings | 0 | 1 | 6 | Table | More data about navigation menu item assignments to navigation menus, including localized content. |
| submission_settings | 0 | 1 | 5 | Table | Localized data about submissions |
| presses | 31 | 0 | 5 | Table | A list of presses managed by the system. |
| new_releases | 0 | 1 | 4 | Table | Information about which submissions in the press are considered new releases. |
| user_settings | 0 | 1 | 5 | Table | More data about users, including localized properties like their name and affiliation. |
| controlled_vocab_entry_settings | 0 | 1 | 6 | Table | More data about a controlled vocabulary entry, including localized properties such as the actual word or phrase. |
| submission_search_object_keywords | 0 | 2 | 4 | Table | Relationships between search objects and keywords in the search index |
| versions | 0 | 0 | 12 | Table | Describes the installation and upgrade version history for the application and all installed plugins. |
| usage_stats_unique_item_investigations_temporary_records | 0 | 6 | 16 | Table | Temporary stats on unique downloads based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| notes | 0 | 1 | 8 | Table | Notes allow users to annotate associated entities, such as submissions. |
| event_log | 1 | 1 | 8 | Table | A log of all events related to an object like a submission. |
| dois | 5 | 1 | 4 | Table | Stores all DOIs used in the system. |
| query_participants | 0 | 2 | 3 | Table | The users assigned to a discussion. |
| metrics_counter_submission_daily | 0 | 3 | 15 | Table | Daily statistics matching the COUNTER R5 protocol for views and downloads of published submissions and files. |
| usage_stats_unique_item_requests_temporary_records | 0 | 6 | 16 | Table | Temporary stats on unique views based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| completed_payments | 0 | 2 | 9 | Table | A list of completed (fulfilled) payments, with information about the type of payment and the entity it relates to. |
| announcement_settings | 0 | 1 | 5 | Table | More data about announcements, including localized properties like names and contents. |
| metrics_counter_submission_institution_monthly | 0 | 3 | 15 | Table | Monthly statistics matching the COUNTER R5 protocol for views and downloads from institutions. |
| metrics_series | 0 | 3 | 6 | Table | Daily statistics for views of published submissions in each series. |
| series | 5 | 2 | 9 | Table | A list of press series, into which submissions can be organized. |
| sales_rights | 0 | 1 | 8 | Table | ONIX sales rights for publication formats. |
| usage_stats_total_temporary_records | 0 | 7 | 18 | Table | Temporary stats totals based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| submission_search_keyword_list | 1 | 0 | 2 | Table | A list of all keywords used in the search index |
| edit_decisions | 0 | 3 | 8 | Table | Editorial decisions recorded on a submission, such as decisions to accept or decline the submission, as well as decisions to send for review, send to copyediting, request revisions, and more. |
| genre_settings | 0 | 1 | 6 | Table | More data about file genres, including localized properties such as the genre name. |
| navigation_menu_items | 2 | 0 | 4 | Table | Navigation menu items are single elements within a navigation menu. |
| representatives | 0 | 1 | 10 | Table | ONIX representatives for publication formats. |
| usage_stats_unique_title_investigations_temporary_records | 0 | 6 | 16 | Table | Temporary stats for views and downloads from institutions based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| sessions | 0 | 1 | 9 | Table | Session data for logged-in users. |
| publication_categories | 0 | 2 | 3 | Table | Associates publications (and thus submissions) with categories. |
| plugin_settings | 0 | 0 | 6 | Table | More data about plugins, including localized properties. This table is frequently used to store plugin-specific configuration. |
| navigation_menus | 1 | 0 | 4 | Table | Navigation menus on the website are installed with the software as a default set, and can be customized. |
| citation_settings | 0 | 1 | 6 | Table | Additional data about citations, including localized content. |