SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 07:07 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `extcal_groups` PROCEDURE ANALYSE();
Rows: 11

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.extcal_groups.group_id 1 5 1 1 0 0 3.0000 1.4142 ENUM('1','2','3','4','5') NOT NULL
puroparty.extcal_groups.group_name Administrators Moderators 6 14 0 0 9.4000 NULL ENUM('Administrators','Anonymous','Approved','Bann...
puroparty.extcal_groups.description Group of anonymous users Users that are approved to add events. 17 46 0 0 34.0000 NULL ENUM('Group of anonymous users','Members of this g...
puroparty.extcal_groups.has_admin_access 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.extcal_groups.can_manage_accounts 1 1 1 1 4 0 0.2000 0.4000 ENUM('0','1') NOT NULL
puroparty.extcal_groups.can_change_settings 1 1 1 1 4 0 0.2000 0.4000 ENUM('0','1') NOT NULL
puroparty.extcal_groups.can_manage_cats 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.extcal_groups.upl_need_approval 0 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL
puroparty.extcal_groups.locked 1 1 1 1 2 0 0.6000 0.4899 ENUM('0','1') NOT NULL
puroparty.extcal_groups.can_edit_events 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.extcal_groups.can_create_events 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL