We have a legacy data structure which has an m:n-relationship with itself (think organizational structure where any entity can have a variable amount of child and/or parent entities). The technical realization is through a table for the entities and a table where each row describes two entities and their relationship (parent or child).