book
Tables (4)
book (Book)
- id — int — Primary key — NOT NULL
- name — String
borrowbooks (BorrowBooks)
- id — int — Primary key — NOT NULL
- userid — int — Foreign key → user.id — NOT NULL
- innerbookid — int — Foreign key → innerbook.id — NOT NULL
- borrow_date — date
- return_date — date
- isreturn — int
innerbook (InnerBook)
- id — int — Primary key — NOT NULL
- bookid — int — Foreign key → book.id — NOT NULL
- iskeep — int
- bookcode — String
user (User)
- id — int — Primary key — NOT NULL
- username (Field) — String
- useremail — String
- password — String