시험
테이블 (5)
Car_Info
- Car_Number (Key) — NUMBER(10) — 기본 키 — NOT NULL
- Car_Type — NVARCHAR2(30)
- Registration_Date — DATE
Customer_Info
- Customer_Number (Key) — NUMBER(10) — 기본 키 — NOT NULL
- Customer_Name (Key2) — NVARCHAR2(30) — 기본 키 — NOT NULL
- Subscription_Date — DATE
- Points — NUMBER(10)
Maintenance_History
- Maintenance_ID — NUMBER
- Car_Number — NUMBER(10)
- Repair_Date — DATE
- Detail — NVARCHAR2(30)
- Price — NUMBER(10)
- Car_Number (Key) — NUMBER(10) — 외래 키 → Car_Info.Car_Number — NOT NULL
- Maintenance_ID (Key2) — NUMBER — 외래 키 → Reservation_Maintenance.Maintenance_ID — NOT NULL
Reservation_Info
- Reservation_ID — NUMBER
- Car_Number — NUMBER(10)
- Customer_Name — NVARCHAR2(30)
- Customer_Number — NUMBER(10)
- Customer_Number (Key) — NUMBER(10) — 외래 키 → Customer_Info.Customer_Number — NOT NULL
- Key2 — 외래 키 → Customer_Info.Customer_Name — NOT NULL
- Car_Number (Key3) — NUMBER(10) — 외래 키 → Car_Info.Car_Number — NOT NULL
Reservation_Maintenance
- Maintenance_ID (Key) — NUMBER — 기본 키 — NOT NULL
- Reservation_ID — NUMBER