order
Tables (8)
claims
- id — BINARY(16) — Primary key — NOT NULL
- claim_id — BINARY(16) — NOT NULL
- order_id — BINARY(16) — NOT NULL
- user_id — BIGINT — NOT NULL
- idempotency_key — VARCHAR(128) — NOT NULL
- status — VARCHAR(40) — NOT NULL
- cancellation_policy_version — INT
- check_in_date — DATE
- coupon_discount_amount — BIGINT
- point_used_amount — BIGINT
- paid_amount — BIGINT
- penalty_rate — DECIMAL(10, 6)
- cash_refund_amount — BIGINT
- point_restore_amount — BIGINT
- payment_refund_status — VARCHAR(40) — NOT NULL
- point_restore_status — VARCHAR(40) — NOT NULL
- order_cancel_status — VARCHAR(40) — NOT NULL
- refund_command_id — BINARY(16)
- point_restore_command_id — BINARY(16)
- cancel_order_command_id — BINARY(16)
- retry_count — INT — NOT NULL
- next_retry_at — DATETIME(6)
- last_error — VARCHAR(1000)
- refunded_at — DATETIME(6)
- point_restored_at — DATETIME(6)
- completed_at — DATETIME(6)
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon_campaign
- id — BINARY(16) — Primary key — NOT NULL
- product_id — BIGINT — NOT NULL
- advertiser_id — BIGINT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- discount_type — VARCHAR(30) — NOT NULL
- discount_value — BIGINT — NOT NULL
- discount_rate — DECIMAL(10, 6)
- maximum_discount_amount — BIGINT
- daily_quantity — INT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- status — VARCHAR(30) — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon_daily_inventory
- id — BINARY(16) — Primary key — NOT NULL
- campaign_id — BINARY(16) — NOT NULL
- stock_date — DATE — NOT NULL
- initial_quantity — INT — NOT NULL
- reserved_quantity — INT — NOT NULL
- confirmed_quantity — INT — NOT NULL
- released_quantity — INT — NOT NULL
- expired_quantity — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon_product_policy
- product_id — BIGINT — Primary key — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon_reservation
- id — BINARY(16) — Primary key — NOT NULL
- reservation_id — BINARY(16) — NOT NULL
- reserve_command_id — BINARY(16) — NOT NULL
- confirm_command_id — BINARY(16)
- release_command_id — BINARY(16)
- saga_id — BINARY(16) — NOT NULL
- order_id — BINARY(16) — NOT NULL
- user_id — BIGINT — NOT NULL
- campaign_id — BINARY(16) — NOT NULL
- stock_date — DATE — NOT NULL
- discount_amount — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- reserved_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- confirmed_at — DATETIME(6)
- released_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
idempotency_request
- id — BINARY(16) — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- idempotency_key — VARCHAR(128) — NOT NULL
- request_hash — CHAR(64) — NOT NULL
- status — VARCHAR(40) — NOT NULL
- resource_id — BINARY(16)
- response_status — INT
- response_body — JSON
- created_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
inbox_event
- id — BIGINT — Primary key — NOT NULL
- event_id — BINARY(16) — NOT NULL
- consumer_name — VARCHAR(100) — NOT NULL
- message_type — VARCHAR(100) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- received_at — DATETIME(6) — NOT NULL
- processed_at — DATETIME(6)
- error_message — VARCHAR(1000)
outbox_event
- id — BIGINT — Primary key — NOT NULL
- event_id — BINARY(16) — NOT NULL
- aggregate_type — VARCHAR(60) — NOT NULL
- aggregate_id — BINARY(16) — NOT NULL
- event_type — VARCHAR(100) — NOT NULL
- partition_key — VARCHAR(128) — NOT NULL
- payload — JSON — NOT NULL
- headers — JSON
- status — VARCHAR(30) — NOT NULL
- retry_count — INT — NOT NULL
- available_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- published_at — DATETIME(6)
- last_error — VARCHAR(1000)