4번

테이블 (6)

Untitled (member)

  • Key (member id) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (adress) — char(10)
  • Field

Untitled (dvd)

  • Key (dvd code) — char(10) — 기본 키 — NOT NULL
  • Field (purchase date) — date
  • Field (number of rent) — char(10)
  • Field (dvd name) — char(10)
  • Field2 (price) — char(5)
  • Key (movie id) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (movie)

  • Key (movie id) — char(10) — 기본 키 — NOT NULL
  • Field (title) — char(10)
  • Field (pubyear) — char(10)

Untitled (rent)

  • Key (member id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dvd code) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (rentdate) — char(1))
  • Field (returndate) — char(10)

Untitled (casting)

  • Key (role id) — char(1)) — 기본 키 — NOT NULL
  • Field (role description) — char(10)
  • Key (movie id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (personid2) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (person)

  • Key (personid) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (description) — chary(10)
  • Field