{"table_name":"accounts_invoices","full_table_name":"wp_accounts_invoices","description":"Stores accounts invoices data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_accounts_invoices ( ID int(11) NOT NULL AUTO_INCREMENT, client int(11) NOT NULL, invoice_date date NOT NULL, monthly tinyint(1) NOT NULL DEFAULT '0', yearly tinyint(1) NOT NULL DEFAULT '0', item1 varchar(255) NOT NULL, price1 decimal(10, 2) NOT NULL, item2 varchar(255) DEFAULT NULL, price2 decimal(10, 2) DEFAULT NULL, item3 varchar(255) DEFAULT NULL, price3 decimal(10, 2) DEFAULT NULL, item4 varchar(255) DEFAULT NULL, price4 decimal(10, 2) DEFAULT NULL, item5 varchar(255) DEFAULT NULL, price5 decimal(10, 2) DEFAULT NULL, invoice_status int(11) NOT NULL DEFAULT '1', date_paid date DEFAULT NULL, payment_method int(11) DEFAULT NULL, mileage int(11) DEFAULT '0', notes text DEFAULT NULL, PRIMARY KEY (ID), KEY client (client), KEY payment_method (payment_method), KEY invoice_status (invoice_status) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\" );","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"client","type":"int(11)","nullable":false,"primary_key":false},{"name":"invoice_date","type":"date","nullable":false,"primary_key":false},{"name":"monthly","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"yearly","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"item1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"price1","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"item2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price2","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item3","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price3","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item4","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price4","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item5","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price5","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"invoice_status","type":"int(11)","nullable":false,"primary_key":false},{"name":"date_paid","type":"date","nullable":true,"primary_key":false},{"name":"payment_method","type":"int(11)","nullable":true,"primary_key":false},{"name":"mileage","type":"int(11)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-accounts","name":"Web:D Accounts","active_installs":10,"version":"2.0.1","wp_org_url":"https://wordpress.org/plugins/wp-accounts/"}}