[[PageOutline]] == courses == Contains all the courses in the iPeer instance. * '''id''' - primary key * '''course''' - the course number, ex: APSC 123 * '''title''' - a very short course description, ex: Academic Writing * '''homepage''' - a link to the course. Must start with !http:// or !https:// * '''self_enroll''' - not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code * '''password''' - an MD5 hash of the user password. * '''record_status''' - either 'A' or 'I', representing active or inactive. Not always checked by code. * '''creator_id''' - the ID of the user who created this course. Foreign Key to ''users'' table. * '''created'' - a date entry for this entry's creation. * '''updater_id''' - the last user's ID who changed this record. Foreign Key to ''users'' table. * '''instructor_id''' - unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. == evaluation_mixeval_details== * '''id''' - primary key * '''evaluation_mixeval_id''' - == evaluation_mixevals == == 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 ...