과제
테이블 (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)