test
Tables (6)
t_cart
- Key (cart_id) — Primary key — NOT NULL
- Key (member_id) — Foreign key → t_member.Key — NOT NULL
t_cartitem (Untitled)
- Key (cart_item_id) — Primary key — NOT NULL
- Field (count)
- Key (cart_id) — Foreign key → t_cart.Key — NOT NULL
- Key (item_id) — Foreign key → t_item.Key — NOT NULL
t_item (Untitled2)
- Key (item_id) — Primary key — NOT NULL
- Field (item_name)
- Field (price)
- Field (stock_number)
- Field (item_detail)
- Field (item_sell_status)
t_member
- Key (member_id) — Primary key — NOT NULL
- Field (name)
- Field (email)
- Field (password)
- ad (address)
- Field (role)
t_order
- Key (order_id) — Primary key — NOT NULL
- Field (order_date)
- Field (order_status)
- Key (member_id) — Foreign key → t_member.Key — NOT NULL
t_orderitem
- Key (order_item_id) — Primary key — NOT NULL
- Field (order_price)
- Field (count)
- Key (order_id) — Foreign key → t_order.Key — NOT NULL
- Key (item_id) — Foreign key → t_item.Key — NOT NULL