Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 10:34 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_1categories` 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_1categories.cat_id | 1 | 53944 | 1 | 5 | 0 | 0 | 2848.1579 | 12043.4065 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.extcal_1categories.cat_parent | 0 | 9 | 1 | 1 | 18 | 0 | 0.4737 | 2.0097 | ENUM('0','9') NOT NULL |
puroparty.extcal_1categories.cat_name | 1511878819 | wharton and more | 3 | 16 | 0 | 0 | 8.0000 | NULL | ENUM('1511878819','arizona','austin','beaumont','c... |
puroparty.extcal_1categories.description | \0 | wharton, el campo, bay city | 1 | 28 | 0 | 0 | 15.6316 | NULL | ENUM('\0','austin msa','beaumont/port arthur area'... |
puroparty.extcal_1categories.color | #000000 | 3872 | 4 | 7 | 0 | 0 | 6.8421 | NULL | ENUM('#000000','#0066CC','#00FF00','#33FFCC','#505... |
puroparty.extcal_1categories.bgcolor | #EEF0F0 | 2070-08-29 | 7 | 10 | 0 | 0 | 7.1579 | NULL | ENUM('#EEF0F0','2070-08-29') NOT NULL |
puroparty.extcal_1categories.options | 0 | 53 | 1 | 2 | 1 | 0 | 4.5789 | 11.4217 | ENUM('0','2','53') NOT NULL |
puroparty.extcal_1categories.enabled | 1 | 1 | 1 | 1 | 1 | 0 | 0.9474 | 0.2233 | ENUM('0','1') NOT NULL |