Introduction
Currently, the database consists of three main objects: Users, Trips, Media.
DB name is "travelhard" (clearly) and password is "itsBetTerwhenits0N" (that's a zero, not an "O"). DB is accessible only through localhost, so you can't directly connect to it without first sshing to the server.
Users Table
- id (primary key)
- username
- password/salt
- phone_id
- join_date
Trips Table
- id (primary key)
- user_id (foreign key, assumes that a Trip belongs to just one User)
- start_date
- end_date
- destination (like "Egypt" or something of that sort)
- thumbnail (to display on main trips page)
Media Table
- id (primary key)
- trip_id (foreign key, assumes that one piece of Media belongs to just one Trip)
- media_type (picture, video, audio?, FB status update, tweet)
- parent_id
- content (pathname or text body)
- lat, long, alt (gps)
- captured_timestamp
- uploaded_timestamp
- content metadata (OPTIONAL: allowing us to find Wikipedia articles, news, etc. that's germane to the content of the media)
Extension possibilities
- Connections between users (would need a join table)
- Possibly split up Media table into different types of media (Picture table, Video table, etc.)
- Tagging users in pictures/video