Table | Description |
---|---|
Community vertex table | Has a row of modularity results for each specified resolution level. |
CommunityEdgeTable | [Optional] Contains edge weights (strengths) between different communities at specified resolutions. Function creates this table on database but does not display it as output. To display this table, use command SELECT * FROM community_edge_table . |
Community Vertex Table Schema (Default Resolution)
Column | Data Type | Description |
---|---|---|
accumulate_column | Same as in Vertices table | Column appears once for each specified accumulate_column.] Column copied from Vertices table. |
resolution | DOUBLE PRECISION | Resolution at which modularity score is computed. |
community_id | VARCHAR or Same as in Vertices table | Identifier of community to which vertex belongs. |
num_communities | INTEGER | Number of communities at this resolution. (Same for each resolution level.) |
modularity_score | DOUBLE PRECISION | Modularity score at this resolution. (Same for each resolution level.) |
CommunityEdgeTable Schema
Column | Data Type | Description |
---|---|---|
src_community_id | Same as in Vertices table or VARCHAR | Identifier of first community of edge. |
target_community_id | Same as in Vertices table or VARCHAR | Identifier of second community of edge. |
resolution | DOUBLE PRECISION | Resolution at which modularity score is computed. |
weight | DOUBLE PRECISION | Strength of link from first community to second community. |