POD 커머스 간략 ERD
테이블 (25)
app_user
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- user_status — VARCHAR(30) — NOT NULL
artwork
- artwork_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- theme_id — BIGINT — 외래 키 → artwork_theme.theme_id
- artwork_name — VARCHAR(150) — NOT NULL
- image_url — VARCHAR(1000) — NOT NULL
- artwork_status — VARCHAR(30) — NOT NULL
artwork_sales_metric
- metric_id — BIGINT — 기본 키 — NOT NULL
- artwork_id — BIGINT — 외래 키 → artwork.artwork_id — NOT NULL
- sold_count — BIGINT — NOT NULL
- sales_score — DECIMAL(10,4) — NOT NULL
artwork_theme
- theme_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- theme_name — VARCHAR(100) — NOT NULL
base_product
- base_product_id — BIGINT — 기본 키 — NOT NULL
- category_id — BIGINT — 외래 키 → base_product_category.category_id — NOT NULL
- base_product_name — VARCHAR(150) — NOT NULL
- base_price — DECIMAL(14,2) — NOT NULL
- product_status — VARCHAR(30) — NOT NULL
base_product_category
- category_id — BIGINT — 기본 키 — NOT NULL
- parent_category_id — BIGINT — 외래 키 → base_product_category.category_id
- category_name — VARCHAR(100) — NOT NULL
base_product_option
- option_id — BIGINT — 기본 키 — NOT NULL
- base_product_id — BIGINT — 외래 키 → base_product.base_product_id — NOT NULL
- option_name — VARCHAR(80) — NOT NULL
- option_type — VARCHAR(30) — NOT NULL
cancellation
- cancellation_id — BIGINT — 기본 키 — NOT NULL
- order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NOT NULL
- cancelled_by_user_id — BIGINT — 외래 키 → app_user.user_id
- cancel_reason — VARCHAR(500) — NOT NULL
- cancellation_status — VARCHAR(30) — NOT NULL
carrier
- carrier_id — BIGINT — 기본 키 — NOT NULL
- carrier_name — VARCHAR(100) — NOT NULL
- carrier_type — VARCHAR(30) — NOT NULL
coupon
- coupon_id — BIGINT — 기본 키 — NOT NULL
- coupon_name — VARCHAR(150) — NOT NULL
- coupon_type — VARCHAR(20) — NOT NULL
- discount_value — DECIMAL(14,2) — NOT NULL
- coupon_status — VARCHAR(20) — NOT NULL
coupon_issue
- coupon_issue_id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- used_order_id — BIGINT — 외래 키 → purchase_order.order_id
- issue_status — VARCHAR(20) — NOT NULL
- issued_at — DATETIME — NOT NULL
- used_at — DATETIME
coupon_scope
- coupon_scope_id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
- base_product_id — BIGINT — 외래 키 → base_product.base_product_id
- product_id — BIGINT — 외래 키 → product.product_id
- scope_type — VARCHAR(20) — NOT NULL
option_value
- option_value_id — BIGINT — 기본 키 — NOT NULL
- option_id — BIGINT — 외래 키 → base_product_option.option_id — NOT NULL
- value_name — VARCHAR(100) — NOT NULL
- price_delta — DECIMAL(14,2) — NOT NULL
order_address
- order_address_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
- source_address_id — BIGINT — 외래 키 → user_address.address_id
- recipient_name — VARCHAR(100) — NOT NULL
- address_snapshot — VARCHAR(500) — NOT NULL
- locked_at — DATETIME
order_item
- order_item_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- quantity — INT — NOT NULL
- selected_option_summary — VARCHAR(500)
- unit_price — DECIMAL(14,2) — NOT NULL
- item_status — VARCHAR(40) — NOT NULL
payment
- payment_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
- payment_status — VARCHAR(30) — NOT NULL
- paid_amount — DECIMAL(14,2) — NOT NULL
- paid_at — DATETIME
point_ledger
- point_ledger_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- order_id — BIGINT — 외래 키 → purchase_order.order_id
- point_type — VARCHAR(30) — NOT NULL
- point_amount — BIGINT — NOT NULL
- occurred_at — DATETIME — NOT NULL
product
- product_id — BIGINT — 기본 키 — NOT NULL
- seller_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- base_product_id — BIGINT — 외래 키 → base_product.base_product_id — NOT NULL
- artwork_id — BIGINT — 외래 키 → artwork.artwork_id — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- sale_price — DECIMAL(14,2) — NOT NULL
- product_status — VARCHAR(30) — NOT NULL
- curated_flag — TINYINT — NOT NULL
- delete_scheduled_at — DATETIME
product_tag
- product_tag_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- tag_id — BIGINT — 외래 키 → tag.tag_id — NOT NULL
- tag_source — VARCHAR(20) — NOT NULL
production
- production_id — BIGINT — 기본 키 — NOT NULL
- order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NOT NULL
- production_status — VARCHAR(30) — NOT NULL
- failure_reason — VARCHAR(500)
- started_at — DATETIME
- completed_at — DATETIME
purchase_order
- order_id — BIGINT — 기본 키 — NOT NULL
- buyer_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- order_number — VARCHAR(50) — NOT NULL
- order_status — VARCHAR(40) — NOT NULL
- total_amount — DECIMAL(14,2) — NOT NULL
- ordered_at — DATETIME — NOT NULL
refund
- refund_id — BIGINT — 기본 키 — NOT NULL
- order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NOT NULL
- requester_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- refund_reason — VARCHAR(500) — NOT NULL
- feedback_text — VARCHAR(1000)
- refund_status — VARCHAR(30) — NOT NULL
- refund_amount — DECIMAL(14,2) — NOT NULL
shipment
- shipment_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
- carrier_id — BIGINT — 외래 키 → carrier.carrier_id — NOT NULL
- tracking_number — VARCHAR(150)
- shipment_status — VARCHAR(30) — NOT NULL
- shipped_at — DATETIME
- delivered_at — DATETIME
tag
- tag_id — BIGINT — 기본 키 — NOT NULL
- tag_name — VARCHAR(80) — NOT NULL
user_address
- address_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- address_name — VARCHAR(80) — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- postal_code — VARCHAR(20) — NOT NULL
- address_text — VARCHAR(500) — NOT NULL