Libarary-app

Tables (3)

Library (User_Loan_History)

  • 아이디 (Id) — bigint — Primary key — NOT NULL
  • 회원아이디 (Id2) — bigint — Foreign key → Library.회원아이디 — NOT NULL
  • 책아이디 (Id3) — bigint — Foreign key → Library.책아이디 — NOT NULL
  • 책제목 (book_name) — varchar(255)
  • 대출현황 (Field) — tinyint

Library (User)

  • 회원아이디 (Id) — bigint — Primary key — NOT NULL
  • 회원이름 (name) — varchar(25)
  • 나이 (age)

Library (Book)

  • 책아이디 (Id) — bigint — Primary key — NOT NULL
  • 책제목 (book_name) — varchar(255)
  • Field