중간고사

테이블 (7)

Untitled (book)

  • Key (isbn) — int(10) — 기본 키 — NOT NULL
  • Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — char(30)
  • Field (pubdate) — date
  • Field (editor name) — char(10)
  • Field (related person) — char(10)
  • Field (related case) — char(10)
  • Key (kdc number) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (publishing company)

  • Key (company id) — int(10) — 기본 키 — NOT NULL
  • Field (company name) — char(10)
  • Field (adress) — char(10)
  • Field (phone) — int(11)

Untitled (writer)

  • Key (writer name) — char(10) — 기본 키 — NOT NULL
  • Field (birthdate) — int(10)
  • Field (adress) — char(10)
  • Field (phone) — int(10)
  • Field (famous work) — char(20)

Untitled (book-wirter)

  • Key (isbn) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (writer name) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (book title) — char(30)

Untitled (printing factory)

  • Key (factory id) — int(10) — 기본 키 — NOT NULL
  • Field (factory name) — char(10)
  • Field (adress) — char(30)
  • Field (phone) — int(11)
  • Field

Untitled (printing contract)

  • Key (printing number) — char(10) — 기본 키 — NOT NULL
  • Field (deadline) — date
  • Key (isbn) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (company id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (factory id) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (kdc)

  • Key (kdc number) — int(10) — 기본 키 — NOT NULL
  • Field (주류(fist keyword)) — char(10)
  • Field (강목(second keyword) — char(10)
  • Field (요목(third keyword) — char(10)