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