So, instead of using enums for order states or originating system, I'll user numbers or text? Or implement lookup tables ?
Use a text field and a CHECK constraint if you have just a couple of states, and a lookup table if you have many.
Always use a lookup table if you plan on adding new states regularly.
Chris
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
