Finalize Database Schema (Checkins, Locations)

[eric-wood]

What we need to do

Checkins

• Throw old model out
• How are we going to accommodate the Twitter streaming?
  • How many checkins will get stored?
  • Will we use the DB as more of a cache?
  • If so, how often will we flush it, and how often do we process checkins?

    Locations

• Finalize the schema
  • What columns will we need in the future?
  • Write down a list of what data is coming from what sources

    Other

• Migration to rename previous checkins database so we can start from scratch without losing all of that data

[wwchen]

Checkins table schema is pretty much finalized. It is as below: Checkin(id: integer, user_id: string, place_id: string, place_name: string, post_date: datetime, latitude: float, longitude: float, url: string, processed: boolean)

[wwchen]

The sample twitter data from the research paper is moved from the Checkins table to Oldcheckins. It currently doesn't have a model. We may look back and leverage these data at a later date