| 67 | It seems that for each answer to a mixed evaluation question, and entry in this table is generated. |
| 68 | ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| |
| 69 | ||'''id'''||integer||Primary_Key |
| 70 | ||'''evaluation_rubric_id'''||integer||The ID of the evaluation_rubric this question answer belongs too. |
| 71 | ||'''criteria_number'''||integer||The criteria number this entry belongs to. Not a foreign key ( :-/ Ugh... ) |
| 72 | ||'''criteria_comment'''||text||A textual comment about the evaluatee according to the above creteria. |
| 73 | ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. |
| 74 | ||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users'' |
| 75 | ||'''created'''||date||a date entry for this entry's creation. |
| 76 | ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users'' |
| 77 | ||'''modified'''||date||the last time of modification. |