Changes between Version 73 and Version 74 of iPeerDatabaseSchema

Timestamp:

2010-10-25T16:37:45Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -366 +366 @@
 ||'''modified'''||date||the last time of modification
 == users ==
+A list of all of iPeer's users.
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
 ||'''id'''||integer||Primary_Key
@@ -384 +385 @@
 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
 ||'''modified'''||date||the last time of modification
-
 == user_enrols ==
-== user_course ==
-phew ...
+Connects courses and __students__ (many-to-many relationship)
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''course_id'''||The ID of the course the student is enrolled in.||''courses''
+||'''user_id'''||The ID of the student that's enrolled in this course.||''users''
+||'''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 record.||''users''
+||'''created'''||date||a date entry for this entry's creation.
+||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
+||'''modified'''||date||the last time of modification
+== user_courses ==
+Connects courses and __instructors & admins__ (many-to-many relationship)
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''user_id'''||The ID of the student that's enrolled in this course.||''users''
+||'''course_id'''||The ID of the course the student is enrolled in.||''courses''
+||'''access_right''||enum(O,A,R)||The access rights to this course: ''O'' means owner, ''A'' means all rights, ''R'' means read only.
+||'''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 record.||''users''
+||'''created'''||date||a date entry for this entry's creation.
+||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users''
+||'''modified'''||date||the last time of modification