Database Schema

[aminbabar]

• [ ] Contains correct datatypes
• [ ] 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] foreign key and table name are lowercased, snake_cased and back_ticked
• [x] Correctly formatted
  • [x] schema is written in a table format
  • [x] the table’s name are lowercased, snake_cased and back_ticked
  • [x] the table header column names are bolded
  • [x] columns names are lowercased and snaked_cased and back_ticked

[aminbabar]

• you dont need both username and email for users table
• you do not need a cart table, but rather a cart_items table.
• The products should not have an image_url column. We will handle that with AWS down the line.
• the products do not need a seller_id. That can be bonus for later down the line.
• The products will need a description column with data type of text.
• The products will not need a cart_id.
• The buyer_id for reviews should be user_id. In amazon anyone can review a product even if they are not a buyer.