Project

General

Profile

1 Snapshots Move the mouse over tables & columns to read the comments. Fk fk_launch_template_snapshots launch_template_snapshots ref login_setups ( login_setup_id ) login_setup_id Fk fk_campaign_snapshots campaign_stage_snapshots ref campaign_stages ( campaign_stage_id ) campaign_stage_id Fk fk_campaigns_definitions campaign_stages ref job_types ( job_type_id ) job_type_id Fk fk_campaigns_launch_id campaign_stages ref login_setups ( login_setup_id ) login_setup_id Fk fk_tasks submissions ref campaign_stages ( campaign_stage_id ) campaign_stage_id Fk fk_tasks_launch_snapshot_id submissions ref launch_template_snapshots ( launch_snapshot_id ) launch_snapshot_id Fk fk_tasks_campaign_snapshot_id submissions ref campaign_stage_snapshots ( campaign_stage_snapshot_id ) campaign_stage_snapshot_id Fk fk_tasks_campaign_definition_snap_id submissions ref job_type_snapshots ( job_type_snapshot_id ) job_type_snapshot_id Fk fk_tasks_recovery_tasks_parent submissions ref submissions ( recovery_tasks_parent -> submission_id ) recovery_tasks_parent Fk fk_campaign_definition_snapshots job_type_snapshots ref job_types ( job_type_id ) job_type_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 launch_template_snapshotsTable public.launch_template_snapshots Pk pk_launch_template_snapshots ( launch_snapshot_id ) launch_snapshot_idseriallaunch_snapshot_id * serial Referred by submissions ( launch_snapshot_id ) idx_launch_template_snapshots_launch_id ( login_setup_id ) login_setup_idintegerlogin_setup_id * integer References login_setups ( login_setup_id ) experimentvarchar(10)experiment * varchar(10) Acroynm for the experiment t launch_hosttextlaunch_host * text t launch_accounttextlaunch_account * text t launch_setuptextlaunch_setup * text t creatorintegercreator * integer # createdtimestamptzcreated * timestamptz d updaterintegerupdater integer # updatedtimestamptzupdated timestamptz d nametextname * text t campaign_stage_snapshotsTable public.campaign_stage_snapshots Pk idx_campaign_snapshots ( campaign_stage_snapshot_id ) campaign_stage_snapshot_idserialcampaign_stage_snapshot_id * serial Referred by submissions ( campaign_stage_snapshot_id ) idx_campaign_snapshots_campaign_id ( campaign_stage_id ) campaign_stage_idintegercampaign_stage_id * integer References campaign_stages ( campaign_stage_id ) experimenttextexperiment * text t nametextname * text t job_type_idintegerjob_type_id * integer # vo_roletextvo_role * text t creatorintegercreator * integer # createdtimestamptzcreated * timestamptz d activeboolactive * bool default true b datasettextdataset * text t software_versiontextsoftware_version * text t login_setup_idintegerlogin_setup_id * integer # completion_typetextcompletion_type * text default 'located'::text t completion_pctintegercompletion_pct * integer default 95 # param_overridesjsonparam_overrides json test_param_overridesjsontest_param_overrides json updaterintegerupdater integer # updatedtimestamptzupdated timestamptz d cs_last_splitintegercs_last_split integer # cs_split_typetextcs_split_type text t cs_split_dimensionstextcs_split_dimensions text t 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 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 ) job_type_snapshotsTable public.job_type_snapshots Pk pk_campaign_definition_snapshots ( job_type_snapshot_id ) job_type_snapshot_idserialjob_type_snapshot_id * serial Referred by submissions ( job_type_snapshot_id ) idx_campaign_definition_snapshots_name ( job_type_id ) job_type_idintegerjob_type_id * integer References job_types ( job_type_id ) nametextname * text t experimenttextexperiment * text Acroynm for the experiment t 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 creatorintegercreator * integer # createdtimestamptzcreated * timestamptz d updaterintegerupdater integer # updatedtimestamptzupdated timestamptz d May 31, 2018


Table campaign_stage_snapshots

IndexesField NameData TypeDescription
* campaign_stage_snapshot_id serial
* campaign_stage_id integer
* experiment text
* name text
* job_type_id integer
* vo_role text
* creator integer
* created timestamptz
* active bool DEFAULT true
* dataset text
* software_version text
* login_setup_id integer
* completion_type text DEFAULT 'located'::text
* completion_pct integer DEFAULT 95
  param_overrides json
  test_param_overrides json
  updater integer
  updated timestamptz
  cs_last_split integer
  cs_split_type text
  cs_split_dimensions text
Indexes
idx_campaign_snapshots ON campaign_stage_snapshot_id
idx_campaign_snapshots_campaign_id ON campaign_stage_id
Foreign Keys
fk_campaign_snapshots ( campaign_stage_id ) ref campaign_stages (campaign_stage_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 job_type_snapshots

IndexesField NameData TypeDescription
* job_type_snapshot_id serial
* job_type_id integer
* 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
  updater integer
  updated timestamptz
Indexes
pk_campaign_definition_snapshots ON job_type_snapshot_id
idx_campaign_definition_snapshots_name ON job_type_id
Foreign Keys
fk_campaign_definition_snapshots ( job_type_id ) ref job_types (job_type_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 launch_template_snapshots

IndexesField NameData TypeDescription
* launch_snapshot_id serial
* login_setup_id integer
* experiment varchar( 10 ) Acroynm for the experiment
* launch_host text
* launch_account text
* launch_setup text
* creator integer
* created timestamptz
  updater integer
  updated timestamptz
* name text
Indexes
idx_launch_template_snapshots_launch_id ON login_setup_id
pk_launch_template_snapshots ON launch_snapshot_id
Foreign Keys
fk_launch_template_snapshots ( login_setup_id ) ref login_setups (login_setup_id)


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 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