History: keep every version
An UPDATE forgets what was true before. Keep a row per version instead: ask what anything cost on any date, and let the database keep exactly one current price.
Checking your access…
An UPDATE forgets what was true before. Keep a row per version instead: ask what anything cost on any date, and let the database keep exactly one current price.
Checking your access…