Version 18 (modified by 14 years ago) ( diff ) | ,
---|
-
- courses
- evaluation_mixevals
- evaluation_mixeval_details
- 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
courses
Contains all the courses in the iPeer instance.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
course | string | the course number, ex: APSC 123 | |
title | string | a very short course description, ex: Academic Writing | |
homepage | string | a link to the course. Must start with http:// or https:// | |
self_enroll | emun(on, off) | not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code | |
password | string | an MD5 hash of the user password. | |
record_status | enum(A,I) | either 'A' or 'I', representing active or inactive. Not always checked by code. | |
creator_id | integer | the ID of the user who created this course. | users |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. | users |
modified | date | the last time of modification. | |
instructor_id | integer | unused, 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.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
evaluator | integer | The user submitting the evaluation. They are evaluating other users. | users |
evaluatee | integer | The user being evaluated. | users |
score | floating | The total given by the evaluator to the evaluatee. (?) | |
comment_release | integer | Are this entry's comments release to be viewed by other users? | |
grade_release | integer | Are this entry's grades release to be viewed by other users? | |
grp_event_id | integer | Points to the group_events entry this entry is a part of. | group_events |
event_id | integer | Points to the event that the above group_event entry is part of. | events |
record_status | enum(A,I) | either 'A' or 'I', representing active or inactive. Not always checked by code. | |
creator_id | integer | the ID of the user who created this course. | users |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. | users |
modified | date | the 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.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
evaluation_mixeval_id | integer | The ID of the evaluation_mixeval this question answer belongs too. | |
evaluation_mixeval table. | |||
question_number | integer | The question being answered | |
question_comment | text | A textual answer to the question, if present. NULL otherwise. | |
selected_lom | integer | Doesn't seem to be used. All entries set at 0. (?) | |
grade | floating | A grade that the user gave when answering the question. Set to 0.0 if a textual question. | |
record_status | enum(A,I) | either 'A' or 'I', representing active or inactive. Not always checked by code. | |
creator_id | integer | the ID of the user who created this course. Not used in this table (All 0's) (?) | users |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. Not used in this table (All 0's) | users |
modified | date | the last time of modification. |
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)
- db-schema1.png (221.2 KB ) - added by 14 years ago.
- db-schema1.2.png (229.3 KB ) - added by 14 years ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.