자동차 대여 기록 별 대여 금액 구하기

테이블 (3)

CAR_RENTAL_COMPANY_CAR (Untitled)

  • car_id (Key) — int — 기본 키 — NOT NULL
  • daily_fee (Field3) — int
  • car_type (Field2) — varchar
  • options (Field4) — varchar

CAR_RENTAL_COMPANY_DISCOUNT_PLAN (Untitled3)

  • paln_id (Key) — int — 기본 키 — NOT NULL
  • car_type (Field2) — varchar
  • duration_type (Field3) — varchar
  • discount_rate (Field4) — int

CAR_RENTAL_COMPANY_RENTAL_HISTORY (Untitled2)

  • history_id (Key) — int — 기본 키 — NOT NULL
  • car_id (Field2) — int
  • start_date (Field3) — date
  • end_date (Field4) — date