과제

테이블 (7)

AUTHOR (Untitled6)

  • authorID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • alternativeName (Field2)
  • description (Field3)
  • majorWork (Field4)

BOOK (Untitled4)

  • iISBN (Key) — 기본 키 — NOT NULL
  • title (Field)
  • originalTitle (Field2)
  • kdc_6th (Field3)
  • pubYear (Field4)
  • type (Field5)
  • expression (Field6)
  • workID (Key2) — 외래 키 → WORK.workID — NOT NULL

MOVIE (Untitled)

  • movieID (Key) — 기본 키 — NOT NULL
  • title (Field)
  • originalTitle (Field2)
  • releasedYear (Field3)
  • expression (Field4)
  • description (Field5)
  • runTime (Field6)
  • workID (Key2) — 외래 키 → WORK.workID — NOT NULL

MOVIE_PERSON (Untitled2)

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

PERSON (Untitled7)

  • persibID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • description (Field2)
  • nationality (Field3)
  • repRole (Field4)
  • majorWorks (Field5)

WORK (Untitled3)

  • workID (Key) — 기본 키 — NOT NULL
  • workTitle (Field)

WORK_AUTHOR (Untitled5)

  • workID (Key2) — 외래 키 → WORK.workID — NOT NULL
  • authorID (Key3) — 외래 키 → AUTHOR.authorID — NOT NULL
  • roll (Field)