goal: looking nice method , idea log field changes. ideal logging way case below?
case: need better db update logs ecommerce site. log product updates date. existing logs, have no idea specific changes on fields. ok, product deluxe updated. field changed? price, color or 1 of other 20 fields?
i have 2 tables , (for simple view) sampled tables few fields
table1: product
id name price cat color 1 deluxe 10 plate white 2 tdog 20 cup blue ... table2: log
id name date 1 deluxe 2015-05-05 2 tdog 2015-05-04 ... my existing logs these
- deluxe-1 updated @ 2015-05-05 - tdog-2 updated @ 2015-05-04 my logs should below
- deluxe-1's price updated (from 10 20) @ 2015-05-05 - tdog-2's price updated (from 20 30), color updated (from blue green) @ 2015-05-04
Comments
Post a Comment