tbl1_Roles¶
- Description
List of roles a person can play when associated with a course and section
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
role varchar(255) DEFAULT NULL
- Description
Role abbreviation, for example L for lecturer
- Options
display="true", null="true", search="false", type=""
role_meaning varchar(255) DEFAULT NULL
- Description
Role meaning
- Options
display="true", null="true", search="false", type=""
FacultyRole bit(1) DEFAULT NULL
- Description
TRUE if role applies to faculty
- Footnote
Fairly sure this isn’t and the following true/false fields are not used.
- Options
display="true", null="true", search="false", type=""
GradStudentRole bit(1) DEFAULT NULL
- Description
TRUE if role applies to graduate students
- Options
display="true", null="true", search="false", type=""
UndergradRole bit(1) DEFAULT NULL
- Description
TRUE if role applies to undergrads
- Options
display="true", null="true", search="false", type=""
TiedToCourse bit(1) DEFAULT NULL
- Description
TRUE if role is associated with a specific course
- Options
display="true", null="true", search="false", type=""
default_email_template varchar(255) DEFAULT NULL
- Description
Email template when course scheduling emails are sent and a specific template is indicated per role
- 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=""