how can one create relationships between entities involving more than one field per table? What I mean is something that in SQL would look like:
a.structureid = b.structureid
and a.summary_key = b.summary_key
is creating two separate
relationships between the same two entities ok , or is there a better way to do it?