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