1-7 final
Tables (4)
CAR (Untitled)
- Serial_no (Field) — UUID — Primary key
- Model (Field2) — VARCHAR(20)
- Manufacturer (Field3) — VARCHAR(20)
- Price (Field4) — BIGINT
OPTION (Untitled3)
- Serial_no (Field) — UUID — Foreign key → CAR.Serial_no
- Option_name (Field2) — VARCHAR(20)
- Price (Field3) — BIGINT
SALE (Untitled2)
- Salesperson_id (Field5) — UUID — Foreign key → SALESPERSON.Salesperson_id
- Date (Field2) — VARCHAR(20)
- Sale_price (Field3) — BIGINT
- Serial_no (Field) — UUID — Foreign key → CAR.Serial_no
SALESPERSON (Untitled4)
- Salesperson_id (Field) — UUID — Primary key
- Name (Field2) — VARCHAR(20)
- Phone (Field3) — VARCHAR(20)