CREATE TABLE rich700_trb3lookup_vers (
  vers_id          NUMBER(8)     NOT NULL,
  date_create      DATE          DEFAULT SYSDATE,
  orig_context_id  NUMBER(8)     NOT NULL 
                                 CONSTRAINT rich700_trb3lookup_context_fk1
                                 REFERENCES hanal2.treepar_context (context_id),
  run_id           NUMBER(10)    NOT NULL,
  author           VARCHAR2(80),
  description      VARCHAR2(4000),
  CONSTRAINT rich700_trb3lookup_vers_pk PRIMARY KEY (vers_id)
    USING INDEX PCTFREE 2 STORAGE (INITIAL 16K NEXT 16K PCTINCREASE 0) )
STORAGE (INITIAL 32K NEXT 32K PCTINCREASE 0);


COMMENT ON TABLE rich700_trb3lookup_vers IS 'List of versions for the TRB3 lookup table used by the rich700 detector TRB3 unpacker';
COMMENT ON COLUMN rich700_trb3lookup_vers.vers_id IS 'Identifier for the version (provided by the sequence rich700_par_vers_sequ)';
COMMENT ON COLUMN rich700_trb3lookup_vers.date_create IS 'Creation date of this version (default sysdate)';
COMMENT ON COLUMN rich700_trb3lookup_vers.orig_context_id IS 'Identifier for the context defined in the analysis before write'; 
COMMENT ON COLUMN rich700_trb3lookup_vers.run_id IS 'Run Id used for initialization in the analysis before write (defines the maximum setup)';
COMMENT ON COLUMN rich700_trb3lookup_vers.author IS 'Author of the parameter set';
COMMENT ON COLUMN rich700_trb3lookup_vers.description IS 'Comment';