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

poll_data

Field Type Null Default
id  int(11) No   
poll_id  int(11) No 
option_id  int(11) No 
option_text  varchar(100) No   
color  varchar(20) No   
votes  int(14) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 23 poll_id
option_id
id_3 UNIQUE 23 id
id_5 UNIQUE 23 id
id_7 UNIQUE 23 id
id_9 UNIQUE 23 id
id_11 UNIQUE 23 id
id_13 UNIQUE 23 id
id INDEX None id
id_2 INDEX None id
poll_id INDEX None poll_id
option_id INDEX None option_id
option_text INDEX None option_text
color INDEX None color
votes INDEX None votes
option_id_2 INDEX None option_id
color_3 INDEX None color
option_text_4 INDEX None option_text
id_4 INDEX None id
poll_id_2 INDEX None poll_id
votes_2 INDEX None votes
id_6 INDEX None id
color_5 INDEX None color
votes_3 INDEX None votes
option_id_3 INDEX None option_id
option_text_6 INDEX None option_text
poll_id_3 INDEX None poll_id
option_text_8 INDEX None option_text
id_8 INDEX None id
option_id_4 INDEX None option_id
poll_id_4 INDEX None poll_id
votes_4 INDEX None votes
color_8 INDEX None color
votes_5 INDEX None votes
option_id_5 INDEX None option_id
poll_id_5 INDEX None poll_id
id_10 INDEX None id
option_text_10 INDEX None option_text
id_12 INDEX None id
poll_id_6 INDEX None poll_id
option_id_6 INDEX None option_id
option_text_11 INDEX None option_text
color_10 INDEX None color
votes_6 INDEX None votes
color_12 INDEX None color
option_text_13 INDEX None option_text
option_text_2 INDEX None option_text
color_2 INDEX None color
option_text_3 INDEX None option_text
color_4 INDEX None color
color_6 INDEX None color
option_text_5 INDEX None option_text
option_text_7 INDEX None option_text
color_7 INDEX None color
option_text_9 INDEX None option_text
color_9 INDEX None color
option_text_12 INDEX None option_text
color_11 INDEX None color
option_text_14 INDEX None option_text


 Space usage :
Type Usage
Data 808 Bytes
Index 62,464 Bytes
Total 63,272 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 23
Row length ø 35
Row size  ø 2,751 Bytes
Next Autoindex 24
Creation Jun 20, 2018 at 05:15 PM
Last update Jun 20, 2018 at 05:15 PM