/hippo-schema/tables/experiments.sql
http://hdbc.googlecode.com/ · SQL · 12 lines · 11 code · 1 blank · 0 comment · 0 complexity · 746f36b96a0207a17481c47cba746083 MD5 · raw file
- CREATE TABLE experiments(
- experiment_cd number CONSTRAINT pk_experiments PRIMARY KEY,
- type varchar2(16 char),
- title varchar2(64 char) NOT NULL,
- purpose varchar2(128 char) NOT NULL,
- method varchar2(4000 char),
- conclusion varchar2(4000 char),
- MODIFIED_DT DATE NOT NULL,
- MODIFIED_BY NUMBER NOT NULL,
- active NUMBER(1) NOT NULL
- );