I wonder if someone could help me through this problem.
I have a settings table. Every user has the same starting base settings table with the same number of columns although content is different. It has column A and column B as dimensions to this table.
I have multiple users.
User 1 may want to add via new columns or dimensions to the table with customised headers - they may want 1 or 2 or 3 new columns/dimensions
User 2 may want to add 10 new dimensions to the table with their own customised headers for the columns.
The cell contents would be different for both user 1 and user 2.
How would I manage this in terms of storage? Would you store "settings" for user 1 and user 2 separately in the Postres database and then load these when the user selects the table component?
After this I then have a fact table and users will be able to tag their transactions users the dimensions unique to them in the other settings table.
In the end the final settings table will look completely different depending on the user logged in.