The dimension of nested array, a dimension is a hint of nested array table name, and index name.
For example, the following JsonObject is a 3 dimension nested array,
{
"default": {"nested": [[["dimension 3"]]]}
}
each dimension reference with a table, total 3 tables will be generated:
default_nested
default_nested_dim2
default_nested_dim2_dim3
The nested array contains it's index of it's parent array, the return of query
'SELECT * FROM default_nested_dim2_dim3' looks
+-------------+--------------------+-------------------------+------------------------------+--------------------------+
| ID | default_nested_idx | default_nested_dim2_idx | default_nested_dim2_dim3_idx | default_nested_dim2_dim3 |
+-------------+--------------------+-------------------------+------------------------------+--------------------------+
| nestedArray | 0 | 0 | 0 | dimension 3 |
+-------------+--------------------+-------------------------+------------------------------+--------------------------+