/hippo-schema/tables/experiments.sql

http://hdbc.googlecode.com/ · SQL · 12 lines · 11 code · 1 blank · 0 comment · 0 complexity · 746f36b96a0207a17481c47cba746083 MD5 · raw file

  1. CREATE TABLE experiments(
  2. experiment_cd number CONSTRAINT pk_experiments PRIMARY KEY,
  3. type varchar2(16 char),
  4. title varchar2(64 char) NOT NULL,
  5. purpose varchar2(128 char) NOT NULL,
  6. method varchar2(4000 char),
  7. conclusion varchar2(4000 char),
  8. MODIFIED_DT DATE NOT NULL,
  9. MODIFIED_BY NUMBER NOT NULL,
  10. active NUMBER(1) NOT NULL
  11. );