[x] The user’s “demo experience” is the same as a logged in user but without necessitating recruiters make an account.
[x] Don’t worry about sellers for now (you can add that as a bonus MVP if you’d like) - we’ll deal with the consumer user here
[x] “Landing page“ - the Splash (what you see when you first navigate to the website) is part of the Auth MVP (though it will be dummy data until we are at the point where we can populate it). Unless you were referring to another page
[x] Go more into depth about the product listing - for example, the product doesn’t just have it’s own description
[x] Can users review any product?
[x] Can users edit/delete/update reviews?
[x] Users can search for any item/string, not just category keywords
[x] Detail search functionality further (can users filter search? What tools are provided for them? Anything else noteworthy?
[x] We’ll discuss the specifics about the categories MVP as it relates to the search feature
Schema
[ ] Check style guides for schema (backtick around items that are representative of what something will be in your actual code, headers for each table should be the actual table name, etc)
[ ] Index on any columns that will be a frequent lookup by in the database
[x] Naming columns with foreign keys as tablename_id will simplify your associations a bit, but optional
[ ] Are there subcategories?
[x] Don’t need seller_id in the carts as that will be available through the item
[ ] revproduct_id/reviewer_id/shopee_id/etc are unique but if it is independently unique each user could only have one item in their shopping cart, each item could only have one review, etc.
Overall
Great work! If you have any questions, send me a Slack. :)
MVP List
Schema
tablename_id
will simplify your associations a bit, but optionalseller_id
in the carts as that will be available through the itemrevproduct_id
/reviewer_id
/shopee_id
/etc are unique but if it is independently unique each user could only have one item in their shopping cart, each item could only have one review, etc.Overall
Great work! If you have any questions, send me a Slack. :)