POD 커머스 플랫폼

테이블 (38)

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
  • recipient_phone — VARCHAR(30) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL
  • address_line1 — VARCHAR(255) — NOT NULL
  • address_line2 — VARCHAR(255)
  • default_flag — TINYINT — NOT NULL
  • address_status — VARCHAR(20) — NOT NULL — ACTIVE,DELETED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

admin_cancel_reason

  • admin_cancel_reason_id — BIGINT — 기본 키 — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • reason_name — VARCHAR(150) — NOT NULL
  • reason_category — VARCHAR(40) — NOT NULL — BASE_PRODUCT_UNAVAILABLE,MACHINE_FAILURE,ARTWORK_ISSUE,POLICY,OTHER
  • active_flag — TINYINT — NOT NULL
  • created_by_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

app_user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • account_status — VARCHAR(30) — NOT NULL — ACTIVE,SUSPENDED,WITHDRAWN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

artwork

  • artwork_id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • artwork_name — VARCHAR(150) — NOT NULL
  • original_image_url — VARCHAR(1000) — NOT NULL
  • preview_image_url — VARCHAR(1000)
  • artwork_status — VARCHAR(30) — NOT NULL — DRAFT,ACTIVE,BLOCKED,DELETED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

artwork_sales_metric

  • artwork_sales_metric_id — BIGINT — 기본 키 — NOT NULL
  • artwork_id — BIGINT — 외래 키 → artwork.artwork_id — NOT NULL
  • paid_order_count — BIGINT — NOT NULL
  • sold_unit_count — BIGINT — NOT NULL
  • gross_sales_amount — DECIMAL(16,2) — NOT NULL
  • refund_count — BIGINT — NOT NULL
  • sales_score — DECIMAL(10,4) — NOT NULL
  • calculated_at — DATETIME — NOT NULL

artwork_theme

  • theme_id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • theme_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

artwork_theme_map

  • artwork_theme_map_id — BIGINT — 기본 키 — NOT NULL
  • artwork_id — BIGINT — 외래 키 → artwork.artwork_id — NOT NULL
  • theme_id — BIGINT — 외래 키 → artwork_theme.theme_id — 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_product_code — VARCHAR(80) — NOT NULL
  • description — TEXT
  • production_status — VARCHAR(30) — NOT NULL — AVAILABLE,PAUSED,DISCONTINUED
  • base_price — DECIMAL(14, 2) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — 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
  • category_code — VARCHAR(50) — NOT NULL
  • display_order — INT — NOT NULL
  • active_flag — TINYINT — NOT NULL
  • created_at — DATETIME — 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 — SIZE,COLOR,MATERIAL,CUSTOM
  • required_flag — TINYINT — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

base_product_variant

  • variant_id — BIGINT — 기본 키 — NOT NULL
  • base_product_id — BIGINT — 외래 키 → base_product.base_product_id — NOT NULL
  • sku — VARCHAR(100) — NOT NULL
  • additional_price — DECIMAL(14, 2) — NOT NULL
  • availability_status — VARCHAR(30) — NOT NULL — AVAILABLE,OUT_OF_BASE_PRODUCT,MACHINE_DOWN,DISABLED
  • lead_time_days — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cancellation

  • cancellation_id — BIGINT — 기본 키 — NOT NULL
  • order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NOT NULL
  • admin_cancel_reason_id — BIGINT — 외래 키 → admin_cancel_reason.admin_cancel_reason_id
  • cancelled_by_user_id — BIGINT — 외래 키 → app_user.user_id
  • requester_type — VARCHAR(20) — NOT NULL — BUYER,ADMIN,SYSTEM
  • cancellation_status — VARCHAR(30) — NOT NULL — REQUESTED,APPROVED,REJECTED,COMPLETED
  • reason_detail — VARCHAR(1000)
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL

carrier

  • carrier_id — BIGINT — 기본 키 — NOT NULL
  • carrier_name — VARCHAR(100) — NOT NULL
  • carrier_code — VARCHAR(50) — NOT NULL
  • carrier_type — VARCHAR(30) — NOT NULL — PARCEL,FREIGHT,DIRECT_PICKUP
  • tracking_url_template — VARCHAR(1000)
  • active_flag — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

coupon

  • coupon_id — BIGINT — 기본 키 — NOT NULL
  • coupon_name — VARCHAR(150) — NOT NULL
  • coupon_code — VARCHAR(80) — NOT NULL
  • coupon_target_type — VARCHAR(20) — NOT NULL — ORDER,ITEM
  • discount_type — VARCHAR(20) — NOT NULL — FIXED,PERCENT
  • discount_value — DECIMAL(14, 2) — NOT NULL
  • max_discount_amount — DECIMAL(14, 2)
  • minimum_order_amount — DECIMAL(14, 2)
  • scope_type — VARCHAR(20) — NOT NULL — ALL,BASE_PRODUCT,PRODUCT
  • valid_from — DATETIME — NOT NULL
  • valid_until — DATETIME — NOT NULL
  • coupon_status — VARCHAR(20) — NOT NULL — DRAFT,ACTIVE,PAUSED,EXPIRED
  • created_by_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • created_at — DATETIME — 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
  • issue_status — VARCHAR(20) — NOT NULL — ISSUED,USED,EXPIRED,REVOKED
  • issued_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used_at — DATETIME
  • revoked_at — DATETIME

