중간고사_김하영

테이블 (7)

Untitled (author)

  • Key (aID) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(5)
  • Field (address) — char(30)
  • Field (email) — char(50)

Untitled (book)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Key (kID) — char(3) — 외래 키 → Untitled.Key — NOT NULL
  • Field (pDate) — date
  • Field (price) — int(6)
  • Field (quantity) — int(3)
  • Key (pID) — char(5) — 외래 키 → Untitled.Key — NOT NULL

Untitled (topic)

  • Key (tno) — int(2) — 기본 키 — NOT NULL
  • Field (tName) — char(10)

Untitled (publisher)

  • Key (pID) — char(5) — 기본 키 — NOT NULL
  • Field (pName) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(11)

Untitled (mainbook)

  • Key (aID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (book_topic)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (tno) — int(2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (KDC)

  • Key (kID) — char(3) — 기본 키 — NOT NULL
  • Field (kName) — char(5)