   `user_id`       integer NOT NULL,
   `name`          varchar(191) NOT NULL,
   `template_name` varchar(191) NOT NULL,
-  `status`        varchar(191),
-  `created_at`    datetime NOT NULL,
-  `updated_at`    datetime NOT NULL,
-  `scheduled_at`  datetime DEFAULT NULL,
-  `completed_at`  datetime DEFAULT NULL,
+  `status`        varchar(191) NOT NULL,
+  `created_at`    datetime(6) NOT NULL,
+  `updated_at`    datetime(6) NOT NULL,
+  `scheduled_at`  datetime(6) DEFAULT NULL,
+  `completed_at`  datetime(6) DEFAULT NULL,
   FOREIGN KEY (`user_id`) REFERENCES users(`id`)
 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 

  `id`              integer primary key AUTO_INCREMENT NOT NULL,
  `campaign_id`     integer NOT NULL,
  `user_id`         integer NOT NULL,
  `recipient`       varchar(191),
  `type`            varchar(30),
  `sub_type`        varchar(30),
  `action`          varchar(191),
  `status`          varchar(191),
  `diagnostic_code` varchar(191),
  `feedback_id`     varchar(191),
  `created_at`      datetime NOT NULL,
  FOREIGN KEY (`user_id`) REFERENCES users(`id`),
  FOREIGN KEY (`campaign_id`) REFERENCES campaigns(`id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

  `id`          integer primary key AUTO_INCREMENT NOT NULL,
  `campaign_id` integer NOT NULL,
  `user_id`     integer NOT NULL,
  `ip_address`  varchar(50) NOT NULL,
  `user_agent`  varchar(191) NOT NULL,
  `link`        varchar(191) NOT NULL,
  `created_at`  datetime(6) NOT NULL,
  FOREIGN KEY (`user_id`) REFERENCES users(`id`),
  FOREIGN KEY (`campaign_id`) REFERENCES campaigns(`id`)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
