데이터베이스

테이블 (6)

Untitled (MOVIE)

  • Key — integer — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field

Untitled (MOVIE_DIRECTOR)

  • Key (ssn) — integer — 기본 키 — NOT NULL
  • Key — integer — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(20)

Untitled (ACTOR)

  • Key (ssn) — integer — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(20)
  • Field

Untitled (PRODUCTION)

  • Key (ProdID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field

Untitled (NARRATIVE)

  • Key (subNo) — integer — 기본 키 — NOT NULL
  • Field (keyword) — text
  • Field (people) — text
  • Field (incident) — text

Untitled (MUSIC)

  • Key (muID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (composer) — char(20)
  • Field