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)