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

[Shhmabbey]

Hey Rod! Looks good so far. Add bullet point explaining references and make sure all of the column names are snake_cased. See example below.

[Shhmabbey]

users

column name	data type	details
id	bigint	not null, primary key
email	string	not null
password_digest	string	not null
session_token	bigInt	not null, indexed

• index on email, unique: true
• index on session_token, unique: true

  ---

carts

column name	data type	details
id	bigint	not null, primary key
user_id	integer	not null, foreign key

• index on user_id, unique: true
• user_id foreign key referencing user table primary key

  ---

products

column name	data type	details
id	bigint	not null, primary key
title	string	not null
description	string	not null
size	string
style	string
price	decimal	not null
stock	integer	not null
category_id	integer	foreign key, indexed

• index on title, unique: true
• index on category_id
• category_id foreign key referencing categories table primary key

  ---

[rodmen07]

Thanks Abbey, I've updated the schema to include the index/reference columns information as well as adjust the column name formats to be snake_cased.