Changes between Version 37 and Version 38 of iPeerDatabaseSchema

Timestamp:

2010-10-18T18:57:27Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -151 +151 @@
 ||'''modified'''||date||the last time of modification
 == groups_members ==
-Connects groups to group members (many to many relationsip):
+Connects groups to group members (many to many relationship):
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
 ||'''id'''||integer||Primary_Key
 ||''group_id''||integer||The ID of the group ||''groups''
-||''user_id''||integer||The ID of a group member ||''groups''
+||''user_id''||integer||The user ID of a group member ||''users''
 That's it :-)
 == group_events == 
-Connects groups to events, holding other data about the group submission, etc. (many to many relationsip):
-
+Connects groups to events, holding other data about the group submission, etc. (many to many relationship).[[br]]
+I think that the extra columns are just to cache other data from the table, and display it to the user.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||''group_id''||integer||The ID of the group ||''groups''
+||''event_id''||integer||The ID of the event ||''event''
+||''marked''||string||One of ''not reviewed'',''to review'', ''reviewed''. Determined whether the instructor reviewed the comments for any offensive contents or the like. As I understand it, "Not reviewed" means not all submissions are yet complete from group members. "To review" implies that all submissions came in, but are not yet reviewed. "Review" means all submissions were turned in and reviewed by instructor.
+||''grade''||integer||I have no idea... NULL in all case I've seen so far. Unused (?)||
+||''grade_release_status''||string||Can the users see the grades their group members gave them, or not? ''Some'', ''None'' and ''All'' are possible.
+||''grade_release_status''||string Can the users see the comments their group members gave them, or not? ''Some'', ''None'' and ''All'' are possible.
+||'''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
+||'''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
 == mixevals ==
 == mixevals_questions_descs ==