Many times in script reviews, feedback is about manual update history missing. There might be places where this would have slipped through as well.
I think we should solve this problem systematically. We can introduce a column for source in all the tables and if the source is manual update then this manual update history cannot be null or same as previous value. Source column can be of Enum type with values like 'Field Android App', 'Field ios App', 'DEA', 'CSV Upload', 'External API'.
Many times in script reviews, feedback is about manual update history missing. There might be places where this would have slipped through as well.
I think we should solve this problem systematically. We can introduce a column for source in all the tables and if the source is manual update then this manual update history cannot be null or same as previous value. Source column can be of Enum type with values like 'Field Android App', 'Field ios App', 'DEA', 'CSV Upload', 'External API'.