{"table_name":"accounts_payments","full_table_name":"wp_accounts_payments","description":"Stores accounts payments data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_accounts_payments ( ID int(11) NOT NULL AUTO_INCREMENT, supplier varchar(255) NOT NULL, invoice_date date NOT NULL, amount decimal(10, 2) NOT NULL, reference varchar(255) DEFAULT NULL, expense_type int(11) NOT NULL, date_paid date NOT NULL, payment_method int(11) NOT NULL, mileage int(11) DEFAULT '0', notes text DEFAULT NULL, PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\" );","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"supplier","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"invoice_date","type":"date","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"reference","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"expense_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"date_paid","type":"date","nullable":false,"primary_key":false},{"name":"payment_method","type":"int(11)","nullable":false,"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/"}}