database 예제 4

테이블 (8)

Untitled (CUSTOMER)

  • Key (memberID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (address) — dhar(50)
  • Field (phone) — int(15)

Untitled (DVD)

  • Key (registerID) — char(10) — 기본 키 — NOT NULL
  • Field (purchaceDate) — date
  • Field (numberOfRentals) — int(2)
  • Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieID) — char(16) — 기본 키 — NOT NULL
  • Field (name) — char(50
  • Field (productionYear) — int(4)
  • Field (description) — text
  • Field (runningTime)
  • Field (genre)
  • Field (grade)

Untitled (ACTOR)

  • Key (actorID) — char(10) — 기본 키 — NOT NULL
  • Field (biography) — text

Untitled (DIRECTOR)

  • Key (directorID) — char(10) — 기본 키 — NOT NULL
  • Field (biography) — text

Untitled (RENTAL_RECORD)

  • Field (rentalDate) — date
  • Field (returnDate) — date
  • Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (registerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (APPEARENCE)

  • Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL
  • Key (actorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DIRECTION)

  • Key (directorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL