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)