도서관

테이블 (3)

Untitled (rental)

  • Key (rentalID) — Long — 기본 키 — NOT NULL
  • Key (memberID) — Long — 외래 키 → 회원.Key — NOT NULL
  • Key (bookID) — Long — 외래 키 → 책.Key — NOT NULL
  • Field (rentDate) — date
  • Field (dueDate) — date
  • Field (returnDate) — date
  • Field (rentState) — enum(ACTIVE, RETURNED)

책 (book)

  • Key (bookID) — Long — 기본 키 — NOT NULL
  • Field (title) — varchar(50)
  • Field (author) — varchar(50)
  • Field (publisher) — varchar(50)
  • Field (publicationDate) — date
  • Field (stock) — int
  • Field (count) — int
  • Field (available) — boolean

회원 (Member)

  • Key (memberID) — Long — 기본 키 — NOT NULL
  • Field (username) — varchar(20)
  • Field (password) — varchar(255)
  • Field (email) — varchar(50)
  • Field (role) — enum(USER, ADMIN, OVERDUE)
  • Field (penaltyPoint) — int
  • Field (penaltyReleaseDate) — date