렌터카 예약

테이블 (4)

Customer

  • CustomerNumber — NUMBER — 기본 키
  • JoinDate — DATE
  • Points — NUMBER
  • CustomerName — VARCHAR2(100) — NOT NULL

Repair

  • CarNumber (CarNumber22) — VARCHAR2(20) — 외래 키
  • RepairDate — DATE
  • RepairDescription — VARCHAR2(255)
  • RepairCost — NUMBER

Reservation

  • CarNumber — VARCHAR2(20) — 기본 키
  • CustomerNumber (CustomerNumber2) — NUMBER — 외래 키 → Customer.CustomerNumber
  • ReservationID — NUMBER
  • ReservationDate — DATE

recode

  • Field
  • Field2
  • Field3