캠핑카 대여관리
테이블 (5)
camping_car
- company_id — NUMBER — 외래 키 → camping_car_rental_company.company_id
- camping_car_id — NUMBER
- model_name — VARCHAR2(50)
- make_year — NUMBER
- daily_rent_fee — NUMBER
camping_car_maintenance_info
- maintenance_id — NUMBER — 기본 키
- camping_car_id — NUMBER — 외래 키 → camping_car.camping_car_id
- maintenance_date — DATE
- maintenance_details — VARCHAR2(200)
- maintenance_fee — NUMBER
- maintenance_station_id — NUMBER — 외래 키 → camping_car_maintenance_station.maintenance_station_id
- driver_license_number — VARCHAR2(20) — 외래 키 → camping_car_rental_customer.driver_license_number
camping_car_maintenance_station
- maintenance_station_id — NUMBER
- station_name — VARCHAR2(50)
- address — VARCHAR2(100)
- phone_number — VARCHAR2(20)
camping_car_rental_company
- company_id — NUMBER — 기본 키
- company_name — VARCHAR2(50)
- address — VARCHAR2(100)
- phone_number — VARCHAR2(20)
- contact_name — VARCHAR2(50)
- contact_email — VARCHAR2(100)
camping_car_rental_customer
- driver_license_number — VARCHAR2(20) — 기본 키
- customer_name — VARCHAR2(50)
- address — VARCHAR2(100)
- phone_number — VARCHAR2(20)
- credit_card_number — VARCHAR2(20)
- customer_id — NUMBER