Database Setup

PSQL Database Schema

users

Column Name	Datatype	Constraints
email	VARCHAR(100)	unique
pw_hash	TEXT	not null
name	VARCHAR(100)	not null

categories

Column Name	Datatype	Constraints
name	TEXT	not null

items

Column Name	Datatype	Constraints
name	TEXT	not null
description	TEXT	not null
location	TEXT	not null
price	INT	not null

category_items

Column Name	Datatype	Constraints
category_id	INT	Foreign Key(REF:categories.id)
item_id	INT	Foreign Key(REF:items.id)