{"table_name":"fe_event_coupons","full_table_name":"wp_fe_event_coupons","description":"Stores fe event coupons data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_fe_event_coupons ( id BIGINT NOT NULL AUTO_INCREMENT, code VARCHAR(32) NOT NULL, description VARCHAR(100) NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, type ENUM('percent','fixed') NOT NULL DEFAULT 'fixed', amount DECIMAL(10,2) NOT NULL, usage_limit INT UNSIGNED NOT NULL DEFAULT '1', usage_limit_per_user INT UNSIGNED NOT NULL DEFAULT '1', used INT UNSIGNED NOT NULL DEFAULT '0', last_used DATETIME NULL, start_date DATETIME NOT NULL, end_date DATETIME NOT NULL, events VARCHAR(64) NULL, tickets VARCHAR(256) NULL, minimum_tickets INT UNSIGNED NULL, maximum_tickets INT UNSIGNED NULL, minimum_amount DECIMAL(10,2) NULL, maximum_amount DECIMAL(10,2) NULL, email VARCHAR(100) NULL, PRIMARY KEY (id), UNIQUE code_index (code) ) ENGINE","columns":[{"name":"id","type":"BIGINT","nullable":false,"primary_key":true},{"name":"code","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"description","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":false,"primary_key":false},{"name":"type","type":"ENUM('percent','fixed')","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"usage_limit","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"usage_limit_per_user","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"used","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"last_used","type":"DATETIME","nullable":true,"primary_key":false},{"name":"start_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"end_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"events","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"tickets","type":"VARCHAR(256)","nullable":true,"primary_key":false},{"name":"minimum_tickets","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"maximum_tickets","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"minimum_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"maximum_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":true,"primary_key":false}],"plugin":{"slug":"fast-events","name":"Fast Events","active_installs":20,"version":"3.0.0","wp_org_url":"https://wordpress.org/plugins/fast-events/"}}