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

jos_polls

Field Type Null Default
id  int(11) No   
title  varchar(255) No   
alias  varchar(255) No   
voters  int(9) No 
checked_out  int(11) No 
checked_out_time  datetime No  0000-00-00 00:00:00 
published  tinyint(1) No 
access  int(11) No 
lag  int(11) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 id
id_2 UNIQUE 1 id
title_2 UNIQUE 1 title
alias_2 UNIQUE 1 alias
voters_2 UNIQUE 1 voters
checked_out_2 UNIQUE 1 checked_out
checked_out_time_2 UNIQUE 1 checked_out_time
published_2 UNIQUE 1 published
access_2 UNIQUE 1 access
lag_2 UNIQUE 1 lag
access_3 UNIQUE 1 access
title_5 UNIQUE 1 title
voters_4 UNIQUE 1 voters
id_4 UNIQUE 1 id
checked_out_time_3 UNIQUE 1 checked_out_time
lag_3 UNIQUE 1 lag
checked_out_4 UNIQUE 1 checked_out
alias_6 UNIQUE 1 alias
published_4 UNIQUE 1 published
access_5 UNIQUE 1 access
id_5 UNIQUE 1 id
alias_7 UNIQUE 1 alias
title_8 UNIQUE 1 title
checked_out_5 UNIQUE 1 checked_out
voters_5 UNIQUE 1 voters
checked_out_time_5 UNIQUE 1 checked_out_time
lag_5 UNIQUE 1 lag
published_6 UNIQUE 1 published
checked_out_time_7 UNIQUE 1 checked_out_time
id INDEX None id
title INDEX None title
alias INDEX None alias
voters INDEX None voters
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
published INDEX None published
access INDEX None access
lag INDEX None lag
title_4 INDEX None title
voters_3 INDEX None voters
alias_4 INDEX None alias
access_4 INDEX None access
id_3 INDEX None id
checked_out_3 INDEX None checked_out
published_3 INDEX None published
lag_4 INDEX None lag
checked_out_time_4 INDEX None checked_out_time
access_6 INDEX None access
id_6 INDEX None id
voters_6 INDEX None voters
alias_8 INDEX None alias
published_5 INDEX None published
title_9 INDEX None title
lag_6 INDEX None lag
checked_out_time_6 INDEX None checked_out_time
checked_out_6 INDEX None checked_out
voters_7 INDEX None voters
title_10 INDEX None title
title_3 INDEX None title
alias_3 INDEX None alias
alias_5 INDEX None alias
title_6 INDEX None title
title_7 INDEX None title
alias_9 INDEX None alias


 Space usage :
Type Usage
Data 60 Bytes
Index 3,072 Bytes
Total 3,132 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 1
Row length ø 60
Row size  ø 3,132 Bytes
Next Autoindex 15
Creation Dec 11, 2017 at 01:49 PM
Last update Apr 25, 2024 at 03:40 PM
Last check Apr 25, 2024 at 03:40 PM