Server: mysql.puroparty.com | Database: puroparty | Table: 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 |
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 :
|
Row Statistic :
|