Project

General

Profile

1 Main Move the mouse over tables & columns to read the comments. Fk fk_experiment_expermenters experiments_experimenters ref experiments ( experiment ) experiment Fk fk_experiment_expermenters_0 experiments_experimenters ref experimenters ( experimenter_id ) experimenter_id Fk fk_job_files job_files ref jobs ( job_id ) job_id Fk fk_job_histories job_histories ref jobs ( job_id ) job_id Fk fk_campaign_recoveries campaign_recoveries ref recovery_types ( recovery_type_id ) recovery_type_id Fk fk_campaign_recoveries_0 campaign_recoveries ref job_types ( job_type_id ) job_type_id Fk fk_campaigns campaign_stages ref experiments ( experiment ) experiment Fk fk_campaigns_definitions campaign_stages ref job_types ( job_type_id ) job_type_id Fk fk_campaigns_updater campaign_stages ref experimenters ( updater -> experimenter_id ) updater Fk fk_campaigns_creator campaign_stages ref experimenters ( creator -> experimenter_id ) creator Fk fk_campaigns_launch_id campaign_stages ref login_setups ( login_setup_id ) login_setup_id Fk fk_campaign_dependencies_down campaign_dependencies ref campaign_stages ( provides_campaign_stage_id -> campaign_stage_id ) provides_campaign_stage_id Fk fk_campaign_dependencies_up campaign_dependencies ref campaign_stages ( needs_campaign_stage_id -> campaign_stage_id ) needs_campaign_stage_id Fk fk_jobs jobs ref submissions ( submission_id ) submission_id Fk fk_held_launches_experimenters held_launches ref experimenters ( launcher -> experimenter_id ) launcher Fk fk_held_launches_campaigns held_launches ref campaign_stages ( campaign_stage_id ) campaign_stage_id Fk fk_tasks submissions ref campaign_stages ( campaign_stage_id ) campaign_stage_id Fk fk_tasks_creator submissions ref experimenters ( creator -> experimenter_id ) creator Fk fk_tasks_updater submissions ref experimenters ( updater -> experimenter_id ) updater Fk fk_tasks_recovery_tasks_parent submissions ref submissions ( recovery_tasks_parent -> submission_id ) recovery_tasks_parent Fk fk_launch_templates_experiment login_setups ref experiments ( experiment ) experiment Fk fk_launch_templates_creator login_setups ref experimenters ( creator -> experimenter_id ) creator Fk fk_launch_templates_updater login_setups ref experimenters ( updater -> experimenter_id ) updater Fk fk_campaign_definitions job_types ref experiments ( experiment ) experiment Fk fk_campaign_definitions_creator job_types ref experimenters ( creator -> experimenter_id ) creator Fk fk_campaign_definitions_updater job_types ref experimenters ( updater -> experimenter_id ) updater Fk fk_tags_experiment campaigns ref experiments ( experiment ) experiment Fk fk_tags_experimenters campaigns ref experimenters ( creator -> experimenter_id ) creator Fk fk_campaigns_tags campaign_campaign_stages ref campaigns ( campaign_id ) campaign_id Fk fk_campaigns_tags_0 campaign_campaign_stages ref campaign_stages ( campaign_stage_id ) campaign_stage_id Fk fk_task_histories submission_histories ref submissions ( submission_id ) submission_id recovery_typesTable public.recovery_types Pk pk_recovery_type ( recovery_type_id ) recovery_type_idserialrecovery_type_id * serial Referred by campaign_recoveries ( recovery_type_id ) nametextname * text t descriptiontextdescription * text t experimentsTable public.experiments Pk pk_experiments ( experiment ) experimentvarchar(10)experiment * varchar(10) Acroynm for the experiment Referred by job_types ( experiment ) Referred by campaign_stages ( experiment ) Referred by experiments_experimenters ( experiment ) Referred by login_setups ( experiment ) Referred by campaigns ( experiment ) Unq idx_experiments_name ( name ) nametextname * text t restrictedboolrestricted bool default false b logbooktextlogbook text t snow_urltextsnow_url text t experiments_experimentersTable public.experiments_experimenters idx_experiment_expermenters ( experiment ) Pk pk_experiment_expermenters ( experimenter_id, experiment ) experimenttextexperiment * text References experiments ( experiment ) Pk pk_experiment_expermenters ( experimenter_id, experiment ) experimenter_idintegerexperimenter_id * integer References experimenters ( experimenter_id ) activeboolactive * bool default true b roletextrole * text default 'analysis'::text t experimentersTable public.experimenters Pk pk_expermenter ( experimenter_id ) experimenter_idserialexperimenter_id * serial Referred by job_types ( creator -> experimenter_id ) Referred by job_types ( updater -> experimenter_id ) Referred by campaign_stages ( updater -> experimenter_id ) Referred by campaign_stages ( creator -> experimenter_id ) Referred by experiments_experimenters ( experimenter_id ) Referred by held_launches ( launcher -> experimenter_id ) Referred by login_setups ( creator -> experimenter_id ) Referred by login_setups ( updater -> experimenter_id ) Referred by campaigns ( creator -> experimenter_id ) Referred by submissions ( creator -> experimenter_id ) Referred by submissions ( updater -> experimenter_id ) first_nametextfirst_name text t last_nametextlast_name * text t Unq idx_experimenters_username ( username ) usernametextusername * text t session_experimenttextsession_experiment * text t session_roletextsession_role * text default 'analysis'::text t last_logintimestamptzlast_login timestamptz default now() d rootboolroot bool default false b job_filesTable public.job_files Pk pk_output_files ( job_id, file_name, file_type ) job_idbigintjob_id * bigint References jobs ( job_id ) Pk pk_output_files ( job_id, file_name, file_type ) job_files_file_name_idx ( file_name ) file_nametextfile_name * text t Pk pk_output_files ( job_id, file_name, file_type ) file_typetextfile_type * text t createdtimestamptzcreated * timestamptz d declaredtimestamptzdeclared timestamptz d job_historiesTable public.job_histories Pk pk_job_histories ( job_id, created ) job_idbigintjob_id * bigint References jobs ( job_id ) Pk pk_job_histories ( job_id, created ) createdtimestamptzcreated * timestamptz d statustextstatus * text t campaign_recoveriesTable public.campaign_recoveries Pk pk_campaign_recoveries ( job_type_id, recovery_type_id, recovery_order ) job_type_idintegerjob_type_id * integer References job_types ( job_type_id ) idx_campaign_recoveries ( recovery_type_id ) Pk pk_campaign_recoveries ( job_type_id, recovery_type_id, recovery_order ) recovery_type_idintegerrecovery_type_id * integer References recovery_types ( recovery_type_id ) Pk pk_campaign_recoveries ( job_type_id, recovery_type_id, recovery_order ) recovery_orderintegerrecovery_order * integer # param_overridesjsonparam_overrides json default to_json('{}'::text) campaign_stagesTable public.campaign_stages Pk pk_campaigns ( campaign_stage_id ) campaign_stage_idserialcampaign_stage_id * serial Referred by campaign_dependencies ( provides_campaign_stage_id -> campaign_stage_id ) Referred by campaign_dependencies ( needs_campaign_stage_id -> campaign_stage_id ) Referred by campaign_stage_snapshots ( campaign_stage_id ) Referred by campaign_campaign_stages ( campaign_stage_id ) Referred by held_launches ( campaign_stage_id ) Referred by submissions ( campaign_stage_id ) idx_campaigns ( experiment ) Unq idx_campaigns_experiment_name ( experiment, name ) experimenttextexperiment * text References experiments ( experiment ) Unq idx_campaigns_experiment_name ( experiment, name ) nametextname * text t idx_campaigns_campaign_definition_id ( job_type_id ) job_type_idintegerjob_type_id * integer References job_types ( job_type_id ) vo_roletextvo_role * text t idx_campaigns_creator ( creator ) creatorintegercreator * integer References experimenters ( creator -> experimenter_id ) createdtimestamptzcreated * timestamptz d creator_roletextcreator_role * text t activeboolactive * bool default true b datasettextdataset * text t software_versiontextsoftware_version * text t idx_campaigns_launch_id ( login_setup_id ) login_setup_idintegerlogin_setup_id * integer References login_setups ( login_setup_id ) completion_typetextcompletion_type * text default 'located'::text t completion_pctintegercompletion_pct * integer default 95 # campaign_typetextcampaign_type * text t param_overridesjsonparam_overrides json test_param_overridesjsontest_param_overrides json idx_campaigns_updater ( updater ) updaterintegerupdater integer References experimenters ( updater -> experimenter_id ) updatedtimestamptzupdated timestamptz d cs_last_splitintegercs_last_split integer # cs_split_typetextcs_split_type text t cs_split_dimensionstextcs_split_dimensions text t hold_experimenter_idintegerhold_experimenter_id integer # role_held_withtextrole_held_with text t campaign_dependenciesTable public.campaign_dependencies Pk pk_campaign_dependencies ( campaign_dep_id ) campaign_dep_idserialcampaign_dep_id * serial # needs_campaign_stage_idintegerneeds_campaign_stage_id * integer References campaign_stages ( needs_campaign_stage_id -> campaign_stage_id ) provides_campaign_stage_idintegerprovides_campaign_stage_id * integer References campaign_stages ( provides_campaign_stage_id -> campaign_stage_id ) file_patternstextfile_patterns * text t jobsTable public.jobs Pk pk_jobs ( job_id ) idx_jobs_status ( status, job_id ) job_idbigserialjob_id * bigserial Referred by job_files ( job_id ) Referred by job_histories ( job_id ) idx_jobs_task_id ( submission_id ) idx_jobs_by_job_id_task_id ( submission_id, jobsub_job_id ) submission_idintegersubmission_id * integer References submissions ( submission_id ) idx_jobs_by_jobsub_job_id ( jobsub_job_id ) idx_jobs_by_job_id_task_id ( submission_id, jobsub_job_id ) jobsub_job_idtextjobsub_job_id * text t node_nametextnode_name * text t cpu_typetextcpu_type * text t host_sitetexthost_site * text t idx_jobs_status ( status, job_id ) statustextstatus * text t updatedtimestamptzupdated * timestamptz d output_files_declaredbooloutput_files_declared * bool default false b user_exe_exit_codeintegeruser_exe_exit_code integer # input_file_namestextinput_file_names text t reason_heldtextreason_held text t consumer_idtextconsumer_id text t cpu_timefloat8cpu_time float8 # wall_timefloat8wall_time float8 # held_launchesTable public.held_launches Pk pk_held_launches ( campaign_stage_id, created ) idx_held_launches_campaign_id ( campaign_stage_id ) campaign_stage_idintegercampaign_stage_id * integer References campaign_stages ( campaign_stage_id ) Pk pk_held_launches ( campaign_stage_id, created ) createdtimestamptzcreated * timestamptz d parent_submission_idintegerparent_submission_id integer # datasettextdataset text t param_overridesjsonparam_overrides json default to_json('{}'::text) idx_held_launches_launcher ( launcher ) launcherintegerlauncher integer References experimenters ( launcher -> experimenter_id ) submissionsTable public.submissions Pk pk_tasks ( submission_id ) submission_idserialsubmission_id * serial Referred by jobs ( submission_id ) Referred by submission_histories ( submission_id ) Referred by submissions ( recovery_tasks_parent -> submission_id ) idx_tasks ( campaign_stage_id ) campaign_stage_idintegercampaign_stage_id * integer References campaign_stages ( campaign_stage_id ) idx_tasks_creator ( creator ) creatorintegercreator * integer References experimenters ( creator -> experimenter_id ) createdtimestamptzcreated * timestamptz d idx_tasks_by_status ( status ) statustextstatus * text t idx_tasks_launch_snapshot_id ( launch_snapshot_id ) launch_snapshot_idintegerlaunch_snapshot_id * integer References launch_template_snapshots ( launch_snapshot_id ) idx_tasks_campaign_snapshot_id ( campaign_stage_snapshot_id ) campaign_stage_snapshot_idintegercampaign_stage_snapshot_id * integer References campaign_stage_snapshots ( campaign_stage_snapshot_id ) idx_tasks_campaign_definition_snap_id ( job_type_snapshot_id ) job_type_snapshot_idintegerjob_type_snapshot_id * integer References job_type_snapshots ( job_type_snapshot_id ) submission_paramsjsonsubmission_params json idx_tasks_depends_on ( depends_on ) depends_onintegerdepends_on integer # depend_thresholdintegerdepend_threshold integer # idx_tasks_updater ( updater ) updaterintegerupdater integer References experimenters ( updater -> experimenter_id ) updatedtimestamptzupdated timestamptz d command_executedtextcommand_executed text The actual command executed to produce the jobs. t projecttextproject text t recovery_positionintegerrecovery_position integer # idx_tasks_recovery_tasks_parent ( recovery_tasks_parent ) recovery_tasks_parentintegerrecovery_tasks_parent integer References submissions ( recovery_tasks_parent -> submission_id ) login_setupsTable public.login_setups Pk pk_launch_templates ( login_setup_id ) login_setup_idseriallogin_setup_id * serial Referred by campaign_stages ( login_setup_id ) Referred by launch_template_snapshots ( login_setup_id ) Unq idx_launch_templates_experiment_name ( experiment, name ) experimentvarchar(10)experiment * varchar(10) Acroynm for the experiment References experiments ( experiment ) launch_hosttextlaunch_host * text t launch_accounttextlaunch_account * text t launch_setuptextlaunch_setup * text t idx_launch_templates_creator ( creator ) creatorintegercreator * integer References experimenters ( creator -> experimenter_id ) createdtimestamptzcreated * timestamptz d creator_roletextcreator_role * text t idx_launch_templates_updater ( updater ) updaterintegerupdater integer References experimenters ( updater -> experimenter_id ) updatedtimestamptzupdated timestamptz d Unq idx_launch_templates_experiment_name ( experiment, name ) nametextname * text t job_typesTable public.job_types Pk pk_campaign_definitions ( job_type_id ) job_type_idserialjob_type_id * serial Referred by job_type_snapshots ( job_type_id ) Referred by campaign_recoveries ( job_type_id ) Referred by campaign_stages ( job_type_id ) idx_campaign_definitions_name ( name ) Unq idx_campaign_definitions_experiment ( experiment, name ) nametextname * text t Unq idx_campaign_definitions_experiment ( experiment, name ) experimenttextexperiment * text Acroynm for the experiment References experiments ( experiment ) launch_scripttextlaunch_script text t definition_parametersjsondefinition_parameters json input_files_per_jobintegerinput_files_per_job integer # output_files_per_jobintegeroutput_files_per_job integer # output_file_patternstextoutput_file_patterns text t idx_campaign_definitions_creator ( creator ) creatorintegercreator * integer References experimenters ( creator -> experimenter_id ) createdtimestamptzcreated * timestamptz d creator_roletextcreator_role * text t idx_campaign_definitions_updater ( updater ) updaterintegerupdater integer References experimenters ( updater -> experimenter_id ) updatedtimestamptzupdated timestamptz d campaignsTable public.campaigns Pk pk_tags ( campaign_id ) campaign_idserialcampaign_id * serial Referred by campaign_campaign_stages ( campaign_id ) idx_tags ( experiment ) Unq idx_tags_experiment_tag_name ( experiment, tag_name ) experimentvarchar(10)experiment * varchar(10) References experiments ( experiment ) Unq idx_tags_experiment_tag_name ( experiment, tag_name ) tag_namevarchar(100)tag_name * varchar(100) t idx_tags_created_by ( creator ) creatorintegercreator * integer References experimenters ( creator -> experimenter_id ) creator_roletextcreator_role * text t campaign_campaign_stagesTable public.campaign_campaign_stages Pk pk_campaign_tags ( campaign_stage_id, campaign_id ) idx_campaigns_tags_campaign_id ( campaign_stage_id ) campaign_stage_idintegercampaign_stage_id * integer References campaign_stages ( campaign_stage_id ) Pk pk_campaign_tags ( campaign_stage_id, campaign_id ) idx_campaigns_tags_tag_id ( campaign_id ) campaign_idintegercampaign_id * integer References campaigns ( campaign_id ) submission_historiesTable public.submission_histories Pk pk_task_histories ( submission_id, created ) submission_idintegersubmission_id * integer References submissions ( submission_id ) Pk pk_task_histories ( submission_id, created ) createdtimestamptzcreated * timestamptz d statustextstatus * text t May 31, 2018


