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

extcal_1groups

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 6 group_id
group_id_2 UNIQUE 6 group_id
group_name_2 UNIQUE 6 group_name
description_2 UNIQUE 6 description
group_id_4 UNIQUE 6 group_id
description_5 UNIQUE 6 description
group_name_6 UNIQUE 6 group_name
description_8 UNIQUE 6 description
group_id_6 UNIQUE 6 group_id
group_name_9 UNIQUE 6 group_name
group_id_8 UNIQUE 6 group_id
upl_need_approval_5 UNIQUE 6 upl_need_approval
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
can_edit_events_2 INDEX None can_edit_events
has_admin_access_2 INDEX None has_admin_access
can_change_settings_2 INDEX None can_change_settings
description_4 INDEX None description
can_create_events_2 INDEX None can_create_events
locked_2 INDEX None locked
upl_need_approval_2 INDEX None upl_need_approval
group_name_5 INDEX None group_name
can_manage_cats_2 INDEX None can_manage_cats
can_submit_events_2 INDEX None can_submit_events
can_manage_accounts_2 INDEX None can_manage_accounts
description_7 INDEX None description
can_edit_events_3 INDEX None can_edit_events
can_submit_events_3 INDEX None can_submit_events
can_manage_cats_3 INDEX None can_manage_cats
locked_3 INDEX None locked
group_name_8 INDEX None group_name
group_id_5 INDEX None group_id
can_change_settings_3 INDEX None can_change_settings
upl_need_approval_3 INDEX None upl_need_approval
has_admin_access_3 INDEX None has_admin_access
can_create_events_3 INDEX None can_create_events
can_manage_accounts_3 INDEX None can_manage_accounts
can_submit_events_4 INDEX None can_submit_events
can_change_settings_4 INDEX None can_change_settings
locked_4 INDEX None locked
can_manage_cats_4 INDEX None can_manage_cats
has_admin_access_4 INDEX None has_admin_access
group_id_7 INDEX None group_id
group_name_10 INDEX None group_name
upl_need_approval_4 INDEX None upl_need_approval
description_10 INDEX None description
can_manage_accounts_4 INDEX None can_manage_accounts
group_name_3 INDEX None group_name
description_3 INDEX None description
group_name_4 INDEX None group_name
description_6 INDEX None description
group_name_7 INDEX None group_name
description_9 INDEX None description


 Space usage :
Type Usage
Data 340 Bytes
Index 3,072 Bytes
Total 3,412 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 6
Row length ø 56
Row size  ø 569 Bytes
Next Autoindex 7
Creation Feb 23, 2018 at 07:08 PM
Last update Apr 19, 2024 at 03:05 PM
Last check Apr 19, 2024 at 03:05 PM