KimchiMall-main

Tables (11)

Cart (장바구니)

  • id (장바구니 ID) — NOT NULL — Primary key — NOT NULL
  • id (회원 ID) — bigint(NOT NULL) — Foreign key → Member.id — NOT NULL

CartKimchi (장바구니 김치)

  • id (장바구니김치 ID) — Primary key — NOT NULL
  • quantity (수량)
  • cart_id (장바구니 ID) — NOT NULL — Foreign key → Cart.id — NOT NULL
  • kimchi_id (김치 ID) — NOT NULL — Foreign key → Kimchi.id — NOT NULL

Category (카테고리)

  • id (카테고리 ID) — NOT NULL — Primary key — NOT NULL
  • kimchi_id (김치 ID) — NOT NULL — Foreign key → Kimchi.id — NOT NULL
  • name (카테고리 이름) — NOT NULL
  • Field

Coupon (쿠폰)

  • id (쿠폰 ID) — NOT NULL — Primary key — NOT NULL
  • member_id (회원 ID) — bigint(NOT NULL) — Foreign key → Member.id — NOT NULL
  • name (쿠폰 이름) — NOT NULL
  • discountRate (할인율) — NOT NULL

Delivery (배송)

  • id (배송 ID) — NOT NULL — Primary key — NOT NULL
  • address (배송지) — NOT NULL
  • status (배송 상태)

Kimchi (김치)

  • id (김치 ID) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • price (가격) — NOT NULL
  • review (후기) — NOT NULL

Member (회원)

  • id (회원 ID) — bigint(NOT NULL) — Primary key — NOT NULL
  • loginId (로그인 ID) — NOT NULL
  • password (로그인 PW) — NOT NULL
  • address (주소) — NOT NULL
  • email (이메일 주소) — NOT NULL
  • Field

Notification (알람)

  • id (알람 ID) — NOT NULL — Primary key — NOT NULL
  • member_id (회원 ID) — bigint(NOT NULL) — Foreign key → Member.id — NOT NULL
  • message (알람 메시지)

Order (주문)

  • id (주문 ID) — NOT NULL — Primary key — NOT NULL
  • member_id (회원 ID) — bigint(NOT NULL) — Foreign key → Member.id — NOT NULL
  • status (주문 상태) — NULL
  • delivery_id (배송 ID) — NOT NULL — Foreign key → Delivery.id — NOT NULL

OrderKimchi (주문 김치)

  • id (주문 김치 ID) — NOT NULL — Primary key — NOT NULL
  • order_id (주문 ID) — NOT NULL — Foreign key → Order.id — NOT NULL
  • kimchi_id (김치 ID) — NOT NULL — Foreign key → Kimchi.id — NOT NULL
  • order_price (주문 가격) — NOT NULL
  • quantity (주문 수량) — NOT NULL
  • Field
  • id (장바구니 ID) — NOT NULL — Foreign key → Cart.id — NOT NULL

Review (리뷰)

  • id (리뷰 ID) — NOT NULL — Primary key — NOT NULL
  • kimchi_id (김치 ID) — NOT NULL — Foreign key → Kimchi.id — NOT NULL
  • comment (리뷰 내용) — NULL
  • score (리뷰 별점) — NOT NULL