자동차판매점

테이블 (4)

CAR (Car)

  • Serial_no — UUID — 기본 키 — NOT NULL
  • Salesperson_id — UUID — 외래 키 → SALE.Salesperson_id — NOT NULL
  • Model — VARCHAR
  • Manufacturer (Manufacurer) — VARCHAR
  • Price — BIGINT

OPTION (Option)

  • Option_name — VARCHAR
  • Option_price — BIGINT
  • Serial_no — VARCHAR — 외래 키 → CAR.Serial_no — NOT NULL
  • Salesperson_id — BITINT — 외래 키 → CAR.Salesperson_id — NOT NULL

SALE (Sale)

  • Salesperson_id — UUID — 외래 키 → SALESPERSON.Salesperson_id — NOT NULL
  • Date — VARCHAR
  • Sale_price — BIGINT

SALESPERSON (Salesperson)

  • Salesperson_id — UUID — 기본 키 — NOT NULL
  • Name — VARCHAR
  • Phone — BIGINT