Define please those FKs on the DB schema. Currently it's a nightmare to follow the DB on any issue, where the admin wants to fix something. Also, according to the DB schema (by the defined FKs), making indexes for increasing performance is much much much much much much much ... more simple.