2023_05_17_개인과제

테이블 (7)

Untitled (MUSICAL)

  • Key (musicalID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — int(4)
  • Field (nationality) — char(10)
  • Field (runtime) — int(3)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK)

  • Key (bookID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (originalTitle) — char(50)
  • Field (pubYear) — int(4)
  • Field (expression) — char(3)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORK)

  • Key (workID) — int(30) — 기본 키 — NOT NULL
  • Field (workTitle) — char(50)

Untitled (WORK_AUTHOR)

  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (roll) — char(20)

Untitled (AUTHOR)

  • Key (authorID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alternativeName) — char(50)
  • Field (description) — text

Untitled (MUSICAL_PERSON)

  • Key (role) — char(10) — 기본 키 — NOT NULL
  • Key (personID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (musicalID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PERSON)

  • Key (personID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (reprole) — char(10)
  • Field (award) — text