기말과제

테이블 (4)

Untitled (PERSON)

  • Key (PersonID) — int(30) — 기본 키 — NOT NULL
  • Field (nationality) — char(10)
  • Field (person_name) — char(30)

Untitled (RENTCAR_COMPANY)

  • Key (CompanyID) — int(30) — 기본 키 — NOT NULL
  • Key (CarID) — int(30) — 외래 키 → Untitled2.Key — NOT NULL
  • Field (CompanyName) — int(10)
  • Key (rent_rate) — int(30) — NOT NULL

Untitled2 (RENTCAR)

  • Key (CarID) — int(30) — 기본 키 — NOT NULL
  • Field (ProductName) — char(30)
  • Field (Date code) — int(10)
  • Field (LimitSeat) — int(10)
  • Field (CarCompany) — text
  • Field (CarDescripition) — text

Untitled2 (BOOKING)

  • Key (BookingDate) — int(30) — 기본 키 — NOT NULL
  • Key (PersonID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (CarID) — int(30) — 외래 키 → Untitled2.Key — NOT NULL