{"slug":"email-reminders","name":"Email Reminders","description":"Sending friendly email reminders or follow-up emails based on custom rules.","author":"wpdevelop","active_installs":200,"version":"2.0.7","wp_org_url":"https://wordpress.org/plugins/email-reminders/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"checkpoint","full_table_name":"wp_checkpoint","description":"Stores checkpoint data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"checkpoint_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"contact_id","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `checkpoint` ( `checkpoint_id` BIGINT NOT NULL , `name` VARCHAR(45) NOT NULL , `date` DATETIME NOT NULL , `action` VARCHAR(255) NOT NULL , `contact_id` BIGINT NOT NULL , PRIMARY KEY (`checkpoint_id`), KEY `fkIdx_200` (`contact_id`), CONSTRAINT `FK_200` FOREIGN KEY `fkIdx_200` (`contact_id`) REFERENCES `contacts` (`contact_id`) );"},{"table_name":"contacts","full_table_name":"wp_contacts","description":"Stores contacts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"contact_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"order_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"check_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"order_parent","type":"BIGINT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"coupon","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"tax","type":"FLOAT","nullable":false,"primary_key":false},{"name":"licence_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"licence_to","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"order_type","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"connected_id","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `contacts` ( `contact_id` BIGINT NOT NULL , `order_key` VARCHAR(255) NOT NULL , `payment_type` VARCHAR(255) NOT NULL , `payment_status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL , `check_date` DATETIME NOT NULL , `ip` VARCHAR(255) NOT NULL , `order_parent` BIGINT NOT NULL , `source` VARCHAR(255) NOT NULL , `product_id` BIGINT NOT NULL , `customer_id` BIGINT NOT NULL , `coupon` VARCHAR(255) NOT NULL , `tax` FLOAT NOT NULL , `licence_key` VARCHAR(255) NOT NULL , `licence_to` VARCHAR(255) NOT NULL , `order_type` VARCHAR(255) , `connected_id` BIGINT NOT NULL , PRIMARY KEY (`contact_id`), KEY `fkIdx_159` (`product_id`), CONSTRAINT `products_to_contacts` FOREIGN KEY `fkIdx_159` (`product_id`) REFERENCES `products` (`product_id`), KEY `fkIdx_163` (`customer_id`), CONSTRAINT `customers_to_contacts` FOREIGN KEY `fkIdx_163` (`customer_id`) REFERENCES `customers` (`customer_id`) );"},{"table_name":"contacts_meta","full_table_name":"wp_contacts_meta","description":"Stores additional metadata (key-value pairs) for contacts records.","detection_method":"static","confidence":"high","columns":[{"name":"contacts_meta_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"contacts_meta_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"contacts_meta_value","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"contacts_meta_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"contact_id","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `contacts_meta` ( `contacts_meta_id` BIGINT NOT NULL , `contacts_meta_key` VARCHAR(255) NOT NULL , `contacts_meta_value` LONGTEXT NOT NULL , `contacts_meta_date` DATETIME NOT NULL , `contact_id` BIGINT NOT NULL , PRIMARY KEY (`contacts_meta_id`), KEY `fkIdx_143` (`contact_id`), CONSTRAINT `contacts_to_meta` FOREIGN KEY `fkIdx_143` (`contact_id`) REFERENCES `contacts` (`contact_id`) );"},{"table_name":"customers","full_table_name":"wp_customers","description":"Stores customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"customer_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"second_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"prefix","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"city","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"adress","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `customers` ( `customer_id` BIGINT NOT NULL , `name` VARCHAR(255) NOT NULL , `second_name` VARCHAR(255) NOT NULL , `prefix` VARCHAR(25) NOT NULL , `email` VARCHAR(255) NOT NULL , `phone` VARCHAR(50) NOT NULL , `country` VARCHAR(255) NOT NULL , `city` VARCHAR(255) NOT NULL , `adress` TEXT NOT NULL , PRIMARY KEY (`customer_id`) );"},{"table_name":"customers_meta","full_table_name":"wp_customers_meta","description":"Stores additional metadata (key-value pairs) for customers records.","detection_method":"static","confidence":"high","columns":[{"name":"customers_meta_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"customers_meta_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"customers_meta_value","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"customers_meta_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `customers_meta` ( `customers_meta_id` BIGINT NOT NULL , `customers_meta_key` VARCHAR(255) NOT NULL , `customers_meta_value` LONGTEXT NOT NULL , `customers_meta_date` DATETIME NOT NULL , `customer_id` BIGINT NOT NULL , PRIMARY KEY (`customers_meta_id`), KEY `fkIdx_151` (`customer_id`), CONSTRAINT `customers_to_meta` FOREIGN KEY `fkIdx_151` (`customer_id`) REFERENCES `customers` (`customer_id`) );"},{"table_name":"labels","full_table_name":"wp_labels","description":"Stores labels data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"labels_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":false,"primary_key":false},{"name":"color","type":"VARCHAR(7)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `labels` ( `labels_id` BIGINT NOT NULL , `name` VARCHAR(255) NOT NULL , `title` TEXT NOT NULL , `color` VARCHAR(7) NOT NULL , PRIMARY KEY (`labels_id`) );"},{"table_name":"products","full_table_name":"wp_products","description":"Stores products data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"product_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"cost","type":"FLOAT","nullable":false,"primary_key":false},{"name":"version_num","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"download_link","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `products` ( `product_id` BIGINT NOT NULL , `title` VARCHAR(255) NOT NULL , `description` LONGTEXT NOT NULL , `cost` FLOAT NOT NULL , `version_num` VARCHAR(255) NOT NULL , `download_link` TEXT NOT NULL , PRIMARY KEY (`product_id`) );"},{"table_name":"products_meta","full_table_name":"wp_products_meta","description":"Stores additional metadata (key-value pairs) for products records.","detection_method":"static","confidence":"high","columns":[{"name":"products_meta_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"products_meta_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"products_meta_value","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"products_meta_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `products_meta` ( `products_meta_id` BIGINT NOT NULL , `products_meta_key` VARCHAR(255) NOT NULL , `products_meta_value` LONGTEXT NOT NULL , `products_meta_date` DATETIME NOT NULL , `product_id` BIGINT NOT NULL , PRIMARY KEY (`products_meta_id`), KEY `fkIdx_155` (`product_id`), CONSTRAINT `products_to_meta` FOREIGN KEY `fkIdx_155` (`product_id`) REFERENCES `products` (`product_id`) );"}],"table_count":8}