{"table_name":"events_attendee","full_table_name":"wp_events_attendee","description":"Stores events attendee data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_events_attendee` ( * `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, * `registration_id` VARCHAR(23) NULL DEFAULT '0', * `is_primary` TINYINT(1) NULL DEFAULT '0', * `lname` VARCHAR(45) NULL DEFAULT NULL, * `fname` VARCHAR(45) NULL DEFAULT NULL, * `address` VARCHAR(255) NULL DEFAULT NULL, * `address2` VARCHAR(255) NULL DEFAULT NULL, * `city` VARCHAR(45) NULL DEFAULT NULL, * `state` VARCHAR(45) NULL DEFAULT NULL, * `zip` VARCHAR(45) NULL DEFAULT NULL, * `country_id` VARCHAR(128) NULL DEFAULT NULL, * `organization_name` VARCHAR(50) NULL DEFAULT NULL, * `vat_number` VARCHAR(20) NULL DEFAULT NULL, * `email` VARCHAR(255) NULL DEFAULT NULL, * `phone` VARCHAR(45) NULL DEFAULT NULL, * `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, * `price_option` VARCHAR(150) NULL DEFAULT NULL, * `orig_price` DECIMAL(20,2) NULL DEFAULT '0.00', * `final_price` DECIMAL(20,2) NULL DEFAULT '0.00', * `quantity` INT(11) NULL DEFAULT '0', * `total_cost` DECIMAL(20,2) NULL DEFAULT '0.00', * `amount_pd` DECIMAL(20,2) NULL DEFAULT '0.00', * `coupon_code` VARCHAR(45) NULL DEFAULT NULL, * `payment` VARCHAR(45) NULL DEFAULT NULL, * `payment_status` VARCHAR(45) NULL DEFAULT 'Incomplete', * `txn_type` VARCHAR(45) NULL DEFAULT NULL, * `txn_id` VARCHAR(250) NULL DEFAULT NULL, * `payment_date` VARCHAR(45) NULL DEFAULT NULL, * `event_id` VARCHAR(45) NULL DEFAULT NULL, * `event_time` VARCHAR(15) NULL DEFAULT NULL, * `end_time` VARCHAR(15) NULL DEFAULT NULL, * `start_date` VARCHAR(45) NULL DEFAULT NULL, * `end_date` VARCHAR(45) NULL DEFAULT NULL, * `attendee_session` VARCHAR(250) NULL DEFAULT NULL, * `transaction_details` TEXT NULL, * `pre_approve` INT(11) NULL DEFAULT '1', * `checked_in` INT(1) NULL DEFAULT '0', * `checked_in_quantity` INT(11) NULL DEFAULT '0', * `hashSalt` VARCHAR(250) NULL DEFAULT NULL, * PRIMARY KEY (`id`), * INDEX `registration_id` (`registration_id`), * INDEX `event_id` (`event_id`) * ) * COLLATE='utf8_general_ci' * ENGINE=InnoDB * AUTO_INCREMENT=3 * ; * 4.1 Attendee tables and fields: * $this->_tables = array( * 'Attendee_CPT'=> new EE_Primary_Table('posts', 'ID'), * 'Attendee_Meta'=>new EE_Secondary_Table('esp_attendee_meta', 'ATTM_ID', 'ATT_ID') * );","columns":[],"plugin":{"slug":"event-espresso-decaf","name":"Event Espresso – Event Registration & Ticketing Sales","active_installs":600,"version":"5.0.58.decaf","wp_org_url":"https://wordpress.org/plugins/event-espresso-decaf/"}}