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| | make | TEXT | not null | | model | TEXT | not null | | year | INT | not null | | mileage | INT | | color | TEXT | | vin | VARCHAR(55) | not null | | doors | INT | | transmission | ENUM | [manual, automatic] |

Clone this wiki locally