{"table_name":"isarud_affiliate_log","full_table_name":"wp_isarud_affiliate_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_isarud_affiliate_log ( id int(11) NOT NULL AUTO_INCREMENT, affiliate_id int(11) NOT NULL, order_id bigint(20) NOT NULL, order_total decimal(14,2) DEFAULT 0, commission decimal(14,2) DEFAULT 0, status enum('pending','approved','paid') DEFAULT 'pending', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY affiliate_id (affiliate_id) ) {$charset};\");","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"affiliate_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"order_total","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"commission","type":"decimal(14,2)","nullable":true,"primary_key":false},{"name":"status","type":"enum('pending','approved','paid')","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"api-isarud","name":"API Isarud Tüm Pazar Yerleri Ticaret Entegrasyonu","active_installs":10,"version":"6.6.8","wp_org_url":"https://wordpress.org/plugins/api-isarud/"}}