Changes between Version 23 and Version 24 of iPeerDatabaseSchema

Timestamp:

2010-10-15T18:22:58Z (14 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -85 +85 @@
 ||'''score'''||integer||The score this evaluator gave the evaluatee.
 ||'''eval_comment'''||text||A comment about the evaluatee by the evaluator.
-||'''release_status'''||integer||Unsure (?)
+||'''release_status'''||integer||Unsure (?) (vs grade_release)
 ||'''grp_event_id'''||integer||Points to the ''group_events'' entry this entry is a part of.||''group_events''
 ||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events''
-||'''date_submitted'''||The date the evaluation was submitted. (Does this just copy the info in ''evaluation_submissions'').
+||'''date_submitted'''||date||The date the evaluation was submitted. (Does this just copy the info in ''evaluation_submissions'' ?)
+||'''grade_release'''||integer||Unsure (?) (vs grade_release)
+||'''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_submissions ==
 == event_template_types ==