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)