Print view - phpMyAdmin 4.5.1

agents

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
name	longtext	Yes	NULL
system_prompt	text	Yes	NULL
tone	varchar(191)	Yes	ramah
ai_enabled	tinyint(1)	No
auto_read	tinyint(1)	No	0
ai_reply_delay_min	bigint(20)	No	4
ai_reply_delay_max	bigint(20)	No	8
device_j_id	longtext	Yes	NULL
number	longtext	Yes	NULL
greeting_enabled	tinyint(1)	No	0
greeting_message	text	Yes	NULL
business_hours_enabled	tinyint(1)	No	0
business_start	varchar(5)	Yes	08:00
business_end	varchar(5)	Yes	21:00
away_message	text	Yes	NULL
conversation_summary	text	Yes	NULL
last_summary_at	datetime(3)	Yes	NULL
spreadsheet_url	text	Yes	NULL
spreadsheet_sheet_name	varchar(80)	Yes	Leads
sheet_sync_enabled	tinyint(1)	No	0
origin_city_id	bigint(20)	Yes	0
origin_city_name	varchar(100)	Yes	NULL
default_weight_gram	bigint(20)	Yes	1000
enabled_couriers	varchar(100)	Yes	jne,jnt,sicepat
api_key	varchar(80)	Yes	NULL
webhook_url	text	Yes	NULL
webhook_secret	varchar(80)	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_agents_tenant_id	BTREE	No	No	tenant_id	A	No
idx_agents_api_key	BTREE	No	No	api_key	A	Yes

ai_form_sessions

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
form_id	bigint(20)	No
step_index	bigint(20)	No	0
data_json	text	Yes	NULL
status	varchar(24)	No	collecting
expires_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_ai_form_agent_sender	BTREE	Yes	No	agent_id	A	No
idx_ai_form_agent_sender	BTREE	Yes	No	sender	A	No
idx_ai_form_sessions_tenant_id	BTREE	No	No	tenant_id	A	No
idx_ai_form_sessions_form_id	BTREE	No	No	form_id	A	No
idx_ai_form_sessions_status	BTREE	No	No	status	A	No
idx_ai_form_sessions_expires_at	BTREE	No	No	expires_at	A	Yes

ai_form_submissions

Column	Type	Null	Default	Links to
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
form_id	bigint(20)	No		ai_forms -> id
sender	varchar(32)	No
code	varchar(32)	No
status	varchar(24)	No	submitted
data_json	text	Yes	NULL
summary	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_ai_form_submissions_code	BTREE	Yes	No	code	A	No
idx_ai_form_submissions_tenant_id	BTREE	No	No	tenant_id	A	No
idx_ai_form_submissions_agent_id	BTREE	No	No	agent_id	A	No
idx_ai_form_submissions_form_id	BTREE	No	No	form_id	A	No
idx_ai_form_submissions_sender	BTREE	No	No	sender	A	No
idx_ai_form_submissions_status	BTREE	No	No	status	A	No

ai_forms

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
name	varchar(160)	No
goal	text	Yes	NULL
intent_hints_json	text	Yes	NULL
steps_json	text	Yes	NULL
enabled	tinyint(1)	No	1
handoff	tinyint(1)	No	1
success_message	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_ai_forms_tenant_id	BTREE	No	No	tenant_id	A	No
idx_ai_forms_agent_id	BTREE	No	No	agent_id	A	No

