렌터카

테이블 (4)

customers (고객)

  • customer_number — int — 기본 키 — NOT NULL
  • customer_name — varchar(10)
  • join_date — DATE
  • points — INT

maintenance_records (정비기록)

  • repair_number — INT — 기본 키 — NOT NULL
  • vehicle_number (vehicle_number2) — varchar(10) — 외래 키 → vehicles.vehicle_number — NOT NULL
  • customer_number (repair_number2) — int — 외래 키 → vehicles.customer_number — NOT NULL
  • vehicle_number — varchar(10)
  • customer_number — int
  • repair_date — DATE
  • description — TEXT
  • cost — DECIMAL(10,2)

reservations (예약)

  • reservation_id — int — 기본 키 — NOT NULL
  • customer_number (repair_number) — int — 외래 키 → customers.customer_number — NOT NULL
  • customer_number (customer_number2) — int
  • vehicle_number — VARCHAR(10)
  • customer_number — INT
  • reservation_date — DATE

vehicles (차량)

  • vehicle_number — varchar(10) — 기본 키 — NOT NULL
  • customer_number (repair_number) — int — 외래 키 → customers.customer_number — NOT NULL
  • customer_number — int
  • vehicle_type — varchar(50)
  • registration_date — DATE