Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 06:12 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_events` PROCEDURE ANALYSE();
Rows: 22
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal_events.id | 4 | 127 | 1 | 3 | 0 | 0 | 65.9421 | 35.0547 | TINYINT(3) UNSIGNED NOT NULL |
puroparty.extcal_events.title | 15th Annual Go Tejano Committee Mariachi Invitatio... | Walkout | 4 | 81 | 0 | 0 | 23.5868 | NULL | ENUM('15th Annual Go Tejano Committee Mariachi Inv... |
puroparty.extcal_events.description | " A Night of Legends&qu... | • Events 1:00-4:30 pm\r\n• Sammy Kershaw 4:30-6:00 p... | 4 | 720 | 0 | 0 | 180.2810 | NULL | TEXT NOT NULL |
puroparty.extcal_events.contact | www.PCCookers.com | 0 | 156 | 67 | 0 | 20.2149 | NULL | ENUM('','(210) 271-3151','(210) 674-5507 or (210) ... | |
puroparty.extcal_events.url | www.wbcalaredo.org/index.html | 0 | 100 | 81 | 0 | 8.9421 | NULL | ENUM('','beasislandclub.com','milbyhispanic.org','... | |
puroparty.extcal_events.email | www.roymezas.com | 0 | 38 | 78 | 0 | 8.0826 | NULL | ENUM('','adeleon7@sbcglobal.net','annbenavidez@sbc... | |
puroparty.extcal_events.picture | f607_charrodays.jpg | 0 | 24 | 113 | 0 | 1.3140 | NULL | ENUM('','028a_charrodays.jpg','2dfb_conjuntoposter... | |
puroparty.extcal_events.cat | 1 | 7 | 1 | 1 | 0 | 0 | 2.4298 | 1.1701 | ENUM('1','2','3','4','5','7') NOT NULL |
puroparty.extcal_events.day | 1 | 30 | 1 | 2 | 0 | 0 | 15.6281 | 8.0352 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_events.month | 1 | 12 | 1 | 2 | 0 | 0 | 4.5372 | 3.4186 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_events.year | 2006 | 2007 | 4 | 4 | 0 | 0 | 2006.0083 | 0.0905 | ENUM('2006','2007') NOT NULL |
puroparty.extcal_events.approved | 1 | 1 | 1 | 1 | 46 | 0 | 0.6198 | 0.4854 | ENUM('0','1') NOT NULL |
puroparty.extcal_events.start_date | 2006-01-05 08:00:00 | 2007-02-03 18:30:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-05 08:00:00','2006-01-06 08:00:00','... |
puroparty.extcal_events.end_date | 2006-01-05 23:59:59 | 2007-02-03 23:59:59 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2006-01-05 23:59:59','2006-01-06 23:59:59','... |
puroparty.extcal_events.recur_type | year | 0 | 4 | 111 | 0 | 0.3223 | NULL | ENUM('','day','week','year') NOT NULL | |
puroparty.extcal_events.recur_val | 0 | 1 | 1 | 1 | 111 | 0 | 0.0826 | 0.2753 | ENUM('0','1') NOT NULL |
puroparty.extcal_events.recur_end_type | 0 | 2 | 1 | 1 | 112 | 0 | 0.1322 | 0.4801 | ENUM('0','1','2') NOT NULL |
puroparty.extcal_events.recur_count | 1 | 10 | 1 | 2 | 0 | 0 | 1.0826 | 0.8191 | ENUM('1','2','10') NOT NULL |
puroparty.extcal_events.recur_until | 2006-01-04 | 2007-06-26 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2006-01-04','2006-01-05','2006-01-06','2006-... |
puroparty.extcal_events.user_id | 0 | 0 | 1 | 1 | 121 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.extcal_events.group_id | 0 | 0 | 1 | 1 | 121 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.extcal_events.showevent | 3 | 3 | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('3') NOT NULL |