ai_turns

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	Yes	NULL
user_message	text	Yes	NULL
ai_reply	text	Yes	NULL
model	varchar(80)	Yes	NULL
prompt_version	varchar(40)	Yes	legacy
knowledge_used_count	bigint(20)	Yes	NULL
knowledge_ids	varchar(255)	Yes	NULL
top_similarity	double	Yes	NULL
answer_overlap	double	Yes	NULL
product_used_count	bigint(20)	Yes	NULL
product_ids	varchar(255)	Yes	NULL
retrieval_mode	varchar(24)	Yes	NULL
retrieval_query	text	Yes	NULL
grounding_retried	tinyint(1)	No	0
grounding_fallback	tinyint(1)	No	0
used_shipping_tool	tinyint(1)	No	0
escalated	tinyint(1)	No	0
error	text	Yes	NULL
latency_ms	bigint(20)	Yes	NULL
created_at	datetime(3)	Yes	NULL
response_policy	varchar(24)	Yes	NULL
response_retried	tinyint(1)	No	0
response_chars	bigint(20)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_ai_turns_agent_id	BTREE	No	No	agent_id	A	No
idx_ai_turns_sender	BTREE	No	No	sender	A	Yes
idx_ai_turns_prompt_version	BTREE	No	No	prompt_version	A	Yes
idx_ai_turns_retrieval_mode	BTREE	No	No	retrieval_mode	A	Yes
idx_ai_turns_grounding_fallback	BTREE	No	No	grounding_fallback	A	No
idx_ai_turns_used_shipping_tool	BTREE	No	No	used_shipping_tool	A	No
idx_ai_turns_escalated	BTREE	No	No	escalated	A	No
idx_ai_turns_created_at	BTREE	No	No	created_at	A	Yes
idx_ai_turns_response_policy	BTREE	No	No	response_policy	A	Yes
idx_ai_turns_response_retried	BTREE	No	No	response_retried	A	No

app_settings

Column	Type	Null	Default	Links to	Comments	MIME
key (Primary)	varchar(64)	No
value	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	key	0	A	No

auto_replies

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
keywords	text	Yes	NULL
match_type	varchar(16)	Yes	contains
reply	text	Yes	NULL
enabled	tinyint(1)	No	1
sort_order	bigint(20)	No	0
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_auto_replies_agent_id	BTREE	No	No	agent_id	0	A	No

broadcast_recipients

Column	Type	Null	Default
id (Primary)	bigint(20)	No
broadcast_id	bigint(20)	No
number	varchar(64)	Yes	NULL
name	longtext	Yes	NULL
agent_id	bigint(20)	Yes	NULL
status	varchar(16)	Yes	pending
error	longtext	Yes	NULL
sent_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_broadcast_recipients_broadcast_id	BTREE	No	No	broadcast_id	A	No
idx_broadcast_recipients_agent_id	BTREE	No	No	agent_id	A	Yes

broadcasts

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
agent_ids	text	Yes	NULL
quarantine_json	text	Yes	NULL
message	text	Yes	NULL
product_id	bigint(20)	Yes	NULL
product_buttons_json	text	Yes	NULL
target_type	varchar(16)	Yes	number
status	varchar(16)	Yes	pending
pause_reason	varchar(48)	Yes	NULL
pause_code	bigint(20)	Yes	NULL
paused_at	datetime(3)	Yes	NULL
consent_category	varchar(32)	Yes	NULL
consent_source	varchar(48)	Yes	NULL
risk_level	varchar(16)	Yes	NULL
risk_reasons	text	Yes	NULL
risk_acknowledged	tinyint(1)	No	0
override_reason	text	Yes	NULL
override_by	bigint(20)	Yes	NULL
override_at	datetime(3)	Yes	NULL
min_delay	bigint(20)	Yes	NULL
max_delay	bigint(20)	Yes	NULL
rest_every	bigint(20)	Yes	NULL
rest_duration	bigint(20)	Yes	NULL
media_type	varchar(16)	Yes	NULL
media_path	longtext	Yes	NULL
file_name	longtext	Yes	NULL
mimetype	longtext	Yes	NULL
contact_name	varchar(120)	Yes	NULL
contact_number	varchar(32)	Yes	NULL
total	bigint(20)	Yes	NULL
sent	bigint(20)	Yes	NULL
failed	bigint(20)	Yes	NULL
skipped	bigint(20)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_broadcasts_tenant_id	BTREE	No	No	tenant_id	A	No
idx_broadcasts_agent_id	BTREE	No	No	agent_id	A	No
idx_broadcasts_product_id	BTREE	No	No	product_id	A	Yes
idx_broadcasts_target_type	BTREE	No	No	target_type	A	Yes
idx_broadcasts_status	BTREE	No	No	status	A	Yes
idx_broadcasts_consent_category	BTREE	No	No	consent_category	A	Yes
idx_broadcasts_risk_level	BTREE	No	No	risk_level	A	Yes
idx_broadcasts_override_by	BTREE	No	No	override_by	A	Yes

