
-- --------------------------------------------------------

--
-- Table structure for table `assignfunction`
--

CREATE TABLE `assignfunction` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `oldrolework` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `newrolework` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tagging` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sourcedb` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `employeeid` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `assignnooflead` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type_of_solution` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `domain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `assignfunction`
--

INSERT INTO `assignfunction` (`id`, `deleted_at`, `created_at`, `updated_at`, `oldrolework`, `newrolework`, `tagging`, `sourcedb`, `employeeid`, `assignnooflead`, `type_of_solution`, `domain`) VALUES
(37, NULL, '2024-09-17 09:52:36', '2024-09-17 09:52:36', '3166', '3166', 'Fresh Lead', 'bsesolutions', '4120', '10', '1', '16'),
(38, NULL, '2024-09-17 09:54:33', '2024-09-17 09:54:33', '3166', '3167', 'Hot Lead', 'bsesolutions', '4131', '10', '1', '16'),
(40, NULL, '2024-09-17 10:11:40', '2024-09-17 10:11:40', '3167', '3168', 'Hot Lead', 'bsesolutions', '4132', '2', '1', '16'),
(42, NULL, '2024-09-19 12:07:50', '2024-09-19 12:07:50', '3173', '3173', 'Fresh Lead', 'bsesolutions', '4147', '5', '1', '35'),
(43, NULL, '2024-09-19 12:24:33', '2024-09-19 12:24:33', '3170', '3170', 'Fresh Lead', 'bsesolutions', '4148', '3', '1', '51');
