기말과제-한경희

테이블 (9)

Untitled (WORK)

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

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (originalTitle) — char(50)
  • Field (pubYear) — int(4)
  • Field (manifestationType) — char(30)
  • Field (description) — text
  • Field (kdc_6th) — char(20)
  • Field (originalPubYear) — int(4)
  • workID — int(30) — 외래 키 → Untitled.workID — NOT NULL

Untitled (PUBLISHER)

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

Untitled (MOVIE)

  • Key (movieID) — char(30) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (originalTitle) — char(50)
  • Field (releasedYear) — int(4)
  • Field (language) — char(30)
  • Field (description) — text
  • Field (runTime) — int(3)
  • workID — int(30) — 외래 키 → Untitled.workID — NOT NULL

Untitled (PERSON)

  • Key (personID) — char(100) — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (description) — text
  • Field (nationality) — char(30)
  • Field (majorWorks) — text
  • Field (repRole) — char(20)
  • Field (alternativeName) — char(50)

Untitled (MOVIE_PERSON)

  • Key (role) — char(20) — 기본 키 — NOT NULL
  • Key (movieID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (personID) — char(100) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK_PERSON)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (personID) — char(100) — 외래 키 → Untitled.Key — NOT NULL
  • Field (role) — char(20)

Untitled (BOOK_PUBLISHER)

  • Key (pubID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORK_PERSON)

  • workID — int(30) — 외래 키 → Untitled.workID — NOT NULL