Table campaign_campaign_stages

IndexesField NameData TypeDescription
* campaign_stage_id integer
* campaign_id integer
Indexes
pk_campaign_tags ON campaign_stage_id, campaign_id
idx_campaigns_tags_tag_id ON campaign_id
idx_campaigns_tags_campaign_id ON campaign_stage_id
Foreign Keys
fk_campaigns_tags ( campaign_id ) ref campaigns (campaign_id)
fk_campaigns_tags_0 ( campaign_stage_id ) ref campaign_stages (campaign_stage_id)


Table campaign_dependencies

IndexesField NameData TypeDescription
* campaign_dep_id serial
* needs_campaign_stage_id integer
* provides_campaign_stage_id integer
* file_patterns text
Indexes
pk_campaign_dependencies ON campaign_dep_id
Foreign Keys
fk_campaign_dependencies_down ( provides_campaign_stage_id ) ref campaign_stages (campaign_stage_id)
fk_campaign_dependencies_up ( needs_campaign_stage_id ) ref campaign_stages (campaign_stage_id)


Table campaign_recoveries

IndexesField NameData TypeDescription
* job_type_id integer
* recovery_type_id integer
* recovery_order integer
  param_overrides json DEFAULT to_json('{}'::text)
Indexes
idx_campaign_recoveries ON recovery_type_id
pk_campaign_recoveries ON job_type_id, recovery_type_id, recovery_order
Foreign Keys
fk_campaign_recoveries ( recovery_type_id ) ref recovery_types (recovery_type_id)
fk_campaign_recoveries_0 ( job_type_id ) ref job_types (job_type_id)


