230409 과제제출
테이블 (6)
BOOK (Untitled)
- title (Key) — char(10) — 기본 키 — NOT NULL
- itemid (Key2) — int(200) — 외래 키 → BOOKITEM.itemid — NOT NULL
- pubyear (Field) — int(5)
- pubmonth (Field2) — int(12)
- description (Field3) — LONGTEXT
- award (Field4)
BOOKITEM (Untitled2)
- itemid (Key) — int(200) — 기본 키 — NOT NULL
- buyingdate (Field) — date
- price (Field2) — int(20)
- status (Field3) — char(3)
- Field4 — int
BOOK_GENRE (Untitled3)
- title (Key) — char(10) — 외래 키 → BOOK.title — NOT NULL
- itemid (Key2) — int(200) — 외래 키 → BOOK.itemid — NOT NULL
- bookID (Field) — int(10)
- genreID (Field2) — int(10)
BOOLSTORE (Untitled6)
- title (Key) — char(10) — 외래 키 → BOOK.title — NOT NULL
- itemid (Key2) — int(200) — 외래 키 → BOOK.itemid — NOT NULL
- place (Field) — int(10)
- placetitle (Field2) — int(10)
CASTING (Untitled4)
- title (Key) — char(10) — 외래 키 → BOOK.title — NOT NULL
- itemid (Key2) — int(200) — 외래 키 → BOOK.itemid — NOT NULL
- personID (Key3) — int(10) — 외래 키 → PERSON.personID — NOT NULL
- bookID (Field) — int(10)
- personID (Field2) — int(10)
- roleID (Field3) — int(3)
- description (Field4) — LONGTEXT
PERSON (Untitled5)
- personID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — int(10)
- birthday (Field2) — chr(20)
- description (Field3) — LONGTEXT