Sample Header Ad - 728x90

Data Modeling Problem - Schema to store approval process

1 vote
0 answers
38 views
I need to design a schema to keep track of data changes (I do not need Change Tracking or Change Data Capture or Temporal Tables) to columns in a few tables. When the data is created, modified, or deleted, and when they meet a certain condition, I will have to initiate a workflow to require approval of those changes from groups of users. Are there any known schema design patterns for this purpose?
Asked by DBK (378 rep)
Oct 30, 2023, 07:33 PM