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