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)