email_queues_unsent

Table comments : InnoDB free: 727040 kB

Field	Type	Null	Default
recipient	int(11)	No	0
queueid	int(11)	Yes	0
reasoncode	int(11)	Yes	0
reason	text	Yes	NULL

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	2	recipient
recipient_2	UNIQUE	2	recipient
recipient_4	UNIQUE	2	recipient
recipient_6	UNIQUE	2	recipient
recipient_8	UNIQUE	2	recipient
recipient_10	UNIQUE	2	recipient
recipient_12	UNIQUE	2	recipient
recipient_14	UNIQUE	2	recipient
recipient_15	UNIQUE	2	recipient
recipient_18	UNIQUE	2	recipient
queueid_2	UNIQUE	2	queueid
queueid_4	UNIQUE	2	queueid
queueid_6	UNIQUE	2	queueid
queueid_8	UNIQUE	2	queueid
queueid_11	UNIQUE	2	queueid
queueid_12	UNIQUE	2	queueid
queueid_15	UNIQUE	2	queueid
recipient	INDEX	2	recipient
queueid	INDEX	2	queueid
reasoncode	INDEX	2	reasoncode
reasoncode_2	INDEX	2	reasoncode
queueid_3	INDEX	2	queueid
recipient_3	INDEX	2	recipient
recipient_5	INDEX	2	recipient
reasoncode_3	INDEX	2	reasoncode
queueid_5	INDEX	2	queueid
recipient_7	INDEX	2	recipient
queueid_7	INDEX	2	queueid
reasoncode_4	INDEX	2	reasoncode
recipient_9	INDEX	2	recipient
reasoncode_5	INDEX	2	reasoncode
queueid_9	INDEX	2	queueid
recipient_11	INDEX	2	recipient
queueid_10	INDEX	2	queueid
reasoncode_6	INDEX	2	reasoncode
queueid_13	INDEX	2	queueid
recipient_13	INDEX	2	recipient
reasoncode_7	INDEX	2	reasoncode
reasoncode_8	INDEX	2	reasoncode
recipient_16	INDEX	2	recipient
queueid_14	INDEX	2	queueid
recipient_17	INDEX	2	recipient

Space usage : Type Usage Data 16,384 Bytes Index 671,744 Bytes Total 688,128 Bytes

Row Statistic : Statements Value Format dynamic Rows 2 Row length ø 8,192 Row size  ø 344,064 Bytes Creation May 02, 2024 at 12:12 AM