chat_histories

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	Yes	NULL
sender	varchar(32)	Yes	NULL
message	longtext	Yes	NULL
reply	longtext	Yes	NULL
from_human	tinyint(1)	No	0
media_type	varchar(16)	Yes	NULL
media_path	longtext	Yes	NULL
file_name	longtext	Yes	NULL
mimetype	longtext	Yes	NULL
image_analysis	text	Yes	NULL
image_analysis_status	varchar(24)	Yes	NULL
image_analysis_model	varchar(120)	Yes	NULL
image_analysis_confidence	double	Yes	NULL
image_analysis_answer	text	Yes	NULL
image_analysis_product_id	bigint(20)	Yes	NULL
image_analysis_needs_human	tinyint(1)	No	0
wa_msg_id	varchar(64)	Yes	NULL
reply_to	longtext	Yes	NULL
reply_text	varchar(200)	Yes	NULL
revoked	tinyint(1)	Yes	0
delivery_status	varchar(24)	Yes	sent
send_error	text	Yes	NULL
retry_count	bigint(20)	No	0
next_retry_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL
media_metadata	blob	Yes	NULL
media_fetch_status	varchar(24)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_chat_histories_agent_id	BTREE	No	No	agent_id	A	Yes
idx_chat_histories_sender	BTREE	No	No	sender	A	Yes
idx_chat_histories_image_analysis_status	BTREE	No	No	image_analysis_status	A	Yes
idx_chat_histories_image_analysis_product_id	BTREE	No	No	image_analysis_product_id	A	Yes
idx_chat_histories_image_analysis_needs_human	BTREE	No	No	image_analysis_needs_human	A	No
idx_chat_histories_delivery_status	BTREE	No	No	delivery_status	A	Yes
idx_chat_histories_next_retry_at	BTREE	No	No	next_retry_at	A	Yes
idx_chat_agent_wa_msg	BTREE	No	No	agent_id	A	Yes
idx_chat_agent_wa_msg	BTREE	No	No	wa_msg_id	A	Yes
idx_chat_agent_sender_time	BTREE	No	No	agent_id	A	Yes
				sender	A	Yes
				created_at	A	Yes

chat_labels

Column	Type	Null
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
label_id	varchar(64)	No
sender	varchar(32)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_chatlabel	BTREE	Yes	No	agent_id	A	No
				label_id	A	No
				sender	A	No

closing_forms

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
schema_json	text	Yes	NULL
enabled	tinyint(1)	No	1
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_closing_forms_agent_id	BTREE	Yes	No	agent_id	0	A	No

closing_records

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	Yes	NULL
status	varchar(20)	Yes	detected
confidence	double	Yes	NULL
data_json	text	Yes	NULL
raw_summary	text	Yes	NULL
sheet_error	longtext	Yes	NULL
idempotency_key	varchar(128)	Yes	NULL
sheet_row	bigint(20)	Yes	0
exported_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_closing_records_idempotency_key	BTREE	Yes	No	idempotency_key	A	Yes
idx_closing_records_agent_id	BTREE	No	No	agent_id	A	No
idx_closing_records_sender	BTREE	No	No	sender	A	Yes

