Changes between Version 80 and Version 81 of iPeerDatabaseSchema
- Timestamp:
- 2010-10-27T17:34:52Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
iPeerDatabaseSchema
v80 v81 1 [[PageOutline ]]2 1 [[PageOutline 2,5]] 2 == Present iPeer Database Schema == 3 3 4 4 [[Image(db-schema1.png, 660px)]] 5 == courses==5 === courses === 6 6 Contains all the courses in the iPeer instance. 7 7 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 18 18 ||'''modified'''||date||the last time of modification. 19 19 ||'''instructor_id'''||integer||unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. 20 == evaluation_mixevals==20 === evaluation_mixevals === 21 21 A student's evaluations are put here, for the mixed evaluation type. Each evaluator-evaluate pair is recorded here. 22 22 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 34 34 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 35 35 ||'''modified'''||date||the last time of modification. 36 == evaluation_mixeval_details==36 === evaluation_mixeval_details=== 37 37 It seems that for each answer to a mixed evaluation question, and entry in this table is generated. 38 38 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 48 48 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. ||''users'' 49 49 ||'''modified'''||date||the last time of modification. 50 == evaluation_rubrics==50 === evaluation_rubrics === 51 51 Holds all the submissions of evaluatee-evaluator pairs. 52 52 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 65 65 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. ||''users'' 66 66 ||'''modified'''||date||the last time of modification. 67 == evaluation_rubrics_details==67 === evaluation_rubrics_details === 68 68 It seems that for each answer to a mixed evaluation question, and entry in this table is generated. 69 69 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 79 79 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users'' 80 80 ||'''modified'''||date||the last time of modification. 81 == evaluation_simples==81 === evaluation_simples === 82 82 Every time an evaluator saves their progress in simple evaluation for an evaluatee, an entry is saved into this table. 83 83 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 97 97 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 98 98 ||'''modified'''||date||the last time of modification. 99 == evaluation_submissions==99 === evaluation_submissions === 100 100 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 101 101 ||'''id'''||integer||Primary_Key … … 110 110 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 111 111 ||'''modified'''||date||the last time of modification. 112 == event_template_types==112 === event_template_types === 113 113 I think this holds the the entries for the rubric types in iPeer. However, the code often assumes it knows the meanings of evaluation type id's (1,2,3,4), and hard-codes those into the code, sometimes ignoring this table. 114 114 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 122 122 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 123 123 ||'''modified'''||date||the last time of modification 124 == events==124 === events === 125 125 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 126 126 ||'''id'''||integer||Primary_Key … … 140 140 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 141 141 ||'''modified'''||date||the last time of modification 142 == groups==142 === groups === 143 143 Holds the members for each group in a class. 144 144 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 151 151 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 152 152 ||'''modified'''||date||the last time of modification 153 == groups_members==153 === groups_members === 154 154 Connects groups to group members (many to many relationship): 155 155 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 158 158 ||''user_id''||integer||The user ID of a group member ||''users'' 159 159 That's it :-) 160 == group_events==160 === group_events === 161 161 Connects groups to events, holding other data about the group submission, etc. (many to many relationship).[[br]] 162 162 I think that the extra columns are just to cache other data from the table, and display it to the user. … … 174 174 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 175 175 ||'''modified'''||date||the last time of modification 176 == mixevals==176 === mixevals === 177 177 Contains a list of Mixed Evaluation (Templates - referenced by evaluation events) 178 178 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 190 190 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 191 191 ||'''modified'''||date||the last time of modification 192 == mixevals_questions_descs==192 === mixevals_questions_descs === 193 193 Holds the LOM descriptions of Lickert (Rubric type) mixed evaluation question. 194 194 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 198 198 ||'''scale_level'''||integer||How many points this LOM is worth. 199 199 ||'''descriptor'''||string||The description of this LOM. 200 == mixevals_questions==200 === mixevals_questions === 201 201 Holds all the question titles and descriptions for this table 202 202 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 211 211 ||'''scale_level'''||integer||The total number of LOMs(?) 212 212 ||'''response_type'''||enum(S,L,NULL)|| ''S'' denotes a short, single-line answer. ''L'' denotes a longer, multi-line answer. 213 == personalizes==213 === personalizes === 214 214 This table was use to store preferences for iPeer Lists, and course Home display. Ajax List doesn't use this table (but this could be added in the future). 215 215 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 220 220 ||'''created'''||date||a date entry for this entry's creation. 221 221 ||'''updated'''||date||a date entry for this entry's modification. 222 == questions==222 === questions === 223 223 Holds Survey questions, as far as I can tell. 224 224 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 227 227 ||'''type'''||enum(M,C,S,L)|| The type of the question. 228 228 ||'''master'''||enum(yes,no)||Not sure. 229 == responses==229 === responses === 230 230 Holds the possible responses for a Survey question. 231 231 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 233 233 ||'''question_id'''||integer||The ID of the question||''questions'' 234 234 ||'''response'''||text||A response to this question. 235 == rubrics==235 === rubrics === 236 236 Hold the templates for the rubrics. 237 237 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 248 248 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 249 249 ||'''modified'''||date||the last time of modification 250 == rubrics_criterias==250 === rubrics_criterias === 251 251 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 252 252 ||'''id'''||integer||Primary_Key … … 258 258 ||'''criteria'''||text||The actual criteria text & description. 259 259 ||'''multiplier'''||integer||The importance of this criteria; its impact on score. 260 == rubrics_loms==260 === rubrics_loms === 261 261 The very top descriptions of LOM, general, not per-question 262 262 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 265 265 ||'''lom_num'''||integer||The position number of this LOM|| 266 266 ||'''lom_comment'''||text||The description of this LOM|| 267 == rubrics_criteria_comments==267 === rubrics_criteria_comments === 268 268 A per-question description of a Criteria's the LOMs 269 269 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 273 273 ||'''lom_num'''||integer||...the position of the LOM that is described. 274 274 ||'''criteria_comment'''||The comment specific to this LOM. 275 == simple_evaluatons==275 === simple_evaluatons === 276 276 Contains the templates for Simple Evaluations 277 277 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 287 287 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 288 288 ||'''modified'''||date||the last time of modification 289 == surveys==289 === surveys === 290 290 Holds the Surveys. There's some confusion here, since a survey has all the info of an ''event'' in it as well. I believe both entries are created for a single survey. 291 291 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 302 302 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 303 303 ||'''modified'''||date||the last time of modification 304 == survey_questions==304 === survey_questions === 305 305 Connects the surveys table to the questions table (Many-to-many relationship). Also, gives the questions a number. 306 306 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 309 309 ||'''number'''||integer||The question number in the survey. 310 310 ||'''question_id'''||integer||The question ID to put into survey||''questions'' 311 == survey_inputs==311 === survey_inputs === 312 312 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 313 313 ||'''id'''||integer||Primary_Key … … 318 318 ||'''response_text'''||string||If this was a text question, the answer is recoded here 319 319 ||'''response_id'''||integer||Non-text responses are recorded here||''responses'' 320 == survey_group_sets==320 === survey_group_sets === 321 321 Holds the Group Sets created from surveys. 322 322 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 327 327 ||'''date'''||integer||date of creation, but integer format (?) 328 328 ||'''released'''||enum(0,1)||Were these survey groups put into real groups in iPeer yet? 329 == survey_groups==329 === survey_groups === 330 330 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 331 331 ||'''id'''||integer||Primary_Key 332 332 ||'''group_set_id'''||integer||The group set that this survey_group belongs to.||''survey_group_sets'' 333 333 ||'''group_number'''||integer||The number of the group in the groups set. Just gives the groups an order, I guess. 334 == survey_group_members==334 === survey_group_members === 335 335 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 336 336 ||'''id'''||integer||Primary_Key … … 338 338 ||'''group_id'''||integer||The __survey group__ this member belongs to||''survey_groups'' 339 339 ||'''user_id'''||integer||The User ID of a user in this group||''users'' 340 == sys_function==340 === sys_function === 341 341 Holds the access permissions, and the location of some iPeer functionality (used sparsely for that). 342 342 ||__Column__||__Type__||__Description__||__Foreign Key to table...__ … … 353 353 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 354 354 ||'''modified'''||date||the last time of modification 355 == sys_parameters==355 === sys_parameters === 356 356 Holds system configuration variables. 357 357 ||__Column__||__Type__||__Description__||__Foreign Key to table...__ … … 366 366 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 367 367 ||'''modified'''||date||the last time of modification 368 == users==368 === users === 369 369 A list of all of iPeer's users. 370 370 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 386 386 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 387 387 ||'''modified'''||date||the last time of modification 388 == user_enrols==388 === user_enrols === 389 389 Connects courses and __students__ (many-to-many relationship) 390 390 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| … … 397 397 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 398 398 ||'''modified'''||date||the last time of modification 399 == user_courses==399 === user_courses === 400 400 Connects courses and __instructors & admins__ (many-to-many relationship) 401 401 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
