wiki:iPeerDatabaseSchema

Version 11 (modified by Serge Okon, 14 years ago) ( diff )

--

courses

Contains all the courses in the iPeer instance.

ColumnTypeDescriptionForeign Key in...
idintegerprimary key
coursestringthe course number, ex: APSC 123
titlestringa very short course description, ex: Academic Writing
homepagestringa link to the course. Must start with http:// or https://
self_enrollemun(on, off)not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code
passwordstringan MD5 hash of the user password.
record_statusenum(A,I)either 'A' or 'I', representing active or inactive. Not always checked by code.
creator_idintegerthe ID of the user who created this course.users
createddatea date entry for this entry's creation.
updater_idintegerthe last user's ID who changed this record.users
instructor_idunused, 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

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

Attachments (2)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.