Courses table: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
The Courses table gives information regarding the Courses. | The Courses table gives information regarding the Courses. | ||
== Courses Variable Documentation == | == Courses Variable Documentation (Reimplementation) == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name !!Type !! | !Field Name !!Type !!Description | ||
|- | |- | ||
!id | !id | ||
|int(11) | |int(11) | ||
|The unique record id | |The unique record id | ||
|- | |- | ||
!name | !name | ||
|varchar(255) | |varchar(255) | ||
| Line 19: | Line 19: | ||
!directory_path | !directory_path | ||
|varchar(255) | |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. | |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) == | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |||
!id | |||
|int(11) | |||
|The unique record id | |||
|- | |||
!name | |||
|varchar(255) | |||
|The name of the course | |||
|- | |||
!instructor_id | |||
|int(11) | |||
|The [[users|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 | !info | ||
| Line 37: | Line 83: | ||
|Whether or not the course is available to other administrators and instructors | |Whether or not the course is available to other administrators and instructors | ||
|- | |- | ||
! | !institutions_id | ||
|int(11) | |int(11) | ||
|Whether or not the course is available to other administrators and instructors | |Whether or not the course is available to other administrators and instructors | ||
|- | |||
!locale | |||
|varchar(255) | |||
|The language/locale setting for the course. | |||
|} | |} | ||
Latest revision as of 03:16, 9 December 2025
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.