mutsa

Tables (3)

Cart (장바구니)

  • id (장바구니아이디) — Long — Primary key — NOT NULL

Cart_Item (장바구니상품내역)

  • id (장바구니상품내역아이디) — Long — Primary key — NOT NULL
  • quantity (수량) — Integer
  • Cart_id (장바구니아이디) — Long — Foreign key → Cart.id — NOT NULL
  • Product_id (상품아이디) — Long — Foreign key → Product.id — NOT NULL

Product (상품)

  • id (상품아이디) — Long — Primary key — NOT NULL
  • name (상품명) — String
  • price (가격) — Integer
  • stock (재고수량) — Integer
  • description (상품설명) — String
  • status (판매상태) — String