book

Tables (5)

Book (Untitled2)

  • bookId (Key) — Long — Primary key — NOT NULL
  • categoryId (Key3) — Long — Foreign key → Category.categoryId — NOT NULL
  • bookName (Field3) — String
  • bookCount (Field4) — int

Category (Untitled5)

  • categoryId (Key) — Long — Primary key — NOT NULL
  • categoryName (Field) — String

Rental (Untitled3)

  • rentlaId (Key) — Long — Primary key — NOT NULL
  • bookId (Key3) — Long — Foreign key → Book.bookId — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL

Review (Untitled4)

  • reviewId (Key) — Long — Primary key — NOT NULL
  • bookId (Key3) — Long — Foreign key → Book.bookId — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • reviewContent (Field3) — String

User (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • userName (Field) — String
  • password (Field2) — String