Courses table

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.