library

Tables (4)

Book (book)

  • BookNum (num) — int(20) — Primary key — NOT NULL
  • BookName (name) — varchar(10)
  • BookState (bookstate) — int(2)
  • Email (member_num) — int(20) — Foreign key → Member.Email — NOT NULL

Member (member)

  • Email (num) — int(20) — Primary key — NOT NULL
  • Pw (pw) — varchar(40)
  • Name (name) — varchar(10)
  • Email (email) — varchar(20)

MemberBook (memberbook)

  • Email (member_num) — int(20) — Foreign key → Member.Email — NOT NULL
  • Borrowed_book Count (borrowed_bookcount) — int(1)
  • Borrowable_bookCount (borrowable_bookcount) — int(1)

Return (retrun)

  • BookNum (book_num) — varchar(15) — Foreign key → Book.BookNum — NOT NULL
  • Return_date (return_date) — date
  • Remaining days (remaining_days) — int(5)