Changes between Version 36 and Version 37 of iPeerDatabaseSchema
- Timestamp:
- 2010-10-18T18:37:17Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
iPeerDatabaseSchema
v36 v37 139 139 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 140 140 ||'''modified'''||date||the last time of modification 141 == group_events == 142 == groups == 141 == groups == 142 Holds the members for each group in a class. 143 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 144 ||'''id'''||integer||Primary_Key 145 ||''group_num''||integer||The Group number, no the ID. Not sure why we have it. 146 ||''course_id''||integer||The ID of the course this group belongs to||''courses'' 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.||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 ||'''modified'''||date||the last time of modification 143 152 == groups_members == 153 Connects groups to group members (many to many relationsip): 154 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 155 ||'''id'''||integer||Primary_Key 156 ||''group_id''||integer||The ID of the group ||''groups'' 157 ||''user_id''||integer||The ID of a group member ||''groups'' 158 That's it :-) 159 == group_events == 160 Connects groups to events, holding other data about the group submission, etc. (many to many relationsip): 161 144 162 == mixevals == 145 163 == mixevals_questions_descs ==
