Project

General

Profile

1 Misc Move the mouse over tables & columns to read the comments. Fk fk_services services ref services ( parent_service_id -> service_id ) parent_service_id Fk fk_service_downtimes service_downtimes ref services ( service_id ) service_id servicesTable public.services Pk pk_services ( service_id ) service_idservice_id * serial Referred by service_downtimes ( service_id ) Referred by services ( parent_service_id -> service_id ) namename * text t host_sitehost_site * text t statusstatus * text t updatedupdated * timestamptz d activeactive * bool default true b descriptiondescription text t idx_services_parent_service_id ( parent_service_id ) parent_service_idparent_service_id integer References services ( parent_service_id -> service_id ) urlurl text t itemsitems integer # failed_itemsfailed_items integer # service_downtimesTable public.service_downtimes Pk pk_service_downtimes ( service_id, downtime_started ) service_idservice_id * integer References services ( service_id ) downtime_typedowntime_type * text t Pk pk_service_downtimes ( service_id, downtime_started ) downtime_starteddowntime_started * timestamptz d downtime_endeddowntime_ended timestamptz d faulty_requestsTable public.faulty_requests Pk faulty_requests_pkey ( url, last_seen ) urlurl * text t Pk faulty_requests_pkey ( url, last_seen ) last_seenlast_seen * timestamptz default now() d statusstatus integer # messagemessage text t ntriesntries integer # held_launchesTable public.held_launches Pk pk_held_launches ( campaign_stage_id, created ) idx_held_launches_campaign_id ( campaign_stage_id ) campaign_stage_idcampaign_stage_id * integer References campaign_stages ( campaign_stage_id ) Pk pk_held_launches ( campaign_stage_id, created ) createdcreated * timestamptz d parent_submission_idparent_submission_id integer # datasetdataset text t param_overridesparam_overrides json default to_json('{}'::text) idx_held_launches_launcher ( launcher ) launcherlauncher integer References experimenters ( launcher -> experimenter_id ) May 31, 2018


Table faulty_requests

IndexesField NameData TypeDescription
* url text
* last_seen timestamptz DEFAULT now()
  status integer
  message text
  ntries integer
Indexes
faulty_requests_pkey ON url, last_seen


Table held_launches

IndexesField NameData TypeDescription
* campaign_stage_id integer
* created timestamptz
  parent_submission_id integer
  dataset text
  param_overrides json DEFAULT to_json('{}'::text)
launcher integer
Indexes
pk_held_launches ON campaign_stage_id, created
idx_held_launches_launcher ON launcher
idx_held_launches_campaign_id ON campaign_stage_id
Foreign Keys
fk_held_launches_experimenters ( launcher ) ref experimenters (experimenter_id)
fk_held_launches_campaigns ( campaign_stage_id ) ref campaign_stages (campaign_stage_id)


Table service_downtimes

IndexesField NameData TypeDescription
* service_id integer
* downtime_type text
* downtime_started timestamptz
  downtime_ended timestamptz
Indexes
pk_service_downtimes ON service_id, downtime_started
Foreign Keys
fk_service_downtimes ( service_id ) ref services (service_id)
Constraints
  ck_downtime_type downtime_type::text = ANY (ARRAY['actual'::character varying, 'scheduled'::character varying]::text[])


Table services

IndexesField NameData TypeDescription
* service_id serial
* name text
* host_site text
* status text
* updated timestamptz
* active bool DEFAULT true
  description text
parent_service_id integer
  url text
  items integer
  failed_items integer
Indexes
pk_services ON service_id
idx_services_parent_service_id ON parent_service_id
Foreign Keys
fk_services ( parent_service_id ) ref services (service_id)

Powered by DbSchema