Changes between Version 29 and Version 30 of iPeerDatabaseSchema
- Timestamp:
- 2010-10-18T17:29:18Z (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
iPeerDatabaseSchema
v29 v30 43 43 ||'''grade'''||floating||A grade that the user gave when answering the question. Set to 0.0 if a textual question. 44 44 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 45 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''45 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. ||''users'' 46 46 ||'''created'''||date||a date entry for this entry's creation. 47 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''47 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. ||''users'' 48 48 ||'''modified'''||date||the last time of modification. 49 49 == evaluation_rubrics == 50 50 Holds all the submissions of evaluatee-evaluator pairs. 51 51 ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| 52 ||'''id'''||integer||Primary_Key 52 ||'''id'''||integer||Primary_KeyNot used in this table (All 0's) (?) 53 53 ||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users'' 54 54 ||'''evaluatee'''||integer||The user being evaluated.||''users'' … … 60 60 ||'''event_id'''||integer||Points to the ''event'' that the above ''group_event'' entry is part of.||''events'' 61 61 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 62 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''62 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. ||''users'' 63 63 ||'''created'''||date||a date entry for this entry's creation. 64 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''64 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. ||''users'' 65 65 ||'''modified'''||date||the last time of modification. 66 66 == evaluation_rubrics_details == … … 92 92 ||'''grade_release'''||integer||Unsure (?) (vs grade_release) 93 93 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 94 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''94 ||'''creator_id'''||integer||the ID of the ''user'' who created this course.||''users'' 95 95 ||'''created'''||date||a date entry for this entry's creation. 96 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''96 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' 97 97 ||'''modified'''||date||the last time of modification. 98 98 == evaluation_submissions == … … 105 105 ||'''date_submitted'''||date||The date the evaluator submitted this evaluation. 106 106 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 107 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. Not used in this table (All 0's) (?)||''users''107 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. 108 108 ||'''created'''||date||a date entry for this entry's creation. 109 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. Not used in this table (All NULLS's)||''users''109 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 110 110 ||'''modified'''||date||the last time of modification. 111 111 == event_template_types == … … 115 115 ||'''table_name'''||string||The name of the table that holds these types of evaluations. 116 116 ||'''model_name'''||string||The name of the model that connects the above table to cake. 117 ||'''display_for_selection'''||integer||A boolean integer. Tells if this type of evaluations should be available for selection when an 117 ||'''display_for_selection'''||integer||A boolean integer. Tells if this type of evaluations should be available for selection when an instructor creates an event 118 118 ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. 119 119 ||'''creator_id'''||integer||the ID of the ''user'' who created this course. 120 120 ||'''created'''||date||a date entry for this entry's creation. 121 121 ||'''updater_id'''||integer||the last ''user's'' ID who changed this record. 122 ||'''modified'''||date||the last time of modification .instructor creates an event.122 ||'''modified'''||date||the last time of modification 123 123 == events == 124 124 == group_events ==
