The gTree function has three required input tables:
- vertices, which defines the set of vertices in the graph
- edges, which defines the set of edges in the graph
- root, which defines the set of root vertices from which the function starts traversing the graph
gTree Vertices Table Schema
Column Name |
Data Type |
Description |
nodeid |
INTEGER |
Numerical ID of the vertex. |
nodestring |
VARCHAR |
Name of the vertex. |
value |
SQL numeric data type |
Value of the vertex. |
gTree Edges Table Schema
Column Name |
Data Type |
Description |
nodeid |
INTEGER |
Numerical ID of the vertex at which the edge starts (the source node of the edge). |
nodestring |
VARCHAR |
Name of the vertex at which the edge starts. |
endnodeid |
SQL numeric data type |
Numerical ID of the vertex at which the edge ends (the target node of the edge). |
endnodestring |
VARCHAR |
Name of the vertex at which the edge ends. |
gTree Root Table Schema
Column Name |
Data Type |
Description |
nodeid |
INTEGER |
Numerical ID of the root vertex. |
nodestring |
VARCHAR |
Name of the root vertex. |
value |
SQL numeric data type |
Value of the root vertex. |