도서 대출

테이블 (3)

Book (books)

  • Book (idx) — INT — 기본 키 — NOT NULL
  • Title (title) — VARCHAR(30)
  • Category (category) — VARCHAR(30)
  • Rent_chk (state) — BOOLEAN

Member (members)

  • Member (idx) — INT — 기본 키 — NOT NULL
  • Email (email) — VARCHAR(30)
  • Name (name) — VARCHAR(30)

Rent (rents)

  • Rent (idx) — INT — 기본 키 — NOT NULL
  • Member (member_id) — INT — 외래 키 → Member.Member — NOT NULL
  • Book (book_id) — INT — 외래 키 → Book.Book — NOT NULL
  • Rent_date (rent_date) — DATE
  • Description (description) — VARCHAR(30)