Changes between Version 56 and Version 57 of iPeerDatabaseSchema
- Timestamp:
- 2010-10-21T20:24:59Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
iPeerDatabaseSchema
v56 v57 105 105 ||'''date_submitted'''||date||The date the evaluator submitted this evaluation. 106 106 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 107 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.108 ||'''created'''||date||a date entry for this entry's creation. 109 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 107 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 108 ||'''created'''||date||a date entry for this entry's creation. 109 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 110 110 ||'''modified'''||date||the last time of modification. 111 111 == event_template_types == … … 117 117 ||'''display_for_selection'''||integer||A boolean integer. Tells if this type of evaluations should be available for selection when an instructor creates an event 118 118 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 119 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.120 ||'''created'''||date||a date entry for this entry's creation. 121 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 119 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 120 ||'''created'''||date||a date entry for this entry's creation. 121 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 122 122 ||'''modified'''||date||the last time of modification 123 123 == events == … … 135 135 ||'''release_date_end'''||date||The when the event will close - stop showing up on the student's display, even if it was completed. 136 136 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 137 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.138 ||'''created'''||date||a date entry for this entry's creation. 139 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 137 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 138 ||'''created'''||date||a date entry for this entry's creation. 139 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 140 140 ||'''modified'''||date||the last time of modification 141 141 == groups == … … 146 146 ||''course_id''||integer||The ID of the course this group belongs to||''courses'' 147 147 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 148 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users149 ||'''created'''||date||a date entry for this entry's creation. 150 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users148 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 149 ||'''created'''||date||a date entry for this entry's creation. 150 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 151 151 ||'''modified'''||date||the last time of modification 152 152 == groups_members == … … 169 169 ||''grade_release_status''||string||Can the users see the comments their group members gave them, or not? Just like above, ''Some'', ''None'' and ''All'' are possible. 170 170 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 171 ||'''creator_id'''||integer||the ID of the ''user'' who created t his course.||users172 ||'''created'''||date||a date entry for this entry's creation. 173 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users171 ||'''creator_id'''||integer||the ID of the ''user'' who created tthis record.||''users'' 172 ||'''created'''||date||a date entry for this entry's creation. 173 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 174 174 ||'''modified'''||date||the last time of modification 175 175 == mixevals == … … 185 185 ||'''prefill_question_max'''||integer||The number of Textual Questions to Add. 186 186 ||'''availability||enum(public,private)||Determines whether this rubric can be used in an event by users other than the creator. 187 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users188 ||'''created'''||date||a date entry for this entry's creation. 189 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users187 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 188 ||'''created'''||date||a date entry for this entry's creation. 189 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 190 190 ||'''modified'''||date||the last time of modification 191 191 == mixevals_questions_descs == … … 243 243 ||'''availability'''||enum(public,private)||are others allowed to use/see this rubric template? 244 244 ||'''template'''||enum(horizontal, vertical)||Not sure (?) 245 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users246 ||'''created'''||date||a date entry for this entry's creation. 247 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users245 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 246 ||'''created'''||date||a date entry for this entry's creation. 247 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 248 248 ||'''modified'''||date||the last time of modification 249 249 == rubrics_criterias == … … 282 282 ||'''point_high_limit'''||integer||The maximum number of points per member, I guess, again. (?) 283 283 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 284 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users285 ||'''created'''||date||a date entry for this entry's creation. 286 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users284 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 285 ||'''created'''||date||a date entry for this entry's creation. 286 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 287 287 ||'''modified'''||date||the last time of modification 288 288 == surveys == … … 297 297 ||'''release_date_end'''||date||The final fate for this survey (and event). Students are unable to access the survey after this date. 298 298 ||'''released'''||emun(0,1)||hm.. no idea... (?) 299 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||users300 ||'''created'''||date||a date entry for this entry's creation. 301 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.|| users299 ||'''creator_id'''||integer||the ID of the ''user'' who created this record.||''users'' 300 ||'''created'''||date||a date entry for this entry's creation. 301 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 302 302 ||'''modified'''||date||the last time of modification 303 303 == survey_questions ==
