ERD

[1.1]

tce_subjects
subject_id	BigSerial	NN (PK)
subject_name	Varcha<nX255) NN
subject_description Text
subject_enabled	Boolean	NN

r

rel_subject_tests

tce_tests				tce_users
test_id	BigSerial	NN (PK)		user_id	BigSerial NN (PK)
test_name	Varcha<nX255) NN			user_name	Varchai(n)(255)NN
test_description	T ext	NN		user_password	Varchai(nX255)NN
test begin time	Timestamp			user_email	Varcha<nX255)
test end time	Timestamp			user_regdate	Timestamp NN
test duration ti m e	Smallint	NN		user_ip	Varchai(nX15) NN
test_ip_range	Varcha<nX255) NN			user_firstname	Varchai(nX255)
test num tquestions	Smallint	NN		userjastname	Varcha<nX255)
test num mquestions	Smallint	NN		user_birthdate	Datę
test num a nawę rs	Smallint	NN		user_birthplace	Varchai(n)(255)
test_score_right	Numeri c<10.3)	NN		user_regnumber Varchai(nX255)
test score wrong	Numeri c<10.3)	NN		user_ssn	Varcha<nX255)
test_score_unanswered Numerii^lO.S)		NN		user_level	Smallint NN

re l_su b j e ct_q u esti o ns

re l_test_i d_su b j e cts

rei test users

tce_test_subjects

rei user tests

tsubj_test_id Bigint NN (PFK) tsubj_subject_id Bigint NN (PFK)

I

tce_questions
question_id	BigSerial NN		(PK)
q u esti o n_su b j e ct_i d	Bigint	NN	(FK)
q u esti o n_d escri pti o n	T ext	NN
guestion enable textarea Boolean		NN
question_enabled	Boolean	NN

T

\

\

re l_q u esti o n_a nswe rs

ici

\

\

1

tce_answers
answer_id	BigSerial NN		(PK)
answer guestion id Bigint		NN	(FK)
answer_description	Text	NN
answer_isright	Boolean	NN
answer_enabled	Boolean	NN

ii

\

____

re l_use ra nswe r_l ogs

tce_tests_users
testuser_id	BigSerial NN	(PK)
testuser test id	Bigint NN	(FK)
testuser user id	Bigint NN	(FK)
testuser status	Smallint NN
testuser_creation_time Timestamp NN
logs	t Irel testuser logs i ’
tce_tests_logs
testlog_id	BigSerial NN	(PK)
testl o g_testuse r_i d	Bigint NN	(FK)
testlog_user_ip	Varchai(nX15)
testlog question id	Bigint NN	(FK)
testl og_answer_id	Bigint	(FK)
testl o g_a nswe r_text	T ext
testl og_score	Numeri c<10.3)
testlog_creation_time Timestamp
testl o g_d isp I ay_ti m e	Timestamp
testlog_change_time Timestamp

session data

logansw_testlog_id Bigint NN (PFK) logansw_answer_id Bigint NN (PFK)