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  
Design of our database schema - for reference.
Updated Mar 20, 2010 by jwei...@gmail.com

Introduction

This is what our DB schema looks like.

Schema

events_types(type_id INTEGER, description LONGTEXT)

events(eid INTEGER, name VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip INTEGER, phone_number VARCHAR, start_time DATETIME, end_time DATETIME, cost VARCHAR, description LONGTEXT, type INTEGER)

event_reviews(eid INTEGER, review LONGTEXT)

movie_theaters(mt_id INTEGER, name VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip INTEGER, phone_number VARCHAR, start_time DATETIME, end_time DATETIME)

movies(m_id INTEGER, name VARCHAR, rating DOUBLE, runtime INTEGER, synopsis LONGTEXT)

theater_to_movie(mt_id INTEGER, m_id INTEGER)

recipes(r_id INTEGER, name VARCHAR, rating DOUBLE, description LONGTEXT)

venue_types(type_id INTEGER, description LONGTEXT)

venues(vid INTEGER, name VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip INTEGER, phone_number VARCHAR, start_time DATETIME, end_time DATETIME, type INTEGER)

venue_reviews(vid INTEGER, review LONGTEXT)

Powered by Google Project Hosting