ERD
Tables (10)
Book (book)
- Book Id (book_id) — INT — Primary key — NOT NULL
- Title (title) — VARCHAR(255) — NOT NULL
- Author (author) — VARCHAR(255) — NOT NULL
- Publisher (publisher) — VARCHAR(255) — NOT NULL
- Summary (summary) — TEXT — NOT NULL
- ISBN (isbn) — VARCHAR(20) — NOT NULL
- Price (price) — INT — NOT NULL
- Publication Date (publication_date) — DATE — NOT NULL
- Created At (created_at) — DATETIME — NOT NULL
- Updated At (updated_at) — DATETIME
Cart (cart)
- Cart Id (cart_id) — INT — Primary key — NOT NULL
- Created At (created_at) — DATETIME — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
CartItem (cart_item)
- Cart Item Id (cart_item_id) — INT — Primary key — NOT NULL
- Quantity (quantity) — INT — NOT NULL
- Cart Id (cart_id) — INT — Foreign key → Cart.Cart Id — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
Favorite (favorite)
- Favorite Id (favorite_id) — INT — Primary key — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
Order (order)
- Order Id (order_id) — INT — Primary key — NOT NULL
- Total Amount (total_amount) — Integer(20) — NOT NULL
- Status (status) — ENUM('SHIPPED') — NOT NULL
- Created At (created_at) — DATETIME — NOT NULL
- Updated At (updated_at) — DATETIME
- User Id (user_id) — Integer(11) — Foreign key → User.User Id — NOT NULL
OrderItem (order_item)
- Order Item Id (order_item_id) — INT — Primary key — NOT NULL
- Quantity (quantity) — INT — NOT NULL
- Price (price) — INT — NOT NULL
- Order Id (order_id) — INT — Foreign key → Order.Order Id — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
Review (review)
- Review Id (review_id) — INT — Primary key — NOT NULL
- Rating (rating) — INT — NOT NULL
- Comment (content) — VARCHAR(255)
- Created At (created_at) — DATETIME — NOT NULL
- Updated At (updated_at) — DATETIME
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
Untitled (library)
- Key (library_id) — INT — Primary key — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
User (user)
- User Id (user_id) — INT — Primary key — NOT NULL
- User Name (user_name) — VARCHAR(255) — NOT NULL
- Email (email) — VARCHAR(255) — NOT NULL
- Birthday (birthday) — DATE — NOT NULL
- Gender (gender) — CHAR(1) — NOT NULL
- Phone (phone) — VARCHAR(20) — NOT NULL
- Role (role) — ENUM('ROLE_USER', 'ROLE_ADMIN', 'ROLE_SALER') — NOT NULL
- Password (password) — VARCHAR(255) — NOT NULL
- Created at (created_at) — DATETIME — NOT NULL
- Updated at (updated_at) — DATETIME
- Address (address) — VARCHAR(255) — NOT NULL
comment
- Key (comment_id) — INT — Primary key — NOT NULL
- Field (content) — VARCHAR(255) — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Review Id (review_id) — INT — Foreign key → Review.Review Id — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (updated_at) — DATETIME