Changes between Version 17 and Version 18 of iPeerDatabaseSchema

Timestamp:

2010-10-15T17:06:03Z (15 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -33 +33 @@
 ||'''modified'''||date||the last time of modification.
 == evaluation_mixeval_details==
-||'''id'''||primary key||
-||'''evaluation_mixeval_id'''|| Foreign Key to ''evaluation_mixeval'' table.||
- * '''id''' - primary key
- * '''evaluation_mixeval_id''' - Foreign Key to ''evaluation_mixeval'' table.
+It seems that for each answer to a mixed evaluation question, and entry in this table is generated.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+||'''evaluation_mixeval_id'''||integer||The ID of the evaluation_mixeval this question answer belongs too.
+||''evaluation_mixeval'' table.
+||'''question_number'''||integer||The question being answered
+||'''question_comment'''||text|| A textual answer to the question, if present. NULL otherwise.
+||'''selected_lom'''||integer||Doesn't seem to be used. All entries set at 0. (?)
+||'''grade'''||floating||A grade that the user gave when answering the question. Set to 0.0 if a textual question.
+||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code.
+||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''
+||'''created'''||date||a date entry for this entry's creation.
+||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All 0's)||''users''
+||'''modified'''||date||the last time of modification.
 == evaluation_rubrics_details ==
 == evaluation_rubrics ==