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