| 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. If you omit Accumulate, function copies vertex_key columns to output Vertices table for each vertex, changing the column names to id, id_1, id_2, and so on. |
| 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. |