coupon_scope_base_product

  • coupon_scope_base_product_id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
  • base_product_id — BIGINT — 외래 키 → base_product.base_product_id — NOT NULL

coupon_scope_product

  • coupon_scope_product_id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL

coupon_usage

  • coupon_usage_id — BIGINT — 기본 키 — NOT NULL
  • coupon_issue_id — BIGINT — 외래 키 → coupon_issue.coupon_issue_id — NOT NULL
  • order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
  • order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NULL for order coupon; required for item coupon
  • applied_amount — DECIMAL(14, 2) — NOT NULL
  • usage_status — VARCHAR(20) — NOT NULL — APPLIED,CANCELLED,RESTORED
  • used_at — DATETIME — NOT NULL
  • restored_at — DATETIME

option_value

  • option_value_id — BIGINT — 기본 키 — NOT NULL
  • option_id — BIGINT — 외래 키 → base_product_option.option_id — NOT NULL
  • value_name — VARCHAR(100) — NOT NULL
  • value_code — VARCHAR(50) — NOT NULL
  • price_delta — DECIMAL(14,2) — NOT NULL
  • display_order — INT — NOT NULL
  • active_flag — TINYINT — NOT NULL

order_delivery_address

  • order_delivery_address_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
  • source_address_id — BIGINT — 외래 키 → address.address_id
  • recipient_name — VARCHAR(100) — NOT NULL
  • recipient_phone — VARCHAR(30) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL
  • address_line1 — VARCHAR(255) — NOT NULL
  • address_line2 — VARCHAR(255)
  • delivery_request — VARCHAR(255)
  • locked_at — DATETIME — Set when shipment starts; no address changes after this time
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

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
  • variant_id — BIGINT — 외래 키 → base_product_variant.variant_id — NOT NULL
  • quantity — INT — NOT NULL
  • product_name_snapshot — VARCHAR(200) — NOT NULL
  • option_snapshot — VARCHAR(1000) — NOT NULL
  • unit_price — DECIMAL(14, 2) — NOT NULL
  • discount_amount — DECIMAL(14, 2) — NOT NULL
  • final_amount — DECIMAL(14, 2) — NOT NULL
  • item_status — VARCHAR(40) — NOT NULL — PAYMENT_PENDING,PAID,PRODUCTION_WAITING,PRODUCING,PRODUCTION_COMPLETED,SHIPPED,DELIVERED,CANCELLED,REFUNDED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payment

  • payment_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → purchase_order.order_id — NOT NULL
  • attempt_no — INT — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL — CARD,BANK_TRANSFER,EASY_PAY,VIRTUAL_ACCOUNT
  • payment_status — VARCHAR(30) — NOT NULL — READY,AUTHORIZED,PAID,FAILED,CANCELLED,PARTIALLY_REFUNDED,REFUNDED
  • requested_amount — DECIMAL(14, 2) — NOT NULL
  • approved_amount — DECIMAL(14, 2)
  • provider_name — VARCHAR(80)
  • provider_transaction_id — VARCHAR(150)
  • paid_at — DATETIME
  • failed_at — DATETIME
  • created_at — DATETIME — NOT NULL

point_balance

  • point_balance_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • available_points — BIGINT — NOT NULL
  • pending_points — BIGINT — NOT NULL
  • version_no — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

point_ledger

  • point_ledger_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • order_id — BIGINT — 외래 키 → purchase_order.order_id
  • related_ledger_id — BIGINT — 외래 키 → point_ledger.point_ledger_id
  • entry_type — VARCHAR(30) — NOT NULL — EARN,USE,CANCEL_REVERSAL,REFUND_REVERSAL,EXPIRE,ADMIN_ADJUST
  • point_amount — BIGINT — NOT NULL — Positive for credit; negative for debit
  • balance_after — BIGINT — NOT NULL
  • description — VARCHAR(500)
  • occurred_at — DATETIME — NOT NULL
  • created_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
  • product_description — TEXT
  • sale_price — DECIMAL(14, 2) — NOT NULL
  • product_status — VARCHAR(30) — NOT NULL — DRAFT,ACTIVE,HIDDEN,DELETE_SCHEDULED,DELETED
  • thumbnail_url — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_curation

  • product_curation_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • curator_user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • curation_area — VARCHAR(50) — NOT NULL — MAIN,HERO,TRENDING,THEME
  • display_order — INT — NOT NULL
  • starts_at — DATETIME — NOT NULL
  • ends_at — DATETIME
  • curation_status — VARCHAR(20) — NOT NULL — SCHEDULED,ACTIVE,ENDED
  • created_at — DATETIME — NOT NULL

