23131

Tables (9)

channel_type

  • id — BIGINT
  • code — VARCHAR(32) — NOT NULL
  • description — VARCHAR(255)

message

  • id — BIGINT
  • to_e164 — VARCHAR(20) — NOT NULL
  • country — CHAR(2)
  • channel_code — ENUM('SMS','KAKAO','RCS') — NOT NULL
  • vendor_code — VARCHAR(32) — NOT NULL
  • sender_profile_id — VARCHAR(128)
  • body_resolved — TEXT — NOT NULL
  • rich_json_resolved — JSON
  • media_urls_json — JSON
  • provider_payload_json — JSON — NOT NULL
  • scheduled_at — DATETIME(3) — NOT NULL
  • status — ENUM('QUEUED','PROCESSING','SENT','FAILED','CANCELED','EXPIRED') — NOT NULL
  • retry_count — INT — NOT NULL
  • max_retries — INT — NOT NULL
  • next_retry_at — DATETIME(3)
  • ttl_at — DATETIME(3)
  • sent_at — DATETIME(3)
  • provider_message_id — VARCHAR(128)
  • error_code — VARCHAR(64)
  • error_message — VARCHAR(255)
  • claim_token — BINARY(16)
  • claimed_by — VARCHAR(64)
  • claimed_at — DATETIME(3)
  • group_code — VARCHAR(64)
  • step_order — INT
  • service_code — VARCHAR(64)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

message_group

  • id — BIGINT
  • code — VARCHAR(64) — NOT NULL
  • default_name — VARCHAR(128) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

message_group_service_name

  • group_id — BIGINT — Primary key — NOT NULL
  • service_type_id — BIGINT — Primary key — NOT NULL
  • display_name — VARCHAR(128) — NOT NULL

message_step

  • id — BIGINT
  • group_id — BIGINT — NOT NULL
  • step_order — INT — NOT NULL
  • day_offset — INT — NOT NULL
  • send_time_policy — ENUM('ANCHOR_TIME','FIXED_TIME','WINDOW') — NOT NULL
  • fixed_time — TIME
  • window_start_min — INT
  • window_end_min — INT
  • channel_type_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • template_id — BIGINT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

message_template

  • id — BIGINT
  • channel_type_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • external_template_id — VARCHAR(128)
  • name — VARCHAR(128) — NOT NULL
  • body — TEXT — NOT NULL
  • buttons_json — JSON
  • variables_schema — JSON
  • status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL

service_send_rule

  • id — BIGINT
  • service_type_id — BIGINT — NOT NULL
  • channel_type_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • template_id — BIGINT — NOT NULL
  • day_offset — INT — NOT NULL
  • send_time_policy — ENUM('ANCHOR_TIME','FIXED_TIME','WINDOW') — NOT NULL
  • fixed_time — TIME
  • window_start_min — INT
  • window_end_min — INT
  • is_active — TINYINT(1) — NOT NULL

service_type

  • id — BIGINT
  • code — VARCHAR(64) — NOT NULL
  • description — VARCHAR(255)

vendor

  • id — BIGINT
  • name — VARCHAR(64) — NOT NULL
  • meta_json — JSON