contact_consents

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
number	varchar(32)	No
category	varchar(32)	No
source	varchar(48)	No
note	text	Yes	NULL
granted_at	datetime(3)	No
revoked_at	datetime(3)	Yes	NULL
recorded_by	bigint(20)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_contact_consent	BTREE	Yes	No	agent_id	A	No
				number	A	No
				category	A	No
idx_contact_consents_granted_at	BTREE	No	No	granted_at	A	No
idx_contact_consents_revoked_at	BTREE	No	No	revoked_at	A	Yes
idx_contact_consents_recorded_by	BTREE	No	No	recorded_by	A	Yes

contacts

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
number	varchar(32)	No
name	longtext	Yes	NULL
notes	text	Yes	NULL
tags	text	Yes	NULL
lead_stage	varchar(24)	No	new
lead_stage_source	varchar(24)	No	system
lead_stage_reason	varchar(500)	Yes	NULL
lead_stage_confidence	double	No	0
lead_stage_locked	tinyint(1)	No	0
lead_stage_analyzed_chat_id	bigint(20)	No	0
lead_stage_updated_at	datetime(3)	Yes	NULL
manual_pause_until	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_contact_agent_number	BTREE	Yes	No	agent_id	A	No
idx_contact_agent_number	BTREE	Yes	No	number	A	No
idx_contacts_lead_stage	BTREE	No	No	lead_stage	A	No
idx_contacts_lead_stage_source	BTREE	No	No	lead_stage_source	A	No
idx_contacts_lead_stage_locked	BTREE	No	No	lead_stage_locked	A	No
idx_contacts_lead_stage_analyzed_chat_id	BTREE	No	No	lead_stage_analyzed_chat_id	A	No
idx_contacts_manual_pause_until	BTREE	No	No	manual_pause_until	A	Yes

conversation_memories

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
summary	text	Yes	NULL
last_chat_id	bigint(20)	No	0
last_summary_at	datetime(3)	Yes	NULL
brief_json	text	Yes	NULL
brief_chat_id	bigint(20)	No	0
brief_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_convmem_agent_sender	BTREE	Yes	No	agent_id	A	No
idx_convmem_agent_sender	BTREE	Yes	No	sender	A	No
idx_conversation_memories_last_chat_id	BTREE	No	No	last_chat_id	A	No

crawl_jobs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
root_url	text	Yes	NULL
domain	varchar(255)	Yes	NULL
status	varchar(16)	Yes	pending
pages_found	bigint(20)	No	0
error	text	Yes	NULL
persona_updated	tinyint(1)	No	0
persona_error	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
finished_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_crawl_jobs_agent_id	BTREE	No	No	agent_id	A	No
idx_crawl_jobs_status	BTREE	No	No	status	A	Yes

crawl_pages

Column	Type	Null	Default
id (Primary)	bigint(20)	No
job_id	bigint(20)	No
agent_id	bigint(20)	No
url	text	Yes	NULL
title	text	Yes	NULL
status	varchar(16)	Yes	found
char_count	bigint(20)	No	0
content	longtext	Yes	NULL
error	text	Yes	NULL
recommended	tinyint(1)	No	0
recommend_score	bigint(20)	No	0
recommend_tier	varchar(16)	Yes
recommend_reason	varchar(400)	Yes	NULL
trained_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_crawl_pages_job_id	BTREE	No	No	job_id	A	No
idx_crawl_pages_agent_id	BTREE	No	No	agent_id	A	No
idx_crawl_pages_status	BTREE	No	No	status	A	Yes

cs_activity_logs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
user_id	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	Yes	NULL
action	varchar(32)	No
detail	varchar(500)	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_cs_activity_logs_tenant_id	BTREE	No	No	tenant_id	A	No
idx_cs_activity_logs_user_id	BTREE	No	No	user_id	A	No
idx_cs_activity_logs_agent_id	BTREE	No	No	agent_id	A	No
idx_cs_activity_logs_sender	BTREE	No	No	sender	A	Yes
idx_cs_activity_logs_action	BTREE	No	No	action	A	No
idx_cs_activity_logs_created_at	BTREE	No	No	created_at	A	Yes

