> 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
