create table simul_project (
  project_id      number(8)      not null,
  exp_id          varchar2(10)   not null
                                 constraint simul_experiment_fk
                                 references hades_oper.experiment (exp_id),
  sub_project     varchar2(30)   not null,
  project_begin   DATE           not null,
  project_end     DATE           not null,
  projectile      varchar2(5)    not null,
  energy          number(4,3)    not null,
  target_version  number(4)      not null 
                                 constraint geom_obj_type_fk2
                                 references hades_oper.object_types (obj_type),
  field_factor    number(5,4)    not null,
  description     varchar2(4000),
  constraint simul_project_pk primary key (project_id),
  constraint simul_project_unq unique (exp_id,sub_project) );

comment on table simul_project is 'Table for HGEANT simulation projects';

--------------------------------------------------------------------------------

create table simul_event_file_config (
  config_id         number(8)       not null,
  package_name      varchar2(30)    not null,
  package_version   varchar2(10)    not null,   
  compiler          varchar2(20)    ,
  event_system      varchar2(10)    not null,
  energy            number(4,3)     not null,
  config_info       varchar2(4000)  not null,
  file_format       varchar2(80)    ,
  author            varchar2(80)    not null,
  description       varchar2(4000)  ,
  constraint simul_event_file_config_pk primary key (config_id) );

comment on table simul_event_file_config is 'Table for configuration of event files used by HGEANT';

--------------------------------------------------------------------------------

create table simul_event_file (
  file_id           number(8)        not null,
  file_name         varchar2(127)    not null,
  file_location     varchar2(255)    ,
  file_size         number(10)       ,
  events            number(10)       ,
  config_id         number(8)        not null
                                     constraint simul_event_file_config_fk1
                                     references simul_event_file_config (config_id),
  created           date             not null,
  constraint simul_event_file_pk primary key (file_id),
  constraint simul_event_file_unq unique (file_name,file_location) );

comment on table simul_event_file is 'Table for event files used by HGEANT';

--------------------------------------------------------------------------------

create table simul_run_config (
  config_id         number(8)        not null,
  generation        number(2)        ,
  geant_version     varchar2(10)     ,
  hydra_version     varchar2(10)     ,
  root_version      varchar2(10)     ,
  cern_lib          varchar2(20)     ,
  compiler          varchar2(20)     ,
  geant_flags       varchar2(4000)   not null,
  parameters        varchar2(4000)   not null,
  config_comment    varchar2(4000),
  constraint simul_run_config_pk primary key (config_id) );

comment on table simul_run_config is 'Table for configuration of HGEANT simulation runs';

--------------------------------------------------------------------------------

create table simul_run_comment (
  comment_id      number(8)       not null,
  author          varchar2(80)    not null,
  description     varchar2(4000)  ,
  constraint simul_run_comment_pk primary key (comment_id));

comment on table simul_run_comment is 'Table for GEANT simulation run comments';

--------------------------------------------------------------------------------

create table simul_run (
  id                number(10)       not null,
  run_id            number(8)        not null,
  file_num          number(2)        not null,
  project_id        number(6)        not null
                                     constraint simul_project_fk1
                                     references simul_project (project_id),
  event_file_id     number(8)        not null
                                     constraint simul_event_file_fk1
                                     references simul_event_file (file_id),
  config_id         number(8)        not null
                                     constraint simul_run_config_fk1
                                     references simul_run_config (config_id),
  file_name         varchar2(127)    not null,
  file_location     varchar2(255)    ,
  file_size         number(10)       ,
  events            number(10)       ,
  run_start         date             not null,
  run_stop          date             not null,
  created           date             not null,
  comment_id        number(8)        not null
                                     constraint simul_run_comment_fk1
                                     references simul_run_comment (comment_id),
  constraint simul_run_pk primary key (id),
  constraint simul_run_unq1 unique (run_id,file_num),
  constraint simul_run_unq2 unique (file_name,file_location) );

comment on table simul_run is 'Table for HGEANT simulation runs';