Sketch

The way you've explained it's not necessary, I think.
For someone quiet lost in explanation own sketch might help.
Don't know if you've ever read 100 Years of Solitude from García Márquez, 7 generations of same family, a "ton" of people with the same name and surname, I have to read twice and make a sketch to not get lost lol.

Ok understood, it's mainly SQL.