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)