Courses table: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| 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 [[us...") |
(No difference)
|
Revision as of 19:48, 17 May 2016
| 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 |
Back to the database documentation