Changes between Version 18 and Version 19 of iPeerDatabaseSchema

Timestamp:

2010-10-15T17:07:39Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -45 +45 @@
 ||'''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''
+||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''
+||'''modified'''||date||the last time of modification.
+== evaluation_rubrics ==
+Holds all the submissions of evaluatee-evaluator pairs.
+||__Column__||__Type__||__Description__||__Foreign Key to table...__||
+||'''id'''||integer||Primary_Key
+
+
+||'''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 NULLS's)||''users''
 ||'''modified'''||date||the last time of modification.
 == evaluation_rubrics_details ==
-== evaluation_rubrics ==
 == evaluation_simples ==
 == evaluation_submissions ==