CREATE TABLE `p_order_customer_due_email_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `successful` enum('yes','no') CHARACTER SET utf8 NOT NULL DEFAULT 'no',
  `customer_id` int(11) unsigned DEFAULT NULL,
  `order_id` int(11) unsigned DEFAULT NULL,
  `payment_plan_payment_id` int(11) unsigned DEFAULT NULL,
  `email_type` enum('due','overdue') CHARACTER SET utf8 DEFAULT NULL,
  `email_notification_id` int(11) DEFAULT NULL,
  `due_overdue_days` int(11) DEFAULT NULL,
  `is_order_overdue` enum('yes','no') CHARACTER SET utf8 NOT NULL DEFAULT 'no',
  `options` text CHARACTER SET utf8 DEFAULT NULL,
  `response` text CHARACTER SET utf8 DEFAULT NULL,
  `recipient_email` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `subject` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `email` mediumtext CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`),
  KEY `order_id` (`order_id`),
  KEY `payment_plan_payment_id` (`payment_plan_payment_id`),
  KEY `email_notification_id` (`email_notification_id`),
  CONSTRAINT `p_order_customer_due_email_log_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `p_customer` (`customer_id`) ON DELETE CASCADE,
  CONSTRAINT `p_order_customer_due_email_log_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `p_order` (`order_id`) ON DELETE CASCADE,
  CONSTRAINT `p_order_customer_due_email_log_ibfk_3` FOREIGN KEY (`payment_plan_payment_id`) REFERENCES `p_order_payment_plan_payment` (`payment_id`) ON DELETE CASCADE,
  CONSTRAINT `p_order_customer_due_email_log_ibfk_4` FOREIGN KEY (`email_notification_id`) REFERENCES `email_notification` (`notification_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2772 DEFAULT CHARSET=utf8mb4;