Print view - phpMyAdmin 4.5.1

agents

Column	Type	Null	Default	Links to	Comments

Indexes

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

ai_form_sessions

Column	Type	Null	Default	Links to	Comments

Indexes

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

ai_form_submissions

Column	Type	Null	Default	Links to	Comments

Indexes

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

ai_forms

Column	Type	Null	Default	Links to	Comments

Indexes

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

ai_turns

Column	Type	Null	Default	Links to	Comments

Indexes

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

app_settings

Column	Type	Null	Default	Links to	Comments

Indexes

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

auto_replies

Column	Type	Null	Default	Links to	Comments

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	Links to	Comments

Indexes

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

broadcasts

Column	Type	Null	Default	Links to	Comments

Indexes

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

chat_histories

Column	Type	Null	Default	Links to	Comments

Indexes

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

chat_labels

Column	Type	Null	Default	Links to	Comments

Indexes

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

closing_forms

Column	Type	Null	Default	Links to	Comments

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	Links to	Comments

Indexes

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

contact_consents

Column	Type	Null	Default	Links to	Comments

Indexes

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

contacts

Column	Type	Null	Default	Links to	Comments

Indexes

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

conversation_memories

Column	Type	Null	Default	Links to	Comments

Indexes

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

crawl_jobs

Column	Type	Null	Default	Links to	Comments

Indexes

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

crawl_pages

Column	Type	Null	Default	Links to	Comments

Indexes

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

cs_activity_logs

Column	Type	Null	Default	Links to	Comments

Indexes

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

flow_sessions

Column	Type	Null	Default	Links to	Comments

Indexes

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

flows

Column	Type	Null	Default	Links to	Comments

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	Links to	Comments

Indexes

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

follow_up_steps

Column	Type	Null	Default	Links to	Comments

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	Links to	Comments

Indexes

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

group_guard_configs

Column	Type	Null	Default	Links to	Comments

Indexes

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

group_moderation_logs

Column	Type	Null	Default	Links to	Comments

Indexes

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

handoffs

Column	Type	Null	Default	Links to	Comments

Indexes

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

inbox_read_states

Column	Type	Null	Default	Links to	Comments

Indexes

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

knowledges

Column	Type	Null	Default	Links to	Comments

Indexes

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

labels

Column	Type	Null	Default	Links to	Comments

Indexes

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

login_throttles

Column	Type	Null	Default	Links to	Comments

Indexes

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

meta_conversion_events

Column	Type	Null	Default	Links to	Comments

Indexes

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

opt_outs

Column	Type	Null	Default	Links to	Comments

Indexes

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

otp_codes

Column	Type	Null	Default	Links to	Comments

Indexes

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

product_checkout_sessions

Column	Type	Null	Default	Links to	Comments

Indexes

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

product_orders

Column	Type	Null	Default	Links to	Comments

Indexes

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

products

Column	Type	Null	Default	Links to	Comments

Indexes

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

scheduled_messages

Column	Type	Null	Default	Links to	Comments

Indexes

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

scheduled_statuses

Column	Type	Null	Default	Links to	Comments

Indexes

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

settings

Column	Type	Null	Default	Links to	Comments

Indexes

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

shipping_cities

Column	Type	Null	Default	Links to	Comments

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	Links to	Comments

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	Links to	Comments

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	Links to	Comments

Indexes

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

users

Column	Type	Null	Default	Links to	Comments

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
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

Open new phpMyAdmin window