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