mysql.puroparty.com
puroparty
extcal_2groups
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: extcal_2groups
|
| Field | Type | Null | Default |
|---|---|---|---|
| group_id | int(11) | No | |
| group_name | varchar(255) | No | |
| description | varchar(255) | No | |
| has_admin_access | tinyint(1) | No | 0 |
| can_manage_accounts | tinyint(1) | No | 0 |
| can_change_settings | tinyint(1) | No | 0 |
| can_manage_cats | tinyint(1) | No | 0 |
| can_create_events | tinyint(1) | No | 0 |
| can_edit_events | tinyint(1) | No | 0 |
| can_submit_events | tinyint(1) | No | 0 |
| upl_need_approval | tinyint(1) | No | 1 |
| locked | tinyint(1) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 5 | group_id | |
| group_id_2 | UNIQUE | 5 | group_id | |
| group_name_2 | UNIQUE | 5 | group_name | |
| description_2 | UNIQUE | 5 | description | |
| description_4 | UNIQUE | 5 | description | |
| group_id_4 | UNIQUE | 5 | group_id | |
| group_name_5 | UNIQUE | 5 | group_name | |
| group_name_7 | UNIQUE | 5 | group_name | |
| group_id_5 | UNIQUE | 5 | group_id | |
| description_9 | UNIQUE | 5 | description | |
| description_10 | UNIQUE | 5 | description | |
| group_id_8 | UNIQUE | 5 | group_id | |
| group_id | INDEX | None | group_id | |
| group_name | INDEX | None | group_name | |
| description | INDEX | None | description | |
| has_admin_access | INDEX | None | has_admin_access | |
| can_manage_accounts | INDEX | None | can_manage_accounts | |
| can_change_settings | INDEX | None | can_change_settings | |
| can_manage_cats | INDEX | None | can_manage_cats | |
| can_create_events | INDEX | None | can_create_events | |
| can_edit_events | INDEX | None | can_edit_events | |
| can_submit_events | INDEX | None | can_submit_events | |
| upl_need_approval | INDEX | None | upl_need_approval | |
| locked | INDEX | None | locked | |
| group_id_3 | INDEX | None | group_id | |
| group_name_4 | INDEX | None | group_name | |
| has_admin_access_2 | INDEX | None | has_admin_access | |
| can_submit_events_2 | INDEX | None | can_submit_events | |
| description_5 | INDEX | None | description | |
| can_create_events_2 | INDEX | None | can_create_events | |
| can_change_settings_2 | INDEX | None | can_change_settings | |
| upl_need_approval_2 | INDEX | None | upl_need_approval | |
| can_edit_events_2 | INDEX | None | can_edit_events | |
| can_manage_accounts_2 | INDEX | None | can_manage_accounts | |
| can_manage_cats_2 | INDEX | None | can_manage_cats | |
| locked_2 | INDEX | None | locked | |
| can_edit_events_3 | INDEX | None | can_edit_events | |
| upl_need_approval_3 | INDEX | None | upl_need_approval | |
| description_7 | INDEX | None | description | |
| group_id_6 | INDEX | None | group_id | |
| can_manage_accounts_3 | INDEX | None | can_manage_accounts | |
| can_manage_cats_3 | INDEX | None | can_manage_cats | |
| can_submit_events_3 | INDEX | None | can_submit_events | |
| group_name_9 | INDEX | None | group_name | |
| can_create_events_3 | INDEX | None | can_create_events | |
| can_change_settings_3 | INDEX | None | can_change_settings | |
| locked_3 | INDEX | None | locked | |
| has_admin_access_3 | INDEX | None | has_admin_access | |
| upl_need_approval_4 | INDEX | None | upl_need_approval | |
| group_id_7 | INDEX | None | group_id | |
| can_create_events_4 | INDEX | None | can_create_events | |
| can_change_settings_4 | INDEX | None | can_change_settings | |
| can_submit_events_4 | INDEX | None | can_submit_events | |
| description_12 | INDEX | None | description | |
| group_name_10 | INDEX | None | group_name | |
| has_admin_access_4 | INDEX | None | has_admin_access | |
| group_name_3 | INDEX | None | group_name | |
| description_3 | INDEX | None | description | |
| description_6 | INDEX | None | description | |
| group_name_6 | INDEX | None | group_name | |
| group_name_8 | INDEX | None | group_name | |
| description_8 | INDEX | None | description | |
| description_11 | INDEX | None | description | |
| group_name_11 | INDEX | None | group_name | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||