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