Changes between Version 20 and Version 21 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-15T17:27:43Z (13 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v20 v21  
    6565||'''modified'''||date||the last time of modification.
    6666== evaluation_rubrics_details ==
     67It seems that for each answer to a mixed evaluation question, and entry in this table is generated.
     68||__Column__||__Type__||__Description__||__Foreign Key to table...__||
     69||'''id'''||integer||Primary_Key
     70||'''evaluation_rubric_id'''||integer||The ID of the evaluation_rubric this question answer belongs too.
     71||'''criteria_number'''||integer||The criteria number this entry belongs to. Not a foreign key ( :-/ Ugh... )
     72||'''criteria_comment'''||text||A textual comment about the evaluatee according to the above creteria.
     73||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
     74||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''
     75||'''created'''||date||a date entry for this entry's creation.
     76||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''
     77||'''modified'''||date||the last time of modification.
    6778== evaluation_simples ==
    6879== evaluation_submissions ==