Courses table: Difference between revisions
Jump to navigation
Jump to search
| Line 50: | Line 50: | ||
== E/R diagram for Child Tables == | == E/R diagram for Child Tables == | ||
Tables referred by the Courses Table as Foreign Key Relationship. | Tables referred by the Courses Table as Foreign Key Relationship. | ||
'''NOTE: courses_users table does not exist in the database.''' | |||
[[File:courses_exported.png]] | [[File:courses_exported.png]] | ||
Latest revision as of 14:22, 5 June 2021
The Courses table gives information regarding the Courses.
Courses Variable Documentation
| 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 |
| instituitions_id | int(11) | Whether or not the course is available to other administrators and instructors |
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.