product_lifecycle

  • product_lifecycle_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • lifecycle_status — VARCHAR(30) — NOT NULL — ACTIVE,STALE_NOTIFIED,DELETE_SCHEDULED,DELETED
  • last_sold_at — DATETIME
  • stale_notified_at — DATETIME
  • delete_scheduled_at — DATETIME
  • deleted_at — DATETIME
  • updated_at — DATETIME — NOT NULL

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 — MANUAL,AUTO
  • confidence_score — DECIMAL(5, 4)
  • created_by_user_id — BIGINT — 외래 키 → app_user.user_id
  • created_at — DATETIME — 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 — WAITING,QUEUED,PRODUCING,COMPLETED,FAILED,CANCELLED
  • failure_code — VARCHAR(50) — BASE_PRODUCT_UNAVAILABLE,MACHINE_FAILURE,ARTWORK_ERROR,OTHER
  • failure_detail — VARCHAR(500)
  • requested_at — DATETIME — Created only after payment completion
  • started_at — DATETIME
  • completed_at — DATETIME
  • failed_at — DATETIME
  • updated_at — DATETIME — NOT NULL

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 — PENDING_PAYMENT,PAID,IN_PRODUCTION,READY_TO_SHIP,SHIPPED,DELIVERED,CANCELLED,PARTIALLY_CANCELLED,REFUNDED,PARTIALLY_REF…
  • fulfillment_method — VARCHAR(20) — NOT NULL — DELIVERY,DIRECT_PICKUP
  • subtotal_amount — DECIMAL(14, 2) — NOT NULL
  • discount_amount — DECIMAL(14, 2) — NOT NULL
  • point_used_amount — DECIMAL(14, 2) — NOT NULL
  • shipping_fee — DECIMAL(14, 2) — NOT NULL
  • total_amount — DECIMAL(14, 2) — NOT NULL
  • ordered_at — DATETIME — NOT NULL
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_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_id — BIGINT — 외래 키 → refund_reason.refund_reason_id — NOT NULL
  • refund_status — VARCHAR(30) — NOT NULL — REQUESTED,REVIEWING,APPROVED,REJECTED,RETURNING,COMPLETED
  • requested_quantity — INT — NOT NULL
  • requested_amount — DECIMAL(14, 2) — NOT NULL
  • approved_amount — DECIMAL(14, 2)
  • reason_detail — VARCHAR(1000)
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL

refund_feedback

  • refund_feedback_id — BIGINT — 기본 키 — NOT NULL
  • refund_id — BIGINT — 외래 키 → refund.refund_id — NOT NULL
  • dissatisfaction_area — VARCHAR(40) — NOT NULL — BASE_PRODUCT,PRINT_QUALITY,DESIGN_MATCH,PACKAGING,DELIVERY,CS,OTHER
  • satisfaction_score — INT
  • feedback_text — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL

refund_reason

  • refund_reason_id — BIGINT — 기본 키 — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • reason_name — VARCHAR(150) — NOT NULL
  • reason_category — VARCHAR(40) — NOT NULL — QUALITY,PRINT,DELIVERY,DAMAGE,SIZE_COLOR,CHANGE_OF_MIND,OTHER
  • seller_fault_flag — TINYINT — NOT NULL
  • active_flag — TINYINT — 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
  • order_delivery_address_id — BIGINT — 외래 키 → order_delivery_address.order_delivery_address_id
  • shipment_status — VARCHAR(30) — NOT NULL — PENDING,READY_TO_SHIP,SHIPPED,IN_TRANSIT,DELIVERED,READY_FOR_PICKUP,PICKED_UP,RETURNED
  • tracking_number — VARCHAR(150)
  • pickup_code — VARCHAR(100)
  • shipped_at — DATETIME
  • delivered_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

shipment_item

  • shipment_item_id — BIGINT — 기본 키 — NOT NULL
  • shipment_id — BIGINT — 외래 키 → shipment.shipment_id — NOT NULL
  • order_item_id — BIGINT — 외래 키 → order_item.order_item_id — NOT NULL
  • shipped_quantity — INT — NOT NULL

tag

  • tag_id — BIGINT — 기본 키 — NOT NULL
  • tag_name — VARCHAR(80) — NOT NULL
  • normalized_name — VARCHAR(80) — NOT NULL
  • tag_status — VARCHAR(20) — NOT NULL — ACTIVE,BLOCKED
  • created_at — DATETIME — NOT NULL

user_address

  • address_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • address_name — VARCHAR(80) — NOT NULL
  • recipient_name — VARCHAR(100) — NOT NULL
  • recipient_phone — VARCHAR(30) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL
  • address_line1 — VARCHAR(255) — NOT NULL
  • address_line2 — VARCHAR(255)
  • default_flag — TINYINT — NOT NULL
  • address_status — VARCHAR(20) — NOT NULL — ACTIVE,DELETED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

variant_option_value

  • variant_option_value_id — BIGINT — 기본 키 — NOT NULL
  • variant_id — BIGINT — 외래 키 → base_product_variant.variant_id — NOT NULL
  • option_value_id — BIGINT — 외래 키 → option_value.option_value_id — NOT NULL