How to do this with two tables connected via one foreign key, that is explained a dozen times in Stackoverflow. But what if the tree is 50 tables and 120 foreign key columns? It can be done. But probably not manually.
So, as this seems a very usual use-case for normalized data, is there any tooling available? Anywhere? (I searched, I didn't find.)
