Changes between Version 15 and Version 16 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T16:35:34Z (14 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • iPeerDatabaseSchema

    v15 v16  
    44Contains all the courses in the iPeer instance.
    55||__Column__||__Type__||__Description__||__Foreign Key to table...__||
    6 ||'''id'''||integer||PrimaryKey
     6||'''id'''||integer||Primary_Key
    77||'''course'''||string||the course number, ex: APSC 123
    88||'''title'''||string||a very short course description, ex: Academic Writing
    … …  
    1818A student's evaluations are put here, for the mixed evaluation type. Each evaluator-evaluate pair is recorded here.
    1919||__Column__||__Type__||__Description__||__Foreign Key to table...__||
    20 ||'''id'''||integer||PrimaryKey
     20||'''id'''||integer||Primary_Key
    2121||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users''
    2222||'''evaluatee'''||integer||The user being evaluated.||''users''
    23 ||'''score'''||integer||The total given by the evaluator to the evaluatee. (?)
    24 
     23||'''score'''||floating||The total given by the evaluator to the evaluatee. (?)
     24||'''comment_release'''||integer||Are this entry's comments release to be viewed by other users?
     25||'''grade_release'''||integer||Are this entry's grades release to be viewed by other users?
     26||'''grp_event_id'''||integer||Points to the ''group_events'' entry this entry is a part of.||''group_events''
     27||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events''
    2528
    2629== evaluation_mixeval_details==