wiki:iPeerDatabaseSchema

Version 9 (modified by Serge Okon, 13 years ago) ( diff )

--

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. Not always checked by code.
  • 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

  • id - primary key
  • evaluation_mixeval_id -

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

Attachments (2)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.