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)