Courses table: Difference between revisions

From Expertiza_Wiki
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.