wiki:iPeerDatabaseSchema

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

--

courses

Contains all the courses in the iPeer instance.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimaryKey
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_idintegerunused, 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.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimaryKey
evaluatorintegerThe user submitting the evaluation. They are evaluating other users.users
evaluateeintegerThe user being evaluated.users
scoreintegerThe total given by the evaluator to the evaluatee. (?)

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.