Server: mysql.puroparty.com | Database: puroparty | Table: djs |
Field | Type | Null | Default |
---|---|---|---|
id | smallint(4) | No | |
name | varchar(50) | No | |
phone1 | varchar(15) | No | |
phone2 | varchar(15) | No | |
type | varchar(50) | No | |
website | varchar(50) | No | |
location | varchar(35) | No | |
smallpic | varchar(35) | No | |
largepic | varchar(35) | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 13 | id | |
id_2 | UNIQUE | 13 | id | |
name_2 | UNIQUE | 13 | name | |
smallpic_2 | UNIQUE | 13 | smallpic | |
largepic_2 | UNIQUE | 13 | largepic | |
id_3 | UNIQUE | 13 | id | |
name_5 | UNIQUE | 13 | name | |
largepic_6 | UNIQUE | 13 | largepic | |
smallpic_6 | UNIQUE | 13 | smallpic | |
name_7 | UNIQUE | 13 | name | |
id_6 | UNIQUE | 13 | id | |
smallpic_7 | UNIQUE | 13 | smallpic | |
largepic_8 | UNIQUE | 13 | largepic | |
id | INDEX | None | id | |
name | INDEX | None | name | |
phone1 | INDEX | None | phone1 | |
phone2 | INDEX | None | phone2 | |
type | INDEX | None | type | |
website | INDEX | None | website | |
location | INDEX | None | location | |
smallpic | INDEX | None | smallpic | |
largepic | INDEX | None | largepic | |
location_3 | INDEX | None | location | |
type_3 | INDEX | None | type | |
website_3 | INDEX | None | website | |
name_6 | INDEX | None | name | |
largepic_4 | INDEX | None | largepic | |
smallpic_5 | INDEX | None | smallpic | |
phone2_4 | INDEX | None | phone2 | |
id_4 | INDEX | None | id | |
phone1_3 | INDEX | None | phone1 | |
phone1_5 | INDEX | None | phone1 | |
phone2_5 | INDEX | None | phone2 | |
id_5 | INDEX | None | id | |
name_8 | INDEX | None | name | |
website_6 | INDEX | None | website | |
location_6 | INDEX | None | location | |
type_5 | INDEX | None | type | |
smallpic_9 | INDEX | None | smallpic | |
largepic_9 | INDEX | None | largepic | |
name_3 | INDEX | None | name | |
phone1_2 | INDEX | None | phone1 | |
phone2_2 | INDEX | None | phone2 | |
type_2 | INDEX | None | type | |
website_2 | INDEX | None | website | |
location_2 | INDEX | None | location | |
smallpic_3 | INDEX | None | smallpic | |
largepic_3 | INDEX | None | largepic | |
smallpic_4 | INDEX | None | smallpic | |
location_4 | INDEX | None | location | |
name_4 | INDEX | None | name | |
phone2_3 | INDEX | None | phone2 | |
largepic_5 | INDEX | None | largepic | |
website_4 | INDEX | None | website | |
type_4 | INDEX | None | type | |
phone1_4 | INDEX | None | phone1 | |
location_5 | INDEX | None | location | |
largepic_7 | INDEX | None | largepic | |
phone2_6 | INDEX | None | phone2 | |
phone1_6 | INDEX | None | phone1 | |
smallpic_8 | INDEX | None | smallpic | |
website_5 | INDEX | None | website | |
name_9 | INDEX | None | name | |
type_6 | INDEX | None | type |
Space usage :
|
Row Statistic :
|