{"table_name":"vv_affiliates","full_table_name":"wp_vv_affiliates","description":"Stores vv affiliates data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_vv_affiliates ( id bigint(20) NOT NULL AUTO_INCREMENT, referrer_vendor_id bigint(20) NOT NULL, referred_vendor_id bigint(20) NOT NULL, commission_rate decimal(5,2) NOT NULL DEFAULT 5.00, total_earned decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(20) NOT NULL DEFAULT 'active', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"referrer_vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"referred_vendor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"commission_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"total_earned","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false}],"plugin":{"slug":"aistore-multi-vendor-store","name":"VendorVerse aistore multi vendor store for WooCommerce","active_installs":0,"version":"2.0.0","wp_org_url":"https://wordpress.org/plugins/aistore-multi-vendor-store/"}}