3 ms·
What's the point of the createid fields? And why do you hardcode two related companies instead of going for a N-N relationship?
by abolibibelot 17y ago
What's the point of the createid fields? And why do you hardcode two related companies instead of going for a N-N relationship?
- fnid2 17y agoThe 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.