ERD연습_4

테이블 (7)

Untitled (CUSTOMER)

  • Key (Id) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(40)
  • Field (phon) — integer(12)

Untitled (DVD)

  • Key (dvdId) — char(10) — 기본 키 — NOT NULL
  • Field (DOP) — integer(8)
  • Field (rentNo) — integer(3)
  • Field (copy) — char(1)
  • Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (RENTAL)

  • Field (date) — integer(8)
  • Field (time) — integer(4)
  • Key (Id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dvdId) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (id) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (id) — char(6) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (yearMade) — integer(4)

Untitled (ACTOR)

  • Key (actId) — char(6) — 기본 키 — NOT NULL
  • Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (biography) — text
  • Field (film) — text

Untitled (DIRECTOR)

  • Key (dirId) — char(6) — 기본 키 — NOT NULL
  • Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (biography) — text
  • Field (film) — text

Untitled (MENAGER)

  • Key (id) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — integer(12)
  • Field (workTime) — integer(10)