Print view - phpMyAdmin 4.8.4

batch_logs

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
batch_id	varchar(50)	Yes	NULL
batch_number	int(11)	Yes	NULL
group_id	varchar(100)	Yes	NULL
messages_fetched	int(11)	Yes	NULL
messages_new	int(11)	Yes	NULL
messages_duplicate	int(11)	Yes	NULL
messages_stored	int(11)	Yes	NULL
questions_detected	int(11)	Yes	NULL
unanswered_count	int(11)	Yes	NULL
fetch_status	enum('pending', 'success', 'failed')	Yes	pending
process_status	enum('pending', 'analyzed', 'sent', 'failed')	Yes	pending
error_message	longtext	Yes	NULL
retry_count	int(11)	Yes	0
fetch_start_at	datetime	Yes	NULL
fetch_end_at	datetime	Yes	NULL
analyze_start_at	datetime	Yes	NULL
analyze_end_at	datetime	Yes	NULL
created_at	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
batch_id	BTREE	Yes	No	batch_id	0	A	Yes
uk_batch_id	BTREE	Yes	No	batch_id	0	A	Yes
idx_status	BTREE	No	No	fetch_status	0	A	Yes
idx_status	BTREE	No	No	process_status	0	A	Yes
idx_created	BTREE	No	No	created_at	0	A	No
idx_group	BTREE	No	No	group_id	0	A	Yes

unanswered_questions

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
message_id	varchar(100)	Yes	NULL
batch_id	varchar(50)	Yes	NULL
group_id	varchar(100)	Yes	NULL
sender_number	varchar(50)	Yes	NULL
sender_name	varchar(100)	Yes	NULL
question_text	text	Yes	NULL
question_timestamp	datetime	Yes	NULL
days_pending	int(11)	Yes	NULL
priority	enum('critical', 'urgent', 'high', 'medium', 'low')	Yes	medium
status	varchar(50)	Yes	pending
resolved_at	datetime	Yes	NULL
ai_model	varchar(50)	Yes	NULL
ai_confidence	float	Yes	NULL
created_at	timestamp	No	CURRENT_TIMESTAMP
updated_at	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	27	A	No
idx_message_id	BTREE	No	No	message_id	27	A	Yes
idx_batch_id	BTREE	No	No	batch_id	2	A	Yes
idx_group	BTREE	No	No	group_id	27	A	Yes
idx_group	BTREE	No	No	status	27	A	Yes
idx_sender	BTREE	No	No	sender_number	2	A	Yes
idx_status	BTREE	No	No	status	2	A	Yes
idx_priority	BTREE	No	No	priority	2	A	Yes
idx_created	BTREE	No	No	created_at	2	A	No
idx_pending_days	BTREE	No	No	days_pending	2	A	Yes

whatsapp_chats

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
message_id	varchar(100)	No
batch_id	varchar(50)	Yes	NULL
group_id	varchar(100)	Yes	NULL
sender_number	varchar(50)	Yes	NULL
sender_name	varchar(100)	Yes	NULL
message_text	longtext	Yes	NULL
message_timestamp	bigint(20)	Yes	NULL
message_datetime	datetime	Yes	NULL
created_at	timestamp	No	CURRENT_TIMESTAMP
processed	tinyint(1)	Yes	0
processed_at	datetime	Yes	NULL
deleted_at	datetime	Yes	NULL
has_question	tinyint(1)	Yes	0
is_answer	tinyint(1)	Yes	0
ai_confidence	float	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	82	A	No
message_id	BTREE	Yes	No	message_id	82	A	No
uk_message_id	BTREE	Yes	No	message_id	82	A	No
idx_batch_id	BTREE	No	No	batch_id	2	A	Yes
idx_group_id	BTREE	No	No	group_id	2	A	Yes
idx_sender	BTREE	No	No	sender_number	27	A	Yes
idx_processed	BTREE	No	No	processed	2	A	Yes
idx_created	BTREE	No	No	created_at	2	A	No
ft_text	FULLTEXT	No	No	message_text	82		Yes

whatsapp_chats_archive

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
message_id	varchar(100)	Yes	NULL
batch_id	varchar(50)	Yes	NULL
group_id	varchar(100)	Yes	NULL
sender_number	varchar(50)	Yes	NULL
sender_name	varchar(100)	Yes	NULL
message_text	longtext	Yes	NULL
message_timestamp	bigint(20)	Yes	NULL
message_datetime	datetime	Yes	NULL
archived_at	timestamp	No	CURRENT_TIMESTAMP
original_created_at	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
message_id	BTREE	Yes	No	message_id	0	A	Yes
idx_date	BTREE	No	No	archived_at	0	A	No
idx_group	BTREE	No	No	group_id	0	A	Yes

Open new phpMyAdmin window