courses

Contains all the courses in the iPeer instance.

Column	Type	Description	Foreign Key to table...
id	integer	PrimaryKey
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

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	PrimaryKey
evaluator	integer	The user submitting the evaluation. They are evaluating other users.	users
evaluatee	integer	The user being evaluated.	users
score	integer	The total given by the evaluator to the evaluatee. (?)

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 ...