FSP Design Docs - Feature List and Schema

[mwmadsen67]

Hi Jas, here is a checklist for going through your docs. I'll go through what you have so far and leave comments underneath.

---

Wiki Page Home

• [ ] Is the first page you see upon entering the wiki
• [ ] Contains a welcome message
• [ ] Contains a link/placeholder for a link to the live page
• [ ] All links in the right sidebar should contain each wiki page and link to the correct page
• [ ] Correctly formatted
  • [ ] each wiki page is listed in bullet points
  • [ ] all links route the correct page

---

Feature List

• [ ] Should have 7 Features.
  • [ ] 3 of those are User Auth, render.io, and Production README.
  • [ ] The other 4 are from the Feature/MVP List or they have clarified them with you
• [ ] Contains a description sentence of the app
• [ ] Includes two to three detailed bullets on functionality and presentation of feature
• [ ] At least one CRUD feature, which states what CRUD operations are planned (creation, reading, updating, deletion)
• [ ] Estimates how long it will take the code each feature
• [ ] Correctly formatted
  • [ ] features are listed in an ordered list
  • [ ] Each feature is broken down into bullet points

---

Database Schema

• [ ] Contains correct datatypes
• [ ] Contains appropriate constraints/details
  • [ ] primary key
  • [ ] not null
  • [ ] unique
  • [ ] indexed
  • [ ] foreign key
• [ ] Contains bullet points after the table that state which foreign keys will reference to which table, or references to the associations which will be made
  • [ ] foreign key and table name are lowercased, snake_cased and back_ticked
• [ ] Correctly formatted
  • [ ] schema is written in a table format
  • [ ] the table's name are lowercased, snake_cased and back_ticked
  • [ ] the table header column names are bolded
  • [ ] columns names are lowercased and snaked_cased and back_ticked

[mwmadsen67]

Hi Jas, I've reviewed you design docs so far and will leave some comments below:

Feature List:

• looks great 👍 The only thing to think about is whether or not you want to leave the shopping cart last, since it is the hardest feature.

Schema:

• For the users table, it looks like sephora asks for a first name and last name in addition to an email. I'll leave it up to you about whether or not you want to just combine that into a username, but I dont think it needs to be unique.
• Products looks pretty good. I noticed there could be some other columns like size, ingredients, how to use, etc. Up to you if you want to include those things.
• Reviews should also have a title.
• Cart Items is good! 👍

That's all for now! Let me know if you have any questions.