BookAPI

Tables (6)

Book (Untitled)

  • PK (bookId) — bigint — Primary key — NOT NULL
  • 카테고리 (category) — varchar
  • 제목 (title) — varchar
  • 저자 (author) — varchar
  • 제작사 (publisher) — varchar
  • 상태 (status) — enum

Library (Untitled3)

  • PK (libraryId) — bigint — Primary key — NOT NULL
  • 도서관 이름 (libararyName) — varchar

LibraryBook (Untitled5)

  • PK (LibraryBookId) — bigint — Primary key — NOT NULL
  • FK (libraryId) — bigint — Foreign key → Library.PK — NOT NULL
  • FK (bookId) — bigint — Foreign key → Book.PK — NOT NULL

LibraryMember (Untitled4)

  • PK (libraryMemberId) — bigint — Primary key — NOT NULL
  • PK (libraryId) — bigint — Foreign key → Library.PK — NOT NULL
  • PK (memberId) — bigint — Foreign key → Member.PK — NOT NULL

Member (Untitled2)

  • PK (memberId) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 전화번호 (phone) — varchar

MemberBook (Untitled6)

  • PK (memberBookId) — bigint — Primary key — NOT NULL
  • FK (memberId) — bigint — Foreign key → Member.PK — NOT NULL
  • FK (bookId) — bigint — Foreign key → Book.PK — NOT NULL
  • 대출 날짜 (createdAt)
  • 연체 일수 (overdueDate)
  • 도서관 ID (libraryId) — bigint
  • 반납여부 (isReturned)
  • 반납 날짜 (returnedAAt)