shelf

Tables (10)

Authors

  • author_id — INT
  • name — VARCHAR(100)
  • biography — TEXT
  • birthdate — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

BookCategories

  • book_id — INT
  • category_id — INT

Books

  • book_id — INT
  • title — VARCHAR(255)
  • author_id — INT
  • description — TEXT
  • genre — VARCHAR(50)
  • price — DECIMAL(10, 2)
  • publication_date — DATE
  • stock — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Categories

  • category_id — INT
  • name — VARCHAR(100)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

OrderItems

  • order_item_id — INT
  • order_id — INT
  • book_id — INT
  • quantity — INT
  • price — DECIMAL(10, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Orders

  • order_id — INT
  • user_id — INT
  • order_date — TIMESTAMP
  • total_amount — DECIMAL(10, 2)
  • status — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Reviews

  • review_id — INT
  • book_id — INT
  • user_id — INT
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Users

  • user_id — INT
  • username — VARCHAR(50)
  • password — VARCHAR(255)
  • email — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Wishlist

  • wishlist_id — INT
  • user_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

WishlistItems

  • wishlist_item_id — INT
  • wishlist_id — INT
  • book_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP