Students Table Structure

The Students Table contains all of our information on every Student in our database. Many of these Students are no longer at the University and some of these students have been in the database since its conception. Which means that a lot of the data may be missing either because those field just did not exist at that time or some of the information was lost over the years.

Again much of the functionality of the Students table revolves around its StudentID which is a unique identifier for all Students. Password and email should be the same as the Users table and is used in many different areas in the site. Most of the other fields are informational besides the gradYear.

1. studentID : Unique ID for only Students
2. userID : Unique ID for all Users in tCF
3. firstName : First Name, or entire name if Student existed before theTransition
4. lastName : Last Name
5. emailID : UVa emailID
6. password : theTransition password
7. gradType : Two options: 0 is Undergraduate and 1 is Graduate
8. created : When the User was created
9. reviewed : When the User last submitted a review
10. visited : When the User last logged in
11. numReviews: # of reviews the Student submitted
12. getEmail : 0 Students do not get emails, 1 Students get emails
13. v1import : 0 Student did not exist before theTransition
14. v1ID : Old Student ID could be different
15. v1Pass : Old Student Password
16. gradTear : Student expected grad year