Megan W Morton edited section_Appendix_1_Tables__.tex  almost 8 years ago

Commit id: 7512faf7dcf58459e754b88cb5f606a9081dc070

deletions | additions      

       

\section{Appendix 1}  Tables  \subsection{Data Types}  \begin{tabular}{|c|c|c|c|c|}  \hline   Question number & Response type & Table name & Column name & Data type \\   \hline   1 & bool & - & - & - \\   \hline   2 & single answer & SCHOOLSDATA & NAME & text \\   \hline   2 & single answer & SCHOOLSDATA & ADDRESS & text \\   \hline   2 & single answer & SCHOOLSDATA & CITY & text \\   \hline   2 & single answer & SCHOOLSDATA & STATE & text \\   \hline   2 & single answer & SCHOOLSDATA & ZIP & int \\   \hline   2 & single answer & SCHOOLSDATA & PHONE & int \\   \hline   3 & single answer & SCHOOLSDATA & ATSDOFFICENAME & text \\   \hline   3 & single answer & SCHOOLSDATA & ATSDLOCATION & text \\   \hline   3 & single answer & SCHOOLSDATA & ATSDEMAIL & text \\   \hline   3 & single answer & SCHOOLSDATA & ATSDPHONE & int \\   \hline   4 & single answer & SCHOOLSDATA & SCHOOLURL & text \\   \hline   5 & single answer & SCHOOLSDATA & ATSDURL & text \\   \hline   6 & single answer & SCHOOLSDATA & PUBLIC_PRIVATE & boolean \\   \hline   7 & boolean & SPREADSHEET & WEBSITEACCESS & boolean \\   \hline   7 & long answer & SCHOOLSDATA & WEBSITEACCESSTEXT & text \\   \hline   8 & boolean & SPREADSHEET & SYLLABIACCESS & boolean \\   \hline   8 & long answer & SCHOOLSDATA & SYLLABIACCESSTEXT & text \\   \hline   9 & boolean & SPREADSHEET & WEBINSTRACCESS & boolean \\   \hline   9 & long answer & SCHOOLSDATA & WEBINSTRACCESSTEXT & text \\   \hline   10 & boolean & SPREADSHEET & FEES & boolean \\   \hline   11 & boolean & SPREADSHEET & DOCUMENTATION & boolean \\   \hline   11 & long answer & SCHOOLSDATA & DOCUMENTATIONTEXT & text \\   \hline   12 & long answer & SCHOOLSDATA & HOWTOREQUEST & text \\   \hline   13 & long answer & SCHOOLSDATA & ACCOMMODATIONPROCESS & text \\   \hline   14 & long answer & SCHOOLSDATA & FUTUREPLANS & text \\   \hline   15 & boolean & SPREADSHEET & COMPLAINTSBOOL & boolean \\   \hline   15 & long answer & SCHOOLSDATA & COMPLAINTSTEXT & text \\   \hline   16 & boolean & SPREADSHEET & ATLABBOOL & boolean \\   \hline   17 & long answer & SCHOOLSDATA & ATLABHOURS & text \\   \hline   18 & single answer & SCHOOLSDATA & ATLABCOMPARE & text \\   \hline   19 & int & SCHOOLSDATA & ATLABCOMPNUM & int \\   \hline   20 & long answer & - & - & - \\   \hline   21 & boolean & SPREADSHEET & SATELLITEATBOOL & boolean \\   \hline   21 & long answer & SCHOOLSDATA & SATELLITEATTEXT & text \\   \hline   22, 23 & int & SPREADSHEET & ATHEADPHONES & int \\   \hline   22, 23 & int & SPREADSHEET & ATLAPTOP & int \\   \hline   22, 23 & int & SPREADSHEET & ATASSISTIVELISTENING & int \\   \hline   22, 23 & int & SPREADSHEET & ATDIGITALRECORDER & int \\   \hline   22, 23 & int & SPREADSHEET & ATCCTVMAGNIFIER & int \\   \hline   22, 23 & int & SPREADSHEET & ATERGOKEYBOARD & int \\   \hline   22, 23 & int & SPREADSHEET & ATLHRHKEYBOARD & int \\   \hline   22, 23 & int & SPREADSHEET & ATSMARTPENS & int \\   \hline   22, 23 & int & SPREADSHEET & ATFMUNIT & int \\   \hline   22, 23 & int & SPREADSHEET & ATIPADMINI & int \\   \hline   22, 23 & int & SPREADSHEET & ATVOICECALC & int \\   \hline   22, 23 & int & SPREADSHEET & ATWIRELESSMIC & int \\   \hline   22, 23 & int & SPREADSHEET & MAGNIFIERS & int \\   \hline   22, 23 & int & SPREADSHEET & COLORFILTERS & int \\   \hline   22, 23 & int & SPREADSHEET & ATDRAGONRECORDER & int \\   \hline   22, 23 & int & SPREADSHEET & ATLARGEPRINTKEYBOARD & int \\   \hline   22, 23 & int & SPREADSHEET & ATBRAILLEKEYBOARD & int \\   \hline   22, 23 & int & SPREADSHEET & ATADJUSTKEYBOARD & int \\   \hline   22, 23 & int & SPREADSHEET & ATLARGEMONITOR & int \\   \hline   22, 23 & int & SPREADSHEET & ATBRAILLEPRINTER & int \\   \hline   22, 23 & int & SPREADSHEET & ATBRAILLESD & int \\   \hline   22, 23 & int & SPREADSHEET & ATDIGITALREADERHW & int \\   \hline   22, 23 & int & SPREADSHEET & ATSCREENMAGSW & int \\   \hline   22, 23 & int & SPREADSHEET & ATSTTSW & int \\   \hline   22, 23 & int & SPREADSHEET & ATSCREENREADERSW & int \\   \hline   22, 23 & int & SPREADSHEET & ATOCRSCANSW & int \\   \hline   22, 23 & int & SPREADSHEET & ATEDUCSUPPORTSW & int \\   \hline   22, 23 & int & SPREADSHEET & ATMATHSCISUPPORT & int \\   \hline   22, 23 & int & SPREADSHEET & ATDIGITALREADERSW & int \\   \hline   24 & single answer & SCHOOLSDATA & COMMONUSED & text \\   \hline   25 & single answer & SCHOOLSDATA & COMMONRQST & text \\   \hline   26 & long answer & - & - & - \\   \hline   27 & long answer & - & - & - \\   \hline   \end{tabular}