Database Schema

[siascone]

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
• [x] 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
  • [x] columns names are lowercased and snaked_cased and back_ticked

[siascone]

• table names should be lower cased and backticked
• add bullets for foreign keys
• table headers do not match case wise (ex: Column Name vs data type)

[siascone]

• on the tables themselves foreign key needs to be added to the details column for any foreign key.
• for the bullets, column names and table names need backticks (ex: user_id references users table)

[siascone]

Looks pretty good.

• missing backtics on bullets for table and column names (ex: index on park_name, user_id references users table)