All Questions
1 question
1
vote
1
answer
595
views
Design recommendations for a history/audit table
I need to keep track of many items and their states throughout time.
Example
ItemId Location DateTime State
1 Mall A 2010-02-03 07:00 on_sale
1 Mall A 2010-02-20 08:22 ...
- 2,161