Issue #03 - Schema

[keginzburg]

Database Schema

• [X] Contains correct datatypes
• [X] Contains appropriate constraints/details
  • [X] primary key
  • [X] not null
  • [X] unique
  • [X] indexed
  • [X] foreign key
• [X] 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
  • [X] schema is written in a table format
  • [ ] the table's name are lowercased, snake_cased and back_ticked
  • [X] the table header column names are bolded
  • [ ] columns names are lowercased and snaked_cased and back_ticked

Comments

Hey Rex, just a few notes regarding your Schema:

1. Right now, there's small formatting issues, but I trust you'll take care of these down the line as you've begun coding.
2. Your Users and Business tables look pretty comprehensive. Lots of data to work with there. We briefly discussed this and what you could scale down, but overall excited to see how you display all of that data. One thing to note: maybe our Business names shouldn't be unique? There's always a small chance two businesses have the same franchise name, but their other information is different.
3. Small note: your foreign key columns will be bigints, not ints.
4. Also, the data type of your Review's body should not be textbox.
5. For your last table, Favorite Reviews, I imagine this is just a joins table, but I was under the impression that Users could favorite Businesses, not Reviews. Also, this table is a bit sparse right now. Be sure to include timestamps.

Solid work here.