CREATE TABLE `internal_notes_history` (
  `id` varchar(45) NOT NULL,
  `ref_id` varchar(45) DEFAULT NULL,
  `note` text,
  `reason` text,
  `type` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `progress` varchar(45) DEFAULT NULL,
  `changed_by` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `done_by` varchar(45) DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci