시험

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