tbl1_Courses¶
- Description
Table containing all the courses the math department cares about
- Relation
all tables that have a field “CourseID” or “course_id” related to the “CourseID” field in this table
Columns¶
CourseID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
CourseTitle varchar(255) DEFAULT NULL
- Description
Title of course
- Options
display="true", null="true", search="false", type=""
CourseUnit varchar(2) DEFAULT NULL
- Description
01 for Undergraduate, 16 for graduate
- Options
display="true", null="true", search="false", type=""
CourseSubject varchar(3) DEFAULT NULL
- Description
3-digit subject code. For Math Department this is usually 640, but could be 642 or 643 for Graduate courses
- Options
display="true", null="true", search="false", type=""
CourseCrse varchar(3) DEFAULT NULL
- Description
3-digit course number.
- Footnote
Warning! some undergraduate and graduate values for this are the same but represent different courses. So this field cannot be used to uniquely identify a course.
- Options
display="true", null="true", search="false", type=""
CourseCode varchar(255) DEFAULT NULL
- Description
This is the full unit-subject-course value for a course: for example 01640152
- Options
display="true", null="true", search="false", type=""
CourseCredits float DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
CourseType varchar(255) DEFAULT NULL
- Description
U for undergraduate, G for graduate
- Footnote
Maybe we want to obsolete this since same info can be derived from the CourseUnit field?
- Options
display="true", null="true", search="false", type=""
CourseNotes mediumtext DEFAULT NULL
- Description
Notes about the course
- Options
display="true", null="true", search="false", type=""
CourseFormat int(11) DEFAULT NULL
- Description
Obsolete? Not sure but looks like CourseFormatCode field might do what this was intended to do.
- Options
display="true", null="true", search="false", type=""
UsesGrader bit(1) DEFAULT NULL
- Description
Does course require a grader? Possibly obsolete
- Footnote
Need to check if this (and following similar fields) are still used
- Options
display="true", null="true", search="false", type=""
UsesHeadTA bit(1) DEFAULT NULL
- Description
Does course require a Head TA? Possibly obsolete
- Options
display="true", null="true", search="false", type=""
UsesTech bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
CourseFormatCode varchar(12) DEFAULT NULL
- Description
Format of this course, selected from the formats available in tbl1_CourseFormats.
- Options
display="true", null="true", search="false", type=""
role1 varchar(15) DEFAULT NULL
- Description
The roleN and roleN_number fields work the same way the similar fields in tbl1_CourseFormats table work. Defaults for a course are assigned based on the values in tbl1_CourseFormats but can be overwritten for a specific course in this table.
- Options
display="true", null="true", search="false", type=""
role1_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role2 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role2_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role1b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role1b_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role1b_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role1_load_count decimal(10,2) DEFAULT NULL
- Description
this value and similar roleN_load_count fields are used in teaching load reports to determine how much a particular role played in a particular course should count towards the instructors’ teaching load.
- Footnote
This feature was in-progress at time of writing this and may be subject to needed revisions
- Options
display="true", null="true", search="false", type=""
role2b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role2b_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role2b_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role2_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3b_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3b_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role3_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4b_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4b_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role4_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5b_number smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5b_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
role5_load_count decimal(10,2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
HonorsCourse bit(1) DEFAULT NULL
- Description
Is this an exclusively honors course?
- Options
display="true", null="true", search="false", type=""
HasHonorsSections bit(1) DEFAULT NULL
- Description
Does this course have honors sections?
- Options
display="true", null="true", search="false", type=""
Prerequisites varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Corequisites varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
exam_code varchar(5) DEFAULT NULL
- Description
the course’s exam group code
- Options
display="true", null="true", search="false", type=""
url_reference varchar(200) DEFAULT NULL
- Description
The final part of the URL when building a URL to bring up this course’s course page. The first part of the URL is in the course_url_prefix* fields in the tbl1_About_sd table
- Options
display="true", null="true", search="false", type=""
inactive_course bit(1) DEFAULT NULL
- Description
True if course is no longer offered
- Options
display="true", null="true", search="false", type=""
web_course_description mediumtext DEFAULT NULL
- Description
was used for possible course-web integration feature, possibly obsolete
- Options
display="true", null="true", search="false", type=""
web_template smallint(6) DEFAULT NULL
- Description
was used for possible course-web integration feature, possibly obsolete
- Options
display="true", null="true", search="false", type=""
default_textbook mediumtext DEFAULT NULL
- Description
possibly obsolete? Used when generating HTML for textbook lists
- Options
display="true", null="true", search="false", type=""
load_0 int(1) DEFAULT 0
- Description
True if this course should never count towards a instructor’s teaching load
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""