waffle-assignment3-team2
Tables (7)
CartProduct
- id — bigint — Primary key — NOT NULL
- count — int
- product_id — varchar(36) — Foreign key → Product.id — NOT NULL
- user_id — varchar(36) — Foreign key → User.id — NOT NULL
Order
- id — varchar(36) — Primary key — NOT NULL
- status — ENUM
- total_price — int
- user_id — varchar(36) — Foreign key → User.id — NOT NULL
OrderProduct
- id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → Order.id — NOT NULL
- product_id — varchar(36) — Foreign key → Product.id — NOT NULL
Product
- id — varchar(36) — Primary key — NOT NULL
- name — varchar(50)
- price — int
- stock — int
- store_id — varchar(36) — Foreign key → Store.id — NOT NULL
Review
- id — bigint — Primary key — NOT NULL
- rating — int
- comment — varchar(300)
- user_id — varchar(36) — Foreign key → User.id — NOT NULL
- product_id — varchar(36) — Foreign key → Product.id — NOT NULL
Store
- id — varchar(36) — Primary key — NOT NULL
- name — varchar(50)
- address — varchar(100)
- email — varchar(50)
- phone_number — varchar(20)
- delivery_fee — int
- user_id — varchar(36) — Foreign key → User.id — NOT NULL
User
- id — varchar(36) — Primary key — NOT NULL
- email — varchar(50)
- hashed_password — varchar(50)
- nickname — varchar(50)
- address — varchar(100)
- phone_number — varchar(20)