Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal_eventsextcal_events
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Table holding events and their attributes

SQL-query
SQL-query: 
SELECT *
FROM `extcal_events`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport