select community_type, supertype, pretty_name, description from dotlrn_community_types order by community_type