Closed coyotemarin closed 8 years ago
We should add a subsidiary table that shows subsidiary relationships between companies, much like subcategory. It should have the following fields:
subsidiary
subcategory
company
is_implied
1
root_company
We should add a
subsidiarytable that shows subsidiary relationships between companies, much likesubcategory. It should have the following fields:company: parent companysubsidiary: company owned bycompanyis_implied:1if this was implied by another relationship (e.g. grandchild company)root_company: the company at the top of this family tree, so we can easily load a corporate family tree