email_customfields

Table comments : InnoDB free: 739328 kB

Field	Type	Null	Default
fieldid	int(11)	No
name	varchar(255)	Yes	NULL
fieldtype	varchar(100)	Yes	NULL
defaultvalue	varchar(255)	Yes	NULL
required	char(1)	Yes	0
fieldsettings	mediumtext	Yes	NULL
createdate	int(11)	Yes	0
ownerid	int(11)	Yes	0

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	9	fieldid
fieldid_2	UNIQUE	9	fieldid
fieldid_4	UNIQUE	9	fieldid
fieldid_6	UNIQUE	9	fieldid
fieldid_7	UNIQUE	9	fieldid
fieldid_9	UNIQUE	9	fieldid
fieldid_12	UNIQUE	9	fieldid
name_2	UNIQUE	9	name
createdate_2	UNIQUE	9	createdate
name_3	UNIQUE	9	name
createdate_4	UNIQUE	9	createdate
createdate_5	UNIQUE	9	createdate
name_6	UNIQUE	9	name
createdate_7	UNIQUE	9	createdate
name_7	UNIQUE	9	name
createdate_9	UNIQUE	9	createdate
name_10	UNIQUE	9	name
createdate_11	UNIQUE	9	createdate
createdate_12	UNIQUE	9	createdate
email_customfields_owner_idx	INDEX	2	ownerid
email_customfield_id_name	INDEX	9	fieldid
			name
fieldid	INDEX	9	fieldid
name	INDEX	9	name
fieldtype	INDEX	9	fieldtype
defaultvalue	INDEX	4	defaultvalue
required	INDEX	2	required
createdate	INDEX	9	createdate
ownerid	INDEX	2	ownerid
fieldid_3	INDEX	9	fieldid
createdate_3	INDEX	9	createdate
ownerid_2	INDEX	2	ownerid
defaultvalue_2	INDEX	4	defaultvalue
required_2	INDEX	2	required
fieldtype_2	INDEX	9	fieldtype
name_4	INDEX	9	name
fieldid_5	INDEX	9	fieldid
name_5	INDEX	9	name
fieldtype_3	INDEX	9	fieldtype
defaultvalue_3	INDEX	4	defaultvalue
required_3	INDEX	2	required
createdate_6	INDEX	9	createdate
ownerid_3	INDEX	2	ownerid
required_4	INDEX	2	required
ownerid_4	INDEX	2	ownerid
defaultvalue_4	INDEX	4	defaultvalue
createdate_8	INDEX	9	createdate
fieldtype_4	INDEX	9	fieldtype
name_8	INDEX	9	name
fieldid_8	INDEX	9	fieldid
ownerid_5	INDEX	2	ownerid
name_9	INDEX	9	name
required_5	INDEX	2	required
required_6	INDEX	2	required
createdate_10	INDEX	9	createdate
ownerid_6	INDEX	2	ownerid
defaultvalue_5	INDEX	4	defaultvalue
fieldtype_5	INDEX	9	fieldtype
fieldtype_6	INDEX	9	fieldtype
defaultvalue_6	INDEX	4	defaultvalue
name_11	INDEX	9	name
createdate_13	INDEX	9	createdate
fieldid_10	INDEX	9	fieldid
fieldid_11	INDEX	9	fieldid
name_12	INDEX	9	name

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

Row Statistic : Statements Value Format dynamic Rows 9 Row length ø 1,820 Row size  ø 116,508 Bytes Next Autoindex 11 Creation Jun 19, 2018 at 10:10 PM