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
owner_id	INT	Foreign Key(REF:users.id)
category	TEXT	not null
name	TEXT	not null
description	TEXT	not null
location	TEXT	not null
price	INT	not null

item_photos

Column Name	Datatype	Constraints
item_id	INT	Foreign Key(REF:items.id)
photo_url	TEXT	not null

transactions

Column Name	Datatype	Constraints
item_id	INT	Foreign Key(REF:items.id)
owner_id	INT	Foreign Key(REF:users.id)
rentee_id	INT	Foreign Key(REF:users.id)

category_items

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

reviews

Column Name	Datatype	Constraints
prod_rating	INT	Foreign Key(REF:items.id)
review	TEXT	Foreign Key(REF:items.id)
owner_rating	INT	Foreign Key(REF:items.id)
transaction_id	INT	Foreign Key(REF:transaction.id)