| | 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. |