flow_sessions

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
node_id	varchar(64)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_flow_session_ac	BTREE	Yes	No	agent_id	A	No
idx_flow_session_ac	BTREE	Yes	No	sender	A	No

flows

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
enabled	tinyint(1)	No	0
trigger	varchar(64)	Yes	NULL
match_type	varchar(16)	Yes	exact
display_mode	varchar(16)	No	auto
structure	longtext	Yes	NULL
delay_min	bigint(20)	No	2
delay_max	bigint(20)	No	4
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_flows_agent_id	BTREE	Yes	No	agent_id	0	A	No

follow_up_enrollments

Column	Type	Null	Default
id (Primary)	bigint(20)	No
follow_up_id	bigint(20)	No
number	varchar(32)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
name	longtext	Yes	NULL
enrolled_at	datetime(3)	Yes	NULL
next_step	bigint(20)	No	0
status	varchar(16)	Yes	active
stopped_reason	varchar(32)	Yes	NULL
last_sent_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_enroll	BTREE	Yes	No	follow_up_id	A	No
idx_enroll	BTREE	Yes	No	number	A	No
idx_follow_up_enrollments_tenant_id	BTREE	No	No	tenant_id	A	No
idx_follow_up_enrollments_agent_id	BTREE	No	No	agent_id	A	No
idx_follow_up_enrollments_status	BTREE	No	No	status	A	Yes

follow_up_steps

Column	Type	Null	Default
id (Primary)	bigint(20)	No
follow_up_id	bigint(20)	No
step_order	bigint(20)	No	0
delay_hours	bigint(20)	No	0
message	text	Yes	NULL
ai_generated	tinyint(1)	No	0
ai_instruction	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_follow_up_steps_follow_up_id	BTREE	No	No	follow_up_id	0	A	No

follow_ups

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
name	varchar(160)	No
enabled	tinyint(1)	No	1
stop_on_reply	tinyint(1)	No	1
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_follow_ups_tenant_id	BTREE	No	No	tenant_id	A	No
idx_follow_ups_agent_id	BTREE	No	No	agent_id	A	No

group_guard_configs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	Yes	NULL
agent_id	bigint(20)	No
group_jid	varchar(64)	No
group_name	varchar(128)	Yes	NULL
enabled	tinyint(1)	No	0
delete_spam	tinyint(1)	No	1
flag_for_kick	tinyint(1)	No	1
auto_kick	tinyint(1)	No	0
block_links	tinyint(1)	No	1
block_phones	tinyint(1)	No	0
block_words	text	Yes	NULL
flood_count	bigint(20)	No	0
flood_window_sec	bigint(20)	No	10
allow_numbers	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_groupguard_agent_group	BTREE	Yes	No	agent_id	A	No
idx_groupguard_agent_group	BTREE	Yes	No	group_jid	A	No
idx_group_guard_configs_tenant_id	BTREE	No	No	tenant_id	A	Yes
idx_group_guard_configs_agent_id	BTREE	No	No	agent_id	A	No

group_moderation_logs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
group_jid	varchar(64)	Yes	NULL
group_name	varchar(128)	Yes	NULL
sender	varchar(32)	Yes	NULL
sender_jid	varchar(64)	Yes	NULL
sender_name	varchar(128)	Yes	NULL
wa_msg_id	varchar(64)	Yes	NULL
action	varchar(16)	Yes	NULL
reason	varchar(128)	Yes	NULL
excerpt	varchar(280)	Yes	NULL
status	varchar(16)	Yes	done
acted_by	varchar(32)	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_group_moderation_logs_agent_id	BTREE	No	No	agent_id	A	No
idx_group_moderation_logs_group_j_id	BTREE	No	No	group_jid	A	Yes
idx_group_moderation_logs_action	BTREE	No	No	action	A	Yes
idx_group_moderation_logs_status	BTREE	No	No	status	A	Yes

