We have an org chart in which the levels are currently organized alphabetically.
We would like to make this user adjustable and would like to do so in a way that is easy for users and fast for the database.
What would be an efficient schema for organizing the display order.
The order entry will have to occur in an automated process. With the record id of the node the user has clicked and the record id of the node the user is putting it beside.
The schema has to allow the user to adjust the order an unlimited number of times.