웹데이터베이스 중간고사

테이블 (5)

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (bKDC) — char(3)
  • Field (bName) — char(50)
  • Field (bdate) — date
  • Field (bPerson) — char(50)
  • Field (bCase) — text
  • Key (pID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (kID) — int(3) — 외래 키 → Untitled.Key — NOT NULL

Untitled (AUTHOR)

  • Key (ssn) — char(30) — 기본 키 — NOT NULL
  • Field (aName) — char(30)
  • Field (aBdate) — date
  • Field (aAddress) — char(50)
  • Field (aPhonenumber) — char(13)

Untitled (PUBLISHER)

  • Key (pID) — char(30) — 기본 키 — NOT NULL
  • Field (pName) — char(30)
  • Field (pAddress) — char(30)
  • Field (pPhonenumber) — char(13)
  • Field (pOwner) — char(30)

Untitled (BOOK_AUTHOR)

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

Untitled (BOOKKEYWORD)

  • Key (kID) — int(3) — 기본 키 — NOT NULL
  • Field (kWord) — char(10)