 <p>You could consider an <code>enum</code> type. An <code>enum</code> is a defined list of possible string values, e.g:</p> <pre><code>create table stuff (status enum ("foo", "bar") not null); </code></pre>