Just to make sure I understand your suggestion fully, you're saying:
1. Use `smallint` instead of `text` for the column type.
2. Otherwise follow our "`CHECK` constraint" approach (without it we're jeopardizing data consistency because we can store anything between -32768 and 32767 in that column).
3. Translate the int to the enum in your application.
Right?