Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 02:43 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal2_events` PROCEDURE ANALYSE();
Rows: 19
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal2_events.id | 2 | 30 | 1 | 2 | 0 | 0 | 16.1786 | 8.4602 | ENUM('2','3','4','5','6','7','8','9','10','12','13... |
puroparty.extcal2_events.title | 2nd event | xxxxxx | 3 | 28 | 0 | 0 | 10.7143 | NULL | ENUM('2nd event','Avizo & Los Hermanos Cortez','BI... |
puroparty.extcal2_events.description | Beas Island Club\r\ndrink specials til 11pm\r\n$1.50 f... | xxxxxxxxxxxxxxxx | 4 | 220 | 0 | 0 | 55.1429 | NULL | ENUM('Beas Island Club\r\ndrink specials til 11pm\r\n$... |
puroparty.extcal2_events.contact | dfdsfdsfsdaf | 0 | 17 | 19 | 0 | 3.9286 | NULL | ENUM('','713-910-3004','713-944-2720','713-9442720... | |
puroparty.extcal2_events.url | puroparty.com | 0 | 13 | 21 | 0 | 3.2500 | NULL | ENUM('','puroparty.com') NOT NULL | |
puroparty.extcal2_events.email | puroparty@puroparty.com | 0 | 23 | 27 | 0 | 0.8214 | NULL | ENUM('','puroparty@puroparty.com') NOT NULL | |
puroparty.extcal2_events.picture | ec5f_jump.jpg | 0 | 13 | 27 | 0 | 0.4643 | NULL | ENUM('','ec5f_jump.jpg') NOT NULL | |
puroparty.extcal2_events.cat | 1 | 10 | 1 | 2 | 0 | 0 | 5.0357 | 3.0057 | ENUM('1','2','3','5','7','8','9','10') NOT NULL |
puroparty.extcal2_events.day | 2 | 31 | 1 | 2 | 0 | 0 | 16.2500 | 11.9631 | ENUM('2','3','4','5','6','8','11','13','15','18','... |
puroparty.extcal2_events.month | 1 | 12 | 1 | 2 | 0 | 0 | 4.1429 | 4.9693 | ENUM('1','12') NOT NULL |
puroparty.extcal2_events.year | 2006 | 2007 | 4 | 4 | 0 | 0 | 2006.6786 | 0.4670 | ENUM('2006','2007') NOT NULL |
puroparty.extcal2_events.approved | 1 | 1 | 1 | 1 | 10 | 0 | 0.6429 | 0.4792 | ENUM('0','1') NOT NULL |
puroparty.extcal2_events.start_date | 2006-01-15 08:00:00 | 2007-01-31 08:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-15 08:00:00','2006-12-28 08:00:00','... |
puroparty.extcal2_events.end_date | 2006-01-15 23:59:59 | 2007-01-31 23:59:59 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-15 23:59:59','2006-12-28 23:59:59','... |
puroparty.extcal2_events.recur_type | day | 0 | 3 | 24 | 0 | 0.4286 | NULL | ENUM('','day') NOT NULL | |
puroparty.extcal2_events.recur_val | 0 | 7 | 1 | 1 | 24 | 0 | 1.0000 | 2.4495 | ENUM('0','7') NOT NULL |
puroparty.extcal2_events.recur_end_type | 0 | 2 | 1 | 1 | 24 | 0 | 0.2500 | 0.6339 | ENUM('0','1','2') NOT NULL |
puroparty.extcal2_events.recur_count | 1 | 4 | 1 | 1 | 0 | 0 | 1.4286 | 1.0498 | ENUM('1','4') NOT NULL |
puroparty.extcal2_events.recur_until | 2006-12-28 | 2007-01-31 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2006-12-28','2006-12-29','2006-12-30','2006-... |