This is the same problem seen in algorithms for concurrent remote document editing, and the author seems to have re-invented some of the same solutions. See [1]

This belongs to the class of problems involving trying to represent a tree in a relational database. There are many solutions, all with some problem.

[1] https://news.ycombinator.com/item?id=24617542