.. index:: tbl1_survey_responses ===================== tbl1_survey_responses ===================== .. default-role:: doc :Description: Data table containing all survey responses from Teaching Availability and Preferences survey and each instructors' response answers :Source: Data originally comes from Qualtrics, where surveys are created :Footnote: Future: associate people with tbl1_People table instead of only having netid here Also, this table has an annoying design where the course fields have prefixes like "BS001" for "basic skills" course 001 and "Calc291" for calculus course 291. This program would be improved if we instead had the field names just be full course number like: 01640135. We could add a CourseID field to this table to related the question to the `tbl1_Courses` table Columns ======= **ID** ``int(11) NOT NULL AUTO_INCREMENT`` :Options: ``display="true", null="true", search="false", type=""`` **the_semester** ``varchar(50) DEFAULT NULL`` :Description: Fall, Spring or Summer :Options: ``display="true", null="true", search="false", type=""`` **the_year** ``smallint(6) DEFAULT NULL`` :Description: Semester Year :Options: ``display="true", null="true", search="false", type=""`` **selected** ``tinyint(1) DEFAULT 0`` :Description: Corresponds to checkbox to the left of each instructor response. TRUE if checked. :Options: ``display="true", null="true", search="false", type=""`` **first_name** ``varchar(255) DEFAULT NULL`` :Description: Instructor First Name :Options: ``display="true", null="true", search="false", type=""`` **last_name** ``varchar(255) DEFAULT NULL`` :Description: Instructor Last Name :Options: ``display="true", null="true", search="false", type=""`` **response_date** ``datetime DEFAULT NULL`` :Description: Resonse Date :Options: ``display="true", null="true", search="false", type=""`` **netid** ``varchar(255) DEFAULT NULL`` :Description: instructor's netid :Options: ``display="true", null="true", search="false", type=""`` **email** ``varchar(255) DEFAULT NULL`` :Description: instructor's email :Options: ``display="true", null="true", search="false", type=""`` **Role** ``varchar(255) DEFAULT NULL`` :Description: Person's Role: Faculty, Annual, PTL or Graduate Student :Options: ``display="true", null="true", search="false", type=""`` **load** ``smallint(6) DEFAULT NULL`` :Description: self-reported teaching load from survey question :Footnote: at time of writing this, we are embarking on a survey rewrite where we will already have the instructors' load at time of survey and tell them instead of having them self-report :Options: ``display="true", null="true", search="false", type=""`` **GradCourse** ``bit(1) DEFAULT NULL`` :Description: corresponds to "Do you plan on teaching a graduate course" question :Options: ``display="true", null="true", search="false", type=""`` **Assignment** ``bit(1) DEFAULT NULL`` :Description: corresponds to "Do you expect a teaching assignment this semester?" question :Options: ``display="true", null="true", search="false", type=""`` **NumCourses** ``smallint(6) DEFAULT NULL`` :Description: Corresponds to "How many courses do you want to teach this semester?" question :Options: ``display="true", null="true", search="false", type=""`` **PTLRecWrk** ``bit(1) DEFAULT NULL`` :Description: Corresponds to PTL question "Lecturing assignments may not always be available. Would you like to be considered for Recitation/Workshop assignments as well?" :Options: ``display="true", null="true", search="false", type=""`` **HeadTA** ``bit(1) DEFAULT NULL`` :Description: Corresponds to "Would you like to be considered for Head TA?" question :Options: ``display="true", null="true", search="false", type=""`` **ppMH1** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Monday/Thursday Period 1 :Footnote: 1=Preferred, 2=OK, 3=Possible but inconvenient, 4=impossible. Same for all period or period-pair preference fields :Options: ``display="true", null="true", search="false", type=""`` **ppTF1** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Tuesday/Friday Period 1 :Options: ``display="true", null="true", search="false", type=""`` **ppMH2** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Monday/Thursday Period 2 :Options: ``display="true", null="true", search="false", type=""`` **ppTF2** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Tuesday/Friday Period 2 :Options: ``display="true", null="true", search="false", type=""`` **ppW2F5** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Wed P2/Friday P5 :Options: ``display="true", null="true", search="false", type=""`` **ppMH3** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Monday/Thursday Period 3 :Options: ``display="true", null="true", search="false", type=""`` **ppTF3** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Tuesday/Friday Period 3 :Options: ``display="true", null="true", search="false", type=""`` **ppW3F4** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for period pair Wed Period 3 / Friday Period 4 :Options: ``display="true", null="true", search="false", type=""`` **ppMW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **PPCampus** ``varchar(255) DEFAULT NULL`` :Description: Preferred campus when asked the period-pair question :Options: ``display="true", null="true", search="false", type=""`` **PPOther** ``varchar(255) DEFAULT NULL`` :Description: Other comments about availability when asked the period-pair question :Options: ``display="true", null="true", search="false", type=""`` **perM1** ``smallint(6) DEFAULT NULL`` :Description: Ranking of availability preference for Monday Period 1 :Footnote: 1=Preferred, 2=OK, 3=Possible but inconvenient, 4=impossible. Same for all period or period preference fields :Options: ``display="true", null="true", search="false", type=""`` **perM2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perCampus** ``varchar(255) DEFAULT NULL`` :Description: Preferred campus when asked period question :Options: ``display="true", null="true", search="false", type=""`` **PerOther** ``varchar(255) DEFAULT NULL`` :Description: other notes when asked the period question :Options: ``display="true", null="true", search="false", type=""`` **BS001** ``smallint(6) DEFAULT NULL`` :Description: Survey answer for course 001 :Footnote: Response values for this and all other course fields: 1=Strong Preference, 2=I have no problems with teaching this course, 3=I would rather not teach this course, but can do so if necessary 4=This course is not appropriate for me, please do not assign it. :Options: ``display="true", null="true", search="false", type=""`` **BS023** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS025** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS026** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS111** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS112** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS115** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS123** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **10X103** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X104** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X105** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X106** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X107** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X108** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X109** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X110** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc135** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc135_Star** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc136** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc138** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc151** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc151H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc152** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc152H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc191** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc191_Star** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc192** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc192_Star** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc196** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc251** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc251H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc291** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc291_Star** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL244** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL250** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL250C** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL252** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL285** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL292** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **LL292_Star** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL300** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL300H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL311** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL311H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL312** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL321** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL325** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL336** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL338** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL348** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL350** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL350H** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL351** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL354** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL355** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL356** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL357** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL361** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL373** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL403** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL411** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL412** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL421** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL423** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL424** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL428** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL432** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL435** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL436** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL437** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **UL441** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL442** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **UL451** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL452** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL453** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL454** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL461** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL468** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL477** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL478** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL481** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL485** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL486** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL487** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL492** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL493** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL495** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **R_CompDaily** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **R_CompWeek** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **R_MinCrsPrep** ``smallint(6) DEFAULT NULL`` :Options: ``type="", null="true", search="false", display="true"`` **ULOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummerTch** ``smallint(6) DEFAULT NULL`` :Description: This corresponds with the "Do you want a summer teaching assignment" question :Options: ``display="true", null="true", search="false", type=""`` **Summer_B** ``bit(1) DEFAULT NULL`` :Description: This and subsequent Summer_X fields represent the availability questions for each series of summer dates when we might offer courses. :Footnote: values 1-4 with 1 being best availability :Options: ``display="true", null="true", search="false", type=""`` **Summer_C** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_E** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_F** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_H** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_T** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM8** ``smallint(6) DEFAULT NULL`` :Description: availability for Summer Monday period 8 :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SumHowMany** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummOther2** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummCampus** ``varchar(255) 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=""``