실습
테이블 (7)
AUTHOR (Untitled4)
- authID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- alternativeName (Field2) — char(30)
- description (Field3) — text
- email (Field4) — char(30)
- majorWorks (Field5) — text
Book (Untitled)
- ISBN (Key) — char(13) — 기본 키 — NOT NULL
- title (Field) — char(50)
- pubDate (Field2) — date
- type (Field3) — char(10)
- kdc(6th) (Field4) — char(20)
- expression (Field5) — char(3)
- price (Field6) — integer
- workID (Key2) — int(20) — 외래 키 → WORK.workID — NOT NULL
MOVIE (Untitled5)
- movieID (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(50)
- originalTitle (Field2) — char(50)
- releassedYear (Field3) — int(4)
- expression (Field4) — char(3)
- description (Field5) — text
- runTime (Field6) — int(3)
- workID (Key2) — int(20) — 외래 키 → WORK.workID — NOT NULL
MOVIE_PERSON (Untitled6)
- role (Key) — char(10) — 기본 키 — NOT NULL
- movieID (Key2) — int(10) — 외래 키 → MOVIE.movieID — NOT NULL
- personID (Key3) — int(10) — 외래 키 → PERSON.personID — NOT NULL
PERSON (Untitled7)
- personID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- nationality (Field3) — char(10)
- repRole (Field4) — char(10)
- majorWorks (Field5) — text
WORK (Untitled2)
- workID (Key) — int(20) — 기본 키 — NOT NULL
- workTitle (Field) — char(50)
WORK_AUTHOR (Untitled3)
- workID (Key) — int(20) — 외래 키 → WORK.workID — NOT NULL
- authID (Key2) — int(10) — 외래 키 → AUTHOR.authID — NOT NULL
- role (Field) — char(20)