{"table_name":"clientoctopus_proposals","full_table_name":"wp_clientoctopus_proposals","description":"Stores clientoctopus proposals data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clientoctopus_proposals ( id INT NOT NULL AUTO_INCREMENT, owner_id INT NOT NULL, client_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT DEFAULT NULL, token VARCHAR(64) NOT NULL DEFAULT '', preview_token VARCHAR(64) DEFAULT NULL, status ENUM('draft','sent','viewed','accepted','declined','expired','completed','revision_requested') NOT NULL DEFAULT 'draft', total_amount DECIMAL(12,2) DEFAULT NULL, currency VARCHAR(3) NOT NULL DEFAULT 'GBP', payment_enabled TINYINT(1) NOT NULL DEFAULT 0, expiry_date DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, sent_at DATETIME DEFAULT NULL, viewed_at DATETIME DEFAULT NULL, accepted_at DATETIME DEFAULT NULL, declined_at DATETIME DEFAULT NULL, decline_reason TEXT DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, revision_note TEXT DEFAULT NULL, revision_requested_at DATETIME DEFAULT NULL, signed_name VARCHAR(255) DEFAULT NULL, signed_at DATETIME DEFAULT NULL, signed_ip VARCHAR(45) DEFAULT NULL, template_id VARCHAR(50) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY token (token), UNIQUE KEY preview_token (preview_token), KEY owner_id (owner_id), KEY client_id (client_id), KEY status (status), KEY created_at (created_at), KEY template_id (template_id) ) $charset_collate;\" );","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"owner_id","type":"INT","nullable":false,"primary_key":false},{"name":"client_id","type":"INT","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"token","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"preview_token","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('draft','sent','viewed','accepted','declined','expired','completed','revision_requested')","nullable":false,"primary_key":false},{"name":"total_amount","type":"DECIMAL(12,2)","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(3)","nullable":false,"primary_key":false},{"name":"payment_enabled","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"expiry_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"viewed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"accepted_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"declined_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"decline_reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"deleted_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"revision_note","type":"TEXT","nullable":true,"primary_key":false},{"name":"revision_requested_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"signed_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"signed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"signed_ip","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"template_id","type":"VARCHAR(50)","nullable":true,"primary_key":false}],"plugin":{"slug":"clientoctopus","name":"Client Octopus","active_installs":0,"version":"1.4.1","wp_org_url":"https://wordpress.org/plugins/clientoctopus/"}}