Courses table: Difference between revisions

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


Back to the [[Documentation_on_Database_Tables|database documentation]]
== 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.