tbl1_CourseFormats¶
- Description
This table describes the ways a course format can be categorized based on how it is presented For example “Lecture and Recitation” which typically has 2 lectures and one recitation per week
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
format_name varchar(255) DEFAULT NULL
- Description
description of the format
- Options
display="true", null="true", search="false", type=""
format_abbr varchar(15) DEFAULT NULL
- Description
format abbreviation
- Options
display="true", null="true", search="false", type=""
default_role1 varchar(15) DEFAULT NULL
- Footnote
This footnote pertains to all default_roleN and default_numberN fields. When new semesters are created, this many “role” fields in tbl1_Schedule_Data table will be pre-assigned to these roles so they can then be assigned. For example, a course that is LLR format might always need a grader. Specifics can be overwriten within individual semester schedule data. The default_numberN fields indicate how many people should be assigned by default to each role (this is typically 1) The fields ending in “b” will refer to the second meeting type of the course. For exmaple, for LLR courses, the “b” series of fields will apply to the recitation (as opposed to the lecture)
- Options
display="true", null="true", search="false", type=""
default_number1 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role2 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role3 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role4 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role5 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role1b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number1b smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role2b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number2b smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role3b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number3b smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role4b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number4b smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_role5b varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
default_number5b smallint(6) DEFAULT NULL
- 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=""