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...") |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
The Courses table gives information regarding the Courses. | |||
== Courses Variable Documentation == | |||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name !!Type !!Description | !Field Name !!Type !!Description | ||
| Line 32: | Line 35: | ||
!private | !private | ||
|tinyint(1) | |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 | |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. | |||
[[File:courses_imported.png]] | |||
== 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.''' | |||
[[File:courses_exported.png]] | |||
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page. | |||
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.