렌터카 예약
테이블 (5)
CustomerInfo
- Customer_Number — NUMBER — 기본 키
- Customer_Name — VARCHAR2(255) — NOT NULL
- Join_Date — DATE
- Points — NUMBER
MaintenanceHistory
- record_id — NUMBER — 기본 키 — NOT NULL
- LicensePlate_Number — VARCHAR2(20) — 외래 키 → VehicleInfo.LicensePlate_Number
- Repair_Date — DATE
- Description — VARCHAR2(255)
- Salary — NUMBER
ReservationInfo
- reservation_id — NUMBER — 기본 키
- Customer_Number — NUMBER — 외래 키 → CustomerInfo.Customer_Number
- LicensePlate_Number — VARCHAR2(20) — 외래 키 → VehicleInfo.LicensePlate_Number
VehicleInfo
- LicensePlate_Number — VARCHAR2(20) — 기본 키
- Car_Type — VARCHAR2(50)
- Registration_Date — DATE