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

extcal_groups

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 
upl_need_approval  tinyint(1) No 
locked  tinyint(1) No 
can_edit_events  tinyint(1) No 
can_create_events  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
group_name_4 UNIQUE 5 group_name
group_id_3 UNIQUE 5 group_id
description_5 UNIQUE 5 description
description_7 UNIQUE 5 description
group_id_5 UNIQUE 5 group_id
group_name_9 UNIQUE 5 group_name
group_id_7 UNIQUE 5 group_id
group_name_10 UNIQUE 5 group_name
description_10 UNIQUE 5 description
can_manage_accounts_5 UNIQUE 5 can_manage_accounts
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
upl_need_approval INDEX None upl_need_approval
locked INDEX None locked
can_edit_events INDEX None can_edit_events
can_create_events INDEX None can_create_events
upl_need_approval_2 INDEX None upl_need_approval
locked_2 INDEX None locked
can_manage_accounts_2 INDEX None can_manage_accounts
can_edit_events_2 INDEX None can_edit_events
can_change_settings_2 INDEX None can_change_settings
group_id_4 INDEX None group_id
group_name_5 INDEX None group_name
description_4 INDEX None description
can_manage_cats_2 INDEX None can_manage_cats
can_create_events_2 INDEX None can_create_events
has_admin_access_2 INDEX None has_admin_access
locked_3 INDEX None locked
can_manage_cats_3 INDEX None can_manage_cats
upl_need_approval_3 INDEX None upl_need_approval
group_name_7 INDEX None group_name
can_change_settings_3 INDEX None can_change_settings
can_edit_events_3 INDEX None can_edit_events
description_8 INDEX None description
group_id_6 INDEX None group_id
can_create_events_3 INDEX None can_create_events
can_manage_accounts_3 INDEX None can_manage_accounts
has_admin_access_3 INDEX None has_admin_access
upl_need_approval_4 INDEX None upl_need_approval
can_create_events_4 INDEX None can_create_events
can_change_settings_4 INDEX None can_change_settings
group_id_8 INDEX None group_id
can_manage_cats_4 INDEX None can_manage_cats
locked_4 INDEX None locked
can_manage_accounts_4 INDEX None can_manage_accounts
description_11 INDEX None description
can_edit_events_4 INDEX None can_edit_events
group_name_11 INDEX None group_name
group_name_3 INDEX None group_name
description_3 INDEX None description
group_name_6 INDEX None group_name
description_6 INDEX None description
group_name_8 INDEX None group_name
description_9 INDEX None description
group_name_12 INDEX None group_name


 Space usage :
Type Usage
Data 288 Bytes
Index 3,072 Bytes
Total 3,360 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 5
Row length ø 57
Row size  ø 672 Bytes
Next Autoindex 6
Creation Jan 19, 2018 at 02:43 AM
Last update Mar 28, 2024 at 08:20 PM
Last check Apr 19, 2024 at 06:08 AM