/hippo-schema/tables/variables.sql

http://hdbc.googlecode.com/ · SQL · 8 lines · 7 code · 1 blank · 0 comment · 0 complexity · f3f2f1ff60d46f749995c88c0ff0ba76 MD5 · raw file 

    

  1. CREATE TABLE variables (
    2. 

  2. 	variable_cd 	number CONSTRAINT pk_variables PRIMARY KEY,
    3. 

  3. 	experiment_cd 	number,
    4. 

  4. 	variable_name	varchar2(64) NOT NULL,
    5. 

  5. 	variable_desc	varchar2(128),
    6. 

  6. 	CONSTRAINT fk_variables_to_exprmnts FOREIGN KEY (experiment_cd) REFERENCES experiments
    7. 

  7. );
    8.