-
Notifications
You must be signed in to change notification settings - Fork 0
/
assessment_regex_patterns.html
75 lines (59 loc) · 2.04 KB
/
assessment_regex_patterns.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
<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>assessment_regex_patterns</h1>
<h2>Description</h2>
<p>
[No table description available]
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>assessment_question_id</td><td>The id that uniquely identifies a question in an assessment</td>
</tr>
<tr>
<td>assessment_pattern_id</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_regex</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_feedback</td><td>The text that is displayed to learners upon answering a question that matches the pattern.</td>
</tr>
<tr>
<td>assessment_pattern_correct</td><td>For regular expression type questions, instructors can insert both correct and incorrect answer patterns in order to provide learners with tailored feedback based on common solutions or misconceptions. This field indicates whether the pattern was one that corresponded to a correct solution (t) or an incorrect solution (f).</td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE assessment_regex_patterns (
assessment_question_id VARCHAR(50)
,assessment_pattern_id VARCHAR(50)
,assessment_pattern_regex VARCHAR(20000)
,assessment_pattern_feedback VARCHAR(20000)
,assessment_pattern_correct BOOL
,PRIMARY KEY (assessment_question_id, assessment_pattern_id)
,FOREIGN KEY (assessment_question_id) REFERENCES assessment_questions(assessment_question_id)
);
</pre>
</div>