2022 정보학의 이해 과제

테이블 (7)

AUTHOR (Untitled4)

  • authorID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • alternativeName (Field2) — char(30)
  • description (Field3) — text
  • majorWork (Field4) — text
  • award (Field5) — text
  • works (Field6) — text

CHARACTER (Untitled6)

  • characterID (Key) — int(30) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • nationality (Field3) — char(10)
  • age (Field4) — char(1)

DRAMA (Untitled7)

  • dramaID (Key) — char(20) — 기본 키 — NOT NULL
  • title (Field) — char(30)
  • originalTitle (Field2) — char(30)
  • runTime (Field3) — char(20)
  • expression (Field4) — char(3)
  • type (Field5) — int(30)
  • workID (Key2) — int(30) — 외래 키 → WORK.workID — NOT NULL

WEBTOON (IC) (Untitled)

  • webtoonID (Key) — int(10) — 기본 키 — NOT NULL
  • title (Field) — char(30)
  • originalTitle (Field2) — char(30)
  • releasedYear (Field3) — int(4)
  • expression (Field4) — char(3)
  • description (Field5) — text
  • runTime (Field6) — int(3)
  • serialOffice (Field7) — char(30)
  • workID (Key2) — int(30) — 외래 키 → WORK.workID — NOT NULL
  • pubYear (Field8) — int(4)
  • serialCycle (Field9) — char(1)

WEBTOON_CHARACTER (Untitled5)

  • role (Key) — char(10) — 기본 키 — NOT NULL
  • webtoonID (Key2) — int(10) — 외래 키 → WEBTOON (IC).webtoonID — NOT NULL
  • characterID (Key3) — int(30) — 외래 키 → CHARACTER.characterID — NOT NULL

WORK (Untitled2)

  • workID (Key) — int(30) — 기본 키 — NOT NULL
  • workTItle (Field) — char(30)

WORK_AUTHOR (Untitled3)

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