/hippo-schema/tables/data.sql

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

    

  1. CREATE TABLE data (
    2. 

  2. 	data_cd 		number CONSTRAINT pk_data PRIMARY KEY,
    3. 

  3. 	user_cd			number,
    4. 

  4. 	experiment_cd	number,
    5. 

  5. 	response		XMLType NOT NULL,
    6. 

  6. 	CONSTRAINT fk_data_to_users FOREIGN KEY (user_cd) REFERENCES users
    7. 

  7. );
    8.