SQLite Web: event

phone_number

Primary key. TEXT

display_name

TEXT

provider

TEXT NOT NULL (default 'textbelt')

message_count

INTEGER NOT NULL (default 0)

pending_reply_count

INTEGER NOT NULL (default 0)

last_message_at

TEXT

last_inbound_at

TEXT

last_outbound_at

TEXT

latest_draft_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now'))

updated_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now'))

Cancel

event_store.db — sms_conversations