One reason for not getting an answer yet might be a missing table structure (reduced to the relevant columns) with some sample data so we can visualize the design.

For some of us the reference to an "object" (like "...the object only had four states..") probably is more confusing than helpful.

But you're right, we could have asked for clarification. And herewith that's what I do: please clarify. 😉