{"table_name":"ec_invoice","full_table_name":"wp_ec_invoice","description":"Stores ec invoice data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_invoice ( invoice_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', invoice_type varchar(20) NOT NULL DEFAULT 'invoice', invoice_number varchar(64) NOT NULL DEFAULT '', sequence_number int(11) NOT NULL DEFAULT '0', sequence_year int(11) NOT NULL DEFAULT '0', issue_date datetime DEFAULT NULL, payment_terms varchar(64) NOT NULL DEFAULT '', due_date datetime DEFAULT NULL, amount float(15,3) NOT NULL DEFAULT '0.000', parent_invoice_id int(11) NOT NULL DEFAULT '0', refund_ref varchar(100) NOT NULL DEFAULT '', snapshot longtext, created_by bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (invoice_id), KEY order_id (order_id), UNIQUE KEY invoice_type_number (invoice_type,invoice_number), KEY issue_date (issue_date) ) $collate;\" );","columns":[{"name":"invoice_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"invoice_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"invoice_number","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"sequence_number","type":"int(11)","nullable":false,"primary_key":false},{"name":"sequence_year","type":"int(11)","nullable":false,"primary_key":false},{"name":"issue_date","type":"datetime","nullable":true,"primary_key":false},{"name":"payment_terms","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"due_date","type":"datetime","nullable":true,"primary_key":false},{"name":"amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"parent_invoice_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"refund_ref","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"snapshot","type":"longtext","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}