실습

테이블 (7)

AUTHOR (Untitled4)

  • authID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • alternativeName (Field2) — char(30)
  • description (Field3) — text
  • email (Field4) — char(30)
  • majorWorks (Field5) — text

Book (Untitled)

  • ISBN (Key) — char(13) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • pubDate (Field2) — date
  • type (Field3) — char(10)
  • kdc(6th) (Field4) — char(20)
  • expression (Field5) — char(3)
  • price (Field6) — integer
  • workID (Key2) — int(20) — 외래 키 → WORK.workID — NOT NULL

MOVIE (Untitled5)

  • movieID (Key) — int(10) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • releassedYear (Field3) — int(4)
  • expression (Field4) — char(3)
  • description (Field5) — text
  • runTime (Field6) — int(3)
  • workID (Key2) — int(20) — 외래 키 → WORK.workID — NOT NULL

MOVIE_PERSON (Untitled6)

  • role (Key) — char(10) — 기본 키 — NOT NULL
  • movieID (Key2) — int(10) — 외래 키 → MOVIE.movieID — NOT NULL
  • personID (Key3) — int(10) — 외래 키 → PERSON.personID — NOT NULL

PERSON (Untitled7)

  • personID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • nationality (Field3) — char(10)
  • repRole (Field4) — char(10)
  • majorWorks (Field5) — text

WORK (Untitled2)

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

WORK_AUTHOR (Untitled3)

  • workID (Key) — int(20) — 외래 키 → WORK.workID — NOT NULL
  • authID (Key2) — int(10) — 외래 키 → AUTHOR.authID — NOT NULL
  • role (Field) — char(20)