Table campaign_stages

IndexesField NameData TypeDescription
* campaign_stage_id serial
* experiment text
* name text
* job_type_id integer
* vo_role text
* creator integer
* created timestamptz
* creator_role text
* active bool DEFAULT true
* dataset text
* software_version text
* login_setup_id integer
* completion_type text DEFAULT 'located'::text
* completion_pct integer DEFAULT 95
* campaign_type text
  param_overrides json
  test_param_overrides json
updater integer
  updated timestamptz
  cs_last_split integer
  cs_split_type text
  cs_split_dimensions text
  hold_experimenter_id integer
  role_held_with text
Indexes
pk_campaigns ON campaign_stage_id
idx_campaigns ON experiment
idx_campaigns_creator ON creator
idx_campaigns_campaign_definition_id ON job_type_id
idx_campaigns_experiment_name ON experiment, name
idx_campaigns_updater ON updater
idx_campaigns_launch_id ON login_setup_id
Foreign Keys
fk_campaigns ( experiment ) ref experiments (experiment)
fk_campaigns_definitions ( job_type_id ) ref job_types (job_type_id)
fk_campaigns_updater ( updater ) ref experimenters (experimenter_id)
fk_campaigns_creator ( creator ) ref experimenters (experimenter_id)
fk_campaigns_launch_id ( login_setup_id ) ref login_setups (login_setup_id)
Constraints
  ch_completion_type (completion_type = 'located'::text) OR (completion_type = 'complete'::text)
  ck_completion_pct (completion_pct > 0) AND (completion_pct <= 100)
  ck_campaign_type (((campaign_type = 'test'::text) OR (campaign_type = 'data transfer'::text)) OR (campaign_type = 'keep up'::text)) OR (campaign_type = 'regular'::text)
  ck_creator_role (creator_role = 'analysis'::text) or (creator_role = 'production'::text)


