{"slug":"silverstream-invoicing","name":"SilverStream Invoicing","description":"Professional invoicing, quotes and client management for WordPress. Create PDF invoices, manage clients, track expenses and send invoices by email — a …","author":"silverstreamdigital","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/silverstream-invoicing/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"ipenta_clients","full_table_name":"wp_ipenta_clients","description":"Stores ipenta clients data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"name","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"address","type":"TEXT","nullable":true,"primary_key":false},{"name":"company","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"vat_number","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_clients ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(200) NOT NULL, email VARCHAR(200), phone VARCHAR(50), address TEXT, company VARCHAR(200), vat_number VARCHAR(50), notes TEXT, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");"},{"table_name":"ipenta_expenses","full_table_name":"wp_ipenta_expenses","description":"Stores ipenta expenses data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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\");"},{"table_name":"ipenta_invoices","full_table_name":"wp_ipenta_invoices","description":"Stores ipenta invoices data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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\");"},{"table_name":"ipenta_notes","full_table_name":"wp_ipenta_notes","description":"Stores ipenta notes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"client_id","type":"INT","nullable":true,"primary_key":false},{"name":"client_name","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"note","type":"TEXT","nullable":true,"primary_key":false},{"name":"follow_up_date","type":"DATE","nullable":true,"primary_key":false},{"name":"follow_up_done","type":"TINYINT","nullable":true,"primary_key":false},{"name":"created_by","type":"INT","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_notes ( id INT AUTO_INCREMENT PRIMARY KEY, client_id INT DEFAULT 0, client_name VARCHAR(200), note TEXT, follow_up_date DATE, follow_up_done TINYINT DEFAULT 0, created_by INT DEFAULT 0, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");"},{"table_name":"ipenta_quote_responses","full_table_name":"wp_ipenta_quote_responses","description":"Stores ipenta quote responses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"quote_id","type":"INT","nullable":false,"primary_key":false},{"name":"token","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"response","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_note","type":"TEXT","nullable":true,"primary_key":false},{"name":"response_count","type":"INT","nullable":true,"primary_key":false},{"name":"responded_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_quote_responses ( id INT AUTO_INCREMENT PRIMARY KEY, quote_id INT NOT NULL, token VARCHAR(64) UNIQUE, response VARCHAR(20) DEFAULT 'pending', response_note TEXT, response_count INT DEFAULT 0, responded_at DATETIME, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");"},{"table_name":"ipenta_quotes","full_table_name":"wp_ipenta_quotes","description":"Stores ipenta quotes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"quote_number","type":"VARCHAR(50)","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":"date_issued","type":"DATE","nullable":true,"primary_key":false},{"name":"date_valid","type":"DATE","nullable":true,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_ipenta_quotes ( id INT AUTO_INCREMENT PRIMARY KEY, quote_number VARCHAR(50) UNIQUE, 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', date_issued DATE, date_valid DATE, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c\");"}],"table_count":6}