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