Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal_2eventsextcal_2events

extcal_2events

Table comments : Table holding events and their attributes

Field Type Null Default
id  int(11) No   
title  varchar(255) No   
description  text No   
contact  text No   
url  varchar(100) No   
email  varchar(120) No   
picture  varchar(100) No   
cat  tinyint(2) No 
day  tinyint(2) No 
month  smallint(2) No 
year  smallint(4) No 
approved  tinyint(1) No 
start_date  datetime No  0000-00-00 00:00:00 
end_date  datetime Yes  0000-00-00 00:00:00 
recur_type  varchar(16) Yes  NULL 
recur_val  tinyint(4) Yes 
recur_end_type  tinyint(1) No 
recur_count  tinyint(3) No 
recur_until  date Yes  0000-00-00 
user_id  int(11) No 
group_id  int(11) No 
showevent  char(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 26 id
id_2 UNIQUE 26 id
id_3 UNIQUE 26 id
start_date_4 UNIQUE 26 start_date
start_date INDEX None start_date
user_id INDEX None user_id
id INDEX None id
title INDEX None title
url INDEX None url
email INDEX None email
picture INDEX None picture
cat INDEX None cat
day INDEX None day
month INDEX None month
year INDEX None year
approved INDEX None approved
start_date_2 INDEX None start_date
end_date INDEX None end_date
recur_type INDEX None recur_type
recur_val INDEX None recur_val
recur_end_type INDEX None recur_end_type
recur_count INDEX None recur_count
recur_until INDEX None recur_until
user_id_2 INDEX None user_id
group_id INDEX None group_id
showevent INDEX None showevent
end_date_2 INDEX None end_date
user_id_3 INDEX None user_id
recur_val_2 INDEX None recur_val
email_3 INDEX None email
recur_until_2 INDEX None recur_until
year_2 INDEX None year
approved_2 INDEX None approved
recur_type_3 INDEX None recur_type
url_4 INDEX None url
month_2 INDEX None month
picture_4 INDEX None picture
cat_2 INDEX None cat
day_2 INDEX None day
recur_end_type_2 INDEX None recur_end_type
title_4 INDEX None title
id_4 INDEX None id
showevent_2 INDEX None showevent
start_date_3 INDEX None start_date
recur_count_2 INDEX None recur_count
group_id_2 INDEX None group_id
recur_val_3 INDEX None recur_val
month_3 INDEX None month
year_3 INDEX None year
email_5 INDEX None email
title_2 INDEX None title
description INDEX None description
contact INDEX None contact
url_2 INDEX None url
email_2 INDEX None email
picture_2 INDEX None picture
recur_type_2 INDEX None recur_type
contact_2 INDEX None contact
title_3 INDEX None title
picture_3 INDEX None picture
recur_type_4 INDEX None recur_type
url_3 INDEX None url
description_2 INDEX None description
email_4 INDEX None email


 Space usage :
Type Usage
Data 9,736 Bytes
Index 4,096 Bytes
Total 13,832 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 26
Row length ø 374
Row size  ø 532 Bytes
Next Autoindex 33
Creation Oct 31, 2017 at 06:08 AM
Last update Jun 03, 2018 at 01:25 PM
Last check Jun 16, 2018 at 07:44 AM