[[PageOutline]]

== courses ==
Contains all the courses in the iPeer instance.
||Column||Type||Description||Foreign Key in...||
||'''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
||'''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 ==
== 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 ...