I am currently undergone a project to create a relationship graph on customers. The graph scheme has been completed and tested, but I am currently having an issue with one particular situation.As per the graph schema above, I want to point every customer to their respective employer. An issue I am facing is, there are times when the employer is also my customer. In that case, I would end up having two nodes (red and purple) that are essentially the same. Ideally, I want my individual customers who work at the the employer (my customer also) to be connected by the WORK_AT relationship.
The only idea I can think of to tackle this issue is to adjust the data source (having join ID). However, if the community has any idea how to tackle this, you guys are more than welcome.
I guess you could take one of these approaches;
1. Label these nodes with both Customer and Employer labels and have a self reference of type WORK_AT. You would need the union of the properties for Customer and Employer.
2. Pick a person that works at the employer that is a client and use that person as the customer.