자동차판매점
테이블 (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