ERD 연습문제4

테이블 (6)

Customers

  • Key (customerNo) — int(6) — 기본 키 — NOT NULL
  • Field (customerName) — char(20)
  • Field (Address) — char(20)

Untitled (DVD)

  • Key (copyCode) — int(6) — 기본 키 — NOT NULL
  • Field (rentalCount) — int(6)
  • Field (purchaseDate) — int(10)
  • Key (DVDCode) — int(8) — NOT NULL
  • Key (MovieID) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Rental)

  • Field (rentalDate) — int(10)
  • Field (rentalTime) — int(20)
  • Key (customerNo) — int(6) — 외래 키 → Customers.Key — NOT NULL
  • Key (copyCode) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Actor)

  • Key (actorID) — int(6) — 기본 키 — NOT NULL
  • Field (biography) — char(30)
  • Key (MovieID) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Movie)

  • Key (MovieID) — int(6) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (productionDate) — int(10)
  • Key (directorID) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Director)

  • Key (directorID) — int(6) — 기본 키 — NOT NULL
  • Field (biography)