Message Storage Design · uc_meta_messages_v109

FB/INS DMs and comments all land in this table; tenant_id reserves multi-tenant white-label; the unique message_mid constraint dedups idempotently.

Column design

channel — channel (messenger/instagram/page_comment/ig_comment)

page_id — receiving FB Page ID

ig_id — receiving IG professional account ID

sender_psid / sender_name — sending user (Meta-side ID and name)

message_mid — Meta's unique message ID (dedup key)

message_text — message text

message_type — kind (text/comment/image…) + is_comment flag

meta_timestamp — Meta-side millisecond timestamp

tenant_id — tenant (default aifeng, multi-tenant white-label reserve)

data_origin — data source marker

Current table data

3 rows total (seed simulation data, waiting for real data)

Below are simulation rows with data_origin='v109_meta_seed' for page and merge-logic testing; once the real webhook is connected, live data is written automatically (data_origin='meta_webhook_live').

[FB DM] Demo Customer (FB) (PSID_DEMO_001)

[SEED] Halo, berapa harga cetak banner 3x1?

[FB Comment] Demo Customer (FB) (PSID_DEMO_001)

[SEED] Komentar di postingan promo: masih ada diskon?

[IG DM] Demo Customer (IG) (IGSID_DEMO_001)

[SEED] Hi, do you ship to Bali?