장바구니

테이블 (8)

Copy Of cart_item (CopyOfUntitled2)

  • user_id (Field2) — 외래 키 → Copy Of user.user_id
  • product_id (Field3) — 외래 키 → Copy Of product.product_id
  • quantity (Field4)
  • option (Field5)

Copy Of product (CopyOfUntitled3)

  • product_id (Field) — 기본 키
  • name (Field2)
  • price (Field3)
  • stock (Field4)
  • product_options (Field5)

Copy Of user (CopyOfUntitled4)

  • user_id (Field) — 기본 키
  • id (Field2)
  • name (Field3)
  • password (Field4)

cart (Untitled)

  • cart_id (Field) — 기본 키
  • user_id (Field3) — 외래 키 → user.user_id
  • Field2

cart_item (Untitled2)

  • item_id (Field) — 기본 키
  • cart_id (Field2) — 외래 키 → cart.cart_id
  • product_id (Field6) — 외래 키 → product.product_id
  • quantity (Field4)
  • option (Field5)

product (Untitled3)

  • product_id (Field) — 기본 키
  • name (Field2)
  • price (Field3)
  • stock (Field4)
  • product_options (Field5)

product_option (Untitled5)

  • option_id (Field) — 기본 키
  • Field2

user (Untitled4)

  • user_id (Field) — 기본 키
  • id (Field2)
  • name (Field3)
  • password (Field4)