-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdiscussion_questions.html
119 lines (95 loc) · 3.87 KB
/
discussion_questions.html
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<head>
<style>
div {
font-family: monospace;
}
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
tr:nth-child(odd) {
background-color: #FFFFFF;
}
tr:nth-child(even) {
background-color: #EBF2F2;
}
th, td {
text-align: left;
padding: 5px 10px 5px 5px;
}
</style>
</head>
<div>
<h1>discussion_questions</h1>
<h2>Description</h2>
<p>
For each course's discussion forums, contains the list of the questions, with its title, content, and author.
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>discussion_question_id</td><td>The id of the question in the discussion forum.</td>
</tr>
<tr>
<td>gatech_discussions_user_id</td><td>Encrypted Coursera user id for gatech discussions data.</td>
</tr>
<tr>
<td>discussion_question_title</td><td>The title of the question.</td>
</tr>
<tr>
<td>discussion_question_details</td><td>The content of the question</td>
</tr>
<tr>
<td>discussion_question_context_type</td><td>The context of this discussion question, e.g. "module"</td>
</tr>
<tr>
<td>course_id</td><td>The (on-demand) course in which this question exists.</td>
</tr>
<tr>
<td>course_module_id</td><td>5 character alphanumeric string identifying an individual module within a course. course_module_id need not be unique, but a course_module_id/course_id pair is unique.</td>
</tr>
<tr>
<td>course_item_id</td><td>5 character alphanumeric string identifying an individual item within a course.
Items that have the same id that are in different branches of the same course are considered to be the same for the purposes of progress and grade computations. For example, if you complete item xxxxx in branch A, then you have completed it in branch B even if item xxxxx in branch B is very different from item xxxxx in branch A.</td>
</tr>
<tr>
<td>discussion_forum_id</td><td>The id of the discussion forum. </td>
</tr>
<tr>
<td>country_cd</td><td> The country context in which the question was posted, only applicable to country-specific questions.</td>
</tr>
<tr>
<td>group_id</td><td>No column description available</td>
</tr>
<tr>
<td>discussion_question_created_ts</td><td>The timestamp of when the discussion question was created. </td>
</tr>
<tr>
<td>discussion_question_updated_ts</td><td>The timestamp of when the discussion question was updated.</td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE discussion_questions (
discussion_question_id VARCHAR(50)
,gatech_discussions_user_id VARCHAR(50) NOT NULL
,discussion_question_title VARCHAR(20000)
,discussion_question_details VARCHAR(20000)
,discussion_question_context_type VARCHAR(50)
,course_id VARCHAR(50)
,course_module_id VARCHAR(50)
,course_item_id VARCHAR(50)
,discussion_forum_id VARCHAR(50)
,country_cd VARCHAR(2)
,group_id VARCHAR(50)
,discussion_question_created_ts TIMESTAMP
,discussion_question_updated_ts TIMESTAMP
,PRIMARY KEY (discussion_question_id)
,FOREIGN KEY (course_id) REFERENCES courses(course_id)
,FOREIGN KEY (discussion_forum_id) REFERENCES discussion_forums(discussion_forum_id)
,FOREIGN KEY (course_id, course_module_id) REFERENCES course_modules(course_id, course_module_id)
,FOREIGN KEY (course_id, course_item_id) REFERENCES course_items(course_id, course_item_id)
);
</pre>
</div>