Table campaigns

IndexesField NameData TypeDescription
* campaign_id serial
* experiment varchar( 10 )
* tag_name varchar( 100 )
* creator integer
* creator_role text
Indexes
pk_tags ON campaign_id
idx_tags ON experiment
idx_tags_experiment_tag_name ON experiment, tag_name
idx_tags_created_by ON creator
Foreign Keys
fk_tags_experiment ( experiment ) ref experiments (experiment)
fk_tags_experimenters ( creator ) ref experimenters (experimenter_id)
Constraints
  ck_creator_role (creator_role = 'analysis'::text) or (creator_role = 'production'::text)


Table experimenters

IndexesField NameData TypeDescription
* experimenter_id serial
  first_name text
* last_name text
* username text
* session_experiment text
* session_role text DEFAULT 'analysis'::text
  last_login timestamptz DEFAULT now()
  root bool DEFAULT false
Indexes
pk_expermenter ON experimenter_id
idx_experimenters_username ON username


Table experiments

IndexesField NameData TypeDescription
* experiment varchar( 10 ) Acroynm for the experiment
* name text
  restricted bool DEFAULT false
  logbook text
  snow_url text
Indexes
pk_experiments ON experiment
idx_experiments_name ON name


Table experiments_experimenters

IndexesField NameData TypeDescription
* experiment text
* experimenter_id integer
* active bool DEFAULT true
* role text DEFAULT 'analysis'::text
Indexes
idx_experiment_expermenters ON experiment
pk_experiment_expermenters ON experimenter_id, experiment
Foreign Keys
fk_experiment_expermenters ( experiment ) ref experiments (experiment)
fk_experiment_expermenters_0 ( experimenter_id ) ref experimenters (experimenter_id)
Constraints
  ck_role ((role = 'coordinator'::text) OR (role = 'production'::text)) OR (role = 'analysis'::text)


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 job_files

