기말고사

테이블 (9)

AUTHOR

  • athorID (authorID) — int(30) — 기본 키 — NOT NULL
  • name — char(30)
  • Field2 (altertivename) — char(40)
  • Field (description) — text
  • Field (majorWork) — text

BOOK

  • ISBN — char(13) — 기본 키 — NOT NULL
  • title — char(30)
  • kd_6th (kdc_6th) — char(20)
  • pubYer (pubYear) — int(4)
  • type — char(10)

BOOK_AUTHOR

  • ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL
  • athorID (authorID) — int(30) — 외래 키 → AUTHOR.athorID — NOT NULL
  • role — char10)

Untitled (MOVIE)

  • Key (movieID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(20)
  • Field (originalTitle) — char(30)
  • Field (releasedYear) — int(4)
  • Field (expression) — char(3)
  • Field (description) — text
  • Field (runtime) — int(3)
  • ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL

Untitled (MOVIE_PERSON)

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

Untitled (PERSON)

  • Key (personID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (description) — text
  • Field (repRole) — char(10)
  • Field (majorWork) — text

Untitled (MUSICAL)

  • Key (musicalID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(20)
  • Field (originalTile) — char(30)
  • Field (releasedYear) — int(4)
  • Field2 (expression) — char(3)
  • Field (description) — text
  • Field (runtime) — int(3)
  • ISBN — char(13) — 외래 키 → BOOK.ISBN — NOT NULL

Untitled (MUSICAL_PERSON)

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

Untitled (person)

  • Key (personID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (description) — text
  • Field (repRole) — char(10)
  • Field (majorWork) — text