Reviews of design doc

[aracpyon]

Great job on the design doc, Elvin! Here are my reviews:

MVPs

• [x] please add time goals
• [x] Ensure to have a full CRUD functionality on at least one MVP
• [ ] Search is very important functionality in Yelp. Make sure you can reach to Search as early as possible.
• [x] Don't worry about ordering or reservation functionality for now when you work on business page. (main functionality of Yelp is reviews.)

Schema

• [x] add fname, lname, birthday column to Users table
• [x] change the column name location to zipcode on Users
• [x] add latitude and longitude columns with float datatype to Businesses (This will be useful for Map mvp later)
• [x] add city, state, price_range columns on Businesses (useful for search later)
• [x] ensure the uniqueness of author_id on the scope of business_id (user can leave a review only once per business) on Reviews table
• [ ] make a categories table and categories_businesses table(joins table). Categories has types of business and categories_businesses is a joins table between categories and businesses. The joins table is for many-to-many relationship: each business can fall into multiple categories, and each category can apply to many businesses.

[aracpyon]

state Hey Elvin, your state looks great so far! Probably we want to make a state for categories but we can talk about this later during our fullstack meeting. The good reference for categories would be reddit clone project's many to many relationship between post,sub and user