IndexesField NameData TypeDescription
* job_id bigint
* file_name text
* file_type text
* created timestamptz
  declared timestamptz
Indexes
pk_output_files ON job_id, file_name, file_type
job_files_file_name_idx ON file_name
Foreign Keys
fk_job_files ( job_id ) ref jobs (job_id)
Constraints
  check_file_type (file_type = 'input'::text) OR (file_type = 'output'::text) OR (file_type = 'log'::text)


Table job_histories

IndexesField NameData TypeDescription
* job_id bigint
* created timestamptz
* status text
Indexes
pk_job_histories ON job_id, created
Foreign Keys
fk_job_histories ( job_id ) ref jobs (job_id)


Table job_types

IndexesField NameData TypeDescription
* job_type_id serial
* name text
* experiment text Acroynm for the experiment
  launch_script text
  definition_parameters json
  input_files_per_job integer
  output_files_per_job integer
  output_file_patterns text
* creator integer
* created timestamptz
* creator_role text
updater integer
  updated timestamptz
Indexes
pk_campaign_definitions ON job_type_id
idx_campaign_definitions_name ON name
idx_campaign_definitions_creator ON creator
idx_campaign_definitions_updater ON updater
idx_campaign_definitions_experiment ON experiment, name
Foreign Keys
fk_campaign_definitions ( experiment ) ref experiments (experiment)
fk_campaign_definitions_creator ( creator ) ref experimenters (experimenter_id)
fk_campaign_definitions_updater ( updater ) ref experimenters (experimenter_id)
Constraints
  ck_creator_role (creator_role = 'analysis'::text) or (creator_role = 'production'::text)


