{"table_name":"dokan_vendor_balance","full_table_name":"wp_dokan_vendor_balance","description":"Stores dokan vendor balance data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_dokan_vendor_balance` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `vendor_id` bigint(20) unsigned NOT NULL, `trn_id` bigint(20) unsigned NOT NULL, `trn_type` varchar(30) NOT NULL, `perticulars` text NOT NULL, `debit` decimal(19,4) NOT NULL, `credit` decimal(19,4) NOT NULL, `status` varchar(30) DEFAULT NULL, `trn_date` timestamp NOT NULL, `balance_date` timestamp NOT NULL, PRIMARY KEY (id) ) ENGINE","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"vendor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"trn_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"trn_type","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"perticulars","type":"text","nullable":false,"primary_key":false},{"name":"debit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"credit","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"trn_date","type":"timestamp","nullable":false,"primary_key":false},{"name":"balance_date","type":"timestamp","nullable":false,"primary_key":false}],"plugin":{"slug":"dokan-lite","name":"Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy","active_installs":40000,"version":"4.3.3","wp_org_url":"https://wordpress.org/plugins/dokan-lite/"}}