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

extcal_2groups

Table comments : Table holding user groups

Field Type Null Default
group_id  int(11) No   
group_name  varchar(255) No   
description  varchar(255) No   
has_admin_access  tinyint(1) No 
can_manage_accounts  tinyint(1) No 
can_change_settings  tinyint(1) No 
can_manage_cats  tinyint(1) No 
can_create_events  tinyint(1) No 
can_edit_events  tinyint(1) No 
can_submit_events  tinyint(1) No 
upl_need_approval  tinyint(1) No 
locked  tinyint(1) No 


 Indexes :
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 :
Type Usage
Data 296 Bytes
Index 3,072 Bytes
Total 3,368 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 5
Row length ø 59
Row size  ø 674 Bytes
Next Autoindex 6
Creation Jan 17, 2018 at 05:04 PM
Last update Apr 07, 2018 at 05:24 PM
Last check Apr 07, 2018 at 05:24 PM