servers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
server_id bigserial 19 √ nextval('servers_server_id_seq'::regclass)
announcement_types.context_id announcement_types_context_id_foreignC
categories.context_id categories_context_id_foreignC
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_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
sections.server_id sections_server_id_foreignC
server_settings.server_id server_settings_server_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
user_group_stage.context_id user_group_stage_context_idC
path varchar 32 null
seq float8 17,17 '0'::double precision

Used to order lists of servers
primary_locale varchar 14 null
enabled int2 5 '1'::smallint

Controls whether or not the server is considered “live” and will appear on the website. (Note that disabled servers may still be accessible, but only if the user knows the URL.)

Indexes

Constraint Name Type Sort Column(s)
servers_pkey Primary key Asc server_id
servers_path Must be unique Asc path

Relationships

Close relationships within degrees of separation