{"table_name":"clientoctopus_ai_usage_logs","full_table_name":"wp_clientoctopus_ai_usage_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clientoctopus_ai_usage_logs ( id INT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, proposal_id INT DEFAULT NULL, action VARCHAR(50) DEFAULT NULL, tokens_input INT DEFAULT NULL, tokens_output INT DEFAULT NULL, cost_usd DECIMAL(10,4) DEFAULT NULL, timestamp DATETIME DEFAULT NULL, month VARCHAR(7) DEFAULT NULL, PRIMARY KEY (id), KEY user_month (user_id, month), KEY timestamp (timestamp), KEY proposal_id (proposal_id), KEY action (action) ) $charset_collate;\" );","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"user_id","type":"INT","nullable":false,"primary_key":false},{"name":"proposal_id","type":"INT","nullable":true,"primary_key":false},{"name":"action","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"tokens_input","type":"INT","nullable":true,"primary_key":false},{"name":"tokens_output","type":"INT","nullable":true,"primary_key":false},{"name":"cost_usd","type":"DECIMAL(10,4)","nullable":true,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":true,"primary_key":false},{"name":"month","type":"VARCHAR(7)","nullable":true,"primary_key":false}],"plugin":{"slug":"clientoctopus","name":"Client Octopus","active_installs":0,"version":"1.4.1","wp_org_url":"https://wordpress.org/plugins/clientoctopus/"}}