선착순 구매 프로젝트 ERD

쿠팡 이커머스

테이블 (19)

Notifications

  • notification_id — INT
  • user_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

반품 (ORDER_RETURN)

  • order_return_pk — LONG — 기본 키 — NOT NULL
  • order_return_date — DATETIME
  • order_return_status — ENUM('Pending', 'Completed', 'Canceled')
  • order_return_reason — String
  • created_at — DATETIME
  • updated_at — DATETIME
  • order_item_pk — LONG — 외래 키 → 주문 아이템.order_item_pk — NOT NULL

배송비 규약 (SHIPPING_POLICY)

  • shipping_policy_pk — LONG — 기본 키
  • seller_pk — LONG — 외래 키 → 판매자.seller_pk — NOT NULL
  • 기본 배송비 (shipping_policy_base_fee) — INT — NOT NULL
  • 무료배송 최소 금액 (shipping_policy_free_threshold) — INT
  • 상품 수량 별 추가 배송비 (shipping_policy_additional_fee_per_item) — INT
  • created_at — DATETIME
  • updated_at — DATETIME

상품 (PRODUCT)

  • product_pk — LONG — 기본 키 — NOT NULL
  • name (product_name) — STRING — NOT NULL
  • description (product_description) — STRING
  • price (product_price) — INT — NOT NULL
  • stock (product_stock) — INT — NOT NULL
  • avg_rating (product_avg_rating) — FLOAT
  • review_count (product_review_count) — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • category_pk — LONG — 외래 키 → 카테고리.category_pk
  • seller_pk — LONG — 외래 키 → 판매자.seller_pk — NOT NULL

세일 (SALE)

  • sale_pk — LONG — 기본 키
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL
  • sale_price — DECIMAL(10, 2) — NOT NULL
  • sale_percent — DECIMAL(5, 2)
  • start_date (sale_start_date) — DATETIME — NOT NULL
  • end_date (sale_end_date) — DATETIME — NOT NULL
  • created_by — ENUM('seller', 'platform')
  • created_at — DATETIME
  • updated_at — DATETIME

유저 (USER)

  • user_pk — LONG — 기본 키 — NOT NULL
  • id (user_id) — STRING
  • name (user_name) — STRING — NOT NULL
  • password (user_pw) — STRING
  • phone_number (user_phone_num) — STRING — NOT NULL
  • email (user_email) — STRING — NOT NULL
  • gender (user_gender) — ENUM('Male', 'Female' )
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

유저상품리뷰 (USER_PRODUCT_REVIEW)

  • review_pk (user_product_review_pk) — LONG — 기본 키
  • rating (user_product_review_rating) — FLOAT
  • comment (user_product_review_comment) — STRING — EX
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_pk — LONG — 외래 키 → 유저.user_pk — NOT NULL
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL

유저상품리뷰판매자댓글 (USER_PRODUCT_REVIEW_SELLER_REPLY)

  • reply_pk (user_product_review_seller_reply_pk) — LONG — 기본 키
  • review_pk — LONG — 외래 키 → 유저상품리뷰.review_pk
  • comment (user_product_review_seller_reply_comment) — STRING — EX
  • created_at — DATETIME
  • updated_at — DATETIME
  • seller_pk — LONG — 외래 키 → 판매자.seller_pk — NOT NULL

유저상품위시 (USER_PRODUCT_WISH)

  • wishlist_pk — LONG — 기본 키 — NOT NULL
  • user_pk — LONG — 외래 키 → 유저.user_pk — NOT NULL
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL
  • created_at — DATETIME

장바구니 (CART)

  • cart_pk — LONG — 기본 키 — NOT NULL
  • user_pk — LONG — 외래 키 → 유저.user_pk — NOT NULL

장바구니 아이템 (CART_ITEM)

  • cart_item_pk — LONG — 기본 키 — NOT NULL
  • price (cart_item_price) — INT
  • quantity (cart_item_quentity) — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL
  • cart_pk — LONG — 외래 키 → 장바구니.cart_pk — NOT NULL

주문 (ORDER)

  • order_pk — LONG — 기본 키 — NOT NULL
  • total_price (order_total_price) — INT — NOT NULL
  • shipping_fee (order_shipping_fee) — INT
  • item_quantity (order_item_quantity) — INT
  • status (order_status) — ENUM('Pending', 'Shipped', 'Completed', 'Cancelled')
  • created_at == order_at (created_at) — DATETIME
  • updated_at — DATETIME
  • user_pk — LONG — 외래 키 → 유저.user_pk — NOT NULL

주문 아이템 (ORDER_ITEM)

  • order_item_pk — LONG — 기본 키 — NOT NULL
  • price (order_item_price) — INT
  • quantity (order_item_quantity) — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL
  • order_pk — LONG — 외래 키 → 주문.order_pk — NOT NULL

카테고리 (CATEGORY)

  • category_pk — LONG — 기본 키
  • major_category — STRING — NOT NULL
  • middle_category — STRING
  • minor_category — STRING

쿠폰 (COUPON)

  • coupon_pk — LONG — 기본 키
  • code — STRING — NOT NULL
  • discount — DECIMAL(10, 2) — NOT NULL
  • expiration_date — DATETIME — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

판매자 (SELLER)

  • seller_pk — LONG — 기본 키 — NOT NULL
  • id (user_id) — STRING
  • name (user_name) — STRING — NOT NULL
  • password (user_pw) — STRING
  • phone_number (user_phone_num) — STRING — NOT NULL
  • email (user_email) — STRING — NOT NULL
  • social_type (user_social_type) — STRING
  • social_id (user_social_id) — STRING
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

판매자 회사 (STORE)

  • store_pk — LONG — 기본 키
  • seller_pk — LONG — 외래 키 → 판매자.seller_pk — NOT NULL
  • store_name — STRING — NOT NULL
  • store_address — STRING — NOT NULL
  • contact_number (store_contact_number) — STRING
  • created_at — DATETIME
  • updated_at — DATETIME

판매자(쇼핑몰 별) 주문 (ORDER_ITEM_GROUP)

  • order_item_group_pk — LONG — 기본 키 — NOT NULL
  • shipping_fee (order_item_group_shipping_fee) — INT
  • quantity (order_item_group_quantity) — INT
  • status (order_item_group_status) — ENUM('Pending', 'Shipped', 'Completed', 'Cancelled')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

핫딜 (HOT_DEAL)

  • hotdeal_pk — LONG — 기본 키
  • product_pk — LONG — 외래 키 → 상품.product_pk — NOT NULL
  • sale_price (hotdeal_sale_price) — INT — NOT NULL
  • sale_percent (hotdeal_sale_percent) — INT
  • start_time (hotdeal_start_time) — DATETIME — NOT NULL
  • end_time (hotdeal_end_time) — DATETIME — NOT NULL
  • created_by — ENUM('seller', 'platform') — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME