.. index:: tbl1_Courses ============ tbl1_Courses ============ .. default-role:: doc :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=""``