Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 08:20 PM
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','12','13','14','15','16','17','18','53944') NOT NULL |
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','california','corpus christi','dfw','General','houston','mexico','other','private','san antonio','tba','the valley','victoria','waco','west texas','wharton and more') NOT NULL |
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','corpus christi msa','dallas/fort worth msa','houston msa','lower rio grande valley','mexico events','non major msa in tx','private gigs','sa msa','state of arizona','state of california','This is the default category','to be announced','victoria msa','waco area','west tx area','wharton, el campo, bay city') NOT NULL |
puroparty.extcal_1categories.color | #000000 | 3872 | 4 | 7 | 0 | 0 | 6.8421 | NULL | ENUM('#000000','#0066CC','#00FF00','#33FFCC','#505054','#663300','#993399','#BBBBBB','#FF9900','#FFFF00','3872') NOT NULL |
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 |