shopping-mall

Tables (7)

CART (장바구니)

  • KEY (id) — Primary key — NOT NULL

CART_PRODUCT (연결테이블2)

  • KEY (cart_id) — Foreign key → CART.KEY — NOT NULL
  • KEY (product_id) — Foreign key → PRODUCT.KEY — NOT NULL

CATEGORY (카테고리)

  • KEY (id) — Primary key — NOT NULL
  • 이름 (name) — unique

ORDER (주문)

  • KEY (id) — Primary key — NOT NULL
  • KEY (user_id) — Foreign key → USER.KEY — NOT NULL

ORDER_PRODUCT (연결테이블)

  • KEY (order_id) — Foreign key → ORDER.KEY — NOT NULL
  • KEY (product_id) — Foreign key → PRODUCT.KEY — NOT NULL

PRODUCT (상품)

  • KEY (id) — Primary key — NOT NULL
  • 제목 (title)
  • 가격 (price)
  • 설명 (description)
  • 이미지 (image)
  • KEY (category_id) — Foreign key → CATEGORY.KEY — NOT NULL

USER (유저)

  • KEY (id) — Primary key — NOT NULL
  • 이메일 (email) — unique
  • 비밀번호 (password)
  • 이름 (name)
  • 비밀번호 (role)
  • FK (cart_id) — Foreign key → CART.KEY — NOT NULL