Let's continue exploring the design space of storing either/or data. In this part we discuss three arrangements: main table, side-table and per-attribute tables.
Unless you are already familiar with Anchor modeling it has many similarities with what you are discussing here. Particularly separating each attribute into its own table.
Unless you are already familiar with Anchor modeling it has many similarities with what you are discussing here. Particularly separating each attribute into its own table.
https://www.anchormodeling.com/