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
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