create table icbevals_alarm (
    eval_id       varchar2(40)     primary key,        Evaluation ID
    complete      varchar2(1),     - -            Completed flag
    number_cases  number(3),       - -            Number of cases in evaluation
    facility      number(3),       references icbdics    Experimental facility
    title         varchar2(1024),  textarea   -         Title of evaluation
    alarms_purpose       number(3),       references icbdics    Main purpose of experiment
    date_approved date,            - -            Date approved
    date_revised  date,            - -            Date revised
     );

create table icbevaluators (
    eval_id    varchar2(30),        - -            Evaluation ID
    evaluator  number(3),        - -            Evaluator
    constraint pk_icbevaluators primary key (eval_id,evaluator)
     );

create table icbmain_diff (
        eval_id         varchar2(40),        -  -            Evaluation ID
        main_diff       number(3),        -  -            Varying parameter accross cases
        constraint pk_icbmain_diff primary key (eval_id,main_diff)
        );

create table icbreferences (
    eval_id        varchar2(30),        - -            Evaluation ID
    line_no        number(3),        - -            Reference line number
    reference    varchar2(80),        textarea -        Bibliographic references
    constraint pk_icbreferences primary key (eval_id,line_no)
     );

create table icbcases_alarm (
    exp_key        varchar2(35)     primary key,        Case ID
    eval_id        varchar2(20),    - -            Evaluation ID
    case_number    number(3),       - -            Case number
    case_label    varchar2(20),     - -            Case label
    exp_years    varchar2(20),      - -            Year of experiment (start)
    exp_years_end    varchar2(10),  - -            Year of experiment (end)
    commt        varchar2(1024)     textarea -        Comment
     );

create table icbsources (
    exp_key        varchar2(35)     - -,        Case ID
    src_no         number(3)        - -,
    src_type     number(3),      references icbdics src_type
    src_particle number(3),      references icbdics src_particle
    src_time_dep number(3),      references icbdics src_time_dep
    src_frequency number,        - -
    src_strength_n number,         - -
    src_strength_g number,         - -
    src_geometry number(3),      references icbdics
    constraint pk_icbsources primary key (eval_id,src_no)
    );
    
create table icbdetectors (
    exp_key        varchar2(35)     primary key,        Case ID
    det_no         number(3)        primary key,
    det_type    number(3),          references icbdics    detector
    det_size number,           - -
    det_efficiency number     - -
    constraint pk_icbdetectors primary key (eval_id,det_no)
  );


create table icbdics (
    dickey        number(3)               primary key,        Dictionary key
    dicname        varchar2(15),        - -            Dictionary name
    code        varchar2(20),        - -            Code abbreviation (not used)
    descr        varchar2(50)        - -            Code description
    );

create table icbreviewer (
        exp_key         varchar2(30),        - -            Case ID
    name_key    number references name, - -            Reviewer key
    review_status    varchar2(1),        - -            Review status
    date_status    date,            - -            Date of last status
    username    varchar2(20)        calculated -         username of reviewer
        constraint pk_icbrev primary key (exp_key,name_key)
        );
