Changes between Version 14 and Version 15 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T16:29:30Z (13 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v14 v15  
    44Contains all the courses in the iPeer instance.
    55||__Column__||__Type__||__Description__||__Foreign Key to table...__||
    6 ||'''id'''||integer||primary key
     6||'''id'''||integer||PrimaryKey
    77||'''course'''||string||the course number, ex: APSC 123
    88||'''title'''||string||a very short course description, ex: Academic Writing
     
    1616||'''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.
    1717== evaluation_mixevals ==
     18A student's evaluations are put here, for the mixed evaluation type. Each evaluator-evaluate pair is recorded here.
     19||__Column__||__Type__||__Description__||__Foreign Key to table...__||
     20||'''id'''||integer||PrimaryKey
     21||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users''
     22||'''evaluatee'''||integer||The user being evaluated.||''users''
     23||'''score'''||integer||The total given by the evaluator to the evaluatee. (?)
     24
     25
    1826== evaluation_mixeval_details==
    1927||'''id'''||primary key||