I'm looking for a some guidance/advice on how to best model my data.
Some background: I have location information that I'm trying to model. There are two categories of locations (company and non-company locations), as such, not all locations have the same data elements.
The two tables below represent my current model (without enumerating all columns).
My thoughts on the current design:
- If I combine the two tables below I will have to put in null values for
company_code, because not all locations have a
company_code. I do not want to add nulls values because of the huge number of different data elements between the two different types of locations.
locationare two important concepts in the company. I would like to have tables in the database two represent these two concepts.
I'm unclear if this is the best approach. Any thoughts on the design would be greatly appreciated. Any additional thoughts are also welcomed.
If my issue is unclear, please ask. I will graciously add clarification. Thanks in advance.