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