선착순 구매 프로젝트 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