mysql.puroparty.com
puroparty
artists
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: artists
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| name | varchar(100) | No | |
| photo | varchar(100) | No | |
| photo2 | varchar(100) | No | |
| photo3 | varchar(100) | No | |
| bio | text | No | |
| message | text | No | |
| ad | text | No | |
| player | text | No | |
| folder | varchar(20) | No | |
| cd1pic | varchar(100) | No | |
| cd1name | varchar(100) | No | |
| cd2pic | varchar(100) | No | |
| cd2name | varchar(100) | No | |
| cd3pic | varchar(100) | No | |
| cd3name | varchar(100) | No | |
| cd4pic | varchar(100) | No | |
| cd4name | varchar(100) | No | |
| lyrics | text | No | |
| thumbnail | varchar(100) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 6 | id | |
| id_3 | UNIQUE | 6 | id | |
| name_2 | UNIQUE | 6 | name | |
| photo_2 | UNIQUE | 6 | photo | |
| photo2_2 | UNIQUE | 6 | photo2 | |
| photo3_2 | UNIQUE | 6 | photo3 | |
| folder_2 | UNIQUE | 6 | folder | |
| thumbnail_2 | UNIQUE | 6 | thumbnail | |
| thumbnail_6 | UNIQUE | 6 | thumbnail | |
| id_5 | UNIQUE | 6 | id | |
| name_5 | UNIQUE | 6 | name | |
| photo_5 | UNIQUE | 6 | photo | |
| photo2_5 | UNIQUE | 6 | photo2 | |
| id | INDEX | None | id | |
| id_2 | INDEX | None | id | |
| name | INDEX | None | name | |
| photo | INDEX | None | photo | |
| photo2 | INDEX | None | photo2 | |
| photo3 | INDEX | None | photo3 | |
| folder | INDEX | None | folder | |
| cd1pic | INDEX | None | cd1pic | |
| cd1name | INDEX | None | cd1name | |
| cd2pic | INDEX | None | cd2pic | |
| cd2name | INDEX | None | cd2name | |
| cd3pic | INDEX | None | cd3pic | |
| cd3name | INDEX | None | cd3name | |
| cd4pic | INDEX | None | cd4pic | |
| cd4name | INDEX | None | cd4name | |
| thumbnail | INDEX | None | thumbnail | |
| cd3name_3 | INDEX | None | cd3name | |
| thumbnail_4 | INDEX | None | thumbnail | |
| cd4pic_3 | INDEX | None | cd4pic | |
| cd4name_4 | INDEX | None | cd4name | |
| id_4 | INDEX | None | id | |
| name_4 | INDEX | None | name | |
| photo_4 | INDEX | None | photo | |
| photo2_4 | INDEX | None | photo2 | |
| name_3 | INDEX | None | name | |
| photo_3 | INDEX | None | photo | |
| photo2_3 | INDEX | None | photo2 | |
| photo3_3 | INDEX | None | photo3 | |
| bio | INDEX | None | bio | |
| message | INDEX | None | message | |
| ad | INDEX | None | ad | |
| player | INDEX | None | player | |
| folder_3 | INDEX | None | folder | |
| cd1pic_2 | INDEX | None | cd1pic | |
| cd1name_2 | INDEX | None | cd1name | |
| cd2pic_2 | INDEX | None | cd2pic | |
| cd2name_2 | INDEX | None | cd2name | |
| cd3pic_2 | INDEX | None | cd3pic | |
| cd3name_2 | INDEX | None | cd3name | |
| cd4pic_2 | INDEX | None | cd4pic | |
| cd4name_2 | INDEX | None | cd4name | |
| lyrics | INDEX | None | lyrics | |
| thumbnail_3 | INDEX | None | thumbnail | |
| cd3name_4 | INDEX | None | cd3name | |
| thumbnail_5 | INDEX | None | thumbnail | |
| cd4pic_4 | INDEX | None | cd4pic | |
| cd4name_3 | INDEX | None | cd4name | |
| lyrics_2 | INDEX | None | lyrics | |
| name_6 | INDEX | None | name | |
| photo_6 | INDEX | None | photo | |
| photo2_6 | INDEX | None | photo2 | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||