-
Notifications
You must be signed in to change notification settings - Fork 0
/
assessment_single_numeric_patterns.html
101 lines (80 loc) · 2.98 KB
/
assessment_single_numeric_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
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
<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_single_numeric_patterns</h1>
<h2>Description</h2>
<p>
Table that stores the single numeric pattern type questions.
</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_type_id</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_value</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_max</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_min</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_include_min</td><td>No column description available</td>
</tr>
<tr>
<td>assessment_pattern_include_max</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_single_numeric_patterns (
assessment_question_id VARCHAR(50)
,assessment_pattern_id VARCHAR(50)
,assessment_pattern_type_id INT4
,assessment_pattern_value VARCHAR(20000)
,assessment_pattern_max FLOAT8
,assessment_pattern_min FLOAT8
,assessment_pattern_include_min BOOL
,assessment_pattern_include_max BOOL
,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)
,FOREIGN KEY (assessment_pattern_type_id) REFERENCES assessment_pattern_types(assessment_pattern_type_id)
);
</pre>
</div>