WebBook
Tables (3)
BookInformation (book_information)
- BookId (book_id) — varchar(255) — Primary key — NOT NULL
- PublisherId (publisher_id) — varchar(255)
- AuthorId (author_id) — varchar(255)
- ControlNumber (control_number) — varchar(255)
Category (category)
- BookId (Key) — varchar(255) — Foreign key → BookInformation.BookId — NOT NULL
- MainCategoryId (main_category_id) — varchar(255)
- SubCategoryId (sub_category_id) — varchar(255)
LoanData (loan_data)
- BookId (Key) — varchar(255) — Foreign key → BookInformation.BookId — NOT NULL
- WhetherId (whether_id) — varchar(255)