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