| Version 13 (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 in...-_ |
| 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 |
| 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. |