bd_world_cities

Field	Type	Null	Default
cityID	int(11)	No
rID	int(4)	No	0
cID	int(3)	No	0
cityName	varchar(255)	No

 Indexes :

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	0	cityID
cityID_2	UNIQUE	0	cityID
rID_3	UNIQUE	0	rID
cID_3	UNIQUE	0	cID
cityName_2	UNIQUE	0	cityName
cID_4	UNIQUE	0	cID
cityName_4	UNIQUE	0	cityName
rID_4	UNIQUE	0	rID
cityID_3	UNIQUE	0	cityID
cityID_6	UNIQUE	0	cityID
rID_7	UNIQUE	0	rID
cID_7	UNIQUE	0	cID
cityName_8	UNIQUE	0	cityName
rID_8	UNIQUE	0	rID
cityName_12	UNIQUE	0	cityName
cityID_8	UNIQUE	0	cityID
cID_9	UNIQUE	0	cID
cityName_13	UNIQUE	0	cityName
rID_11	UNIQUE	0	rID
cityID_9	UNIQUE	0	cityID
rID_12	UNIQUE	0	rID
cityID_10	UNIQUE	0	cityID
cityName_18	UNIQUE	0	cityName
cID_12	UNIQUE	0	cID
cID_13	UNIQUE	0	cID
cityID_13	UNIQUE	0	cityID
rID_15	UNIQUE	0	rID
cID_15	UNIQUE	0	cID
cityName_20	UNIQUE	0	cityName
rID	INDEX	None	rID
			cID
cID	INDEX	None	cID
cityID	INDEX	None	cityID
rID_2	INDEX	None	rID
cID_2	INDEX	None	cID
cityName	INDEX	None	cityName
cityName_5	INDEX	None	cityName
rID_5	INDEX	None	rID
cID_5	INDEX	None	cID
cityID_4	INDEX	None	cityID
cityID_5	INDEX	None	cityID
rID_6	INDEX	None	rID
cID_6	INDEX	None	cID
cityName_7	INDEX	None	cityName
cID_8	INDEX	None	cID
cityName_11	INDEX	None	cityName
cityID_7	INDEX	None	cityID
rID_9	INDEX	None	rID
cID_10	INDEX	None	cID
rID_10	INDEX	None	rID
cID_11	INDEX	None	cID
cityName_16	INDEX	None	cityName
cityName_17	INDEX	None	cityName
rID_13	INDEX	None	rID
cityID_11	INDEX	None	cityID
cityID_12	INDEX	None	cityID
rID_14	INDEX	None	rID
cID_14	INDEX	None	cID
cityName_19	INDEX	None	cityName
cityName_3	INDEX	None	cityName
cityName_6	INDEX	None	cityName
cityName_9	INDEX	None	cityName
cityName_10	INDEX	None	cityName
cityName_14	INDEX	None	cityName
cityName_15	INDEX	None	cityName

Space usage : Type Usage Data 0 Bytes Index 3,072 Bytes Total 3,072 Bytes

Row Statistic : Statements Value Format dynamic Rows 0 Next Autoindex 1 Creation Apr 13, 2018 at 06:39 PM Last update Apr 28, 2024 at 10:24 PM Last check Apr 28, 2024 at 10:24 PM