렌터카 예약
테이블 (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