CREATE TABLE `automated_email_recipients` ( `id` varchar(24) NOT NULL, `automated_email_id` varchar(24) NOT NULL, `member_id` varchar(24) NOT NULL, `member_uuid` varchar(36) NOT NULL, `member_email` varchar(191) NOT NULL, `member_name` varchar(191) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `automated_email_recipients_automated_email_id_foreign` (`automated_email_id`), KEY `automated_email_recipients_member_id_index` (`member_id`), CONSTRAINT `automated_email_recipients_automated_email_id_foreign` FOREIGN KEY (`automated_email_id`) REFERENCES `automated_emails` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;