[[PageOutline]] == courses == Contains all the courses in the iPeer instance. ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| ||'''id'''||integer||Primary_Key ||'''course'''||string||the course number, ex: APSC 123 ||'''title'''||string||a very short course description, ex: Academic Writing ||'''homepage'''||string||a link to the course. Must start with !http:// or !https:// ||'''self_enroll'''||emun(on, off)||not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code ||'''password'''||string||an MD5 hash of the user password. ||'''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.||''users'' ||'''created'''||date||a date entry for this entry's creation. ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' ||'''modified'''||date||the last time of modification. ||'''instructor_id'''||integer||unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. == evaluation_mixevals == A student's evaluations are put here, for the mixed evaluation type. Each evaluator-evaluate pair is recorded here. ||__Column__||__Type__||__Description__||__Foreign Key to table...__|| ||'''id'''||integer||Primary_Key ||'''evaluator'''||integer||The user submitting the evaluation. They are evaluating other users.||''users'' ||'''evaluatee'''||integer||The user being evaluated.||''users'' ||'''score'''||floating||The total given by the evaluator to the evaluatee. (?) ||'''comment_release'''||integer||Are this entry's comments release to be viewed by other users? ||'''grade_release'''||integer||Are this entry's grades release to be viewed by other users? ||'''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'' ||'''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.||''users'' ||'''created'''||date||a date entry for this entry's creation. ||'''updater_id'''||integer||the last ''user's'' ID who changed this record.||''users'' ||'''modified'''||date||the last time of modification. == evaluation_mixeval_details== ||'''id'''||primary key|| ||'''evaluation_mixeval_id'''|| Foreign Key to ''evaluation_mixeval'' table.|| * '''id''' - primary key * '''evaluation_mixeval_id''' - Foreign Key to ''evaluation_mixeval'' table. == evaluation_rubrics_details == == evaluation_rubrics == == evaluation_simples == == evaluation_submissions == == event_template_types == == events == == group_events == == groups == == groups_members == == mixevals == == mixevals_questions_descs == == mixevals_questions == == personalizes == == questions == == responces == == rubrics == == rubtics_criteria_comments == == rubrics_criterias == == rubrics_loms == == simple_evaluatons == == survey_group_members == == survey_group_sets == == survey_groups == == survey_inputs == == survey_questions == == surveys == == sys_function == == sys_parameters == == user_course == == user_enrols == == users == phew ...