want to have a table that holds information about a task. PriorityId, StateId, AssignedToUserId etc. These columns can be updated. I'd like to be able to list the history of a task, showing the changes, and the user who made the changes. The table will have an UpdateUserId table with the user who did the update.
Column history for keeping history
stackoverflow.com