presses


Description

A list of presses managed by the system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
press_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
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
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_series.context_id metrics_series_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
press_settings.press_id press_settings_press_id_foreignC
series.press_id series_press_idC
spotlights.press_id spotlights_press_id_foreignC
static_pages.context_id static_pages_context_idC
subeditor_submission_group.context_id section_editors_context_idC
submissions.context_id submissions_context_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
usage_stats_unique_title_investigations_temporary_records.context_id usti_context_id_foreignC
usage_stats_unique_title_requests_temporary_records.context_id ustr_context_id_foreignC
user_group_stage.context_id user_group_stage_context_idC
path VARCHAR 32 null
seq DOUBLE 8,2 0.00
primary_locale VARCHAR 14 null
enabled SMALLINT 5 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc press_id
press_path Must be unique Asc path

Relationships

Close relationships within degrees of separation