Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: picspics

pics

Field Type Null Default
month  char(2) No 
day  char(2) No 
year  int(4) No 
link1  text No   
entertainer  varchar(200) No   
eventname  varchar(100) No   
venue  varchar(50) No   
city  varchar(50) No   
weekday  varchar(10) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 743 venue
month INDEX None month
day INDEX None day
year INDEX None year
entertainer INDEX None entertainer
eventname INDEX None eventname
venue INDEX None venue
city INDEX None city
weekday INDEX None weekday
eventname_3 INDEX None eventname
day_2 INDEX None day
weekday_4 INDEX None weekday
venue_4 INDEX None venue
city_3 INDEX None city
year_2 INDEX None year
entertainer_3 INDEX None entertainer
month_2 INDEX None month
year_3 INDEX None year
venue_6 INDEX None venue
entertainer_5 INDEX None entertainer
city_5 INDEX None city
weekday_5 INDEX None weekday
day_3 INDEX None day
month_3 INDEX None month
eventname_6 INDEX None eventname
year_4 INDEX None year
venue_7 INDEX None venue
weekday_7 INDEX None weekday
day_4 INDEX None day
city_8 INDEX None city
entertainer_7 INDEX None entertainer
eventname_8 INDEX None eventname
month_4 INDEX None month
month_5 INDEX None month
day_5 INDEX None day
year_5 INDEX None year
entertainer_8 INDEX None entertainer
eventname_9 INDEX None eventname
link1 INDEX None link1
entertainer_2 INDEX None entertainer
eventname_2 INDEX None eventname
venue_2 INDEX None venue
city_2 INDEX None city
weekday_2 INDEX None weekday
weekday_3 INDEX None weekday
venue_3 INDEX None venue
eventname_4 INDEX None eventname
link1_2 INDEX None link1
city_4 INDEX None city
entertainer_4 INDEX None entertainer
link1_3 INDEX None link1
venue_5 INDEX None venue
eventname_5 INDEX None eventname
weekday_6 INDEX None weekday
city_6 INDEX None city
entertainer_6 INDEX None entertainer
link1_4 INDEX None link1
venue_8 INDEX None venue
city_7 INDEX None city
eventname_7 INDEX None eventname
weekday_8 INDEX None weekday
link1_5 INDEX None link1
entertainer_9 INDEX None entertainer
eventname_10 INDEX None eventname


 Space usage :
Type Usage
Data 271,532 Bytes
Index 3,072 Bytes
Total 274,604 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 743
Row length ø 365
Row size  ø 370 Bytes
Creation Apr 21, 2018 at 05:24 PM
Last update Apr 21, 2018 at 05:24 PM