{"table_name":"ezy_invoices","full_table_name":"wp_ezy_invoices","description":"Stores ezy invoices data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_ezy_invoices ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, invoice_number varchar(50) NOT NULL DEFAULT '', client_id bigint(20) unsigned NOT NULL DEFAULT 0, issue_date date NOT NULL DEFAULT '0000-00-00', due_date date NOT NULL DEFAULT '0000-00-00', status varchar(20) NOT NULL DEFAULT 'draft', subtotal decimal(15,2) NOT NULL DEFAULT 0.00, tax_rate decimal(5,2) NOT NULL DEFAULT 0.00, tax_amount decimal(15,2) NOT NULL DEFAULT 0.00, service_charge_rate decimal(5,2) NOT NULL DEFAULT 0.00, service_charge_amount decimal(15,2) NOT NULL DEFAULT 0.00, discount_amount decimal(15,2) NOT NULL DEFAULT 0.00, total decimal(15,2) NOT NULL DEFAULT 0.00, notes text NOT NULL, pdf_path varchar(500) NOT NULL DEFAULT '', email_sent_at datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY invoice_number (invoice_number), KEY client_id (client_id) ) $c;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"invoice_number","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"client_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"issue_date","type":"date","nullable":false,"primary_key":false},{"name":"due_date","type":"date","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"tax_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"tax_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"service_charge_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"service_charge_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":false,"primary_key":false},{"name":"pdf_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"email_sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"ezy-e-invoice","name":"ezy E Invoice","active_installs":0,"version":"2.2.4","wp_org_url":"https://wordpress.org/plugins/ezy-e-invoice/"}}