/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. variable_cd number CONSTRAINT pk_variables PRIMARY KEY,
  3. experiment_cd number,
  4. variable_name varchar2(64) NOT NULL,
  5. variable_desc varchar2(128),
  6. CONSTRAINT fk_variables_to_exprmnts FOREIGN KEY (experiment_cd) REFERENCES experiments
  7. );