Modeling State Transitions in Postgres

Status starts as a column. Then someone asks “who was denied last Tuesday?” and the schema can’t answer. Model each status change as its own row from the start, without sacrificing read performance.