Courses table - Revision history

Rtantry2: /* Courses Variable Documentation */

2025-12-09T03:16:19Z

Courses Variable Documentation

@@ Line 1: / Line 1: @@
 The Courses table gives information regarding the Courses.
-== Courses Variable Documentation ==
+== Courses Variable Documentation (Reimplementation) ==
 {| class="wikitable"
 !Field Name !!Type !!Description
 |-
 !id
 |int(11)
 |The unique record id
 |-
 !name
 |varchar(255)
@@ Line 19: / Line 19: @@
 !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.
+|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
@@ Line 37: / Line 83: @@
 |Whether or not the course is available to other administrators and instructors
 |-
-!instituitions_id
+!institutions_id
 |int(11)
 |Whether or not the course is available to other administrators and instructors
 |}

Jcui9: /* E/R diagram for Child Tables */

2021-06-05T14:22:27Z

E/R diagram for Child Tables

← Older revision		Revision as of 14:22, 5 June 2021
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]]

Psinha: /* E/R diagram for Child Tables */

2018-04-24T23:19:29Z

E/R diagram for Child Tables

← Older revision		Revision as of 23:19, 24 April 2018
Line 49:		Line 49:

	== E/R diagram for Child Tables ==		== E/R diagram for Child Tables ==
	Tables referred by the Courses ~~Actions~~ Table as Foreign Key Relationship.		Tables referred by the Courses Table as Foreign Key Relationship.

	[[File:courses_exported.png]]		[[File:courses_exported.png]]

Psinha at 23:15, 24 April 2018

2018-04-24T23:15:21Z

@@ Line 1: / Line 1: @@
 {| class="wikitable"
 !Field Name !!Type !!Description
@@ Line 32: / Line 35: @@
 !private
 |tinyint(1)
 |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 ==

Rkyadav: 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..."

2016-05-17T19:48:53Z

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..."

New page

{| 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
|-
!private
|tinyint(1)
|Whether or not the course is available to other administrators and instructors
|}

Back to the [[Documentation_on_Database_Tables|database documentation]]