중간고사

테이블 (7)

Untitled (BOOK)

  • Key (ISBN) — INT — 기본 키 — NOT NULL
  • Field (bName) — char(20)
  • Field (puDate) — char(30)

Untitled (PUBLISHER)

  • Key (puID) — INT — 기본 키 — NOT NULL
  • Field (puName) — text
  • Field (puAddress) — char(30)
  • Key (ISBN) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (AUTHOR)

  • Key (auID) — int — 기본 키 — NOT NULL
  • Field (auName) — char(30)
  • Field (auAddress) — char(30)
  • Key (ISBN) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRINTER)

  • Key (priID) — INT — 기본 키 — NOT NULL
  • Field (prName) — text
  • Field (prBook) — text
  • Field (prContract) — char(20)
  • Key (ISBN) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (SUBJECT)

  • Key (KDC) — INT — 기본 키 — NOT NULL
  • Field (subName) — text
  • Field (subPeople) — char(30)
  • Field
  • Key (ISBN) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (교량개체)

    Untitled2 (교량개체2)