Changes between Version 9 and Version 10 of iPeerDatabaseSchema
- Timestamp:
- 2010-10-15T16:17:34Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
iPeerDatabaseSchema
v9 v10 11 11 * '''record_status''' - either 'A' or 'I', representing active or inactive. Not always checked by code. 12 12 * '''creator_id''' - the ID of the user who created this course. Foreign Key to ''users'' table. 13 * '''created'' - a date entry for this entry's creation.13 * '''created''' - a date entry for this entry's creation. 14 14 * '''updater_id''' - the last user's ID who changed this record. Foreign Key to ''users'' table. 15 15 * '''instructor_id''' - unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. 16 == evaluation_mixevals == 16 17 == evaluation_mixeval_details== 18 ||'''id'''||primary key|| 19 ||'''evaluation_mixeval_id'''|| Foreign Key to ''evaluation_mixeval'' table.|| 17 20 * '''id''' - primary key 18 * '''evaluation_mixeval_id''' - 19 == evaluation_mixevals == 21 * '''evaluation_mixeval_id''' - Foreign Key to ''evaluation_mixeval'' table. 20 22 == evaluation_rubrics_details == 21 23 == evaluation_rubrics ==