create indexes for child / parent relationships