중간고사

테이블 (4)

Untitled (book)

  • Key (isbn) — CHAR(20) — 기본 키 — NOT NULL
  • Field (descri) — text
  • Field (b_date) — date

Untitled (book_com)

  • Key (book_id) — CHAR(20) — 기본 키 — NOT NULL
  • Key (isbn) — CHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (com_name) — char(20)
  • Field (adress) — char(20)

Untitled (author)

  • Key (au_no) — char(20) — 기본 키 — NOT NULL
  • Field (au_name) — char(20)
  • Field (au_adress) — char(20)
  • Field (au_book) — text
  • Key (isbn) — CHAR(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (book_topic)

  • Key (kdc) — CHAR(20) — 기본 키 — NOT NULL
  • Key (isbn) — CHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (topic) — char(20)
  • Field (person_in) — char(20)
  • Field (case_in) — text