-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
50 lines (42 loc) · 959 Bytes
/
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
42
43
44
drop table if exists tasks;
create table tasks (
id integer,
tutorialtitle text,
tutorialwebsite text,
tutorialtypevideo text,
tutorialtypeaudio text,
tutorialtypedirections text,
levelofexperience text,
knownInformation text,
sampletutorial text,
comments text,
tutorialcollectionreplciations INTEGER DEFAULT 2,
tutorialverificationreplications INTEGER DEFAULT 2,
tutorialvotingreplications INTEGER DEFAULT 2,
desiredSkill text
);
drop table if exists tutorials;
create table tutorials (
id integer,
taskid integer,
title text,
resource_link text,
main text,
comment text,
assignmentId text,
hitId text,
workerId text,
turkSubmitTo text,
agree integer,
disagree integer
);
drop table if exists votes;
create table votes (
taskid integer,
tutorial1 text,
tutorial2 text,
assignmentId text,
hitId text,
workerId text,
turkSubmitTo text
);