Database Properties
Database Type: PostgreSQL - 14.7 (Ubuntu 14.7-0ubuntu0.22.04.1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| review_form_element_settings | 0 | 1 | 5 | 0 | Table | |
| filters | 1 | 1 | 8 | 12 | Table | |
| sections | 2 | 2 | 12 | 0 | Table | |
| notification_settings | 0 | 1 | 5 | 0 | Table | |
| oai_resumption_tokens | 0 | 0 | 4 | 0 | Table | |
| review_round_files | 0 | 2 | 4 | 0 | Table | |
| publications | 6 | 4 | 11 | 0 | Table | Each publication is one version of a submission. |
| failed_jobs | 0 | 0 | 6 | 0 | Table | A log of all failed jobs. |
| review_rounds | 2 | 0 | 6 | 0 | Table | |
| citations | 1 | 1 | 4 | 0 | Table | |
| library_files | 1 | 2 | 11 | 0 | Table | |
| navigation_menu_item_assignments | 1 | 2 | 5 | 7 | Table | |
| filter_settings | 0 | 1 | 5 | 0 | Table | |
| categories | 3 | 2 | 6 | 0 | Table | |
| scheduled_tasks | 0 | 0 | 2 | 0 | Table | The last time each scheduled task was run. |
| email_templates_default_data | 0 | 0 | 5 | 46 | Table | Default email templates created for every installed locale. |
| email_templates | 1 | 1 | 4 | 0 | Table | Custom email templates created by each context, and overrides of the default templates. |
| filter_groups | 1 | 0 | 6 | 12 | Table | |
| navigation_menu_item_settings | 0 | 1 | 5 | 7 | Table | |
| users | 17 | 0 | 21 | 1 | Table | All registered users, including authentication data and profile data. |
| submission_files | 10 | 5 | 14 | 0 | 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 | 7 | 0 | Table | Monthly statistics matching the COUNTER R5 protocol for views and downloads of published submissions and galleys. |
| genres | 2 | 1 | 9 | 0 | 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 | 9 | 0 | Table | Daily statistics matching the COUNTER R5 protocol for views and downloads from institutions. |
| user_group_stage | 0 | 2 | 3 | 0 | Table | Which stages of the editorial workflow the user_groups can access. |
| submission_search_objects | 1 | 1 | 4 | 0 | Table | |
| review_assignments | 2 | 4 | 28 | 0 | Table | Data about peer review assignments for all submissions. |
| data_object_tombstone_settings | 0 | 1 | 5 | 0 | Table | |
| job_batches | 9 | 0 | 10 | 0 | Table | |
| announcement_types | 2 | 1 | 2 | 0 | Table | |
| publication_settings | 0 | 1 | 4 | 0 | Table | Localized data about publications, such as the title and abstract. |
| user_groups | 6 | 0 | 7 | 1 | Table | All defined user roles in a context, such as Author, Reviewer, Section Editor and Journal Manager. |
| notifications | 1 | 0 | 9 | 0 | Table | User notifications created during certain operations. |
| announcement_type_settings | 0 | 1 | 5 | 0 | Table | |
| notification_subscription_settings | 0 | 2 | 6 | 0 | Table | Which email notifications a user has chosen to unsubscribe from. |
| site | 0 | 0 | 6 | 1 | Table | |
| submissions | 20 | 2 | 11 | 0 | Table | All submissions submitted to the context, including incomplete, declined and unpublished submissions. |
| user_interests | 0 | 2 | 2 | 0 | Table | |
| access_keys | 0 | 1 | 6 | 0 | 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. |
| doi_settings | 0 | 1 | 4 | 0 | Table | |
| review_form_settings | 0 | 1 | 5 | 0 | Table | |
| authors | 2 | 2 | 6 | 0 | Table | The authors of a publication. |
| metrics_submission_geo_daily | 0 | 3 | 9 | 0 | Table | Daily statistics by country, region and city for views and downloads of published submissions and galleys. |
| metrics_submission_geo_monthly | 0 | 2 | 8 | 0 | Table | Monthly statistics by country, region and city for views and downloads of published submissions and galleys. |
| submission_file_revisions | 0 | 2 | 3 | 0 | Table | Revisions map submission_file entries to files on the data store. |
| email_log | 1 | 0 | 12 | 0 | Table | |
| review_files | 0 | 2 | 2 | 0 | Table | |
| usage_stats_institution_temporary_records | 0 | 2 | 3 | 0 | 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. |
| jobs | 0 | 0 | 7 | 0 | Table | All pending or in-progress jobs. |
| user_group_settings | 0 | 1 | 4 | 2 | Table | Localized data about user groups, such as the name. |
| servers | 24 | 0 | 5 | 0 | Table | |
| category_settings | 0 | 1 | 4 | 0 | Table | |
| publication_galley_settings | 0 | 1 | 4 | 0 | Table | |
| announcements | 1 | 1 | 6 | 0 | Table | |
| email_templates_settings | 0 | 1 | 4 | 0 | Table | Localized data about custom email templates, such as the subject and body. |
| library_file_settings | 0 | 1 | 5 | 0 | Table | |
| publication_galleys | 5 | 3 | 10 | 0 | Table | |
| user_user_groups | 0 | 2 | 2 | 1 | Table | Maps users to their assigned user_groups. |
| review_form_elements | 2 | 1 | 6 | 0 | Table | |
| metrics_submission | 0 | 5 | 9 | 0 | Table | Daily statistics for views and downloads of published submissions and galleys. |
| submission_comments | 0 | 2 | 11 | 0 | Table | |
| email_log_users | 0 | 2 | 2 | 0 | Table | |
| institution_settings | 0 | 1 | 4 | 0 | Table | |
| queries | 1 | 0 | 8 | 0 | Table | Discussions, usually related to a submission, created by editors, authors and other editorial staff. |
| institutions | 5 | 1 | 4 | 0 | Table | |
| data_object_tombstones | 2 | 0 | 6 | 0 | Table | Entries for published data that has been removed. Usually used in the OAI endpoint. |
| subeditor_submission_group | 0 | 3 | 5 | 0 | Table | |
| site_settings | 0 | 0 | 3 | 10 | Table | |
| author_settings | 0 | 1 | 4 | 0 | Table | Localized data about authors, such as their name and affiliation. |
| controlled_vocab_entries | 2 | 1 | 3 | 0 | 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 | 0 | Table | Localized data about submission files like published metadata. |
| files | 2 | 0 | 3 | 0 | Table | |
| event_log_settings | 0 | 1 | 4 | 0 | 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 | 4 | 0 | Table | Daily statistics for views of the homepage. |
| review_forms | 4 | 0 | 5 | 0 | Table | |
| data_object_tombstone_oai_set_objects | 0 | 1 | 4 | 0 | Table | |
| controlled_vocabs | 1 | 0 | 4 | 0 | 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 | 0 | Table | |
| review_form_responses | 0 | 2 | 4 | 0 | Table | |
| stage_assignments | 0 | 3 | 7 | 0 | 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 | 0 | Table | |
| navigation_menu_item_assignment_settings | 0 | 1 | 5 | 0 | Table | |
| submission_settings | 0 | 1 | 4 | 0 | Table | Localized data about submissions |
| user_settings | 0 | 1 | 4 | 2 | Table | Localized data about users, like their name and affiliation. |
| controlled_vocab_entry_settings | 0 | 1 | 5 | 0 | Table | Localized data about a controlled vocabulary entry, such as the actual word or phrase. |
| submission_search_object_keywords | 0 | 2 | 3 | 0 | Table | |
| versions | 0 | 0 | 11 | 19 | Table | Describes the installation and upgrade version history for the application and all installed plugins. |
| notes | 0 | 1 | 8 | 0 | Table | |
| usage_stats_unique_item_investigations_temporary_records | 0 | 5 | 14 | 0 | Table | Temporary stats on unique downloads based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| event_log | 1 | 1 | 8 | 0 | Table | A log of all events related to an object like a submission. |
| dois | 3 | 1 | 4 | 0 | Table | |
| query_participants | 0 | 2 | 2 | 0 | Table | The users assigned to a discussion. |
| metrics_counter_submission_daily | 0 | 3 | 8 | 0 | Table | Daily statistics matching the COUNTER R5 protocol for views and downloads of published submissions and galleys. |
| server_settings | 0 | 1 | 5 | 0 | Table | |
| usage_stats_unique_item_requests_temporary_records | 0 | 5 | 14 | 0 | Table | Temporary stats on unique views based on visitor log records. Data in this table is provisional. See the metrics_* tables for compiled stats. |
| announcement_settings | 0 | 1 | 5 | 0 | Table | |
| metrics_counter_submission_institution_monthly | 0 | 3 | 8 | 0 | Table | Monthly statistics matching the COUNTER R5 protocol for views and downloads from institutions. |
| usage_stats_total_temporary_records | 0 | 5 | 15 | 0 | 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 | 0 | Table | |
| edit_decisions | 0 | 3 | 8 | 0 | 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 | 5 | 0 | Table | Localized data about file genres, such as the genre name. |
| navigation_menu_items | 2 | 0 | 4 | 7 | Table | |
| sessions | 0 | 1 | 9 | 0 | Table | Session data for logged-in users. |
| publication_categories | 0 | 2 | 2 | 0 | Table | |
| plugin_settings | 0 | 0 | 5 | 10 | Table | |
| citation_settings | 0 | 1 | 5 | 0 | Table | |
| navigation_menus | 1 | 0 | 4 | 1 | Table | |
| section_settings | 0 | 1 | 4 | 0 | Table |