-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcourse_items.html
88 lines (69 loc) · 2.89 KB
/
course_items.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
<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>course_items</h1>
<h2>Description</h2>
<p>
A single content item in a course such as lecture, quiz or peer review assignment.
Note: For courses that uses the Course Versioning feature, please refer to the branch version of this table.
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>course_id</td><td>22 character unique string identifying an individual course</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>course_lesson_id</td><td>5 character alphanumeric string identifying an individual lesson within a course. course_lesson_id need not be unique, but a course_lesson_id/course_id pair is unique.</td>
</tr>
<tr>
<td>course_item_order</td><td>The order of an item within a particular lesson, with "0" indicating the first item in the lesson.</td>
</tr>
<tr>
<td>course_item_type_id</td><td>There are many different types of of items that make up a course. Each item is given an item_type_id for ease of identification. </td>
</tr>
<tr>
<td>course_item_name</td><td>The name of an item, as seen in the learner view of the course. </td>
</tr>
<tr>
<td>course_item_optional</td><td>A course item can either be optional ("true", which means a learner does not need to pass it to complete the course) or not ("false", which means the learner must pass it to complete the course. </td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE course_items (
course_id VARCHAR(50)
,course_item_id VARCHAR(50)
,course_lesson_id VARCHAR(50)
,course_item_order INT4
,course_item_type_id INT4
,course_item_name VARCHAR(10000)
,course_item_optional BOOL
,PRIMARY KEY (course_id, course_item_id)
,FOREIGN KEY (course_id, course_lesson_id) REFERENCES course_lessons(course_id, course_lesson_id)
);
</pre>
</div>