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...")
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{| class="wikitable"  
The Courses table gives information regarding the Courses.
!Field Name !!Type !!Description
== Courses Variable Documentation (Reimplementation) ==
 
{| 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 [[users|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
|-
!is_private
|tinyint(1)
|Whether or not the course is available to other administrators and instructors
|-
!institution_id
|int(11)
|The institution this course belongs to.
|-
!language
|varchar(255)
|The language/locale setting for the course.
|}
 
== Courses Variable Documentation (2023 version) ==
 
{| class="wikitable" 
!Field Name !!Type !!Description 
|-
|-
!id
!id
|int(11)
|int(11)
|The unique record id
|The unique record id
|-  
|- 
!name
!name
|varchar(255)
|varchar(255)
Line 16: Line 65:
!directory_path
!directory_path
|varchar(255)
|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.
|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
!info
Line 33: Line 82:
|tinyint(1)
|tinyint(1)
|Whether or not the course is available to other administrators and instructors
|Whether or not the course is available to other administrators and instructors
|-
!institutions_id
|int(11)
|Whether or not the course is available to other administrators and instructors
|-
!locale
|varchar(255)
|The language/locale setting for the course.
|}
|}


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 03:16, 9 December 2025

The Courses table gives information regarding the Courses.

Courses Variable Documentation (Reimplementation)

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
is_private tinyint(1) Whether or not the course is available to other administrators and instructors
institution_id int(11) The institution this course belongs to.
language varchar(255) The language/locale setting for the course.

Courses Variable Documentation (2023 version)

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
institutions_id int(11) Whether or not the course is available to other administrators and instructors
locale varchar(255) The language/locale setting for the course.

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.

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Courses_table&oldid=167462"