Context Navigation

config

Timestamp:

05/27/08 21:49:48 (6 months ago)

Author:

aarkerio

Message:

Update record student

Files:

r570	r574
2	2	id serial NOT NULL UNIQUE,
3	3	user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
4		results smallint NOT NULL,
	4	question_id int NOT NULL,
	5	answer_id smallint NOT NULL,
5	6	test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
6	7	vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
7	8	created timestamp(0) with time zone DEFAULT now() NOT NULL,
8		percentage decimal NOT NULL,
9		PRIMARY KEY (user_id, test_id, vclassroom_id)
	9	PRIMARY KEY (user_id, test_id, vclassroom_id, question_id)
10	10	);
	11
	12	-- CREATE TABLE results ( -- tests student results
	13	-- id serial NOT NULL UNIQUE,
	14	-- user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
	15	-- results smallint NOT NULL,
	16	-- test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
	17	-- vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
	18	-- created timestamp(0) with time zone DEFAULT now() NOT NULL,
	19	-- percentage decimal NOT NULL,
	20	-- PRIMARY KEY (user_id, test_id, vclassroom_id)
	21	-- );
11	22	-- Test model tables ends
12	23