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

poll_log

Field Type Null Default
log_id  int(11) No   
poll_id  int(11) No 
option_id  int(11) No 
timestamp  int(11) No 
ip_addr  varchar(15) No   
host  varchar(255) No   
agent  varchar(255) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 2 log_id
log_id_2 UNIQUE 2 log_id
timestamp_2 UNIQUE 2 timestamp
timestamp_4 UNIQUE 2 timestamp
log_id_4 UNIQUE 2 log_id
timestamp_5 UNIQUE 2 timestamp
log_id_5 UNIQUE 2 log_id
timestamp_7 UNIQUE 2 timestamp
log_id_7 UNIQUE 2 log_id
log_id_9 UNIQUE 2 log_id
timestamp_10 UNIQUE 2 timestamp
log_id_12 UNIQUE 2 log_id
log_id INDEX None log_id
poll_id INDEX None poll_id
option_id INDEX None option_id
timestamp INDEX None timestamp
ip_addr INDEX None ip_addr
host INDEX None host
agent INDEX None agent
timestamp_3 INDEX None timestamp
agent_4 INDEX None agent
option_id_2 INDEX None option_id
poll_id_2 INDEX None poll_id
host_4 INDEX None host
ip_addr_4 INDEX None ip_addr
log_id_3 INDEX None log_id
agent_5 INDEX None agent
agent_6 INDEX None agent
option_id_3 INDEX None option_id
timestamp_6 INDEX None timestamp
host_6 INDEX None host
poll_id_3 INDEX None poll_id
log_id_6 INDEX None log_id
ip_addr_6 INDEX None ip_addr
agent_8 INDEX None agent
option_id_4 INDEX None option_id
timestamp_8 INDEX None timestamp
ip_addr_8 INDEX None ip_addr
poll_id_4 INDEX None poll_id
host_8 INDEX None host
log_id_8 INDEX None log_id
poll_id_5 INDEX None poll_id
option_id_5 INDEX None option_id
timestamp_9 INDEX None timestamp
ip_addr_9 INDEX None ip_addr
host_9 INDEX None host
agent_10 INDEX None agent
log_id_10 INDEX None log_id
log_id_11 INDEX None log_id
ip_addr_2 INDEX None ip_addr
host_2 INDEX None host
agent_2 INDEX None agent
ip_addr_3 INDEX None ip_addr
agent_3 INDEX None agent
host_3 INDEX None host
ip_addr_5 INDEX None ip_addr
agent_7 INDEX None agent
host_5 INDEX None host
ip_addr_7 INDEX None ip_addr
agent_9 INDEX None agent
host_7 INDEX None host
ip_addr_10 INDEX None ip_addr
host_10 INDEX None host
agent_11 INDEX None agent


 Space usage :
Type Usage
Data 440 Bytes
Index 3,072 Bytes
Total 3,512 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 2
Row length ø 220
Row size  ø 1,756 Bytes
Next Autoindex 3
Creation May 19, 2018 at 09:20 AM
Last update Mar 28, 2024 at 01:25 PM
Last check Apr 25, 2024 at 03:42 PM