Changes between Version 14 and Version 15 of iPeerDatabaseSchema

Timestamp:

2010-10-15T16:29:30Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -4 +4 @@
 Contains all the courses in the iPeer instance.
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
-||'''id'''||integer||primary key
+||'''id'''||integer||PrimaryKey
 ||'''course'''||string||the course number, ex: APSC 123
 ||'''title'''||string||a very short course description, ex: Academic Writing
@@ -16 +16 @@
 ||'''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 ==
+A student's evaluations are put here, for the mixed evaluation type. Each evaluator-evaluate pair is recorded here.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||PrimaryKey
+||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users''
+||'''evaluatee'''||integer||The user being evaluated.||''users''
+||'''score'''||integer||The total given by the evaluator to the evaluatee. (?)
+
+
 == evaluation_mixeval_details==
 ||'''id'''||primary key||