| -- 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() | |
| ); | |