CREATE TABLE IF NOT EXISTS message_idempotency ( user_id UUID NOT NULL REFERENCES users(id), chat_id UUID NOT NULL REFERENCES chats(id), idempotency_key VARCHAR(128) NOT NULL, request_hash CHAR(64) NOT NULL, message_id UUID NOT NULL REFERENCES messages(id), created_at TIMESTAMPTZ NOT NULL DEFAULT clock_timestamp(), PRIMARY KEY (user_id, chat_id, idempotency_key) ); CREATE INDEX IF NOT EXISTS idx_idempotency_created ON message_idempotency(created_at);