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)