-
Notifications
You must be signed in to change notification settings - Fork 3
Database Setup
Adam Tahiri edited this page Aug 28, 2021
·
9 revisions
| Column Name | Datatype | Constraints |
|---|---|---|
| VARCHAR(100) | unique | |
| pw_hash | TEXT | not null |
| name | VARCHAR(100) | not null |
| 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] |