Server: mysql.puroparty.com | Database: puroparty | Table: extcal2_events |
Field | Type | Null | Default |
---|---|---|---|
id | int(11) | No | |
title | varchar(255) | No | |
description | text | No | |
contact | text | No | |
url | varchar(100) | No | |
varchar(120) | No | ||
picture | varchar(100) | No | |
cat | tinyint(2) | No | 0 |
day | tinyint(2) | No | 0 |
month | smallint(2) | No | 0 |
year | smallint(4) | No | 0 |
approved | tinyint(1) | No | 0 |
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 | 0 |
recur_end_type | tinyint(1) | No | 0 |
recur_count | tinyint(3) | No | 0 |
recur_until | date | Yes | 0000-00-00 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 28 | id | |
id | UNIQUE | 28 | id | |
id_3 | UNIQUE | 28 | id | |
id_5 | UNIQUE | 28 | id | |
email_6 | UNIQUE | 28 | ||
start_date | INDEX | None | start_date | |
id_2 | INDEX | None | id | |
title | INDEX | None | title | |
url | INDEX | None | url | |
INDEX | None | |||
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 | |
day_2 | INDEX | None | day | |
url_3 | INDEX | None | url | |
email_3 | INDEX | None | ||
picture_3 | INDEX | None | picture | |
recur_until_2 | INDEX | None | recur_until | |
month_2 | INDEX | None | month | |
recur_val_2 | INDEX | None | recur_val | |
cat_2 | INDEX | None | cat | |
year_2 | INDEX | None | year | |
recur_type_3 | INDEX | None | recur_type | |
title_3 | INDEX | None | title | |
id_4 | INDEX | None | id | |
start_date_3 | INDEX | None | start_date | |
end_date_2 | INDEX | None | end_date | |
approved_2 | INDEX | None | approved | |
recur_count_2 | INDEX | None | recur_count | |
recur_end_type_2 | INDEX | None | recur_end_type | |
recur_end_type_3 | INDEX | None | recur_end_type | |
day_3 | INDEX | None | day | |
picture_5 | INDEX | None | picture | |
end_date_3 | INDEX | None | end_date | |
recur_count_3 | INDEX | None | recur_count | |
recur_type_5 | INDEX | None | recur_type | |
start_date_4 | INDEX | None | start_date | |
title_2 | INDEX | None | title | |
description | INDEX | None | description | |
contact | INDEX | None | contact | |
url_2 | INDEX | None | url | |
email_2 | INDEX | None | ||
picture_2 | INDEX | None | picture | |
recur_type_2 | INDEX | None | recur_type | |
recur_type_4 | INDEX | None | recur_type | |
url_4 | INDEX | None | url | |
title_4 | INDEX | None | title | |
email_4 | INDEX | None | ||
description_2 | INDEX | None | description | |
picture_4 | INDEX | None | picture | |
contact_2 | INDEX | None | contact | |
email_5 | INDEX | None | ||
url_5 | INDEX | None | url | |
picture_6 | INDEX | None | picture |
Space usage :
|
Row Statistic :
|