{"table_name":"ipenta_invoices","full_table_name":"wp_ipenta_invoices","description":"Stores ipenta invoices data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_invoices ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_number VARCHAR(50) UNIQUE, quote_id INT DEFAULT 0, client_id INT DEFAULT 0, client_name VARCHAR(200), client_email VARCHAR(200), client_address TEXT, client_company VARCHAR(200), items LONGTEXT, subtotal DECIMAL(12,2) DEFAULT 0, tax_enabled TINYINT DEFAULT 0, tax_rate DECIMAL(5,2) DEFAULT 0, tax_amount DECIMAL(12,2) DEFAULT 0, total DECIMAL(12,2) DEFAULT 0, notes TEXT, status VARCHAR(20) DEFAULT 'draft', payment_status VARCHAR(20) DEFAULT 'unpaid', date_issued DATE, date_due DATE, date_paid DATE, amount_paid DECIMAL(12,2) DEFAULT 0, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"invoice_number","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"quote_id","type":"INT","nullable":true,"primary_key":false},{"name":"client_id","type":"INT","nullable":true,"primary_key":false},{"name":"client_name","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"client_email","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"client_address","type":"TEXT","nullable":true,"primary_key":false},{"name":"client_company","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"items","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"subtotal","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"tax_enabled","type":"TINYINT","nullable":true,"primary_key":false},{"name":"tax_rate","type":"DECIMAL(5,2)","nullable":true,"primary_key":false},{"name":"tax_amount","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"total","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"payment_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"date_issued","type":"DATE","nullable":true,"primary_key":false},{"name":"date_due","type":"DATE","nullable":true,"primary_key":false},{"name":"date_paid","type":"DATE","nullable":true,"primary_key":false},{"name":"amount_paid","type":"DECIMAL(12,2)","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/"}}