Table jobs

IndexesField NameData TypeDescription
* job_id bigserial
* submission_id integer
* jobsub_job_id text
* node_name text
* cpu_type text
* host_site text
* status text
* updated timestamptz
* output_files_declared bool DEFAULT false
  user_exe_exit_code integer
  input_file_names text
  reason_held text
  consumer_id text
  cpu_time float8
  wall_time float8
Indexes
pk_jobs ON job_id
idx_jobs_task_id ON submission_id
idx_jobs_by_jobsub_job_id ON jobsub_job_id
idx_jobs_by_job_id_task_id ON submission_id, jobsub_job_id
idx_jobs_status ON status, job_id
Foreign Keys
fk_jobs ( submission_id ) ref submissions (submission_id)
Triggers
  update_job_history


Table login_setups

IndexesField NameData TypeDescription
* login_setup_id serial
* experiment varchar( 10 ) Acroynm for the experiment
* launch_host text
* launch_account text
* launch_setup text
* creator integer
* created timestamptz
* creator_role text
updater integer
  updated timestamptz
* name text
Indexes
pk_launch_templates ON login_setup_id
idx_launch_templates_creator ON creator
idx_launch_templates_updater ON updater
idx_launch_templates_experiment_name ON experiment, name
Foreign Keys
fk_launch_templates_experiment ( experiment ) ref experiments (experiment)
fk_launch_templates_creator ( creator ) ref experimenters (experimenter_id)
fk_launch_templates_updater ( updater ) ref experimenters (experimenter_id)
Constraints
  ck_creator_role (creator_role = 'analysis'::text) or (creator_role = 'production'::text)