handoffs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	Yes	NULL
sender	varchar(32)	Yes	NULL
last_msg	text	Yes	NULL
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_handoffs_agent_id	BTREE	No	No	agent_id	A	Yes
idx_handoffs_sender	BTREE	No	No	sender	A	Yes

inbox_read_states

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
last_read_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL
whats_app_unread_count	bigint(20)	No	0
whats_app_synced	tinyint(1)	No	0
whats_app_state_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_inbox_read_agent_sender	BTREE	Yes	No	agent_id	A	No
idx_inbox_read_agent_sender	BTREE	Yes	No	sender	A	No

knowledges

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	Yes	NULL
question	text	Yes	NULL
answer	text	Yes	NULL
tags	longtext	Yes	NULL
embedding	longtext	Yes	NULL
embedding_model	varchar(80)	Yes	NULL
source	varchar(16)	Yes	manual
source_url	text	Yes	NULL
char_count	bigint(20)	No	0
created_at	datetime(3)	Yes	NULL
active	tinyint(1)	No	1
priority	bigint(20)	No	0
verified_at	datetime(3)	Yes	NULL
effective_from	datetime(3)	Yes	NULL
effective_until	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_knowledges_agent_id	BTREE	No	No	agent_id	A	Yes
idx_knowledges_source	BTREE	No	No	source	A	Yes
idx_knowledges_active	BTREE	No	No	active	A	No
idx_knowledges_priority	BTREE	No	No	priority	A	No
idx_knowledges_verified_at	BTREE	No	No	verified_at	A	Yes
idx_knowledges_effective_from	BTREE	No	No	effective_from	A	Yes
idx_knowledges_effective_until	BTREE	No	No	effective_until	A	Yes

labels

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
label_id	varchar(64)	No
name	longtext	Yes	NULL
color	bigint(20)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_label_agent	BTREE	Yes	No	agent_id	A	No
idx_label_agent	BTREE	Yes	No	label_id	A	No

login_throttles

Column	Type	Null	Default
id (Primary)	bigint(20)	No
key	varchar(255)	No
failures	bigint(20)	No	0
first_seen	datetime(3)	Yes	NULL
locked_until	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_login_throttles_key	BTREE	Yes	No	key	A	No
idx_login_throttles_first_seen	BTREE	No	No	first_seen	A	Yes
idx_login_throttles_locked_until	BTREE	No	No	locked_until	A	Yes

meta_conversion_events

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	Yes	NULL
event_id	varchar(100)	No
event_name	varchar(48)	No
event_time	datetime(3)	No
source_url	text	Yes	NULL
user_data_json	text	Yes	NULL
custom_data_json	text	Yes	NULL
status	varchar(16)	Yes	pending
attempts	bigint(20)	No	0
next_attempt_at	datetime(3)	Yes	NULL
last_error	text	Yes	NULL
meta_response	text	Yes	NULL
sent_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_meta_conversion_events_event_id	BTREE	Yes	No	event_id	A	No
idx_meta_conversion_events_tenant_id	BTREE	No	No	tenant_id	A	Yes
idx_meta_conversion_events_event_name	BTREE	No	No	event_name	A	No
idx_meta_conversion_events_event_time	BTREE	No	No	event_time	A	No
idx_meta_conversion_events_status	BTREE	No	No	status	A	Yes
idx_meta_conversion_events_next_attempt_at	BTREE	No	No	next_attempt_at	A	Yes

opt_outs

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_optout_agent_sender	BTREE	Yes	No	agent_id	A	No
idx_optout_agent_sender	BTREE	Yes	No	sender	A	No

otp_codes

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
number	varchar(32)	No
code_hash	varchar(64)	No
expires_at	datetime(3)	Yes	NULL
attempts	bigint(20)	No	0
used	tinyint(1)	No	0
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_otp_codes_agent_id	BTREE	No	No	agent_id	A	No
idx_otp_codes_number	BTREE	No	No	number	A	No
idx_otp_codes_expires_at	BTREE	No	No	expires_at	A	Yes

