The createid is the unique id of the user who created the record. There is an N-N relationship between companies persisted in the RelatedCompanies table. Perh

The createid is the unique id of the user who created the record. There is an N-N relationship between companies persisted in the RelatedCompanies table. Perhaps I should add a field to the RelatedCompanies table that is a description of the relationship: Subsidiary, Partnership, Spin-off. When we start, we are probably going to start listing companies without really knowing how they are related. They are just a group of companies. I considered a self-join, but we may not know who the parent is and a company may be related to more than one company through some mechanisms I don't understand yet.