Version 42 (modified by 14 years ago) ( diff ) | ,
---|
-
- courses
- evaluation_mixevals
- evaluation_mixeval_details
- evaluation_rubrics
- evaluation_rubrics_details
- evaluation_simples
- evaluation_submissions
- event_template_types
- events
- groups
- groups_members
- group_events
- 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. | 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_rubrics
Holds all the submissions of evaluatee-evaluator pairs.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_KeyNot used in this table (All 0's) (?) | |
evaluator | integer | The user submitting the evaluation. They are evaluating other users. | users |
evaluatee | integer | The user being evaluated. | users |
general_comment | text | A general comment about the evaluatee from the evaluator | |
score | floating | The total score that the evaluatee received from the evaluator. | |
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_rubrics_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_rubric_id | integer | The ID of the evaluation_rubric this question answer belongs too. | |
criteria_number | integer | The criteria number this entry belongs to. Not a foreign key ( :-/ Ugh... ) | |
criteria_comment | text | A textual comment about the evaluatee according to the above creteria. | |
selected_lom | integer | The level-of-mastery the evaluator selected for the evaluatee. | |
grade | floating | The grade the above LOM gives the evaluatee. | |
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 NULLS's) | users |
modified | date | the 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.
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 | integer | The score this evaluator gave the evaluatee. | |
eval_comment | text | A comment about the evaluatee by the evaluator. | |
release_status | integer | Unsure (?) (vs grade_release) | |
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 |
date_submitted | date | The date the evaluation was submitted. (Does this just copy the info in evaluation_submissions ?) | |
grade_release | integer | Unsure (?) (vs grade_release) | |
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_submissions
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
event_id | integer | Points to the event that the above group_event entry is part of. | events |
grp_event_id | integer | Points to the group_events entry this entry is a part of. | group_events |
submitter_id | integer | The evaluator's user ID | users |
submitted | integer | Apparently 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_submitted | date | The date the evaluator submitted this evaluation. | |
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. | |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. | |
modified | date | the 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.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
table_name | string | The name of the table that holds these types of evaluations. | |
model_name | string | The name of the model that connects the above table to cake. | |
display_for_selection | integer | A boolean integer. Tells if this type of evaluations should be available for selection when an instructor creates an event | |
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. | |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. | |
modified | date | the last time of modification |
events
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
title | string | The title of this event; | |
course_id | integer | The id of the course that this event will appear in | courses |
description | text | A textual description of this event. | |
event_template_type_id | integer | The type of the evaluation. | event_template_types |
template_id | integer | The ID of in the entry of this evaluation inside the particular evaluation type's table | simple_evaluations or rubrics or surveys or mixevals |
self_eval | boolean integer | Does the user evaluate themselves as well? | |
com_req' | boolean integer | Are the comments required? | |
due_date | date | The due date for the event. | |
release_date_begin | date | The when the event will open - start showing up on the student's display. | |
release_date_end | date | The when the event will close - stop showing up on the student's display, even if it was completed. | |
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. | |
created | date | a date entry for this entry's creation. | |
updater_id | integer | the last user's ID who changed this record. | |
modified | date | the last time of modification |
groups
Holds the members for each group in a class.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
group_num | integer | The Group number, no the ID. Not sure why we have it. | |
course_id | integer | The ID of the course this group belongs to | courses |
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 |
groups_members
Connects groups to group members (many to many relationship):
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
group_id | integer | The ID of the group | groups |
user_id | integer | The user ID of a group member | users |
That's it :-)
group_events
Connects groups to events, holding other data about the group submission, etc. (many to many relationship).
I think that the extra columns are just to cache other data from the table, and display it to the user.
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
group_id | integer | The ID of the group | groups |
event_id | integer | The ID of the event | event |
marked | string | One of not reviewed,to review, reviewed. Determined whether the instructor reviewed the comments for any offensive contents or the like. As I understand it, "Not reviewed" means not all submissions are yet complete from group members. "To review" implies that all submissions came in, but are not yet reviewed. "Review" means all submissions were turned in and reviewed by instructor. | |
grade | integer | I have no idea... NULL in all case I've seen so far. Unused (?) | |
grade_release_status | string | Can the users see the grades their group members gave them, or not? Some, None and All are possible. | |
grade_release_status | string | Can the users see the comments their group members gave them, or not? Just like above, Some, None and All are possible. | |
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 |
mixevals
Contains a list of Mixed Evaluation (Templates - referenced by evaluation events)
Column | Type | Description | Foreign Key to table... |
id | integer | Primary_Key | |
name | string | Title of the evaluation | |
total_marks | integer | The total amount of point possible in this evaluation per member. | |
zero_mark | enum(on,off) | Does the lowerst LOM count as a zero score? | |
total_question | integer | The total number of questions - both Lickert and Textual Answer. | |