library

테이블 (3)

대출기록 (HISTORY)

  • key (user_id) — NOT NULL
  • key (book_id) — NOT NULL
  • date (start_date) — NOT NULL
  • date (end_date)
  • date (return_date)

책목록 (BOOK)

  • Key (pk) — 기본 키 — NOT NULL
  • text (title) — NOT NULL
  • text (author) — NOT NULL
  • boolean (can) — NOT NULL
  • text (publish_comm)
  • date (publish_date)
  • int (category)
  • int (count)

회원 (USER)

  • Key (pk) — 기본 키 — NOT NULL
  • text (name) — NOT NULL
  • text (phone) — NOT NULL
  • text (email)
  • text (addr) — NOT NULL