캠핑카 대여관리

테이블 (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