[[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_mixevals ==
== 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 ...