0
With the intention of describing how you could do this with a hierarchical key/value pairs table, supporting foreign keys, I've built the following tiny test-bed of code that allows exploring how the structure might work.
Do this in tempdb, to avoid killing anything "interesting":
USE tempdb;
I...