You've seen this pattern. You might have written it yourself. I know I did.



CREATE TABLE audit_log (
id SERIAL PRIMARY KEY,
user_id TEXT NOT NULL,
action TEXT NOT NULL,
resource TEXT,
metadata JSONB,
created_at TIMESTAMPTZ DEFAULT now()
);






Every time something important happens — a user signs a contract, an...