Courses table
The Courses table gives information regarding the Courses.
Courses Variable Documentation (Reimplementation)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| name | varchar(255) | The name of the course |
| instructor_id | int(11) | The user who created this course |
| directory_path | varchar(255) | The directory to be used for work submitted to this course (assuming that files will be submitted, rather than wiki pages, etc.). Concatenated with the instructor's name to create a unique location within the directory hierarchy. We expect that submission directories for particular assignments in the course will be subdirectories of this directory. |
| info | text | A description of the course |
| created_at | datetime | The timestamp at which this course was created |
| updated_at | datetime | The timestamp at which this course was last updated |
| is_private | tinyint(1) | Whether or not the course is available to other administrators and instructors |
| institution_id | int(11) | The institution this course belongs to. |
| language | varchar(255) | The language/locale setting for the course. |
Courses Variable Documentation (2023 version)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| name | varchar(255) | The name of the course |
| instructor_id | int(11) | The user who created this course |
| directory_path | varchar(255) | The directory to be used for work submitted to this course (assuming that files will be submitted, rather than wiki pages, etc.). Concatenated with the instructor's name to create a unique location within the directory hierarchy. We expect that submission directories for particular assignments in the course will be subdirectories of this directory. |
| info | text | A description of the course |
| created_at | datetime | The timestamp at which this course was created |
| updated_at | datetime | The timestamp at which this course was last updated |
| private | tinyint(1) | Whether or not the course is available to other administrators and instructors |
| institutions_id | int(11) | Whether or not the course is available to other administrators and instructors |
| locale | varchar(255) | The language/locale setting for the course. |
E/R diagram for Parents Tables
Tables referred by the Courses Table as Foreign Key Relationship.
E/R diagram for Child Tables
Tables referred by the Courses Table as Foreign Key Relationship. NOTE: courses_users table does not exist in the database.
Back to Database Tables Main page.