Database Schema

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

[ ] Instead of user_page
[ ] For games table genre and category should be string typed
[ ] For games table add unique to name column as detail
[ ] foreign keys are typically indexed for quick look up via associations. add indexed as part of details for those columns.
[ ] missing timestamp columns for all tables except for the users table.
[ ] consider switching cart table to cart_items joins table. Instead of having a user_page table, you should consider having a boolean column for purchased
[ ] consider adding composite index to user_id and game_id columns and add unique constraint. This way user cannot add same game multiple times.

Tysuiku / Staream