enum

Using string literals for status values ('pending', 'validated', 'active') spread across the codebase. Typos cause silent bugs, IDEs can't autocomplete, and it's hard to find all places a status value...

When SQLAlchemy/SQLModel creates a table with an sa.Enum(...) column against PostgreSQL, the database auto-creates a backing named type (e.g. `passwordresetstatus`). op.drop_table removes the table bu...