Skip to content

Database Setup

Adam Tahiri edited this page Aug 28, 2021 · 9 revisions

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

categories/subcategories

Column Name Datatype Constraints
name TEXT not null
description TEXT not null
location TEXT not null
price INT not null
Clone this wiki locally