book-store
Tables (6)
cart
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- quantity — bigint(10)
cart_item
- id — bigint(20) — Primary key — NOT NULL
- item_id — bigint(20) — Foreign key → item.id — NOT NULL
- quantity — bigint(20) — NOT NULL
item
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(255) — NOT NULL
- publisher — varchar(255) — NOT NULL
- publish_year — int(10) — NOT NULL
- price — bigint(20) — NOT NULL
- stock — bigint(20) — NOT NULL
order
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- totalPirce (total_price) — bigint(20) — NOT NULL
- orderDate — datetime(6) — NOT NULL
- delivery_status — enum — NOT NULL
order_item
- id — bigint(20) — Primary key — NOT NULL
- order_id — bigint(20) — Foreign key → order.id — NOT NULL
- item_id — bigint(20) — Foreign key → item.id — NOT NULL
- order_count — bigint(20) — NOT NULL
user
- id — bigint(20) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(15) — NOT NULL
- address — varchar(255) — NOT NULL
- phoneNum (phone_num) — varchar(255) — NOT NULL
- point — int(10) — NOT NULL
- role — enum — NOT NULL