Table recovery_types

IndexesField NameData TypeDescription
* recovery_type_id serial
* name text
* description text
Indexes
pk_recovery_type ON recovery_type_id


Table submission_histories

IndexesField NameData TypeDescription
* submission_id integer
* created timestamptz
* status text
Indexes
pk_task_histories ON submission_id, created
Foreign Keys
fk_task_histories ( submission_id ) ref submissions (submission_id)


Table submissions

IndexesField NameData TypeDescription
* submission_id serial
* campaign_stage_id integer
* creator integer
* created timestamptz
* status text
* launch_snapshot_id integer
* campaign_stage_snapshot_id integer
* job_type_snapshot_id integer
  submission_params json
depends_on integer
  depend_threshold integer
updater integer
  updated timestamptz
  command_executed text The actual command executed to produce the jobs.
  project text
  recovery_position integer
recovery_tasks_parent integer
Indexes
pk_tasks ON submission_id
idx_tasks ON campaign_stage_id
idx_tasks_depends_on ON depends_on
idx_tasks_creator ON creator
idx_tasks_updater ON updater
idx_tasks_launch_snapshot_id ON launch_snapshot_id
idx_tasks_campaign_snapshot_id ON campaign_stage_snapshot_id
idx_tasks_campaign_definition_snap_id ON job_type_snapshot_id
idx_tasks_recovery_tasks_parent ON recovery_tasks_parent
idx_tasks_by_status ON status
Foreign Keys
fk_tasks ( campaign_stage_id ) ref campaign_stages (campaign_stage_id)
fk_tasks_creator ( creator ) ref experimenters (experimenter_id)
fk_tasks_updater ( updater ) ref experimenters (experimenter_id)
fk_tasks_launch_snapshot_id ( launch_snapshot_id ) ref launch_template_snapshots (launch_snapshot_id)
fk_tasks_campaign_snapshot_id ( campaign_stage_snapshot_id ) ref campaign_stage_snapshots (campaign_stage_snapshot_id)
fk_tasks_campaign_definition_snap_id ( job_type_snapshot_id ) ref job_type_snapshots (job_type_snapshot_id)
fk_tasks_recovery_tasks_parent ( recovery_tasks_parent ) ref submissions (submission_id)
Triggers
  update_submission_history
  update_submission_history

Powered by DbSchema