Index parent column on child tables

Child table `parent` column was not indexed on PostgreSQL, causing sequential scans on child-row loads and subqueries.