MySHOP
Tables (6)
Cart (Untitled4)
- cart_id (카트 식별자) — AUTO — Primary key — NOT NULL
- member_id (회원식별자) — AUTO — Foreign key → Meber.member_id
CartItem (Untitled5)
- cart_Item_ID (카트 아이템 식별자) — AUTO — Primary key — NOT NULL
- count (카트에 담긴 개수) — null
- cart_id (카트 식별자) — AUTO — Foreign key → Cart.cart_id — NOT NULL
- item_id (아이템식별자) — AUTO — Foreign key → Item.item_id — NOT NULL
Item (Untitled2)
- item_id (아이템식별자) — AUTO — Primary key — NOT NULL
- item_Name (이름) — not null
- stock_Quantity (수량) — not null
- price (가격) — not null
Meber (.)
- member_id (회원식별자) — AUTO — Primary key
- email (이메일(ID)) — Unique
- password (비밀번호) — not null
- name (이름) — not null
Order (Untitled)
- order_id (주문식별자) — AUTO — Primary key — NOT NULL
- amount (주문 총액) — not null
- order_Status (상태(주문,취소)) — not null
- member_id (회원식별자) — AUTO — Foreign key → Meber.member_id
OrderItem (Untitled3)
- orderItem_id (주문 아이템 식별자) — AUTO — Primary key — NOT NULL
- item_id (아이템식별자) — AUTO — Foreign key → Item.item_id — NOT NULL
- total_Count (주문 수량) — not null
- Quantity (총 금액) — not null
- order_id (주문식별자) — AUTO — Foreign key → Order.order_id — NOT NULL