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