Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 24, 2024 at 05:06 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_2events` 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_2events.id | 6 | 32 | 1 | 2 | 0 | 0 | 19.4615 | 7.5663 | ENUM('6','8','9','10','11','12','13','14','15','16... |
| puroparty.extcal_2events.title | BBQ Cook Off | Tourney Tuesday | 5 | 85 | 0 | 0 | 21.2692 | NULL | ENUM('BBQ Cook Off','Beas Friday','Benefit Dance',... |
| puroparty.extcal_2events.description | One of A Kind Cookers\r\n ... | [I][CENTER]The Houston Livestock Show & Rodeo and ... | 7 | 1149 | 0 | 0 | 249.8077 | NULL | ENUM(' One of A Kind Cookers\r\n... |
| puroparty.extcal_2events.contact | 1-800-726-1313 | Shirley 713-828-8551\r\nButch 281-228-3423 | 12 | 140 | 3 | 0 | 33.6154 | NULL | ENUM('','1-800-726-1313','713-645-8400','713-910-3... |
| puroparty.extcal_2events.url | PuroParty | www.sarodeo.com/ | 9 | 33 | 13 | 0 | 7.2308 | NULL | ENUM('','PuroParty','puroparty.com','puroparty.com... |
| puroparty.extcal_2events.email | quinces@latina.com | 0 | 27 | 16 | 0 | 8.3846 | NULL | ENUM('','dude_21@hotmail.com','emilylarcos@yahoo.c... | |
| puroparty.extcal_2events.picture | 4a57_JimmyEdwardItsAllRight2.jpg | 0 | 32 | 24 | 0 | 1.9231 | NULL | ENUM('','2529_littlejoe.jpg','4a57_JimmyEdwardItsA... | |
| puroparty.extcal_2events.cat | 1 | 3 | 1 | 1 | 0 | 0 | 2.0769 | 0.3846 | ENUM('1','2','3') NOT NULL |
| puroparty.extcal_2events.day | 3 | 31 | 1 | 2 | 0 | 0 | 14.7308 | 7.3983 | ENUM('3','5','6','9','10','11','12','13','14','17'... |
| puroparty.extcal_2events.month | 1 | 5 | 1 | 1 | 0 | 0 | 2.6538 | 1.2071 | ENUM('1','2','3','4','5') NOT NULL |
| puroparty.extcal_2events.year | 2007 | 2007 | 4 | 4 | 0 | 0 | 2007.0000 | 0.0000 | ENUM('2007') NOT NULL |
| puroparty.extcal_2events.approved | 1 | 1 | 1 | 1 | 8 | 0 | 0.6923 | 0.4615 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2events.start_date | 2007-01-09 08:00:00 | 2007-05-10 05:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-01-09 08:00:00','2007-01-10 08:00:00','... |
| puroparty.extcal_2events.end_date | 2007-01-09 23:59:59 | 2007-05-12 23:59:59 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-01-09 23:59:59','2007-01-10 23:59:59','... |
| puroparty.extcal_2events.recur_type | week | 0 | 4 | 21 | 0 | 0.7308 | NULL | ENUM('','day','week') NOT NULL | |
| puroparty.extcal_2events.recur_val | 0 | 1 | 1 | 1 | 21 | 0 | 0.1923 | 0.3941 | ENUM('0','1') NOT NULL |
| puroparty.extcal_2events.recur_end_type | 0 | 2 | 1 | 1 | 19 | 0 | 0.4231 | 0.7428 | ENUM('0','1','2') NOT NULL |
| puroparty.extcal_2events.recur_count | 1 | 4 | 1 | 1 | 0 | 0 | 1.2308 | 0.7994 | ENUM('1','4') NOT NULL |
| puroparty.extcal_2events.recur_until | 2007-01-08 | 2007-04-10 | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('2007-01-08','2007-01-15','2007-01-26','2007-... |
| puroparty.extcal_2events.user_id | 0 | 3 | 1 | 1 | 19 | 0 | 0.6538 | 1.1748 | ENUM('0','1','3') NOT NULL |
| puroparty.extcal_2events.group_id | 0 | 5 | 1 | 1 | 19 | 0 | 0.8077 | 1.6177 | ENUM('0','1','2','5') NOT NULL |
| puroparty.extcal_2events.showevent | 3 | 3 | 1 | 1 | 13 | 0 | 0.5000 | NULL | ENUM('','3') NOT NULL |