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

extcal2_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 


 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_name_4 UNIQUE 5 group_name
group_id_4 UNIQUE 5 group_id
description_8 UNIQUE 5 description
group_name_8 UNIQUE 5 group_name
group_id_5 UNIQUE 5 group_id
group_name_10 UNIQUE 5 group_name
description_10 UNIQUE 5 description
group_id_8 UNIQUE 5 group_id
group_name_13 UNIQUE 5 group_name
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
has_admin_access_2 INDEX None has_admin_access
upl_need_approval_2 INDEX None upl_need_approval
description_5 INDEX None description
locked_2 INDEX None locked
group_id_3 INDEX None group_id
can_manage_accounts_2 INDEX None can_manage_accounts
group_name_5 INDEX None group_name
can_change_settings_2 INDEX None can_change_settings
can_manage_cats_2 INDEX None can_manage_cats
group_name_7 INDEX None group_name
can_change_settings_3 INDEX None can_change_settings
locked_3 INDEX None locked
has_admin_access_3 INDEX None has_admin_access
can_manage_accounts_3 INDEX None can_manage_accounts
can_manage_cats_3 INDEX None can_manage_cats
upl_need_approval_3 INDEX None upl_need_approval
description_9 INDEX None description
group_id_6 INDEX None group_id
has_admin_access_4 INDEX None has_admin_access
can_manage_accounts_4 INDEX None can_manage_accounts
locked_4 INDEX None locked
group_id_7 INDEX None group_id
group_name_11 INDEX None group_name
description_11 INDEX None description
upl_need_approval_4 INDEX None upl_need_approval
can_change_settings_4 INDEX None can_change_settings
can_manage_cats_4 INDEX None can_manage_cats
can_manage_accounts_5 INDEX None can_manage_accounts
locked_5 INDEX None locked
has_admin_access_5 INDEX None has_admin_access
description_13 INDEX None description
can_change_settings_5 INDEX None can_change_settings
group_id_9 INDEX None group_id
group_name_3 INDEX None group_name
description_3 INDEX None description
description_6 INDEX None description
group_name_6 INDEX None group_name
description_7 INDEX None description
group_name_9 INDEX None group_name
description_12 INDEX None description
group_name_12 INDEX None group_name


 Space usage :
Type Usage
Data 276 Bytes
Index 3,072 Bytes
Total 3,348 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 5
Row length ø 55
Row size  ø 670 Bytes
Next Autoindex 6
Creation Feb 25, 2018 at 08:57 AM
Last update Feb 25, 2018 at 08:57 AM
Last check Apr 03, 2018 at 08:22 AM