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