auditor_schema.sql

-- Create transaction_logs table
CREATE TABLE IF NOT EXISTS transaction_logs (
    id SERIAL PRIMARY KEY,
    session_id INTEGER,
    agent_name TEXT,
    tool_name TEXT,
    input_data JSONB,
    output_data JSONB,
    is_compliant BOOLEAN DEFAULT TRUE,
    timestamp TIMESTAMP DEFAULT NOW()
);