/hippo-schema/tables/experiments.sql

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