library

Tables (5)

Book (책)

  • ID (책ID) — BIGINT — Primary key — NOT NULL
  • ISBN (책 유일 ID) — VARCHAR(20) — NOT NULL
  • title (책 제목) — VARCHAR(255) — NOT NULL
  • author (책 저자) — VARCHAR(255) — NOT NULL
  • category (책 카테고리) — BIGINT — NOT NULL

Borrowing (대출)

  • ID (대출 번호) — BIGINT — Primary key — NOT NULL
  • member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
  • borrowingDate (대출일) — DATE — NOT NULL
  • returnDueDate (반납예정일) — DATE — NOT NULL

BorrowingDetail (대출 상세)

  • ID (대출 상세 번호) — BIGINT — Primary key — NOT NULL
  • borrowing_ID (대출 번호) — BIGINT — Foreign key → Borrowing.ID — NOT NULL
  • realBook_ID (실제 책 ID) — BIGINT — Foreign key → RealBook.ID — NOT NULL
  • returnDate (실제 반납일) — DATE

Member (회원)

  • ID (회원ID) — BIGINT — Primary key — NOT NULL
  • name (회원 이름) — VARCHAR(255) — NOT NULL
  • email (회원 이메일) — VARCHAR(255) — NOT NULL
  • roll (역할) — ENUM(사서, 유저) — NOT NULL

RealBook (진짜 책)

  • ID (실제 책 ID) — BIGINT — Primary key — NOT NULL
  • book_ID (책ID) — BIGINT — Foreign key → Book.ID — NOT NULL
  • status (이용가능여부) — ENUM(avaiable, loaned), — NOT NULL
  • location (실제 책 위치) — VARCHAR(255) — NOT NULL