wiki:iPeerDatabaseSchema

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

--

courses

Contains all the courses in the iPeer instance.

ColumnTypeDescriptionForeign Key to table...
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
modifieddatethe last time of modification.
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...
idintegerPrimary_Key
evaluatorintegerThe user submitting the evaluation. They are evaluating other users.users
evaluateeintegerThe user being evaluated.users
scorefloatingThe total given by the evaluator to the evaluatee. (?)
comment_releaseintegerAre this entry's comments release to be viewed by other users?
grade_releaseintegerAre this entry's grades release to be viewed by other users?
grp_event_idintegerPoints to the group_events entry this entry is a part of.group_events
event_idintegerPoints to the event that the above group_event entry is part of.events
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
modifieddatethe last time of modification.

evaluation_mixeval_details

It seems that for each answer to a mixed evaluation question, and entry in this table is generated.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
evaluation_mixeval_idintegerThe ID of the evaluation_mixeval this question answer belongs too.
evaluation_mixeval table.
question_numberintegerThe question being answered
question_commenttext A textual answer to the question, if present. NULL otherwise.
selected_lomintegerDoesn't seem to be used. All entries set at 0. (?)
gradefloatingA grade that the user gave when answering the question. Set to 0.0 if a textual question.
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
modifieddatethe last time of modification.

evaluation_rubrics

Holds all the submissions of evaluatee-evaluator pairs.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_KeyNot used in this table (All 0's) (?)
evaluatorintegerThe user submitting the evaluation. They are evaluating other users.users
evaluateeintegerThe user being evaluated.users
general_commenttextA general comment about the evaluatee from the evaluator
scorefloatingThe total score that the evaluatee received from the evaluator.
comment_releaseintegerAre this entry's comments release to be viewed by other users?
grade_releaseintegerAre this entry's grades release to be viewed by other users?
grp_event_idintegerPoints to the group_events entry this entry is a part of.group_events
event_idintegerPoints to the event that the above group_event entry is part of.events
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
modifieddatethe last time of modification.

evaluation_rubrics_details

It seems that for each answer to a mixed evaluation question, and entry in this table is generated.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
evaluation_rubric_idintegerThe ID of the evaluation_rubric this question answer belongs too.
criteria_numberintegerThe criteria number this entry belongs to. Not a foreign key ( :-/ Ugh... )
criteria_commenttextA textual comment about the evaluatee according to the above creteria.
selected_lomintegerThe level-of-mastery the evaluator selected for the evaluatee.
gradefloatingThe grade the above LOM gives the evaluatee.
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. Not used in this table (All 0's) (?)users
createddatea date entry for this entry's creation.
updater_idintegerthe last user's ID who changed this record. Not used in this table (All NULLS's)users
modifieddatethe last time of modification.

evaluation_simples

Every time an evaluator saves their progress in simple evaluation for an evaluatee, an entry is saved into this table.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
evaluatorintegerThe user submitting the evaluation. They are evaluating other users.users
evaluateeintegerThe user being evaluated.users
scoreintegerThe score this evaluator gave the evaluatee.
eval_commenttextA comment about the evaluatee by the evaluator.
release_statusintegerUnsure (?) (vs grade_release)
grp_event_idintegerPoints to the group_events entry this entry is a part of.group_events
event_idintegerPoints to the event that the above group_event entry is part of.events
date_submitteddateThe date the evaluation was submitted. (Does this just copy the info in evaluation_submissions ?)
grade_releaseintegerUnsure (?) (vs grade_release)
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
modifieddatethe last time of modification.

evaluation_submissions

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
event_idintegerPoints to the event that the above group_event entry is part of.events
grp_event_idintegerPoints to the group_events entry this entry is a part of.group_events
submitter_idintegerThe evaluator's user IDusers
submittedintegerApparently determined whether the evaluation was submitted or not. I don't see any 0's in the prod2009 database though. Might have something to do with re-releases. Not sure (?).
date_submitteddateThe date the evaluator submitted this evaluation.
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.
createddatea date entry for this entry's creation.
updater_idintegerthe last user's ID who changed this record.
modifieddatethe last time of modification.

event_template_types

I think this holds the the entries for the rubric types in iPeer. However, the code often assumes it knows the meanings of evaluation type id's (1,2,3,4), and hard-codes those into the code, sometimes ignoring this table.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
table_namestringThe name of the table that holds these types of evaluations.
model_namestringThe name of the model that connects the above table to cake.
display_for_selectionintegerA boolean integer. Tells if this type of evaluations should be available for selection when an instructor creates an event
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.
createddatea date entry for this entry's creation.
updater_idintegerthe last user's ID who changed this record.
modifieddatethe last time of modification

events

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
titlestringThe title of this event;
course_idintegerThe id of the course that this event will appear incourses
descriptiontextA textual description of this event.
event_template_type_idintegerThe type of the evaluation.event_template_types
template_idintegerThe ID of in the entry of this evaluation inside the particular evaluation type's tablesimple_evaluations or rubrics or surveys or mixevals
self_evalboolean integerDoes the user evaluate themselves as well?
com_req'boolean integerAre the comments required?
due_datedateThe due date for the event.
release_date_begindateThe when the event will open - start showing up on the student's display.
release_date_enddateThe when the event will close - stop showing up on the student's display, even if it was completed.
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.
createddatea date entry for this entry's creation.
updater_idintegerthe last user's ID who changed this record.
modifieddatethe last time of modification

groups

Holds the members for each group in a class.

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
group_numintegerThe Group number, no the ID. Not sure why we have it.
course_idintegerThe ID of the course this group belongs tocourses
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
modifieddatethe last time of modification

groups_members

Connects groups to group members (many to many relationsip):

ColumnTypeDescriptionForeign Key to table...
idintegerPrimary_Key
group_idintegerThe ID of the group groups
user_idintegerThe ID of a group member groups

That's it :-)

group_events

Connects groups to events, holding other data about the group submission, etc. (many to many relationsip):

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.