I am confused by the expression 'simple parent_id many-to-many child_id', because parent/child is a one-to-many relationship and many-to-many is a peer-to-peer relationship, normally implemented as parent-to-parent via a mutual child table known as a link table..