My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
DatabaseSchema  
Description of the backend database schema.
Updated Mar 1, 2011 by lew.leti...@gmail.com

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
Powered by Google Project Hosting