Changes between Version 41 and Version 42 of iPeerDatabaseSchema


Ignore:
Timestamp:
2010-10-18T20:58:18Z (13 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • iPeerDatabaseSchema

    v41 v42  
    190190||'''modified'''||date||the last time of modification
    191191== mixevals_questions_descs ==
    192 Holds the LOM descriptions of each mixed evaluation question.
     192Holds the LOM descriptions of Lickert (Rubric type) mixed evaluation question.
    193193||__Column__||__Type__||__Description__||__Foreign Key to table...__||
    194194||'''id'''||integer||Primary_Key
    195195||'''mixeval_id'''||integer||The ID of the mixed evaluation being described.||''mixevals''
    196196||'''question_num'''||integer||The question this LOM description is for.
    197 ||'''scale_level'''||string||How many points this LOM is works.
     197||'''scale_level'''||integer||How many points this LOM is worth.
    198198||'''descriptor'''||string||The description of this LOM.
    199199== mixevals_questions ==
     200Holds all the question titles and descriptions for this table
     201||__Column__||__Type__||__Description__||__Foreign Key to table...__||
     202||'''id'''||integer||Primary_Key
     203||'''mixeval_id'''||integer||The ID of the mixed evaluation being described.||''mixevals''
     204||'''question_num'''||integer||The number of this question in the mixed evaluation.
     205||'''title'''||text||The question itself
     206||'''instructions'''||text||A detailed description of the question.
     207||'''question_type'''||enum(S,T)||The type of question. ''S'' stands for Rubric-type, ''T'' for text-answer type.
     208||'''required'''||boolean integer||This question is mandatory. (I'm not sure if this is checked by code).
     209||'''multiplier'''||integer||The weight of this question (?)
     210||'''scale_level'''||integer||The total number of LOMs(?)
     211||'''response_type'''||enum(S,L,NULL)|| ''S'' denotes a short, single-line answer. ''L'' denotes a longer, multi-line answer.
    200212== personalizes ==
    201213== questions ==