Column Name | Data Type | Description |
---|---|---|
node | VARCHAR | Column containing the path to the node, including the node itself. |
parent | VARCHAR | Parent of the node (path the users traveled to the node). |
children | VARCHAR | Children of the node (paths the users traveled from the node), a
list of subsequences with this
syntax:[(subsequence)[,...]] The outer brackets appear in the table. |
cnt | INTEGER or BIGINT | Count (sum) of the values in the input column count_column. |
depth | INTEGER or BIGINT | Number of steps on the path to the node. |
prefix | VARCHAR | Subsequence of the node, copied from the prefix_column of the input table. |