DB Schema

[xnanodax]

Database Schema

• [x] Contains correct datatypes Example: Restaurant's description. (do you want a string or text?) There are a couple more spots to fix the data type as well.

• [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

• [x] Correctly formatted

  • [x] schema is written in a table format
  • [x] column names are bolded
  • [x] columns names are lowercased and snaked_cased and back_ticked

Comments:

[xnanodax]

In the current configuration, the restaurants can only have ONE tag, photo, menu, review. Is that what you wanted? We need to overhaul your db schema. We need to add more join tables so we can have a one to many relationship built.

I would suggest for tags to have a Tags table (includes name of tag) and a Tagging joins table (joins tags to restaurant_id). That way you don't have to store multiple row entries that have the exact same tag name for multiple restaurants. Same can be same for payment option and cuisine.

[xnanodax]

Looks good!