Changes between Version 19 and Version 20 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T17:22:30Z (15 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • iPeerDatabaseSchema

    v19 v20  
    5151||__Column__||__Type__||__Description__||__Foreign Key to table...__||
    5252||'''id'''||integer||Primary_Key
    53 
    54 
     53||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users''
     54||'''evaluatee'''||integer||The user being evaluated.||''users''
     55||'''general_comment'''||text||A general comment about the evaluatee from the evaluator
     56||'''score'''||floating||The total score that the evaluatee received from the evaluator.
     57||'''comment_release'''||integer||Are this entry's comments release to be viewed by other users?
     58||'''grade_release'''||integer||Are this entry's grades release to be viewed by other users?
     59||'''grp_event_id'''||integer||Points to the ''group_events'' entry this entry is a part of.||''group_events''
     60||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events''
    5561||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
    5662||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''