자동차 대여 기록 별 대여 금액 구하기
테이블 (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