Database Schema Checklist

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

    Comments

[siascone]

• Missing 'foreign key' details
• Missing table/association references

[david-ross1]

updated

[david-ross1]

foreign key details and table associations added

[siascone]

Looks good, almost there.

• the foreign key details go in the table under details similar to how primary key is listed.
• in bullets, indexed should not be highlighted. Indexed fields should read:
  • indexed on column_name, validations if any
  • see bluebird schema example

[david-ross1]

corrected

[siascone]

Last two corrections:

• photos table needs foreign key added to details for user_id and trail_id
• reviews table needs foreign key added to details for user_id and trail_id

[siascone]

Looks good