So, we’re receiving a data feed that looks a bit like this…
| CHILD_TYPE | CHILD_ID | PARENT_ID | PARENT_TYPE | LINKTYPE | START_DATE | END_DATE |
|---|---|---|---|---|---|---|
We have multiple entity types, which in turn have multiple link type codes, which suggests that these are a consolidated list of link tables.
Is it worth splitting them out into several link tables where the link tables are clearly labelled/named, or leaving them inside a similar structure to the above to avoid adding more tables to the design?