product_checkout_sessions

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
sender	varchar(32)	No
product_id	bigint(20)	No
step_index	bigint(20)	No	0
data_json	text	Yes	NULL
status	varchar(24)	No	collecting
expires_at	datetime(3)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_checkout_agent_sender	BTREE	Yes	No	agent_id	A	No
idx_checkout_agent_sender	BTREE	Yes	No	sender	A	No
idx_product_checkout_sessions_tenant_id	BTREE	No	No	tenant_id	A	No
idx_product_checkout_sessions_product_id	BTREE	No	No	product_id	A	No
idx_product_checkout_sessions_status	BTREE	No	No	status	A	No
idx_product_checkout_sessions_expires_at	BTREE	No	No	expires_at	A	Yes

product_orders

Column	Type	Null	Default	Links to
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
product_id	bigint(20)	No		products -> id
sender	varchar(32)	No
order_code	varchar(32)	No
status	varchar(24)	No	pending_cs
data_json	text	Yes	NULL
summary	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_product_orders_order_code	BTREE	Yes	No	order_code	A	No
idx_product_orders_tenant_id	BTREE	No	No	tenant_id	A	No
idx_product_orders_agent_id	BTREE	No	No	agent_id	A	No
idx_product_orders_product_id	BTREE	No	No	product_id	A	No
idx_product_orders_sender	BTREE	No	No	sender	A	No
idx_product_orders_status	BTREE	No	No	status	A	No

products

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
name	varchar(255)	No
product_type	varchar(32)	No	physical
price	varchar(64)	Yes	NULL
description	text	Yes	NULL
details_json	text	Yes	NULL
knowledge	text	Yes	NULL
ai_sales_guidance	text	Yes	NULL
image_path	varchar(512)	Yes	NULL
image_mime	varchar(64)	Yes	NULL
buttons_json	text	Yes	NULL
checkout_steps_json	text	Yes	NULL
checkout_handoff	tinyint(1)	No	1
checkout_success_message	text	Yes	NULL
embedding	longtext	Yes	NULL
embedding_model	varchar(80)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_products_tenant_id	BTREE	No	No	tenant_id	A	No
idx_products_agent_id	BTREE	No	No	agent_id	A	No

scheduled_messages

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
run_at	datetime(3)	Yes	NULL
message	text	Yes	NULL
product_id	bigint(20)	Yes	NULL
product_buttons_json	text	Yes	NULL
recipients	longtext	Yes	NULL
recipient_count	bigint(20)	Yes	NULL
target_type	varchar(16)	Yes	number
media_type	varchar(16)	Yes	NULL
media_path	longtext	Yes	NULL
file_name	longtext	Yes	NULL
mimetype	longtext	Yes	NULL
min_delay	bigint(20)	Yes	NULL
max_delay	bigint(20)	Yes	NULL
rest_every	bigint(20)	Yes	NULL
rest_duration	bigint(20)	Yes	NULL
status	varchar(16)	Yes	scheduled
consent_category	varchar(32)	Yes	NULL
consent_source	varchar(48)	Yes	NULL
risk_level	varchar(16)	Yes	NULL
risk_reasons	text	Yes	NULL
risk_acknowledged	tinyint(1)	No	0
override_reason	text	Yes	NULL
override_by	bigint(20)	Yes	NULL
override_at	datetime(3)	Yes	NULL
broadcast_id	bigint(20)	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_scheduled_messages_tenant_id	BTREE	No	No	tenant_id	A	No
idx_scheduled_messages_agent_id	BTREE	No	No	agent_id	A	No
idx_scheduled_messages_run_at	BTREE	No	No	run_at	A	Yes
idx_scheduled_messages_product_id	BTREE	No	No	product_id	A	Yes
idx_scheduled_messages_target_type	BTREE	No	No	target_type	A	Yes
idx_scheduled_messages_status	BTREE	No	No	status	A	Yes
idx_scheduled_messages_consent_category	BTREE	No	No	consent_category	A	Yes
idx_scheduled_messages_risk_level	BTREE	No	No	risk_level	A	Yes
idx_scheduled_messages_override_by	BTREE	No	No	override_by	A	Yes

