title: Using a SQL table to handle state transitions
body: <p>I am working on a Order (MVC) system where the orders transition to different states, i.e new order, paid, shipped, etc.  Each state can have multiple transitions.  Originally I thought I would have a status table with an ID and Description and then a transition table that would have current status and transitions status, with each transition on a single row.  In order to populate a selection box, I would have to do the join to get the descriptions.  Now I am thinking I could do it all in one table and add a comma separate column which would list the possible transitions.  Is this a good idea or is there a better way?</p>