렌터카 예약

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

Untitled

    VehicleInfo

    • LicensePlate_Number — VARCHAR2(20) — 기본 키
    • Car_Type — VARCHAR2(50)
    • Registration_Date — DATE