email_templates

Table comments : InnoDB free: 743424 kB

Field	Type	Null	Default
templateid	int(11)	No
name	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
isglobal	int(11)	Yes	0
ownerid	int(11)	No	0

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	0	templateid
templateid_2	UNIQUE	0	templateid
ownerid_2	UNIQUE	0	ownerid
templateid_4	UNIQUE	0	templateid
ownerid_4	UNIQUE	0	ownerid
templateid_6	UNIQUE	0	templateid
ownerid_6	UNIQUE	0	ownerid
templateid_7	UNIQUE	0	templateid
ownerid_8	UNIQUE	0	ownerid
ownerid_9	UNIQUE	0	ownerid
name_2	UNIQUE	0	name
format_2	UNIQUE	0	format
createdate_2	UNIQUE	0	createdate
active_2	UNIQUE	0	active
isglobal_2	UNIQUE	0	isglobal
isglobal_3	UNIQUE	0	isglobal
active_3	UNIQUE	0	active
name_3	UNIQUE	0	name
format_4	UNIQUE	0	format
createdate_4	UNIQUE	0	createdate
format_6	UNIQUE	0	format
isglobal_5	UNIQUE	0	isglobal
createdate_6	UNIQUE	0	createdate
active_5	UNIQUE	0	active
name_6	UNIQUE	0	name
name_7	UNIQUE	0	name
isglobal_7	UNIQUE	0	isglobal
format_8	UNIQUE	0	format
active_7	UNIQUE	0	active
createdate_8	UNIQUE	0	createdate
format_9	UNIQUE	0	format
isglobal_10	UNIQUE	0	isglobal
isglobal_11	UNIQUE	0	isglobal
email_templates_owner_idx	INDEX	0	ownerid
templateid	INDEX	0	templateid
name	INDEX	0	name
format	INDEX	0	format
createdate	INDEX	0	createdate
active	INDEX	0	active
isglobal	INDEX	0	isglobal
ownerid	INDEX	0	ownerid
format_3	INDEX	0	format
ownerid_3	INDEX	0	ownerid
templateid_3	INDEX	0	templateid
createdate_3	INDEX	0	createdate
isglobal_4	INDEX	0	isglobal
name_4	INDEX	0	name
active_4	INDEX	0	active
format_5	INDEX	0	format
templateid_5	INDEX	0	templateid
createdate_5	INDEX	0	createdate
name_5	INDEX	0	name
isglobal_6	INDEX	0	isglobal
ownerid_5	INDEX	0	ownerid
active_6	INDEX	0	active
name_8	INDEX	0	name
format_7	INDEX	0	format
isglobal_8	INDEX	0	isglobal
createdate_7	INDEX	0	createdate
ownerid_7	INDEX	0	ownerid
templateid_8	INDEX	0	templateid
active_8	INDEX	0	active
isglobal_9	INDEX	0	isglobal
format_10	INDEX	0	format

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 Mar 13, 2024 at 12:19 PM