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