-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathgatech_course_user_ids.html
410 lines (327 loc) · 15.2 KB
/
gatech_course_user_ids.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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
<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>gatech_course_user_ids</h1>
<h2>Description</h2>
<p>
Encrypted user id mapping table. Use this table to connect learner data from exports, which identifies gatech learners using gatech_user_id, to course-scoped data from external surveys.
</p>
<h2> Columns </h2>
<table>
<tr><th>Name</th><th>Description</th></tr>
<tr>
<td>gatech_user_id</td><td>Encrypted Coursera user id for gatech data.</td>
</tr>
<tr>
<td>normal_abnormal_behavior_user_id</td><td>Encrypted Coursera user id for normal-abnormal-behavior data.</td>
</tr>
<tr>
<td>mechanics_1_user_id</td><td>Encrypted Coursera user id for mechanics-1 data.</td>
</tr>
<tr>
<td>introtoelectronics_old_user_id</td><td>Encrypted Coursera user id for introtoelectronics-old data.</td>
</tr>
<tr>
<td>mechanics_1_internal_gt_version_user_id</td><td>Encrypted Coursera user id for mechanics-1-internal-gt-version data.</td>
</tr>
<tr>
<td>compinvesting1_dev_user_id</td><td>Encrypted Coursera user id for compinvesting1-dev data.</td>
</tr>
<tr>
<td>linear_circuits_legacy_user_id</td><td>Encrypted Coursera user id for linear-circuits-legacy data.</td>
</tr>
<tr>
<td>large_scale_applications_in_cloud_user_id</td><td>Encrypted Coursera user id for large-scale-applications-in-cloud data.</td>
</tr>
<tr>
<td>professional_emails_english_user_id</td><td>Encrypted Coursera user id for professional-emails-english data.</td>
</tr>
<tr>
<td>phys2211_user_id</td><td>Encrypted Coursera user id for phys2211 data.</td>
</tr>
<tr>
<td>user_experience_design_user_id</td><td>Encrypted Coursera user id for user-experience-design data.</td>
</tr>
<tr>
<td>phys2211dup_deprecate_user_id</td><td>Encrypted Coursera user id for phys2211dup-deprecate data.</td>
</tr>
<tr>
<td>large_scale_runtime_user_id</td><td>Encrypted Coursera user id for large-scale-runtime data.</td>
</tr>
<tr>
<td>business_writing_english_user_id</td><td>Encrypted Coursera user id for business-writing-english data.</td>
</tr>
<tr>
<td>mobile_robot_user_id</td><td>Encrypted Coursera user id for mobile-robot data.</td>
</tr>
<tr>
<td>engineering_mechanics_statics_internal_gt_version_user_id</td><td>Encrypted Coursera user id for engineering-mechanics-statics-internal-gt-version data.</td>
</tr>
<tr>
<td>gt_linearcircuits1_user_id</td><td>Encrypted Coursera user id for gt-linearcircuits1 data.</td>
</tr>
<tr>
<td>material_science_engineering_user_id</td><td>Encrypted Coursera user id for material-science-engineering data.</td>
</tr>
<tr>
<td>dynamics_user_id</td><td>Encrypted Coursera user id for dynamics data.</td>
</tr>
<tr>
<td>acms2_user_id</td><td>Encrypted Coursera user id for acms2 data.</td>
</tr>
<tr>
<td>stem_integration_k_12_user_id</td><td>Encrypted Coursera user id for stem-integration-k-12 data.</td>
</tr>
<tr>
<td>fe_exam_user_id</td><td>Encrypted Coursera user id for fe-exam data.</td>
</tr>
<tr>
<td>network_virtualization_user_id</td><td>Encrypted Coursera user id for network-virtualization data.</td>
</tr>
<tr>
<td>motion_and_kinetics_user_id</td><td>Encrypted Coursera user id for motion-and-kinetics data.</td>
</tr>
<tr>
<td>fhir_user_id</td><td>Encrypted Coursera user id for fhir data.</td>
</tr>
<tr>
<td>physics_lab_user_id</td><td>Encrypted Coursera user id for physics-lab data.</td>
</tr>
<tr>
<td>engineering_mechanics_statics_2_user_id</td><td>Encrypted Coursera user id for engineering-mechanics-statics-2 data.</td>
</tr>
<tr>
<td>english_communication_capstone_user_id</td><td>Encrypted Coursera user id for english-communication-capstone data.</td>
</tr>
<tr>
<td>energy_101_user_id</td><td>Encrypted Coursera user id for energy-101 data.</td>
</tr>
<tr>
<td>material_behavior_user_id</td><td>Encrypted Coursera user id for material-behavior data.</td>
</tr>
<tr>
<td>linear_circuits_acanalysis_user_id</td><td>Encrypted Coursera user id for linear-circuits-acanalysis data.</td>
</tr>
<tr>
<td>electronics_user_id</td><td>Encrypted Coursera user id for electronics data.</td>
</tr>
<tr>
<td>gt_material_behavior_user_id</td><td>Encrypted Coursera user id for gt-material-behavior data.</td>
</tr>
<tr>
<td>eportfolio_english_user_id</td><td>Encrypted Coursera user id for eportfolio-english data.</td>
</tr>
<tr>
<td>computational_investing_user_id</td><td>Encrypted Coursera user id for computational-investing data.</td>
</tr>
<tr>
<td>mechanics2_user_id</td><td>Encrypted Coursera user id for mechanics2 data.</td>
</tr>
<tr>
<td>engineering_mechanics_statics_user_id</td><td>Encrypted Coursera user id for engineering-mechanics-statics data.</td>
</tr>
<tr>
<td>beam_bending_user_id</td><td>Encrypted Coursera user id for beam-bending data.</td>
</tr>
<tr>
<td>supply_chain_mgmt_user_id</td><td>Encrypted Coursera user id for supply-chain-mgmt data.</td>
</tr>
<tr>
<td>mhealth_informatics_user_id</td><td>Encrypted Coursera user id for mhealth-informatics data.</td>
</tr>
<tr>
<td>material_informatics_user_id</td><td>Encrypted Coursera user id for material-informatics data.</td>
</tr>
<tr>
<td>mind_behavior_fundamentals_user_id</td><td>Encrypted Coursera user id for mind-behavior-fundamentals data.</td>
</tr>
<tr>
<td>acms1_user_id</td><td>Encrypted Coursera user id for acms1 data.</td>
</tr>
<tr>
<td>earsketch_development_user_id</td><td>Encrypted Coursera user id for earsketch-development data.</td>
</tr>
<tr>
<td>materials_structures_user_id</td><td>Encrypted Coursera user id for materials-structures data.</td>
</tr>
<tr>
<td>music_technology_user_id</td><td>Encrypted Coursera user id for music-technology data.</td>
</tr>
<tr>
<td>motion_and_kinetics_internal_gt_version_user_id</td><td>Encrypted Coursera user id for motion-and-kinetics-internal-gt-version data.</td>
</tr>
<tr>
<td>gt_mom_iv_user_id</td><td>Encrypted Coursera user id for gt-mom-iv data.</td>
</tr>
<tr>
<td>psyc110as_user_id</td><td>Encrypted Coursera user id for psyc110as data.</td>
</tr>
<tr>
<td>test_shell_3_user_id</td><td>Encrypted Coursera user id for test-shell-3 data.</td>
</tr>
<tr>
<td>combinatorial_game_theory_user_id</td><td>Encrypted Coursera user id for combinatorial-game-theory data.</td>
</tr>
<tr>
<td>mse2001properties_user_id</td><td>Encrypted Coursera user id for mse2001properties data.</td>
</tr>
<tr>
<td>gtcomp_user_id</td><td>Encrypted Coursera user id for gtcomp data.</td>
</tr>
<tr>
<td>engineering_mechanics_statics_2_internal_gt_version_user_id</td><td>Encrypted Coursera user id for engineering-mechanics-statics-2-internal-gt-version data.</td>
</tr>
<tr>
<td>mechanics2_internal_gt_version_user_id</td><td>Encrypted Coursera user id for mechanics2-internal-gt-version data.</td>
</tr>
<tr>
<td>dynamics_internal_gt_version_user_id</td><td>Encrypted Coursera user id for dynamics-internal-gt-version data.</td>
</tr>
<tr>
<td>gt_circuits_2_user_id</td><td>Encrypted Coursera user id for gt-circuits-2 data.</td>
</tr>
<tr>
<td>high_throughput_user_id</td><td>Encrypted Coursera user id for high-throughput data.</td>
</tr>
<tr>
<td>gt_electronics_user_id</td><td>Encrypted Coursera user id for gt-electronics data.</td>
</tr>
<tr>
<td>mobile_ubiquitous_computing_user_id</td><td>Encrypted Coursera user id for mobile-ubiquitous-computing data.</td>
</tr>
<tr>
<td>linear_circuits_dcanalysis_user_id</td><td>Encrypted Coursera user id for linear-circuits-dcanalysis data.</td>
</tr>
<tr>
<td>gatech_shell_2_user_id</td><td>Encrypted Coursera user id for gatech-shell-2 data.</td>
</tr>
<tr>
<td>compphoto_user_id</td><td>Encrypted Coursera user id for compphoto data.</td>
</tr>
<tr>
<td>healthcare_tech_user_id</td><td>Encrypted Coursera user id for healthcare-tech data.</td>
</tr>
<tr>
<td>health_data_visual_user_id</td><td>Encrypted Coursera user id for health-data-visual data.</td>
</tr>
<tr>
<td>methodological_biological_foundations_user_id</td><td>Encrypted Coursera user id for methodological-biological-foundations data.</td>
</tr>
<tr>
<td>gt_beam_bending_user_id</td><td>Encrypted Coursera user id for gt-beam-bending data.</td>
</tr>
<tr>
<td>gt_circuits2040_user_id</td><td>Encrypted Coursera user id for gt-circuits2040 data.</td>
</tr>
<tr>
<td>machine_design1_user_id</td><td>Encrypted Coursera user id for machine-design1 data.</td>
</tr>
<tr>
<td>tackling_toefl_user_id</td><td>Encrypted Coursera user id for tackling-toefl data.</td>
</tr>
<tr>
<td>speak_english_professionally_user_id</td><td>Encrypted Coursera user id for speak-english-professionally data.</td>
</tr>
<tr>
<td>m_lisle_sandbox_user_id</td><td>Encrypted Coursera user id for m-lisle-sandbox data.</td>
</tr>
</table>
<h2>SQL create statement</h2>
<pre>
CREATE TABLE gatech_course_user_ids (
gatech_user_id VARCHAR(50) NOT NULL
,normal_abnormal_behavior_user_id VARCHAR(50) NOT NULL
,mechanics_1_user_id VARCHAR(50) NOT NULL
,introtoelectronics_old_user_id VARCHAR(50) NOT NULL
,mechanics_1_internal_gt_version_user_id VARCHAR(50) NOT NULL
,compinvesting1_dev_user_id VARCHAR(50) NOT NULL
,linear_circuits_legacy_user_id VARCHAR(50) NOT NULL
,large_scale_applications_in_cloud_user_id VARCHAR(50) NOT NULL
,professional_emails_english_user_id VARCHAR(50) NOT NULL
,phys2211_user_id VARCHAR(50) NOT NULL
,user_experience_design_user_id VARCHAR(50) NOT NULL
,phys2211dup_deprecate_user_id VARCHAR(50) NOT NULL
,large_scale_runtime_user_id VARCHAR(50) NOT NULL
,business_writing_english_user_id VARCHAR(50) NOT NULL
,mobile_robot_user_id VARCHAR(50) NOT NULL
,engineering_mechanics_statics_internal_gt_version_user_id VARCHAR(50) NOT NULL
,gt_linearcircuits1_user_id VARCHAR(50) NOT NULL
,material_science_engineering_user_id VARCHAR(50) NOT NULL
,dynamics_user_id VARCHAR(50) NOT NULL
,acms2_user_id VARCHAR(50) NOT NULL
,stem_integration_k_12_user_id VARCHAR(50) NOT NULL
,fe_exam_user_id VARCHAR(50) NOT NULL
,network_virtualization_user_id VARCHAR(50) NOT NULL
,motion_and_kinetics_user_id VARCHAR(50) NOT NULL
,fhir_user_id VARCHAR(50) NOT NULL
,physics_lab_user_id VARCHAR(50) NOT NULL
,engineering_mechanics_statics_2_user_id VARCHAR(50) NOT NULL
,english_communication_capstone_user_id VARCHAR(50) NOT NULL
,energy_101_user_id VARCHAR(50) NOT NULL
,material_behavior_user_id VARCHAR(50) NOT NULL
,linear_circuits_acanalysis_user_id VARCHAR(50) NOT NULL
,electronics_user_id VARCHAR(50) NOT NULL
,gt_material_behavior_user_id VARCHAR(50) NOT NULL
,eportfolio_english_user_id VARCHAR(50) NOT NULL
,computational_investing_user_id VARCHAR(50) NOT NULL
,mechanics2_user_id VARCHAR(50) NOT NULL
,engineering_mechanics_statics_user_id VARCHAR(50) NOT NULL
,beam_bending_user_id VARCHAR(50) NOT NULL
,supply_chain_mgmt_user_id VARCHAR(50) NOT NULL
,mhealth_informatics_user_id VARCHAR(50) NOT NULL
,material_informatics_user_id VARCHAR(50) NOT NULL
,mind_behavior_fundamentals_user_id VARCHAR(50) NOT NULL
,acms1_user_id VARCHAR(50) NOT NULL
,earsketch_development_user_id VARCHAR(50) NOT NULL
,materials_structures_user_id VARCHAR(50) NOT NULL
,music_technology_user_id VARCHAR(50) NOT NULL
,motion_and_kinetics_internal_gt_version_user_id VARCHAR(50) NOT NULL
,gt_mom_iv_user_id VARCHAR(50) NOT NULL
,psyc110as_user_id VARCHAR(50) NOT NULL
,test_shell_3_user_id VARCHAR(50) NOT NULL
,combinatorial_game_theory_user_id VARCHAR(50) NOT NULL
,mse2001properties_user_id VARCHAR(50) NOT NULL
,gtcomp_user_id VARCHAR(50) NOT NULL
,engineering_mechanics_statics_2_internal_gt_version_user_id VARCHAR(50) NOT NULL
,mechanics2_internal_gt_version_user_id VARCHAR(50) NOT NULL
,dynamics_internal_gt_version_user_id VARCHAR(50) NOT NULL
,gt_circuits_2_user_id VARCHAR(50) NOT NULL
,high_throughput_user_id VARCHAR(50) NOT NULL
,gt_electronics_user_id VARCHAR(50) NOT NULL
,mobile_ubiquitous_computing_user_id VARCHAR(50) NOT NULL
,linear_circuits_dcanalysis_user_id VARCHAR(50) NOT NULL
,gatech_shell_2_user_id VARCHAR(50) NOT NULL
,compphoto_user_id VARCHAR(50) NOT NULL
,healthcare_tech_user_id VARCHAR(50) NOT NULL
,health_data_visual_user_id VARCHAR(50) NOT NULL
,methodological_biological_foundations_user_id VARCHAR(50) NOT NULL
,gt_beam_bending_user_id VARCHAR(50) NOT NULL
,gt_circuits2040_user_id VARCHAR(50) NOT NULL
,machine_design1_user_id VARCHAR(50) NOT NULL
,tackling_toefl_user_id VARCHAR(50) NOT NULL
,speak_english_professionally_user_id VARCHAR(50) NOT NULL
,m_lisle_sandbox_user_id VARCHAR(50) NOT NULL
,PRIMARY KEY (gatech_user_id)
,FOREIGN KEY (gatech_user_id) REFERENCES users(gatech_user_id)
);
</pre>
</div>