PageRenderTime 24ms CodeModel.GetById 17ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 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);