Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: MySQL table design question

    I'm designing a workflow dbase tool and need to add a status column to the table. Question is how would I populate it with about 10 different static status types as well as timestamp and keep a history of the timestamp? I'm building a workflow tool to track steps in project mgmt process. I'm tracking off of order numbers and users and will track from start till completion of the job and keep a history of time in each status and total time overall. I'll figure out the frontend after I get the backend right.
    Thanks for any help as it's greatly appreciated, just jumping into the database world finally after avoiding it for the last 7 years in MIS.

  2. #2
    Join Date
    Mar 2004
    create a separate table with three columns
    1) an id column that relates back to your main table
    2) a status column that you enter one of the 10 or so statuses
    3) a timestamp column

    now every time you make a change to your main table add a row with these three values to your status table. you can refer back to any state and any date/time in relation to an id from your main table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts