I have a table of Companies. Within this table, some are “Operating Companies” and some are “Investors”.
I want to create another table of Holdings, with two main columns that link back to first table. Column 1 is “Operating Company” and Column 2 is “Investor”. The purpose of this table is to capture which investors own a stake in which OpCo’s. The primary key here is simply a concatenation of the two data fields, OpCo and Investor.
When I create this table, though, it introduces not one, but two new columns into my Company table. The first new column is “Holdings” and the second is “Holdings2”. I would rather have just one column for Holdings appear in the “Companies” table.
I guess I understand what is happening. If I were to separate OpCo’s and Investors into separate tables, then each of those tables would have a single column linked to Holdings table.
But there are other advantages to having all Companies in single table, so I would rather not split them off just yet. But it seems messy and inconvenient. Has anyone encountered this issue?