Tables


SchemaSpy Analysis of omp_3_4_0

Generated on Tue Mar 07 13:55 GMT 2023

XML Representation
Insertion Order Deletion Order
TABLES 128
VIEWS 0
COLUMNS 857
Constraints 177
Anomalies 13
Routines 0

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 19 Table
series_categories 0 2 2 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 7 4 14 0 Table

Each publication is one version of a submission.

press_settings 0 1 5 0 Table
failed_jobs 0 0 6 0 Table

A log of all failed jobs.

spotlight_settings 0 1 5 0 Table
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 4 2 6 0 Table
scheduled_tasks 0 0 2 0 Table

The last time each scheduled task was run.

submission_chapters 9 4 6 0 Table
email_templates_default_data 0 0 5 117 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 19 Table
navigation_menu_item_settings 0 1 5 7 Table
users 18 0 21 1 Table

All registered users, including authentication data and profile data.

submission_files 11 6 15 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 13 0 Table

Monthly statistics matching the COUNTER R5 protocol for views and downloads of published submissions and files.

static_pages 0 0 3 0 Table
markets 0 1 17 0 Table
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 15 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
identification_codes 0 1 4 0 Table
job_batches 12 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.

submission_chapter_settings 0 1 5 0 Table
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
publication_dates 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 25 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
series_settings 0 1 4 0 Table
authors 4 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 files.

metrics_submission_geo_monthly 0 2 8 0 Table

Monthly statistics by country, region and city for views and downloads of published submissions and files.

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
features 0 1 4 0 Table
review_files 0 2 2 0 Table
usage_stats_institution_temporary_records 0 2 3 0 Table
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.

category_settings 0 1 4 0 Table
queued_payments 0 0 5 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
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 6 10 0 Table

Daily statistics for views and downloads of published submissions and files.

submission_chapter_authors 0 2 4 0 Table
submission_comments 0 2 11 0 Table
static_page_settings 0 0 5 0 Table
spotlights 1 1 4 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
publication_formats 11 2 29 0 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
publication_format_settings 0 1 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.

usage_stats_unique_title_requests_temporary_records 0 6 15 0 Table
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

presses 29 0 5 0 Table
new_releases 0 1 3 0 Table
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 31 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 6 15 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 5 1 4 0 Table
query_participants 0 2 2 0 Table

The users assigned to a discussion.

metrics_counter_submission_daily 0 3 14 0 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 15 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.

completed_payments 0 2 9 0 Table
announcement_settings 0 1 5 0 Table
metrics_counter_submission_institution_monthly 0 3 14 0 Table

Monthly statistics matching the COUNTER R5 protocol for views and downloads from institutions.

metrics_series 0 3 5 0 Table

Daily statistics for views of published submissions in each series.

series 5 2 9 0 Table
sales_rights 0 1 8 0 Table
usage_stats_total_temporary_records 0 7 17 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
representatives 0 1 10 0 Table
usage_stats_unique_title_investigations_temporary_records 0 6 15 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.

sessions 0 1 9 0 Table

Session data for logged-in users.

publication_categories 0 2 2 0 Table
plugin_settings 0 0 5 12 Table
citation_settings 0 1 5 0 Table
navigation_menus 1 0 4 1 Table