CSC220 Tables Schema

From CSclasswiki
Jump to: navigation, search

Introduction

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