CSC220 Tables Schema

userInfo

This table is filled from information that comes from the registration form.

• userId: int(1), auto increment, primary index
• email: varchar(40)
• schoolId: int(1)
• housingArea: int(1)
• affiliationId: int(1)
• majorId: int(1)
• phonetypeId: int(1)
• interestId: int(1)

kmldata

This table is filled from information that comes from the KML file upload form.

• tripId: int(1), auto increment, primary index
• userId: int(1)
• date: timestamp
• data: mediumtext
• coordinates: mediumtext
• md5: varchar(33)
• synthetic: int(1)

intersectPoints

This table is filled from this form.

• Id: int(1)
• trackId1: int(1)
• trackId2: int(1)
• latitude: float(15,12)
• longitude: float(15,12)
• comment: varchar(255)

schools

This table is pre-filled.

• schoolId: int(1), auto increment, primary index
• schoolName: varchar(40)
  • Smith, UMass-Amherst, Hampshire, Mt. Holyoke, Amherst, Other

housingArea

This table is pre-filled.

• houseId: int(1), auto increment, primary index
• housingArea: varchar(40)
  • Green Street, Center Campus, East Quad, West Quad, Upper Elm, Lower Elm, Off Campus

affiliation

This table is pre-filled.

• affId: int(1), auto increment, primary index
• affName: varchar(40)
  • First-Year, Sophomore, Junior, Senior, Ada Comstock, Faculty, Other

majors

This table is pre-filled

• majorId: int(1), auto increment, primary index
• majorName: varchar(40)

phones

This table is pre-filled.

• phoneId: int(1), auto increment, primary index
• phoneName: varchar(40)
  • iPhone, Android, Other

interests

• interestId: int(1), auto increment, primary index
• interestName: varchar(40)
  • Athlete, Musician, Dancer, Performer, Student Government, Volunteering, Other, None