{"table_name":"fbs_stockmind_daily_sales","full_table_name":"wp_fbs_stockmind_daily_sales","description":"Stores fbs stockmind daily sales data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fbs_stockmind_daily_sales ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, date date NOT NULL, units_sold int(11) NOT NULL DEFAULT 0, refund_quantity int(11) NOT NULL DEFAULT 0, revenue decimal(19,4) NOT NULL DEFAULT 0.0000, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY product_date (product_id, date), KEY date (date) ) $collate;\", \"CREATE TABLE wp_fbs_stockmind_inventory_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, event_type varchar(50) NOT NULL, quantity_change int(11) NOT NULL, stock_after int(11) NOT NULL, reference_id bigint(20) unsigned DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY product_id (product_id), KEY event_type (event_type), KEY created_at (created_at) ) $collate;\", \"CREATE TABLE wp_fbs_stockmind_inventory_snapshots ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, date date NOT NULL, stock_level int(11) NOT NULL, stock_value decimal(19,4) NOT NULL DEFAULT 0.0000, PRIMARY KEY (id), UNIQUE KEY product_date (product_id, date) ) $collate;\", \"CREATE TABLE wp_fbs_stockmind_forecasts ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, forecast_date date NOT NULL, expected_daily_demand decimal(10,4) NOT NULL DEFAULT 0.0000, days_until_runout decimal(10,2) DEFAULT NULL, confidence_score decimal(4,2) NOT NULL DEFAULT 0.00, risk_level varchar(20) NOT NULL DEFAULT 'SAFE', calculated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY product_date (product_id, forecast_date), KEY risk_level (risk_level) ) $collate;\" ]; return $tables; } /** * Create or update database tables */ public function create_tables() { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; $schemas = $this->get_schema();","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"units_sold","type":"int(11)","nullable":false,"primary_key":false},{"name":"refund_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"revenue","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"quantity_change","type":"int(11)","nullable":false,"primary_key":false},{"name":"stock_after","type":"int(11)","nullable":false,"primary_key":false},{"name":"reference_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"stock_level","type":"int(11)","nullable":false,"primary_key":false},{"name":"stock_value","type":"decimal(19,4)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"forecast_date","type":"date","nullable":false,"primary_key":false},{"name":"expected_daily_demand","type":"decimal(10,4)","nullable":false,"primary_key":false},{"name":"days_until_runout","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"confidence_score","type":"decimal(4,2)","nullable":false,"primary_key":false},{"name":"risk_level","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"calculated_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"fbs-stockmind","name":"FBS StockMind – AI Inventory Management, Predictive Stock Alerts & Reorder Reminders for WooCommerce","active_installs":0,"version":"1.2.0","wp_org_url":"https://wordpress.org/plugins/fbs-stockmind/"}}