homework5
Tables (4)
CART_ITEM (장바구니아이템)
- cart_item_id (장바구니아이템아이디) — BIGINT — Primary key — NOT NULL
- quantity (수량) — INT
- image_url (이미지URL) — VARCHAR
- cart_id (장바구니아이디) — BIGINT — Foreign key → Cart.cart_id — NOT NULL
- product_id (상품아이디) — BIGINT — Foreign key → Product.product_id — NOT NULL
Cart (장바구니)
- cart_id (장바구니아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.member_id — NOT NULL
Member (회원)
- member_id (회원아이디) — BIGINT — Primary key — NOT NULL
Product (상품)
- product_id (상품아이디) — BIGINT — Primary key — NOT NULL
- product_name (상품명) — VARCHAR
- price (가격) — BIGINT
- stock (재고) — INT