Tables in this database:
| activities |
| classification |
| committee |
| curriculum |
| ethnicity |
| faculty |
| forms |
| hours |
| recommendations |
| student |
| students |
students
| ssn |
char(9) |
NO |
PRI |
|
|
| fname |
char(20) |
NO |
|
|
|
| middleinitial |
char(1) |
YES |
|
|
|
| lname |
char(20) |
NO |
|
|
|
| classification |
char(20) |
YES |
|
|
|
| curriculum |
char(10) |
YES |
|
|
|
| street |
char(30) |
YES |
|
|
|
| city |
char(20) |
YES |
|
|
|
| state |
char(2) |
YES |
|
|
|
| zip |
char(9) |
YES |
|
|
|
| country |
char(15) |
YES |
|
|
|
| homephone |
char(10) |
YES |
|
|
|
| workphone |
char(10) |
YES |
|
|
|
| cellphone |
char(10) |
YES |
|
|
|
| email |
char(25) |
YES |
|
|
|
| gender |
char(6) |
YES |
|
|
|
| ethnicity |
char(25) |
YES |
|
|
|
| notes |
text |
YES |
|
|
|
committee
| ssn |
char(9) |
NO |
PRI |
|
|
| datebegansemester |
char(6) |
YES |
|
|
|
| datebeganyear |
int(11) |
YES |
|
|
|
| dissertationchair |
char(30) |
YES |
|
|
|
| adminchair1 |
char(30) |
YES |
|
|
|
| adminchair2 |
char(30) |
YES |
|
|
|
| committee1 |
char(30) |
YES |
|
|
|
| committee2 |
char(30) |
YES |
|
|
|
| committee3 |
char(30) |
YES |
|
|
|
| committee4 |
char(30) |
YES |
|
|
|
| committee5 |
char(30) |
YES |
|
|
|
| majorprofessor |
char(30) |
YES |
|
|
|
forms
| ssn |
char(9) |
NO |
PRI |
|
|
| planofstudy |
char(1) |
YES |
|
|
|
| dateofplanmonth |
int(11) |
YES |
|
|
|
| dateofplanday |
int(11) |
YES |
|
|
|
| dateofplanyear |
int(11) |
YES |
|
|
|
| greverbal |
int(11) |
YES |
|
|
|
| grequantitative |
int(11) |
YES |
|
|
|
| grewriting |
int(11) |
YES |
|
|
|
| prelimoralsmonth |
int(11) |
YES |
|
|
|
| prelimoralsday |
int(11) |
YES |
|
|
|
| prelimoralsyear |
int(11) |
YES |
|
|
|
| finaloralsmonth |
int(11) |
YES |
|
|
|
| finaloralsday |
int(11) |
YES |
|
|
|
| finaloralsyear |
int(11) |
YES |
|
|
|
faculty
| facultyfname |
char(15) |
NO |
|
|
|
| facultylname |
char(20) |
NO |
|
|
|
recommendations
| ssn |
char(9) |
NO |
PRI |
|
|
| reclname1 |
char(20) |
YES |
|
|
|
| reclname2 |
char(20) |
YES |
|
|
|
| reclname3 |
char(20) |
YES |
|
|
|
| rec1yn |
char(1) |
YES |
|
|
|
| rec2yn |
char(1) |
YES |
|
|
|
| rec3yn |
char(1) |
YES |
|
|
|
| statementofintent |
char(1) |
YES |
|
|
|
classification
curriculum
ethnicity
|
