bookstore
Tables (7)
Book
- book_id — int — Primary key — NOT NULL
- publisher_id — INT — Foreign key → Publisher.publisher_id — NOT NULL
- book_title — VARCHAR — NOT NULL
- author — VARCHAR
- price — INT
- rating — DECIMAL
Book_Inventory_History
- id — VARCHAR — Primary key — NOT NULL
- book_id — int — Foreign key → Book.book_id — NOT NULL
- t_type — VARCHAR — NOT NULL
- Quantity — INT — NOT NULL
- t_date — DATETIME — NOT NULL
Cart
- cart_id — INT — Primary key — NOT NULL
- id (user_id) — VARCHAR — Foreign key → Members.id — NOT NULL
- book_id — int — Foreign key → Book.book_id — NOT NULL
- quantity — INT — NOT NULL
- dateAdded — DATETIME — NOT NULL
Members
- id — VARCHAR — Primary key — NOT NULL
- pw — VARCHAR — NOT NULL
- adress — VARCHAR
- email — VARCHAR
- user_per — CHAR
Orders
- order_id — VARCHAR — Primary key — NOT NULL
- id (user_id) — VARCHAR — Foreign key → Members.id — NOT NULL
- total_amount — DECIMAL — NOT NULL
- order_date — DATETIME
Publisher
- publisher_id — INT — Primary key — NOT NULL
- publisher_name — VARCHAR
- manager — VARCHAR
- phone_number — VARCHAR
book_history
- id — INT — Primary key — NOT NULL
- book_id — int — Foreign key → Book.book_id — NOT NULL
- publisher_id — INT
- quantity — INT
- book_date — DATETIME