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

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