rental vehicle

Tables (27)

Accident (사고)

  • Key — Primary key — NOT NULL
  • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL

AudioOption (오디오 옵션)

  • Key — Primary key — NOT NULL
  • car_id (Key2) — Foreign key → Car.Key — NOT NULL

Brand (차 브랜드)

  • Key — Primary key — NOT NULL

Car (차량)

  • Key — Primary key — NOT NULL
  • car_model_id (Key2) — Foreign key → CarModel.Key — NOT NULL
  • car_group_id (Key3) — Foreign key → CarGroup.Key — NOT NULL
  • owning_corp_id (Key4) — Foreign key → OwningCorp.Key — NOT NULL

CarGroup (차량 그룹)

  • Key — Primary key — NOT NULL

CarModel (차량 모델)

  • Key — Primary key — NOT NULL
  • car_type_id (Key2) — Foreign key → CarType.Key — NOT NULL
  • brand_id (Key3) — Foreign key → Brand.Key — NOT NULL
  • car_size_id (Key4) — Foreign key → CarSize.Key — NOT NULL

CarModelFee (모델별 요금)

  • Key — Primary key — NOT NULL
  • car_model_id (Key2) — Foreign key → CarModel.Key — NOT NULL

CarOption (차량 옵션)

  • Key — Primary key — NOT NULL
  • car_id (Key2) — Foreign key → Car.Key — NOT NULL

CarSize (차량 크기)

  • Key — Primary key — NOT NULL

CarType (차량 분류)

  • Key — Primary key — NOT NULL

Customer (고객)

  • Key — Primary key — NOT NULL

DeliveryReturn (출고 및 반납)

  • Key — Primary key — NOT NULL
  • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL

ExtraFee (기타 요금)

  • Key — Primary key — NOT NULL

Holder (예약자(삭제 필요))

    Insurance (보험)

    • Key — Primary key — NOT NULL
    • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL

    KeyOption (키 옵션)

    • Key — Primary key — NOT NULL
    • car_id (Key2) — Foreign key → Car.Key — NOT NULL

    OwningCorp (소유 법인)

    • Key — Primary key — NOT NULL

    Payment (결제)

    • Key — Primary key — NOT NULL
    • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL
    • payment_method_id (Key3) — Foreign key → PaymentMethod.Key — NOT NULL

    PaymentMethod (결제 방식)

    • Key — Primary key — NOT NULL

    Rental (예약)

    • Key — Primary key — NOT NULL
    • car_id (Key2) — Foreign key → Car.Key — NOT NULL
    • user_id (Key3) — Foreign key → User.Key — NOT NULL
    • store_id (Key4) — Foreign key → Store.Key — NOT NULL

    RentalCustomer (예약-고객 중간 테이블)

    • Key — Primary key — NOT NULL
    • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL
    • customer_id (Key3) — Foreign key → Customer.Key — NOT NULL

    RentalFee (요금)

    • Key — Primary key — NOT NULL
    • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL

    RentalOption (예약 옵션)

    • Key — Primary key — NOT NULL
    • rental_id (Key2) — Foreign key → Rental.Key — NOT NULL

    Repair (정비)

    • Key — Primary key — NOT NULL
    • car_id (Key2) — Foreign key → Car.Key — NOT NULL

    Store (지점)

    • Key — Primary key — NOT NULL

    User (담당자)

    • Key — Primary key — NOT NULL

    UserLicense (면허증)

    • Key — Primary key — NOT NULL
    • customer_id (Key2) — Foreign key → Customer.Key — NOT NULL