7강

테이블 (7)

AUTHOR (Untitled5)

  • authorId (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • alternativeName (Field2) — char(50)
  • description (Field3) — text
  • majorWork (Field4) — text

BOOK (Untitled3)

  • ISBN (Key) — char(13) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • kdc_6th (Field3) — char(20)
  • pubYear (Field4) — int(4)
  • type (Field5) — char(10)
  • expression (Field6) — char(3)
  • workId (Key2) — int(30) — 외래 키 → WORK.workId — NOT NULL

MOVIE (Untitled)

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

MOVIE_PERSON (Untitled6)

  • role (Key) — char(10) — 기본 키 — NOT NULL

Untitled7

    WORK (Untitled2)

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

    WORK_AUTHOR (Untitled4)

    • workId (Key) — int(30) — 기본 키 — NOT NULL
    • authorId (Key2) — int(10) — 기본 키 — NOT NULL
    • workId (Key3) — int(30) — 외래 키 → WORK.workId — NOT NULL
    • authorId (Key4) — int(10) — 외래 키 → AUTHOR.authorId — NOT NULL
    • roll (Field) — char(20)