shop
Tables (6)
Cart
- id — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
CartItem
- cart_item_id (id) — BIGINT — Primary key — NOT NULL
- id (cart_id) — BIGINT — Foreign key → Cart.id — NOT NULL
- id (item_id) — BIGINT — Foreign key → Untitled.id — NOT NULL
- count — BIGINT
Member
- id — BIGINT — Primary key — NOT NULL
- name — varchar
- email — varchar
- password — varchar
- address — varchar
- role — varchar
Untitled (Item)
- id — BIGINT — Primary key — NOT NULL
- name — varchar
- price — BIGINT
- stock_number — BIGINT
- detail — varchar
- sell_status — varchar
Untitled (Orders)
- id — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- date — DATETIME
- status — varchar
Untitled (OrderItem)
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → Untitled.id — NOT NULL
- id (item_id) — BIGINT — Foreign key → Untitled.id — NOT NULL
- price — BIGINT
- count — BIGINT