도서관

테이블 (5)

AUTHOR (Untitled3)

  • authorID (Key) — char(15) — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • birthday (Field2) — char(15)
  • description (Field3) — text

BOOK (Untitled)

  • bookID — char(15) — 기본 키 — NOT NULL
  • title (Field) — char(30)
  • author (Field3) — char(15)
  • price (Field5) — char(10)
  • purchaseDate (Field6) — date
  • KDC (Field4) — char(30)
  • ISBN (Field2) — char(15)
  • bmlID (Key) — int(15) — 외래 키 → BOOK_MEMBER.bmlID — NOT NULL
  • balID (Key2) — int(10) — 외래 키 → BOOK_AUTHOR.balID — NOT NULL
  • bmlID (Key3) — int(15) — 외래 키 → BOOK_MEMBER.bmlID — NOT NULL

BOOK_AUTHOR (Untitled2)

  • balID (Key) — int(10) — 기본 키 — NOT NULL
  • bookID (Field) — char(15)
  • authorID (Field2) — char(15)
  • role (Field3) — char(30)
  • authorID (Key2) — char(15) — 외래 키 → AUTHOR.authorID — NOT NULL

BOOK_MEMBER (Untitled4)

  • bmlID (Key) — int(15) — 기본 키 — NOT NULL
  • bookID (Field) — char(15)
  • loanDate (Field2) — date
  • returnDate (Field3) — date
  • ssn (Key2) — char(15) — 외래 키 → MEMBER.ssn — NOT NULL

MEMBER (Untitled5)

  • ssn (Key) — char(15) — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(30)
  • phone (Field3) — char(15)
  • joindateField4 (Field4) — date