Good queries are hard. Database design is hard. System architecture is hard.

My comment described the problem.

The solution is left as an exercise for the reader.

Keep in mind that people change their minds, misspeak, and use words in peculiar ways.