Changes between Version 41 and Version 42 of iPeerDatabaseSchema

Timestamp:

2010-10-18T20:58:18Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -190 +190 @@
 ||'''modified'''||date||the last time of modification
 == mixevals_questions_descs == 
-Holds the LOM descriptions of each mixed evaluation question.
+Holds the LOM descriptions of Lickert (Rubric type) mixed evaluation question.
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
 ||'''id'''||integer||Primary_Key
 ||'''mixeval_id'''||integer||The ID of the mixed evaluation being described.||''mixevals''
 ||'''question_num'''||integer||The question this LOM description is for.
-||'''scale_level'''||string||How many points this LOM is works. 
+||'''scale_level'''||integer||How many points this LOM is worth. 
 ||'''descriptor'''||string||The description of this LOM.
 == mixevals_questions ==
+Holds all the question titles and descriptions for this table
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''mixeval_id'''||integer||The ID of the mixed evaluation being described.||''mixevals''
+||'''question_num'''||integer||The number of this question in the mixed evaluation.
+||'''title'''||text||The question itself
+||'''instructions'''||text||A detailed description of the question.
+||'''question_type'''||enum(S,T)||The type of question. ''S'' stands for Rubric-type, ''T'' for text-answer type.
+||'''required'''||boolean integer||This question is mandatory. (I'm not sure if this is checked by code).
+||'''multiplier'''||integer||The weight of this question (?)
+||'''scale_level'''||integer||The total number of LOMs(?)
+||'''response_type'''||enum(S,L,NULL)|| ''S'' denotes a short, single-line answer. ''L'' denotes a longer, multi-line answer.
 == personalizes == 
 == questions ==