shopping
Tables (6)
cart
- cart_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- product_id — int — NOT NULL
category
- category_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
order
- order_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- created_at — datetime(6) — NOT NULL
- delivery_request — varchar(100)
- recipient_name — varchar(20) — NOT NULL
- recipient_tel — varchar(20) — NOT NULL
- delivery_address — json — NOT NULL
- delivery_detail_address — varchar(50)
- delivery_fee — int — NOT NULL
- total_price — int — NOT NULL
- order_status — enum — NOT NULL
order_detail
- order_detail_id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- product_id — int — NOT NULL
- count — int — NOT NULL
- price — int — NOT NULL
product
- product_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- price — int — NOT NULL
- description — varchar(255) — NOT NULL
- detail (deatil) — text
user
- id — INT — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- is_admin — boolean — NOT NULL
- is_seller — boolean — NOT NULL
- address — varchar(255)
- phone — varchar(15) — NOT NULL