PA Review: Database Schema

[Shhmabbey]

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

[AlchemR]

not null is null:false in the table. Fixed formatting. formatting Should be correct now. did not pouplate bonus features with foreign keys, as some of that is tenative and will be crossed if there is time available

[Shhmabbey]

Just make sure every id column in your table has primary key under the Details column