'ER Database - Track History
I am designing a database to captures personnel tied to office codes. The problem is that occasionally the office codes will change due to re-orgs. My questions is what is the best way to track this change in an ER database?
Would a LUT be appropriate where I generate a set of ID numbers for current orgs with revision number (baseline everything to 0). Then use that ID + REV as Primary Key.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|