Databases

Audit Logging and Change Tracking Schema

ER Diagrams · made in Skemio

ER diagram of an audit logging schema showing users, audit events, field diffs, and security contexts.
ER diagram of an audit logging schema showing users, audit events, field diffs, and security contexts.
Open it in SkemioMake your own

What it shows

  • Grant INSERT only to audit tables to guarantee strict immutability.
  • Split audit event metadata from field-level diff payloads.
  • Record user identity, IP address, and operational reason codes.

The takeaway

Never overwrite historical state without an append-only audit log linking users, diffs, and context.

More er diagrams