Overview
Consent and Retention
Consent is a record, not a checkbox; retention is a daily delete job.
Why it matters
Most regulators care less about your privacy policy and more about whether your system actually honours it (deletes when consent is withdrawn, ages out beyond retention).
Going deeper
The engineering behind Retention and Consent:
- Immutable Consent Logs: A consent table should be append-only.
(user_id, granted, purpose, timestamp, policy_version). When they withdraw, you append a new rowgranted = false. - Time-to-Live (TTL): Modern systems use TTL configurations on storage layers (like DynamoDB TTL or S3 Lifecycle policies) to automate retention.
- Tombstone tables: In an RDBMS, instead of running random DELETE queries, teams often move expired data to a cold tombstone table, which is periodically wiped by an automated, auditable script.
If retention requires a human to remember to run a script, you are already non-compliant.