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