Build Datatable with Type Datatable Columns

we recommend to have a quick entry into the topic iteself:

with these concepts it should be possible to find a good strategy on the datadesign and balancing redundancies and table splits.

Once the datamodelling is done, than you can map it to code. from the technicals /options still we recommend to have a closer look on: