{"table_name":"givasso_receipts","full_table_name":"wp_givasso_receipts","description":"Stores givasso receipts data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_givasso_receipts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, donation_id BIGINT UNSIGNED NOT NULL, receipt_number VARCHAR(20) NOT NULL, fiscal_year SMALLINT NOT NULL, status ENUM('issued','cancelled','replaced') NOT NULL DEFAULT 'issued', replaces_id BIGINT UNSIGNED DEFAULT NULL, pdf_path VARCHAR(512) DEFAULT NULL, sent_at DATETIME DEFAULT NULL, issued_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, cancelled_at DATETIME DEFAULT NULL, cancel_reason VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uq_receipt_number (receipt_number), KEY idx_donation (donation_id), KEY idx_fiscal_year (fiscal_year) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"donation_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"receipt_number","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"fiscal_year","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('issued','cancelled','replaced')","nullable":false,"primary_key":false},{"name":"replaces_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"pdf_path","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"issued_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancel_reason","type":"VARCHAR(255)","nullable":true,"primary_key":false}],"plugin":{"slug":"givasso","name":"Givasso","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/givasso/"}}