기말과제
테이블 (7)
Author (Untitled3)
- AuthorID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- alternativeName (Field2) — char(30)
- description (Field3) — text
- majorWork (Field4) — text
Book (Untitled2)
- ISBN (Key) — char(13) — 기본 키 — NOT NULL
- title (Field) — char(50)
- pubYear (Field2) — int(4)
- type (Field3) — char(10)
- expression (Field4) — char(3)
- workID (Key2) — int(30) — 외래 키 → Work.workID — NOT NULL
Person (Untitled4)
- personID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- nationality (Field3) — char(10)
- repRole (Field4) — char(10)
- majorWork (Field5) — text
Play (Untitled)
- playID (Key) — int(10) — 기본 키 — NOT NULL
- title (Field) — char(50)
- originalTitle (Field2) — char(50)
- releasedYear (Field3) — int(4)
- expression (Field4) — char(3)
- description (Field5) — text
- runTime (Field6) — int(3)
- workID (Key2) — int(30) — 외래 키 → Work.workID — NOT NULL
Play_Person (Untitled6)
- role (Key) — char(10) — 기본 키 — NOT NULL
- playID (Key2) — int(10) — 외래 키 → Play.playID — NOT NULL
- personID (Key3) — int(10) — 외래 키 → Person.personID — NOT NULL
Work (Untitled5)
- workID (Key) — int(30) — 기본 키 — NOT NULL
- workTitle (Field) — char(50)
Work_Author (Untitled7)
- workID (Key) — int(30) — 외래 키 → Work.workID — NOT NULL
- AuthorID (Key2) — int(10) — 외래 키 → Author.AuthorID — NOT NULL