email_autoresponders

Table comments : InnoDB free: 739328 kB

Field	Type	Null	Default
autoresponderid	int(11)	No
name	varchar(255)	Yes	NULL
subject	varchar(255)	Yes	NULL
format	char(1)	Yes	NULL
textbody	longtext	Yes	NULL
htmlbody	longtext	Yes	NULL
createdate	int(11)	Yes	0
active	int(11)	Yes	0
hoursaftersubscription	int(11)	Yes	0
ownerid	int(11)	No	0
searchcriteria	mediumtext	Yes	NULL
listid	int(11)	Yes	0
tracklinks	char(1)	Yes	1
trackopens	char(1)	Yes	1
multipart	char(1)	Yes	1
queueid	int(11)	Yes	0
sendfromname	varchar(255)	Yes	NULL
sendfromemail	varchar(255)	Yes	NULL
replytoemail	varchar(255)	Yes	NULL
bounceemail	varchar(255)	Yes	NULL
charset	varchar(255)	Yes	NULL
embedimages	char(1)	Yes	0
to_firstname	int(11)	Yes	0
to_lastname	int(11)	Yes	0
autorespondersize	int(11)	Yes	0

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	0	autoresponderid
autoresponderid_2	UNIQUE	0	autoresponderid
ownerid_2	UNIQUE	0	ownerid
autoresponderid_3	UNIQUE	0	autoresponderid
name_2	UNIQUE	0	name
subject_2	UNIQUE	0	subject
format_2	UNIQUE	0	format
createdate_2	UNIQUE	0	createdate
active_2	UNIQUE	0	active
hoursaftersubscription_2	UNIQUE	0	hoursaftersubscription
listid_2	UNIQUE	0	listid
tracklinks_2	UNIQUE	0	tracklinks
trackopens_2	UNIQUE	0	trackopens
multipart_2	UNIQUE	0	multipart
queueid_2	UNIQUE	0	queueid
sendfromname_2	UNIQUE	0	sendfromname
sendfromemail_2	UNIQUE	0	sendfromemail
replytoemail_2	UNIQUE	0	replytoemail
bounceemail_2	UNIQUE	0	bounceemail
charset_2	UNIQUE	0	charset
embedimages_2	UNIQUE	0	embedimages
to_firstname_2	UNIQUE	0	to_firstname
to_lastname_2	UNIQUE	0	to_lastname
autorespondersize_2	UNIQUE	0	autorespondersize
bounceemail_3	UNIQUE	0	bounceemail
format_3	UNIQUE	0	format
multipart_3	UNIQUE	0	multipart
trackopens_3	UNIQUE	0	trackopens
name_4	UNIQUE	0	name
createdate_3	UNIQUE	0	createdate
email_autoresponders_owner_idx	INDEX	0	ownerid
email_autoresponders_list_idx	INDEX	0	listid
email_autoresponders_queue_idx	INDEX	0	queueid
autoresponderid	INDEX	0	autoresponderid
name	INDEX	0	name
subject	INDEX	0	subject
format	INDEX	0	format
createdate	INDEX	0	createdate
active	INDEX	0	active
hoursaftersubscription	INDEX	0	hoursaftersubscription
ownerid	INDEX	0	ownerid
listid	INDEX	0	listid
tracklinks	INDEX	0	tracklinks
trackopens	INDEX	0	trackopens
multipart	INDEX	0	multipart
queueid	INDEX	0	queueid
sendfromname	INDEX	0	sendfromname
sendfromemail	INDEX	0	sendfromemail
replytoemail	INDEX	0	replytoemail
bounceemail	INDEX	0	bounceemail
charset	INDEX	0	charset
embedimages	INDEX	0	embedimages
to_firstname	INDEX	0	to_firstname
to_lastname	INDEX	0	to_lastname
autorespondersize	INDEX	0	autorespondersize
name_3	INDEX	0	name
autorespondersize_3	INDEX	0	autorespondersize
sendfromemail_3	INDEX	0	sendfromemail
active_3	INDEX	0	active
tracklinks_3	INDEX	0	tracklinks
to_lastname_3	INDEX	0	to_lastname
queueid_3	INDEX	0	queueid
ownerid_3	INDEX	0	ownerid
subject_3	INDEX	0	subject

Space usage : Type Usage Data 16,384 Bytes Index 1,008 KB Total 1,024 KB

Row Statistic : Statements Value Format dynamic Rows 0 Next Autoindex 1 Creation Apr 16, 2024 at 12:29 PM