book
Tables (5)
book (도서등록)
- id (Key) — BIGINT — Primary key — NOT NULL
- bookname (도서명) — VARCHAR(255_ — NOT NULL
- information (도서정보) — VARCHAR(255)
- inventory (도서재고) — int — NOT NULL
- volume loan (대출중인 도서수량) — int — NOT NULL
loan detail (대출상세내용)
- id (Key) — BIGINT — Primary key — NOT NULL
- loan_id (실시간대출 id) — BIGINT — Foreign key → loan id.id — NOT NULL
- book_id (도서id) — BIGINT — Foreign key → book.id — NOT NULL
- amount loan (대출수량) — int — NOT NULL
- date loan (대출날짜) — date — NOT NULL
- date return (반납날짜) — date — NOT NULL
loan id (실시간 도서대출)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원 id) — BIGNIT — Foreign key → user.id — NOT NULL
return (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- book _id (도서id) — BIGINT — Foreign key → book.id — NOT NULL
- 대출상세id — BIGINT — Foreign key → loan detail.id — NOT NULL
- amount return (반납수량) — int — NOT NULL
- date return (반납날짜) — date — NOT NULL
user (회원등록)
- id (Key) — BIGINT — Primary key — NOT NULL
- user name (회원명) — VARCHAR(255) — NOT NULL
- sex (성별) — VARCHAR(255)