Set up the Scan Result Policy Violations to introduce a running state

Reference: @mcavoj's comment in #444459 (comment 1896220476).

• Extend the scan_result_policy_violations table to include the current state of the scan
• Keep the scan_result_policy_violations table up to date with the current state of the scan