-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
41 lines (35 loc) · 1 KB
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
create table if not exists uploads (
responses text,
answers text,
question_texts text
);
create table if not exists discarded_questions (
session_id integer not null,
discarded_questions text,
foreign key(session_id) references uploads(ROWID)
);
create table if not exists boundaries (
session_id integer not null,
boundaries text,
foreign key(session_id) references uploads(ROWID)
);
create table if not exists subboundaries (
session_id integer not null,
subboundaries text,
foreign key(session_id) references uploads(ROWID)
);
create table if not exists question_discriminations (
session_id integer not null,
question_discriminations text,
foreign key(session_id) references uploads(ROWID)
);
create table if not exists question_weights (
session_id integer not null,
question_weights text,
foreign key(session_id) references uploads(ROWID)
);
create table if not exists student_locations (
session_id integer not null,
student_locations text,
foreign key(session_id) references uploads(ROWID)
);