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)