Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 05:58 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_categories` PROCEDURE ANALYSE();
Rows: 8
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.extcal_categories.cat_id | 1 | 9 | 1 | 1 | 0 | 0 | 5.0000 | 2.5820 | ENUM('1','2','3','4','5','6','7','8','9') NOT NULL |
puroparty.extcal_categories.cat_parent | 0 | 0 | 1 | 1 | 9 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.extcal_categories.cat_name | Austin | West Texas | 5 | 17 | 0 | 0 | 9.3333 | NULL | ENUM('Austin','Dallas/Fort Worth','Houston','Mexico','Other','Out of State','San Antonio','The Valley','West Texas') NOT NULL |
puroparty.extcal_categories.description | All Other Places | The West | 6 | 24 | 0 | 0 | 12.2222 | NULL | ENUM('All Other Places','DFW Area','El Valle','Greater San Anto','Hill Country','Mexico','Not in Texas','The Greater Houston Area','The West') NOT NULL |
puroparty.extcal_categories.color | #000000 | tan | 3 | 7 | 0 | 0 | 5.2222 | NULL | ENUM('#000000','#663333','#9900CC','#FF9900','green','lime','navy','red','tan') NOT NULL |
puroparty.extcal_categories.bgcolor | #EEF0F0 | #EEF0F0 | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('#EEF0F0') NOT NULL |
puroparty.extcal_categories.options | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.extcal_categories.enabled | 1 | 1 | 1 | 1 | 1 | 0 | 0.8889 | 0.3143 | ENUM('0','1') NOT NULL |