Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 09:20 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `poll_data` PROCEDURE ANALYSE();
Rows: 6
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.poll_data.id | 1 | 23 | 1 | 2 | 0 | 0 | 12.0000 | 6.6332 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23') NOT NULL |
puroparty.poll_data.poll_id | 1 | 4 | 1 | 1 | 0 | 0 | 2.2174 | 1.0197 | ENUM('1','2','3','4') NOT NULL |
puroparty.poll_data.option_id | 1 | 7 | 1 | 1 | 0 | 0 | 3.6087 | 1.9278 | ENUM('1','2','3','4','5','6','7') NOT NULL |
puroparty.poll_data.option_text | ASP | WindowsNT | 3 | 23 | 0 | 0 | 7.4783 | NULL | ENUM('ASP','BSD','DB/2','FreeBSD','I will sit this one out','I will vote for McCain','I will vote for Obama','JSP','Linux','MS SQL','MySQL','Oracle','other','Perl','PHP','PostgreSQL','Python','Solaris','Sybase','Unix','WindowsNT') NOT NULL |
puroparty.poll_data.color | aqua | yellow | 3 | 6 | 0 | 0 | 4.5217 | NULL | ENUM('aqua','blue','brown','gold','green','grey','orange','pink','purple','red','yellow') NOT NULL |
puroparty.poll_data.votes | 2 | 105 | 1 | 3 | 0 | 0 | 25.9565 | 26.9871 | ENUM('2','3','4','6','7','9','10','12','15','16','17','20','25','29','31','34','51','67','91','105') NOT NULL |