Database Schema
Database Schema
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| name | Varchar(150) | Not Null |
| key | Varchar(150) | Not Null |
| siteId | Int | Not Null FK |
| typeId | Int | Not Null FK |
| movieId | Int | Not Null Fk |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| name | Varchar | Not null |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| name | Varchar | Not Null |
| makeId | Int | Not Null FK |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| speedNum | Varchar | Not Null |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| drive | Varchar | Not Null |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| Seat | Varchar | Not Null |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| driveTrain | Varchar | Not Null |
| Column | DataType | Details |
|---|---|---|
| SerialId | Int | Pk Not Null |
| address | Varchar | Not Null |
| city | Varchar | Not Null |
| state | Varchar | Not Null |
| country | Varchar | Not Null |
| price | Decimal | Not Null |
| color | Varchar | Not Null |
| userId | Int | Not Null FK |
| modelId | Int | Not Null Fk |
| transmissionId | Int | FK |
| cylinderId | Int | FK |
| seatId | Int | FK |
| drivetrainId | Int | FK |