{"table_name":"ipenta_expenses","full_table_name":"wp_ipenta_expenses","description":"Stores ipenta expenses data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_expenses ( id INT AUTO_INCREMENT PRIMARY KEY, description VARCHAR(200) NOT NULL, category VARCHAR(100), amount DECIMAL(12,2) DEFAULT 0, tax_amount DECIMAL(12,2) DEFAULT 0, supplier VARCHAR(200), reference VARCHAR(100), date_expense DATE, receipt_url VARCHAR(500), notes TEXT, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"description","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"category","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"amount","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"tax_amount","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"supplier","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"reference","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"date_expense","type":"DATE","nullable":true,"primary_key":false},{"name":"receipt_url","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"silverstream-invoicing","name":"SilverStream Invoicing","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/silverstream-invoicing/"}}