CREATE TABLE idempotency_keys ( user_id uuid NOT NULL REFERENCES users(id), method text NOT NULL, path text NOT NULL, key text NOT NULL, request_hash text NOT NULL, status_code int, response_body text, created_at timestamptz NOT NULL DEFAULT clock_timestamp(), PRIMARY KEY (user_id, method, path, key) ); CREATE INDEX idempotency_keys_created_at_idx ON idempotency_keys (created_at);