ITS ➤ Docs ➤ TABLES

• courses strong — list of courses

  id PK	name	term	year	filename
  1	ECE 2026	Fall	2009	ece2025.csv

• courses[courses_id]_users — list of participants in a course

  id PK	first_name	last_name	username UK	password	role
  1	John	Smith	js34	myPass	[ admin | instructor | student ]

  • courses_id → courses.id

courses[courses_id]_users[users_id]_log — log of course participant's activity

id PK	questions_id FK	concepts_id FK	current_chapter	answered	score	rating	comment	timestamp	duration	action
1	17	63	4	D	[0-100]	[1-5]		unixtime	78	SUBMIT

• questions_id → questions.id
• concepts_id → concepts.id

questions — question list

id PK	qtype	title	images_id FK	question	answers	answersConfig	questionConfig	category
1	MC	My multiple choice	1123	What is sin(t)?	4	[1|2]	[1|2]	Chapter1

• images_id → images.id

questions_mc — question extension list of type "multiple-choice"

questions_id FK	feedback	weight[i]	answer[i]	reason[i]	image[i] FK
1	Hint: Consider using Euler	[0-100]	x[n]=δ[n]	since x[0] = 0	77

• questions_id → questions.id
• image[i] → images.id

questions_m — question extension list of type "matching"

questions_id FK	L[i]	Limage[i] FK	R[i]	Rimage[i] FK
1	sin(θ)	234	cos(θ - π/2)	235

• questions_id → questions.id
• Limage[i] → images.id
• Rimage[i] → images.id

questions_c — question extension list of type "computed"

questions_id FK	formula[k]	weight[k]	text[k]	val[i]	min_val[i]	max_val[i]	vals
1	2*{a}+1	50	Part 1:	{a}	1	5	1

• questions_id → questions.id

questions_p — question extension list of type "paragraph"

questions_id FK	template	answer
1	What is aliasing?	Aliasing is ...

• questions_id → questions.id

questions_s — question extension list of type "short answer"

questions_id FK	ans[k]
1	sin(t)

• questions_id → questions.id

solutions — list of solutions to questions

id PK	questions_id FK	solution[k]	author FK	verified	verified_by FK	rating[k]	numratings[k]
1	17	Hint k	1638	[0|1]	1	[1-5]	3

• questions_id → questions.id
• author → users.id
• verified_by → users.id

• solution1: hint
• solution2: short solution
• solution3: detailed solution

images — list of images

id PK	name UK	concepts_id FK
1	fir.png	12

• concepts_id → concepts.id

concepts — list of concepts

id PK	name UK	node_number	equation
1	convolution	4	$$x(t) \ast y(t)$$

• concepts_id → concepts.id

tags — list of tags

id PK	name UK	concepts_id FK
1	sinc	12

• concepts_id → concepts.id

questions_tags — linking of questions and tags

questions_id FK	tags_id FK
1	57

• questions_id → questions.id
• tags_id → tags.id

modules — list of system modules

id PK	name UK	concepts_id FK
1	Chapter 1	12

• concepts_id → concepts.id

logs — log of system activity

id PK	questions_id FK	tbname	field	content	author FK	timestamp	action
1	17	questions	answer1	x=1	1638	unixtime	EDIT

• questions_id → questions.id
• author → users.id