Changes between Version 13 and Version 14 of iPeerDatabaseSchema

Timestamp:

2010-10-15T16:23:45Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -3 +3 @@
 == courses ==
 Contains all the courses in the iPeer instance.
-||__Column__||__Type__||__Description__||__Foreign Key in...-_||
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
 ||'''id'''||integer||primary key
 ||'''course'''||string||the course number, ex: APSC 123
@@ -11 +11 @@
 ||'''password'''||string||an MD5 hash of the user password.
 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
-||'''creator_id'''||integer||the ID of the user who created this course.||users
+||'''creator_id'''||integer||the ID of the user who created this course.||''users''
 ||'''created'''||date||a date entry for this entry's creation.
-||'''updater_id'''||integer||the last user's ID who changed this record.||users
+||'''updater_id'''||integer||the last user's ID who changed this record.||''users''
 ||'''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.
 == evaluation_mixevals ==