scheduled_statuses

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
agent_id	bigint(20)	No
run_at	datetime(3)	Yes	NULL
text	text	Yes	NULL
media_type	varchar(16)	Yes	NULL
media_path	longtext	Yes	NULL
mimetype	longtext	Yes	NULL
status	varchar(16)	Yes	scheduled
error	text	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_scheduled_statuses_tenant_id	BTREE	No	No	tenant_id	A	No
idx_scheduled_statuses_agent_id	BTREE	No	No	agent_id	A	No
idx_scheduled_statuses_run_at	BTREE	No	No	run_at	A	Yes
idx_scheduled_statuses_status	BTREE	No	No	status	A	Yes

settings

Column	Type	Null	Default
id (Primary)	bigint(20)	No
system_prompt	text	Yes	NULL
ai_model	varchar(191)	Yes	deepseek-v4-pro
tone	varchar(191)	Yes	ramah

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

shipping_cities

Column	Type	Null	Default
id (Primary)	bigint(20)	No
raja_ongkir_id	bigint(20)	Yes	NULL
province	varchar(100)	Yes	NULL
type	varchar(20)	Yes	NULL
city_name	varchar(100)	Yes	NULL
full_name	varchar(200)	Yes	NULL
search_text	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_shipping_cities_raja_ongkir_id	BTREE	Yes	No	raja_ongkir_id	0	A	Yes

templates

Column	Type	Null	Default
id (Primary)	bigint(20)	No
agent_id	bigint(20)	No
title	varchar(120)	No
body	text	Yes	NULL
sort_order	bigint(20)	No	0
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL
media_type	varchar(24)	Yes	NULL
media_path	longtext	Yes	NULL
file_name	varchar(255)	Yes	NULL
mimetype	varchar(120)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_templates_agent_id	BTREE	No	No	agent_id	0	A	No

tenants

Column	Type	Null	Default
id (Primary)	bigint(20)	No
name	longtext	Yes	NULL
created_at	datetime(3)	Yes	NULL
updated_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

user_agent_assignments

Column	Type	Null	Default
id (Primary)	bigint(20)	No
tenant_id	bigint(20)	No
user_id	bigint(20)	No
agent_id	bigint(20)	No
created_at	datetime(3)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
idx_user_agent_assignment	BTREE	Yes	No	tenant_id	A	No
				user_id	A	No
				agent_id	A	No
idx_user_agent_assignments_tenant_id	BTREE	No	No	tenant_id	A	No
idx_user_agent_assignments_user_id	BTREE	No	No	user_id	A	No
idx_user_agent_assignments_agent_id	BTREE	No	No	agent_id	A	No

users

Column	Type	Null	Default
id (Primary)	bigint(20)	No
username	varchar(64)	No
password	longtext	Yes	NULL
role	varchar(24)	Yes	owner
name	longtext	Yes	NULL
email	varchar(255)	Yes	NULL
email_verified	tinyint(1)	Yes	0
email_verify_token	varchar(128)	Yes	NULL
phone	varchar(32)	Yes	NULL
tenant_id	bigint(20)	Yes	NULL
is_super_admin	tinyint(1)	Yes	0
password_reset_token	varchar(128)	Yes	NULL
password_reset_expiry	datetime(3)	Yes	NULL
active	tinyint(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	1	A	No
idx_users_username	BTREE	Yes	No	username	1	A	No
idx_users_phone	BTREE	No	No	phone	1	A	Yes
idx_users_tenant_id	BTREE	No	No	tenant_id	1	A	Yes