mysql.puroparty.com
puroparty
extcal_2events
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: extcal_2events
|
| 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 |
| user_id | int(11) | No | 0 |
| group_id | int(11) | No | 0 |
| showevent | char(1) | No | 3 |
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||