cart-member

Tables (4)

Cart (Untitled)

  • cart_id (장바구니코드) — Long — Primary key — NOT NULL
  • member_id (멤버코드) — Long — Foreign key → Member.member_id — NOT NULL

Item (Untitled3)

  • product_id (상품 코드) — Long — Primary key — NOT NULL
  • product_name (상품명) — String — NOT NULL
  • product_stock (재고수량) — Int — NOT NULL
  • product_price (상품가격) — Int — NOT NULL
  • product_status (상품상태) — String — NOT NULL — (품절 or 판매)추후에 enum자료형으로 바꿀 예정
  • product_detail (상품 설명) — NOT NULL

Member (Untitled4)

  • member_id (멤버코드) — Long — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

cart_item (Untitled2)

  • cart_item_id (장바구니상품코드) — Long — Primary key — NOT NULL
  • count (수량) — Int — NOT NULL
  • cart_id (장바구니코드) — Long — Foreign key → Cart.cart_id — NOT NULL
  • product_id (상품 코드) — Long — Foreign key → Item.product_id — NOT NULL