-- Table structure for table `tb_types`
--

CREATE TABLE `tb_types` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tb_types`
--

INSERT INTO `tb_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
('c380cb8a-4e94-4199-a09b-4f9be9f833d9', 'Уушгины', '2022-08-05 10:05:03', '2022-08-05 10:05:03'),
('ebb8b080-0a19-4582-b9e0-9fb2c941e42e', 'Уушгины бус', '2022-08-05 10:05:03', '2022-08-05 10:05:03');

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('debit','credit') COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_balance_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `count` decimal(18,2) NOT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transfers`
--

INSERT INTO `transfers` (`id`, `number`, `type`, `account_balance_id`, `year_id`, `count`, `model`, `model_id`, `created_at`, `updated_at`) VALUES
('0251a2e5-9e5f-4533-88cd-101f38d6abf0', '2022000000012', 'credit', '3cad7137-1bc8-41b7-a128-9967828e3f6f', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '4.00', 'App\\Models\\TreatmentProcess', '48bf94fa-4d05-414e-a794-cc2bd4cedde9', '2022-08-24 07:22:00', '2022-08-24 07:22:00'),
('042faf22-408e-442d-b6fe-ff1c206974e6', '2022000000011', 'credit', '13d898a2-b6cc-420f-9572-8622ee56cd84', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '4.00', 'App\\Models\\TreatmentProcess', '2a61021f-f0d0-4408-9eec-46faa11738dc', '2022-08-24 07:22:00', '2022-08-24 07:22:00'),
('1b6e33a0-1bd4-469a-9eb1-c176a3103ed5', '2022000000004', 'credit', '13d898a2-b6cc-420f-9572-8622ee56cd84', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', '8515209e-e33f-4dd2-b077-cac66d0458f4', '2022-08-24 01:32:52', '2022-08-24 01:32:52'),
('1cedcb1d-8205-44a6-b6c5-ae3f5948a438', '2022000000006', 'credit', '13d898a2-b6cc-420f-9572-8622ee56cd84', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', '82989ae3-29ce-429e-b739-58638f8679de', '2022-08-24 01:57:27', '2022-08-24 01:57:27'),
('27aabf77-cbb0-480c-ba3a-8a2ec4230143', '2022000000008', 'credit', '77b85309-921e-42b9-82a6-83ee1cdf2375', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', 'f392b111-83d9-4fa4-853a-c0fa65d44f13', '2022-08-24 02:19:13', '2022-08-24 02:19:13'),
('326b9057-c784-45da-a7b2-d4b953280c91', '2022000000005', 'credit', '3cad7137-1bc8-41b7-a128-9967828e3f6f', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', '0fde726b-8982-4042-bdee-d7fdb42aebb1', '2022-08-24 01:32:52', '2022-08-24 01:32:52'),
('3e1c2aa6-ebdf-4529-ab3c-03bf8014a31f', '2022000000003', 'credit', '3cad7137-1bc8-41b7-a128-9967828e3f6f', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', '07de436d-6617-4dbc-a0a6-119da2ec4c24', '2022-08-24 01:32:26', '2022-08-24 01:32:26'),
('5dc63a18-7ad6-48b5-bc5e-fc25f69c2ad9', '2022000000001', 'debit', '3cad7137-1bc8-41b7-a128-9967828e3f6f', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '100.00', 'App\\Models\\DrugOrder', '684bbef3-e6a9-441a-a477-7336349246c5', '2022-08-23 09:11:01', '2022-08-23 09:11:01'),
('631ca7b5-3e5a-4571-8594-63ac3fdb95b4', '2022000000010', 'credit', 'a47eedab-10b2-4087-8a45-b2400ac3472b', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '2.00', 'App\\Models\\TreatmentProcess', '49cb7868-ba81-48cd-8936-c023a955ed1c', '2022-08-24 03:04:33', '2022-08-24 03:04:33'),
('7b67589c-9fbb-4f59-8af3-b75af572006f', '2022000000007', 'credit', '3cad7137-1bc8-41b7-a128-9967828e3f6f', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', 'ededc6d9-3bb2-41ac-a1c4-28bf32c02fa4', '2022-08-24 01:57:27', '2022-08-24 01:57:27'),
('866215b1-b5c4-4538-bf8d-222712842f21', '2022000000002', 'credit', '13d898a2-b6cc-420f-9572-8622ee56cd84', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', 'dc2632d4-25a0-4cf2-a6d7-a2ca2cb75156', '2022-08-24 01:32:26', '2022-08-24 01:32:26'),
('93c451dd-fa25-42f0-9525-c99533e9b351', '2022000000001', 'debit', '13d898a2-b6cc-420f-9572-8622ee56cd84', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '100.00', 'App\\Models\\DrugOrder', '684bbef3-e6a9-441a-a477-7336349246c5', '2022-08-23 09:11:01', '2022-08-23 09:11:01'),
('9f42d26f-bf13-43a0-884f-829cc697400b', '2022000000009', 'credit', '22ea9825-0a02-4f39-a4c8-64fb416a2015', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '2.00', 'App\\Models\\TreatmentProcess', '4971cb0d-c760-4d77-b083-f99501cf2c1d', '2022-08-24 03:04:33', '2022-08-24 03:04:33'),
('a44b135f-ebeb-4271-b3eb-af9920c6ecb0', '2022000000001', 'credit', '22ea9825-0a02-4f39-a4c8-64fb416a2015', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '100.00', 'App\\Models\\DrugOrder', '684bbef3-e6a9-441a-a477-7336349246c5', '2022-08-23 09:11:01', '2022-08-23 09:11:01'),
('c14d0ee9-d7e7-450d-975c-6fdf2c4fc6d5', '2022000000007', 'credit', '2bd1ede2-4386-4d93-819e-45fadd1a2841', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\TreatmentProcess', '0d629c4a-ea70-4050-99c0-f6fb3aefe3eb', '2022-08-24 02:19:13', '2022-08-24 02:19:13'),
('cca63269-c7fe-457c-894a-dc4212c07b32', '2022000000005', 'credit', '969fa90a-19c8-498f-a3eb-d5765d9ba980', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\DrugOrder', '0fdd3d8c-d1be-41c7-a7fe-8ae3dac88930', '2022-08-24 01:52:49', '2022-08-24 01:52:49'),
('d79dc2cb-26f8-442b-af79-38e7a7212217', '2022000000001', 'credit', 'a47eedab-10b2-4087-8a45-b2400ac3472b', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '100.00', 'App\\Models\\DrugOrder', '684bbef3-e6a9-441a-a477-7336349246c5', '2022-08-23 09:11:01', '2022-08-23 09:11:01'),
('dcf7ef01-ed8a-4245-a729-69fb4040078b', '2022000000005', 'debit', '09865c6f-239c-485e-b172-feb48fd118a7', 'd9a6f97c-e422-4370-b794-c9ff659f881c', '3.00', 'App\\Models\\DrugOrder', '0fdd3d8c-d1be-41c7-a7fe-8ae3dac88930', '2022-08-24 01:52:49', '2022-08-24 01:52:49');

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

--
-- Table structure for table `treatments`
--

CREATE TABLE `treatments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `case_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `weight_index` int(11) DEFAULT NULL,
  `treatment_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_date_2` date DEFAULT NULL,
  `end_date_2` date DEFAULT NULL,
  `treatment_place_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `treatment_result_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result_date` date DEFAULT NULL,
  `result_user_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatments`
--

INSERT INTO `treatments` (`id`, `number`, `case_id`, `weight_index`, `treatment_method_id`, `create_user_id`, `start_date`, `end_date`, `start_date_2`, `end_date_2`, `treatment_place_id`, `treatment_result_id`, `result_date`, `result_user_id`, `result_description`, `created_at`, `updated_at`) VALUES
('6421f01e-8f7a-4386-adcb-4cdd00f815d1', '220822001', '7dd4890a-4efe-4428-807f-07d3a443a64c', 2, 'e360efd0-09d5-4d28-bbb9-e9a5d6c76206', 'eaa4a519-abff-4bd3-a256-b8b17ce38c73', '2022-08-15', '2022-10-10', '2022-10-11', '2023-01-31', '42b4d5d4-205b-4041-9db2-d22ed2288eb3', NULL, NULL, NULL, NULL, '2022-08-22 02:02:19', '2022-08-23 09:53:24'),
('d1479c30-9098-45fb-aa7c-5a224a235e15', '220821001', '67f382e6-73bc-4e07-807d-f2d3fe84aa65', 5, 'e360efd0-09d5-4d28-bbb9-e9a5d6c76206', '4b4b9dbe-11e0-420f-b1e6-da950369430e', '2022-08-21', '2022-10-16', '2022-10-17', '2023-02-06', '42b4d5d4-205b-4041-9db2-d22ed2288eb3', '4ccc0790-eaa8-4c97-b88a-f92d7b79fae9', '2022-08-24', '4b4b9dbe-11e0-420f-b1e6-da950369430e', NULL, '2022-08-21 11:11:31', '2022-08-24 08:24:54');

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

--
-- Table structure for table `treatment_controls`
--

CREATE TABLE `treatment_controls` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `treatment_month` int(11) NOT NULL,
  `treatment_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `treatment_section_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `send_purpose_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_controls`
--

INSERT INTO `treatment_controls` (`id`, `treatment_month`, `treatment_number`, `treatment_section_id`, `send_purpose_id`, `created_at`, `updated_at`) VALUES
('021e3c25-73ac-4e21-a1df-24e5e5bfd5d1', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('02b23bfc-359c-464f-a48d-9f39af66df06', 5, '73', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('0304c540-4e95-4c8b-a826-14e297044043', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('0378d31a-9a7b-450c-b0a8-04113884d243', 12, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('03a7f0dd-2573-4eb3-926d-4279dc2e8462', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('04b06821-3e83-4c14-8cda-9bb74c6dc1b8', 9, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('04f7919e-3569-459c-bf45-7ba34f15b53c', 5, '422', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('05401ba3-3fdc-41ee-93b8-ece8f6a5995a', 3, '570', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('07727846-a800-4727-b3d3-24bff9aa493f', 5, '508', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('07b115c4-349a-4eb0-84e7-d14616832fd6', 6, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('09adb28a-ed32-440f-b064-417f4524da8a', 6, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('0a236ab6-1e6f-4c8b-a6c6-cf721e7b99a5', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('0a335f76-eb2b-4625-919c-0a77dcf4e926', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('0a7eac8d-f365-4a2e-a0f3-0ff59cf69973', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('0b653afe-f430-49bc-bf21-6b507e629bee', 3, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('0bbebce1-2261-479d-8965-7b5d18398329', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('0d2a7b73-5da1-49a5-8c0f-55c812f9c4f5', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('0d6a7131-1cba-4993-80dd-66f91b372592', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('0d94a458-71b4-4a76-b937-3240619cbe6b', 1, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('0df05804-0d27-4c67-8870-0cf2825490bb', 2, '548', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('0ee0a757-04de-4b6b-b57e-0a0e3f198595', 9, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('0ee9ecb8-4beb-4fd8-a328-fd635c02c947', 4, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('1046f029-fe97-41e9-afb0-f07157b09f9b', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('10dc9fe4-c3b2-4f20-935c-c48b6d214977', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('1202b482-c4e4-48e1-8075-83b62df4a10f', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('133fc950-e851-442b-9244-ec87d576db26', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('1495271e-72f0-4ad7-91be-03f5a9b59b37', 7, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('15255732-f657-43c2-acee-e9d1270cca9e', 1, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('15fc8ff7-0b9b-41e5-9cdd-98a265d16f2a', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('161595a4-cd46-4483-abd2-45f7f58db43d', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('1813102a-63ad-48bb-8eb5-86edb3378534', 2, '2200001', '150814cb-c70a-4db3-8d4c-1cafa7fc1760', '0c5ab7f9-55b6-4b78-af25-9df55211f4a6', '2022-08-22 02:38:07', '2022-08-22 02:38:07'),
('1834c6f2-61e8-4729-96bf-a088d65996a7', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('188de14d-89e6-46b4-8c42-9dc69db7cff1', 15, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('18f76087-4af4-4451-8c48-94087161241c', 7, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('192c8e1e-31de-430b-9ac3-1458715495b8', 5, '491', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('196d20b0-0582-4c7b-b15a-739f89803be0', 8, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('1a5d8d4d-1b5f-4a82-a2be-f7c7e0983aba', 8, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('1aad5131-079f-4e34-9cc8-716d52d3a67e', 2, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('1add5d6d-9b02-4606-9f2a-27f8e29eaee8', 3, '588', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('1ae8c055-5a24-417b-b30b-01cf71417566', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('1bf8f392-37f2-4840-b925-1a16573fb570', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('1c7880d1-3954-418a-8481-83b7862238ff', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('1e1dd576-ee99-413a-8dd3-cc921559210e', 5, '35', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('201154dc-1523-455c-82eb-d121403c6b03', 5, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('201a4b9b-dc40-407b-9412-cbb1c515b156', 9, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('20579c5c-d954-4401-a0dd-57c18edd5bba', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('212103a9-71f8-48ed-ba80-3ee3e37ee9ac', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('21fff6d6-bd38-4f4f-9847-449798a6c703', 2, '630', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('221becf1-a152-4413-b4d6-e19df44bf479', 3, '10', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('2244283d-1560-4376-a09f-e04e4a7ac255', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('22ac971a-353e-4a7a-ba88-2af6623a994d', 4, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('247735c4-ce2a-4d5a-a65f-d4f89d98fad1', 2, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('248ccbc1-7d9b-4379-930a-e675cfb2aa42', 12, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('265faf62-1c26-4906-a024-202c9615b60a', 3, '628', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('26bbcb34-1b43-4196-8c2d-e93a793382bc', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('27a117fe-86ce-412f-a2a2-75dc302c1f47', 6, '151', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('283a4264-0afb-4953-b417-5a2a0f1b011a', 6, '386', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('2885ad63-fa27-40a0-8acf-b9ebd6908cb5', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('28d16795-22e2-47fd-98b3-126426a26f4b', 8, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('28d76785-a7c7-4a63-b84d-4468f4c8d388', 2, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('298b4b13-9a6b-4298-b79d-88e6addd47aa', 9, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('29980415-325f-4b35-8bb1-f617e644b709', 18, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('29d4f152-486c-4e07-8064-9d935d046c52', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('2ad1a643-a197-432f-aa09-1fbc295907a8', 2, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('2c0ba589-fb37-4daf-b53e-a4e815ff63cc', 15, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('2c7c0488-0967-42ee-9c2c-a31769a2e39f', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('2e1bbab1-d56c-474d-80d9-ae916b7d0ffc', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('2ef05516-55af-44ce-ad76-dffadfc58077', 4, '481', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('30306b82-7386-4349-aab5-92728f68760d', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('309e6566-d4a4-49a1-971b-91e5468061d7', 1, '11', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('314ae91b-f90e-47ce-9554-fc766e7da203', 1, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('3261a85d-e5a2-47cc-a075-4664bb13456a', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('3567b732-013e-4804-af2b-7651d1f2eec6', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('36b5e331-0590-4d2a-8f25-e00ee6146d0c', 6, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('37074bef-d4cf-412d-8f07-9287f92a7598', 8, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('3911a7f2-34ff-48ff-8ea4-ffadd91b7e86', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('3b051255-ae9b-498e-b1a6-16edbb9c530e', 3, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('3b699dbd-9172-4192-b853-bb8f2453f740', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('3b776059-e4c0-4dac-9406-ef37046386dc', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('3bf8e772-ed6b-46e9-8700-f99d94907996', 4, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('3c915277-d1f0-4cf7-8d98-0c5b7d263156', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('3de032df-92d0-4bd7-b261-13cd05ca45bb', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('3df4fc64-1a56-4b98-9a8d-d2462956c0c1', 6, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('3f1bc2fd-181c-4eef-b1bf-83b04ae47f76', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('401a0599-4d7a-4bea-8bbb-e85405712ab3', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('40636f7a-8dce-47a7-92f1-9f54002f56f1', 12, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('40f63194-62d1-4813-bea3-c6d020892cce', 13, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('41484135-6c5c-4250-b234-909a98482b83', 13, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('4216b85c-af66-4892-907b-fd7d56f86e1d', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('43162ee9-0029-44b8-913f-e8ba2bb24989', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('445bf80c-7a58-4b56-9eb6-cef7644243e9', 8, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('44d13947-82d3-47ec-b1ff-ef44abc2cb78', 6, '0', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('4507a16a-416f-40e6-b5e7-6a6225adb289', 5, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('45bdf3c2-0261-4edb-bdcf-cf62f7079864', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('46378de9-a396-4629-bfef-c1dc353ed125', 24, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('4710e73d-3a1d-4153-a8fb-9f31d0579d88', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('471b020e-6124-47cb-a8d6-1c35431aef36', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('47950574-5795-4404-ac50-37e976dbd203', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('479b00e3-e089-4b0e-9859-21ff131ba57d', 6, '414', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('4a2cdb71-0113-40cb-b9b8-361a2b37fbcb', 1, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('4bb74ddd-a3a9-4362-b2ff-5d8bfd877f02', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('4be14ec3-b26d-4abe-88ec-cc78857f3545', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('4c004ed8-9299-481a-aa3a-30620bb9bee8', 3, '553', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('4c33d993-7ed6-4ece-a70a-00dd9a6e5e4b', 5, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('4c38fc8a-daf4-4918-995d-d231e99cff6c', 5, '366', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('4c500726-fd93-4337-b9eb-7094f9b71e23', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('4cb9bb54-dfef-40b9-a838-de8bb2c4dd6b', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('4da107b7-06de-4be0-b8aa-6498fdcbfe14', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('50a27378-0678-4d82-ba8b-625239cb0110', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('51cbb41a-0be0-40f1-9ea3-0f5dfe9ce961', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('51cd1e41-3c2b-4bc4-962d-5699241aca21', 2, '237', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('5243b428-73de-4bbb-8fd8-6e988b25563c', 9, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('5388f289-9b0c-4bd7-a17c-be4c1b3bfbf1', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('53b859f2-323d-4899-9d79-7ccfebdaf221', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('57910307-a4e8-45f5-90c1-11c02daac724', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('57b01ab4-9d79-4c37-9e20-ee93dce3861d', 12, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('57be62fe-00e1-4592-b4f9-d9df9cf37fe3', 6, '0', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('593c58a5-be72-48af-9150-b02ca4691a69', 3, '648', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('594b4a35-ffca-4d31-b768-e627e324deb6', 1, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('59b8cb56-ab94-42fa-bfe2-6f73a07e6212', 9, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('5a43f061-5313-42c3-9799-dd958ea1fb3d', 2, '253', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('5b0f556b-6bb1-4acf-9a2a-cf3c7efcc8b1', 5, '374', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('5b9a1a15-000d-42bc-92f9-f73022df6acc', 7, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('5cf22bf7-e562-409b-9398-7b124632ea1e', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('5eacf97f-5dae-4c97-a600-bac3ac6deb59', 3, '543', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('61777d06-5722-419c-a92e-2ae19ee8bcc4', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('6420b6d9-f03b-4583-9a09-9f8b8fdbac81', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('650a18a9-5d6f-4a90-a302-75cf438bc48b', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('6521ac80-4180-4a2f-a283-cbb791fb489f', 11, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('658ca832-8c8f-4a96-9c11-05b4de167355', 1, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('667d8041-bf70-429a-b038-5c7d995bd58f', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('66ddf126-809c-4ccf-8599-d0ae0a14a665', 16, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('66f7695b-7b07-4e37-92d8-85ecd08ef3c7', 13, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('672f9a05-70ea-4f20-bad7-6b2739b16a33', 2, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('67daa710-45e8-4ea5-af6e-e37a6f2ae17f', 3, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('67e8eec5-20a1-49dc-9e82-5fd06b46ec32', 4, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('68d3e346-d91c-470f-b0fb-a899133c20f1', 3, '247', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('69ee040b-7e66-46ca-986d-008897f9b89e', 5, '211', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('6a0ecba8-a7cc-43e0-8ee2-eb149db51000', 2, '0', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('6cba810f-dcad-4443-966f-c994e570030e', 1, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('6d1e2cd8-fabd-4c81-a8f5-35c47c99a744', 5, '544', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('6da7080d-fa44-4323-86a6-91890b988d37', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('6f6f0f34-ddb7-4ed9-8175-19eefb8cfcaa', 5, '59', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('70b644a8-0056-4563-8a5a-4ca9abef1927', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('71bea519-f52e-4c50-8db3-d9af50ccf693', 9, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7245c8e2-481c-4a7d-ab1a-5baf3ff24c2c', 17, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('771f1dbd-3826-4848-8013-214125f058ab', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('7790c84d-aaa9-480a-a267-7f0047d76b63', 5, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('779f3e11-5ca4-43d3-9e83-5bb99ec5c63f', 2, '531', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('77a653af-376e-4e53-99ae-e7b6d2996c65', 1, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('78b627a0-a7d2-4209-909c-793c9681fe8d', 5, '9', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('78dee78c-7019-479c-b940-f214ec24a3fd', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('79391364-e6e9-4e93-90c1-7814c704b1a4', 1, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('799509d0-3cb4-4aaf-b026-089f748a9675', 1, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('7afa413a-25b2-4278-895e-cd4c53dc9907', 4, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('7b10285c-2653-4a24-8f8b-414cffb59d75', 10, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7b2d6dd2-b36a-496b-aa7d-f8f5ff888ad3', 2, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('7b584d44-2ff3-440d-802e-690ee9054125', 7, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('7c5dc147-c1ee-40cb-bc01-94041737eac4', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7c634633-db6b-44e8-990a-f302e1f3abf8', 3, '647', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('7d64abd9-3654-4ed2-8c17-baba5e72f5cf', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7dadb4d4-0350-4489-8677-17a391a936d4', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7de44238-b219-4a24-9465-e1db66aa727c', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('7e6db009-e16d-4f91-9682-b44fb2c8d08f', 10, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('7e94f617-12af-4f58-a4a1-aab30fa3c2d2', 2, '2200001', '150814cb-c70a-4db3-8d4c-1cafa7fc1760', '0c5ab7f9-55b6-4b78-af25-9df55211f4a6', '2022-08-18 07:14:48', '2022-08-18 07:14:48'),
('7f697b16-be83-4b9c-a441-0bbb3d712fa8', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('7f822409-9560-4314-8b99-d086a20fcfff', 2, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('811b31be-c2de-4779-9090-2e6e4d87764f', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('814aca26-f989-4797-88fa-6067ed2e83df', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('815f25c1-71b7-4715-a9f2-ab0c8e9847ed', 9, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('83092155-b790-4bab-9226-be3d77847a73', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('838e08c5-8d30-4706-bd4f-4af3766f53d9', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('841fcfc4-af64-4141-8ddb-a22be1ad180d', 4, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('84987763-3149-4601-8657-7ada45898152', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('861f800a-2220-4f62-884e-3a31d678e517', 6, '53', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('868b1e50-0ba9-4781-b42a-3707379f2524', 5, '201', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('88466b90-eb27-4608-9eaa-e8b5202e6496', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('8b4b69be-45ce-4c4e-becc-f16ee5522bd1', 30, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('8cfd241d-bfdf-4747-ab21-38ec498303a1', 12, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('8d5dc616-58db-4942-baef-19b41199e563', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('8e74c155-d3a0-4360-8651-cba51c56bd57', 15, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('8e75ccc0-af20-49ad-a7e6-f34c953ee1eb', 6, '68', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('8f9a3f05-ec53-4763-b36e-b65e4abe62df', 6, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('9102352c-6bf3-45f4-b17f-d1dd2eea0385', 3, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('91ec285d-3fa8-47c4-9feb-518f7fe258c0', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('91f5daeb-2306-4fca-a121-7ce00f0e466a', 4, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('926fd6a6-60cd-445e-b9ca-d8bb0513af16', 13, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('93c6584f-1a58-4248-b9c9-cce858e7f005', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('93febfec-dfaa-4b68-994c-618ae0a3a314', 9, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('941aeb21-973e-4fe2-81ca-c1b761bd2ed1', 6, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('965864ea-27fe-4d2c-9d62-c4e53ed14751', 3, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('97b839b1-9ece-44b5-9465-9b7088569eca', 3, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('987859b3-909a-4ae6-9651-0f80c6d7fdbd', 2, '616', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('988fa6cc-6983-47da-b3c1-6b03cafc659b', 10, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('98f8077c-7b96-4f02-a980-c8ab5a3e734f', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('9933741e-817f-437d-8c6f-18f66b18acbe', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('99ed4a17-111d-4e4c-8328-6cfe3a6be121', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('9a238a40-155f-4fa8-83d3-94d7845d7047', 6, '448', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('9beb6706-c9be-4c0e-866c-3328ac14a51f', 4, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('9ce1cf60-03a5-4432-9b52-5ea48d270f75', 15, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('9d9e8dcb-b3ec-4c86-9f52-a4d84d22e59e', 3, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('9ed82cff-f6b4-488d-abb4-26fbf1d928dc', 5, '224', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('9f013c57-8fe7-47a7-99a2-d2019275ad4e', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('9f65f457-9093-4ead-bcfc-265d40505a0f', 17, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('a1b4bd9e-93f4-44c5-b6a1-bdc254dbde06', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('a1f03c4c-aa3a-42c8-9233-95605c59f3be', 6, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('a2fced70-88e5-4655-a442-c87ee755371d', 8, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('a51f8770-88e2-4c0f-9821-c29c0152afbf', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('a687a173-1792-4b57-b5cb-9beccc349fa2', 2, '549', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('a770b383-fd1c-457c-bda3-9aeb64726b2c', 2, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('a7d3fccf-f4af-4281-a9a8-f4fe40d2df8a', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('a9561847-5e49-4e5c-816c-16ebc38f9245', 2, '252', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('aa5f336a-7be4-49a0-88aa-134d2a2bee3c', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('abaee766-1c4e-45fd-afc2-f1f6ed23ed5a', 5, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('abbbb144-9726-49ce-95cd-988f35107567', 8, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('aca72de3-ff13-469b-9b82-fbf6855fc478', 6, '177', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('acb29cc4-94a1-4b9c-920f-72a1788af1f9', 3, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('ad8a6cc4-f09f-4dc8-a71d-9f28cba64779', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('ae87d502-c267-4bdc-9172-0e75ffeb7f85', 6, '410', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('aecb8de8-c222-4623-bd76-1c15df988189', 6, '194', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('aeeaedfc-4890-48eb-951c-672403f9a285', 4, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('b0124e9d-6daf-4bf5-b82f-58e988a402bb', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('b0335dc8-69c1-4236-88c1-4c71336ce7a0', 9, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('b04f028e-9032-4a32-90aa-728b2c25be79', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('b057faa8-0e41-4f0d-9e38-75e0d9ace87e', 15, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('b2b4ecd9-a666-41f0-ad6a-2b07cef883e8', 2, '259', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('b3ee75da-214a-4819-a2ab-e308a1ee87bb', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('b4332ee7-1aab-488b-98ca-8b04b85ecac7', 8, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('b6d9e3e8-d678-4213-a1ae-746df85440c7', 2, '220001', '150814cb-c70a-4db3-8d4c-1cafa7fc1760', '0c5ab7f9-55b6-4b78-af25-9df55211f4a6', '2022-08-18 07:05:09', '2022-08-18 07:05:09'),
('b7349ef5-ccc9-4d35-8577-0b2453f7bfd7', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('b784ba07-6ec0-4719-b847-0c2c420fa2e4', 8, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('b8104f43-c31f-4e63-8cec-b59c85ef50fa', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('b84f2c6c-81d0-49b1-b0c9-1fbf7506c9ea', 5, '17', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('b889a061-a021-4b97-8431-92b7db8eff03', 5, '418', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('b8c03de3-4cb7-4b02-9ab6-0352fdfda88a', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('b958056e-9d4d-4ee6-8082-21e69c4dd977', 9, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('ba4a415a-207a-470a-82b4-1cc7cca00cb8', 4, '34', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('ba4bb355-d2a9-4a26-96cc-d780d4ea6d42', 6, '351', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('ba9c7030-1a26-4781-93d5-3a932c584fe3', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('bad2246c-9bad-4904-8147-5a4ca7265ba2', 9, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('bb6f94d3-7cf5-4b71-91e5-118467a6c6d6', 9, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('bd005867-2113-493b-b605-9dbfb02ab3cc', 9, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('bd01bd7c-4699-46ab-b0f3-363965e8dcf9', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('be635d8e-4d1b-4a51-929a-4e7f60092d7a', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('bfd5883d-67b4-4f90-980f-4838ba8e1692', 8, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('c01d1ab6-ae0c-40f2-b2e2-823a4d3a577f', 1, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('c020edb1-c365-4ad2-8b74-cc6d0b09a862', 6, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('c094f3f8-334e-4f0d-907c-d4b8cc6dccc8', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('c0afebd3-9a3f-42c6-8eed-28181c566092', 3, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('c1131c35-0125-4926-9a4d-f2ce63abc23d', 8, '373', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('c28091df-647f-4c89-9cd3-457eae5cae73', 4, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('c2aabc00-7be3-4c55-aa56-a2070ce3e89c', 5, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('c33e25c7-b49a-44ac-8611-7c3bbc173bce', 4, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('c3c22720-6618-4908-8dea-590afa979f7a', 3, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('c3fc66b4-e756-4c8b-bd15-bfc2db58d722', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('c43c0819-c63e-4281-b0b0-304f63e27b96', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('c4a5ba7a-4747-4386-8f2e-9f53b0ad5cd2', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('c4f9e231-ba8f-450b-a4da-91ae7541b9a0', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('c5a1af38-4f2b-4911-9ea2-73fab6c184ed', 17, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('c6266c25-d49d-4fd4-88ea-c94a54af4a2d', 7, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('c6b2dc38-7a78-4ed8-a6ed-4b573f69709f', 5, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('c74ee299-afde-4f55-8d04-4897a48031fe', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('c7c042e5-6b6c-4feb-84a5-87ce905e0bab', 1, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('c84ca4ed-147f-4acb-b9e8-7cddd426c372', 1, '7', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('c96462d2-4c0a-43e4-871b-35413bc7c3ac', 5, '466', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('c9833820-a64b-44d4-8375-47bc796553f1', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('ca280564-84b2-479d-88cd-0bb765ad7d15', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('cab69ecb-7248-475f-874b-598dd9864719', 8, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('cb3a86d7-0dff-4b96-987f-0c90a87f6945', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('cb96e984-f4f1-4a1a-ad3d-13393d1a9b22', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('cc42ee2d-9edc-4cd6-9418-ad26f587647f', 6, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('cc92318a-1215-4e8f-a285-0ffab802194f', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('cc93003c-ac4d-4a3d-a242-2c2e2284da99', 5, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('cd66a134-91dd-45b4-8b04-56addea31da9', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('cdb2e38a-11f3-4ce2-bc3f-dc3ba30ef425', 5, '399', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('ce488785-efd2-4897-9c37-84c83da67441', 2, '14', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('ceb00c96-d03a-44d7-a2ce-6488ff2073be', 21, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('ceff7b76-7ded-494a-9ddc-7bed646f3c98', 6, '393', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('d18dc45a-9b94-441b-83ec-db0655028de5', 8, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('d2e3084a-29ae-495e-aad7-4f6287fb47f9', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('d41c6b32-29cd-4ffa-add5-6d4a84a4110b', 6, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('d498774a-eafe-45d1-add5-b64fa229ae4b', 12, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('d4d3b854-f1b0-4f36-a9e8-976fd8fe2315', 4, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('d5863bdf-0730-4740-b6ff-41a647951594', 3, '22', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('d6bb4dab-00f0-4aea-bb75-2be0a10a0edd', 2, '529', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('d73b0ced-dddf-41f8-9a60-cbbacd4954a7', 15, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('d7908931-3a4c-47bf-b42b-8f6d333c3dc3', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('d8817f4f-9e4d-4896-9b94-a5570726dfc1', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('d8da56ed-77a3-491a-9d62-6e095bb603a3', 5, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('da77f46d-f3af-44ab-b08e-44e7faeb6f85', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('dafbc73d-7d72-43ad-8582-67f0d578e122', 14, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('dc37a2c4-97ec-408f-ac98-58678f77a7fb', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('dc5ba9c8-fb05-442d-a9c6-aac5a17b791b', 6, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('dccf2ced-d7a6-4e16-b3c9-a3c0704a3244', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('de4e2190-22ce-47a0-bd62-c9f498ffebc3', 0, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('deb9cbce-a72a-45c0-961a-72d4fcf600c6', 2, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('ded6e35c-2bd7-4e16-9616-bd7a7d112d4a', 3, '579', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('dfc44b74-4332-4251-9777-57c4fba0a82e', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('dfccb138-d506-41e4-8cd8-01235ab54e40', 2, '598', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('e0863dd0-8123-42c5-a89a-6eba232638bd', 4, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('e093b8f2-35d0-4457-ae7b-bcdbd4fba867', 5, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('e2058a46-9bc9-4cdd-9903-7eb2095ce27f', 2, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('e29427cc-67d7-4457-85e2-1027d968fdbc', 10, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('e2a21351-e840-47d2-bf7d-5a8a1878fed0', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('e34a5b15-455c-4dec-bab4-1fbc61462337', 5, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('e3dc30c5-0d66-4d96-a6cc-b9b16c4ec757', 6, '0', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('e5dbc525-920e-4d1e-ae40-c8008ebbc68d', 2, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('e5e402f0-b5f7-4d0e-8456-9104b248a923', 6, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('e6609574-b684-4e07-8ae8-be6c1cc063a9', 3, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('e69da9ec-fb95-42e3-af3a-a713f3725ff0', 4, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('e7562c52-c517-4d73-9920-570e16f55b0c', 11, '', NULL, NULL, '2022-08-28 23:47:59', '2022-08-28 23:47:59'),
('e760f670-fbe4-4c3a-9fe2-b0b2093e3f28', 4, '85', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('e76ba717-ca84-467d-8b7d-4f89e0584122', 2, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('e7b9e892-669d-4257-995e-65b4424c889c', 2, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('e8187bc7-c084-4c32-88b7-d5c8dc193324', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('e8be8612-4ea6-416b-bd06-291c542b0bae', 4, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('e912d7e9-cfd8-4787-b7c9-a0810f40e823', 2, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('e979beea-8d68-4c94-bd35-b7d227bcca27', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('e9a640f2-8b56-4833-a92e-9cc959100d6a', 1, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('ea5fe9f8-29f9-458f-8050-7a6b2d1e268b', 3, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('eb2dd6ef-be53-4e30-8901-8e9683e0200c', 2, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('ee098572-f88b-40ed-8d1a-761205a6f739', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('ee646a3d-4133-4f62-94f2-2aa867789642', 7, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('ef1d58f4-c4e6-48bd-aca2-9f99967f76e8', 5, '397', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('f0d015fd-1d80-464b-b4bc-11a7df029afa', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('f238dff9-39f3-44da-a049-cb316016913f', 11, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('f46593b5-0569-4a43-b5ec-91735645fc22', 6, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('f59295ac-ae0f-49d6-bbcb-37fc7d8ea096', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('f5ec3c18-1d49-4ad2-84d6-4d0a0837b7ae', 6, '', NULL, NULL, '2022-08-28 23:47:56', '2022-08-28 23:47:56'),
('f81661f8-c51a-4e3a-87be-f774f91e41d8', 8, '180', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('f836dda1-d9f4-4b60-8f19-175565e7889d', 15, '', NULL, NULL, '2022-08-28 23:47:54', '2022-08-28 23:47:54'),
('f8711a74-d54c-4f0a-be76-7b576391eb94', 7, '23', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('f9e3bee6-423d-40f8-9d61-c6442e080f81', 2, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('fa8e0a2d-3249-4c8e-923e-f0b2fb000b6a', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('fafc9bec-3de3-47b9-8e92-7cb855dc075b', 7, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('fb30cff2-d808-43a5-8f65-6029d619ad4d', 5, '', NULL, NULL, '2022-08-28 23:47:53', '2022-08-28 23:47:53'),
('fb39d95e-1e8a-45de-afb0-44e5b65458fe', 10, '', NULL, NULL, '2022-08-28 23:47:57', '2022-08-28 23:47:57'),
('fc79dafd-43ff-4e0f-b595-c93a98e2c344', 2, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('fcd469c2-6b0e-4db1-8fde-2bed689b4cdf', 5, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('fd0382c2-6831-4061-9fda-bd12d48488b3', 3, '', NULL, NULL, '2022-08-28 23:47:58', '2022-08-28 23:47:58'),
('fd2e2d85-66db-4c7a-a447-ecf395e1d8c8', 3, '', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('fda5dc9a-890f-40ab-98b6-8fcf9cbeee76', 6, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('fdfb2d84-6c6d-4ce1-9e73-41291efcb069', 2, '76', NULL, NULL, '2022-08-28 23:47:52', '2022-08-28 23:47:52'),
('ff605fa9-0ad5-4db8-bb25-ebcfffad9a69', 1, '', NULL, NULL, '2022-08-28 23:47:55', '2022-08-28 23:47:55'),
('fffd5a85-8f77-4d33-aa53-6a3e4f8e19f3', 5, '', NULL, NULL, '2022-08-28 23:47:51', '2022-08-28 23:47:51');

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

--
-- Table structure for table `treatment_methods`
--

CREATE TABLE `treatment_methods` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` enum('resistant','adverse') COLLATE utf8mb4_unicode_ci NOT NULL,
  `drug_group_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugs` json NOT NULL,
  `months` int(11) NOT NULL,
  `months_2` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_methods`
--

INSERT INTO `treatment_methods` (`id`, `name`, `category`, `drug_group_id`, `drugs`, `months`, `months_2`, `created_at`, `updated_at`) VALUES
('01176407-cc3d-4e0a-ae40-fc1daa070b34', '2 RHZ/4 RH', 'adverse', '75cb1211-1e34-4775-9cfa-83c879db0d11', '[\"554f0ad0-30ce-449b-a031-fe21d0adf889\", \"de785e45-bd8a-4759-8d02-e419e25d7b75\"]', 2, 4, '2022-08-25 04:14:39', '2022-08-25 04:14:39'),
('0256d0dd-2c6c-442e-b901-13094c9163ea', '6 Bdq-Dlm-Cs-Lzd-Cfz/ 3-6 Cs-Lzd-Cfz', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"da938bb0-0f60-4592-88d6-c1e7e71b5032\", \"b44a00be-1649-41fa-9323-4c2c466e1b16\", \"2ecc1332-2d99-43aa-b2c7-9d61264f2d23\", \"bca55c1a-a072-4d57-8948-40466a743422\", \"2a3d7937-6788-4b6c-afe2-91bf06120a56\"]', 6, 6, '2022-08-25 04:06:06', '2022-08-25 04:13:37'),
('2b4d26b5-bc8a-4d94-837e-6e0d27c67a21', '9HRZE-Lfx', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"2f033930-e257-4045-8fec-fae04fbe1169\"]', 9, 0, '2022-08-21 08:01:22', '2022-08-25 04:00:44'),
('356086a1-4a8c-4c46-8e52-6113085aa214', '6-9 сар Bdq-Lzd-Pa', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"da938bb0-0f60-4592-88d6-c1e7e71b5032\", \"c8958180-07f4-4625-9c5a-247ab18ab278\"]', 9, 9, '2022-08-25 04:08:41', '2022-08-25 04:08:41'),
('395a7a22-a059-492f-84b7-ffd3ba1f5501', '2RHZE / 4 RH', 'adverse', '31d08f60-6fd8-4d39-917e-c32c75152608', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"8f82172e-17a9-467a-a340-4b5bd15adabb\"]', 2, 4, '2022-08-25 04:16:07', '2022-08-25 04:16:07'),
('60cba7dc-357e-4e20-9109-f04bb26e21a0', '3 HRZE / 4 HR', 'adverse', '31d08f60-6fd8-4d39-917e-c32c75152608', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"8f82172e-17a9-467a-a340-4b5bd15adabb\"]', 3, 4, '2022-08-21 07:59:51', '2022-08-21 12:33:52'),
('6a7dba8e-b6aa-4288-9a70-42c6de59a6b0', '9 HREZ-H*', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"e523f5d9-1c57-4830-aec8-8cc9ea49c062\"]', 9, 0, '2022-08-25 02:37:37', '2022-08-25 02:37:37'),
('7dd37f34-b77e-4b43-aeaa-0f4661926951', '9HRZE-H*', 'adverse', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"4bc29187-e57b-4112-a5fe-05cd8e1a4912\"]', 9, 0, '2022-08-21 08:00:36', '2022-08-25 03:59:50'),
('9093887e-ce0c-4ce7-99ba-7735a537aa77', '6-9 сар Bdq-Lzd*-Pa', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"da938bb0-0f60-4592-88d6-c1e7e71b5032\", \"3c10bbde-fe55-4a55-88ea-0b0dd65b676a\", \"c8958180-07f4-4625-9c5a-247ab18ab278\"]', 9, 9, '2022-08-25 04:07:38', '2022-08-25 04:07:38'),
('e360efd0-09d5-4d28-bbb9-e9a5d6c76206', '2 HRZE / 4 HR', 'adverse', '31d08f60-6fd8-4d39-917e-c32c75152608', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"8f82172e-17a9-467a-a340-4b5bd15adabb\"]', 2, 4, '2022-08-21 07:58:24', '2022-08-21 11:10:31'),
('e7da32d0-f4c2-4aa0-b39f-3ab4c31f57fb', '3 HRZE / 6 HR', 'adverse', '31d08f60-6fd8-4d39-917e-c32c75152608', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"8f82172e-17a9-467a-a340-4b5bd15adabb\"]', 3, 6, '2022-08-21 07:58:58', '2022-08-21 12:33:33'),
('eb289381-8e13-4b8d-898d-356c940013a4', '2RHZE/ 4RH', 'adverse', '31d08f60-6fd8-4d39-917e-c32c75152608', '[\"3f110d69-f250-4eeb-bcf0-e3461247c7ab\", \"8f82172e-17a9-467a-a340-4b5bd15adabb\"]', 2, 4, '2022-08-25 04:15:27', '2022-08-25 04:15:27'),
('ef71879c-6c8e-4a35-96b8-0d855caadd1b', '6 Bdq-4 Lfx-Eto-E-Z-H*-Cfz / 5-6 Lfx-Cfz-Z-E', 'resistant', '80bac310-e17e-4b4c-ac58-81237d73f010', '[\"da938bb0-0f60-4592-88d6-c1e7e71b5032\", \"7f858bb3-1c6c-4029-afb8-145d1ad3b941\", \"bda6f0ad-4831-4304-8e3a-6f5a5af36924\", \"0e7c6c9c-b233-4bae-bc39-9d2cb86e29aa\", \"e523f5d9-1c57-4830-aec8-8cc9ea49c062\", \"bca55c1a-a072-4d57-8948-40466a743422\"]', 10, 6, '2022-08-25 04:04:00', '2022-08-25 04:04:00');

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

--
-- Table structure for table `treatment_places`
--

CREATE TABLE `treatment_places` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_places`
--

INSERT INTO `treatment_places` (`id`, `name`, `created_at`, `updated_at`) VALUES
('3b924dc5-82c6-46fb-aff8-1d2dadfc5e26', 'СДИ-ээр', '2022-05-07 01:26:28', '2022-05-07 01:26:52'),
('42b4d5d4-205b-4041-9db2-d22ed2288eb3', 'Диспансер', '2022-05-07 01:27:06', '2022-05-07 01:27:06'),
('5d6ceffe-88e1-444f-a6c3-17bc5e0b81d8', 'Өрхийн ЭМТ', '2022-05-01 20:45:57', '2022-05-01 20:45:57'),
('78fb302e-d8fa-4ac3-877b-6bca8be02bf4', 'Хоолтой эмчилгээ', '2022-05-07 01:26:57', '2022-05-07 01:26:57');

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

--
-- Table structure for table `treatment_processes`
--

CREATE TABLE `treatment_processes` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `treatment_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `drug_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `process_date` date NOT NULL,
  `status` enum('pending','issued','used') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_processes`
--

INSERT INTO `treatment_processes` (`id`, `treatment_id`, `drug_id`, `process_date`, `status`, `created_at`, `updated_at`) VALUES
('07de436d-6617-4dbc-a0a6-119da2ec4c24', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-21', 'pending', '2022-08-24 01:32:26', '2022-08-24 01:32:26'),
('0d629c4a-ea70-4050-99c0-f6fb3aefe3eb', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-24', 'pending', '2022-08-24 02:19:13', '2022-08-24 02:19:13'),
('0fde726b-8982-4042-bdee-d7fdb42aebb1', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-22', 'pending', '2022-08-24 01:32:52', '2022-08-24 01:32:52'),
('2a61021f-f0d0-4408-9eec-46faa11738dc', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-25', 'pending', '2022-08-24 07:22:00', '2022-08-24 07:22:00'),
('48bf94fa-4d05-414e-a794-cc2bd4cedde9', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-25', 'pending', '2022-08-24 07:22:00', '2022-08-24 07:22:00'),
('4971cb0d-c760-4d77-b083-f99501cf2c1d', '6421f01e-8f7a-4386-adcb-4cdd00f815d1', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-15', 'pending', '2022-08-24 03:04:33', '2022-08-24 03:04:33'),
('49cb7868-ba81-48cd-8936-c023a955ed1c', '6421f01e-8f7a-4386-adcb-4cdd00f815d1', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-15', 'pending', '2022-08-24 03:04:33', '2022-08-24 03:04:33'),
('82989ae3-29ce-429e-b739-58638f8679de', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-23', 'pending', '2022-08-24 01:57:27', '2022-08-24 01:57:27'),
('8515209e-e33f-4dd2-b077-cac66d0458f4', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-22', 'pending', '2022-08-24 01:32:52', '2022-08-24 01:32:52'),
('dc2632d4-25a0-4cf2-a6d7-a2ca2cb75156', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-21', 'pending', '2022-08-24 01:32:26', '2022-08-24 01:32:26'),
('ededc6d9-3bb2-41ac-a1c4-28bf32c02fa4', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '3f110d69-f250-4eeb-bcf0-e3461247c7ab', '2022-08-23', 'pending', '2022-08-24 01:57:27', '2022-08-24 01:57:27'),
('f392b111-83d9-4fa4-853a-c0fa65d44f13', 'd1479c30-9098-45fb-aa7c-5a224a235e15', '8f82172e-17a9-467a-a340-4b5bd15adabb', '2022-08-24', 'pending', '2022-08-24 02:19:13', '2022-08-24 02:19:13');

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

--
-- Table structure for table `treatment_results`
--

CREATE TABLE `treatment_results` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `condition` enum('again','close','transfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result_react` enum('dead','cured') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_results`
--

INSERT INTO `treatment_results` (`id`, `name`, `sort`, `condition`, `result_react`, `created_at`, `updated_at`) VALUES
('123d576e-2cfe-42a3-8ff9-c2dd422112bb', 'Эдгэрсэн', 1, 'close', 'cured', NULL, '2022-08-14 11:08:27'),
('3f511354-5c9d-405b-95d1-eeea23ea4396', 'Хяналт алдагдсан', 4, 'again', NULL, '2022-08-15 09:10:34', '2022-08-28 23:44:09'),
('4ccc0790-eaa8-4c97-b88a-f92d7b79fae9', 'Үр дүнгүй', 3, 'again', NULL, '2022-05-05 02:37:19', '2022-08-15 09:12:13'),
('6a029901-5d13-4892-9118-87447f7e237f', 'Эмчилгээний үр дүн тооцоогүй', 7, 'again', NULL, '2022-08-15 09:11:53', '2022-08-15 09:12:19'),
('6fc218c7-f1ed-483c-8ad1-fc5cc22ea321', 'Дүгнэгдээгүй', 5, 'again', NULL, '2022-08-15 09:10:52', '2022-08-15 09:12:24'),
('73033ff5-25ca-4ea2-b6db-96834a6af931', 'Онош өөрчлөгдсөн', 9, NULL, NULL, '2022-08-28 23:43:44', '2022-08-28 23:43:44'),
('7e17ce99-8db2-4be2-b41b-79c44c13bdc4', 'Нас барсан', 6, 'close', 'dead', '2022-06-26 01:01:31', '2022-08-15 09:11:29'),
('b5c98162-1d8f-4f72-a8c4-d7a15d046385', 'Эмчилгээ дуусгасан', 2, 'close', 'cured', '2022-08-15 03:51:12', '2022-08-28 23:43:03');

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

--
-- Table structure for table `treatment_sections`
--

CREATE TABLE `treatment_sections` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatment_sections`
--

INSERT INTO `treatment_sections` (`id`, `name`, `sort`, `created_at`, `updated_at`) VALUES
('02c20673-51db-49f7-bdaa-3edf138b42fe', 'Өвөрмөц эмчилгээний бүлэг', 7, '2022-08-28 23:34:13', '2022-08-28 23:34:13'),
('150814cb-c70a-4db3-8d4c-1cafa7fc1760', 'Бүлэг I', 1, '2022-08-05 11:36:27', '2022-08-14 11:07:54'),
('4349bfe7-8607-4d3f-9e2e-6af2fff000ce', 'Бүлэг III', 3, '2022-08-05 11:36:48', '2022-08-15 09:59:31'),
('4e528507-27b4-4af7-a7af-56044cbfa4cc', 'Бүлэг II', 2, '2022-08-05 11:36:40', '2022-08-14 11:07:57'),
('b686cabb-36e8-4292-a6f3-92974c14a191', 'Бүлэг IV-2', 6, '2022-08-28 23:33:48', '2022-08-28 23:33:48'),
('f5031521-8bde-4c08-a46d-61c92d6c9ac7', 'Бүлэг PDR-1', 5, '2022-08-28 23:33:39', '2022-08-28 23:33:39'),
('fbf65f3b-d4d7-4701-827c-a7c1fbeccf91', 'Бүлэг IV', 4, '2022-08-05 13:39:49', '2022-08-15 09:59:34');

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

--
-- Table structure for table `tubis_cases`
--

CREATE TABLE `tubis_cases` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `patient_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` enum('resistant','adverse') COLLATE utf8mb4_unicode_ci NOT NULL,
  `resistant_level_1` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resistant_level_2` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resistant_level_3` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `case_index_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `case_description_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `survey_date` date NOT NULL,
  `diagnose_date` date NOT NULL,
  `register_date` date NOT NULL,
  `treatment_date` date DEFAULT NULL,
  `tb_type_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `diag_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `diag_note` text COLLATE utf8mb4_unicode_ci,
  `confrim_model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confrim_model_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detection_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_cough` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `cough_days` int(11) NOT NULL DEFAULT '0',
  `has_vaccine` enum('yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `x_ray_result_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `x_ray_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risk_factories` json DEFAULT NULL,
  `hiv` enum('unknown','yes','no') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unknown',
  `hiv_test` json DEFAULT NULL,
  `infection_source_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_adult` int(11) NOT NULL DEFAULT '0',
  `contact_child` int(11) NOT NULL DEFAULT '0',
  `province_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_state_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tubis_cases`
--

INSERT INTO `tubis_cases` (`id`, `number`, `patient_id`, `category`, `resistant_level_1`, `resistant_level_2`, `resistant_level_3`, `case_index_id`, `case_description_id`, `start_date`, `survey_date`, `diagnose_date`, `register_date`, `treatment_date`, `tb_type_id`, `diag_id`, `diag_note`, `confrim_model`, `confrim_model_id`, `detection_method_id`, `is_cough`, `cough_days`, `has_vaccine`, `x_ray_result_id`, `x_ray_path`, `risk_factories`, `hiv`, `hiv_test`, `infection_source_id`, `contact_adult`, `contact_child`, `province_id`, `state_id`, `sub_state_id`, `organization_id`, `register_user_id`, `created_at`, `updated_at`) VALUES
('01792879-1195-4695-9a26-8262b99eeea6', '261800030', 'df05c717-e512-47ef-b1b8-c67fc4e125f0', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-01', '2018-01-12', '2018-01-12', '2018-01-23', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '05d68fef-9dc4-4289-9e4d-3dab4ff49a7c', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('044f4acc-265c-4293-9771-7053cd7f4327', '221800001', 'be28c51b-c047-4ab1-81e6-1d91de5194a0', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-02', '2017-12-10', '2018-01-08', '2018-01-02', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'a7c2cbec-ad80-40a6-93b4-128ba0d53685', '1b2caaea-afe9-4679-acf1-7cd8ecc31b02', '854f9f44-2928-4742-a811-9f920a010876', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('07145212-2a16-46c1-8027-0fa79c9bff79', '281800050', 'bc6e4ae2-3067-4d7c-89b5-a51b19f89f87', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-02-20', '2018-02-27', '2018-02-28', '2018-03-01', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '8a9b1207-ed48-4162-8521-e785a4f07f73', '2ad0e077-b677-4288-8427-4e50a8199d84', '9883efbe-3e0b-49f9-9dba-e457a3b4eaff', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('0a9ead51-9952-4d6b-b142-4fa76b2af431', '181800002', 'd1095ab2-8765-42af-9328-eff783a69f3e', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-12-20', '2018-01-02', '2018-01-01', '2018-01-05', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '9fca428d-9841-4559-a5ab-838164bda5c7', 'cd466423-d8ca-49f3-8eb6-754cf346322b', '3d9f55b6-8648-446b-bf14-586edac990a2', '97b5e258-cbd0-4190-a76c-d9ca50d0d3fb', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('0ddb46a5-7b72-4cb8-a08b-5776c0ed2e7f', '101800001', '76dab4b9-ac76-4027-8b7c-49a973ac607e', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-28', '2018-01-05', '2018-01-05', '2018-01-08', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0f20353e-032c-47ab-b2bc-5eaca84f19a8', 'e8e94be8-5d40-4521-a36f-531e899b785a', 'b5f3e2b7-7537-4ef4-b260-49d11a5fcae8', 'd4900182-5fdf-481c-9b45-93dbcdcaf1e6', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('0e7f208d-a31d-4cae-9152-e917edea068b', '261800023', '63b02e31-9bee-428e-b42c-9c3397dbbb07', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-10', '2018-01-10', '2018-01-11', '2018-01-12', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '072bd156-c88e-46df-9b9a-121dde8c0b11', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('0e97fc9c-69af-4d48-9dfe-966cac5c637d', '261800028', '1e807229-63b5-4de4-9deb-6481eccc1de7', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-01-03', '2018-01-15', '2018-01-19', '2018-01-22', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('10c5d3ba-b141-4f7f-b038-906c166b499e', '261800032', 'f1d688bd-246c-486a-8157-0de1b1ced988', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-15', '2018-01-19', '2018-01-22', '2018-01-23', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '1baf8893-0ec2-4d1e-863e-d6485d54ea76', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('1760d5aa-496d-4158-a289-26fc8a1cd443', '031800002', '0d106dac-cb17-4399-9d5c-d0bc2588826e', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-09-25', '2018-01-17', '2018-01-18', '2018-01-18', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '72e6ea3c-e632-4832-ae1c-f950d078267b', 'e2e6a76a-deb3-451b-ba99-8bff8cc9bc97', '049954eb-8ca3-4a4e-a82e-bd31cfe5fc2a', '44594233-077d-4e7c-b234-ed773914b96e', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('1842a83f-6124-4c99-abde-ee5df72a8404', '231800005', '19271e18-94c1-427d-8515-3fd4713928ef', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-20', '2017-12-07', '2017-12-07', '2018-01-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '072bd156-c88e-46df-9b9a-121dde8c0b11', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('1b54caca-dfc1-415f-b514-a767ccee0532', '261800037', 'cfcd977c-13b6-47c5-b30d-906cbb639e28', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-05', '2017-12-22', '2017-12-22', '2018-01-24', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('1e48087f-abfa-47dc-b457-1f517777fb63', '261800001', '5f3c05c5-bb97-4252-a432-2f4d20c0f5bf', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-13', '2017-12-26', '2017-12-27', '2018-01-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '6f1dacfe-9baf-4623-8124-82f9ea83ce8f', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('26b934c9-0679-46e8-b337-7212fbc5d64c', '141800001', 'e9c9da9c-08ee-4a21-8c46-a6b42eaeb4e9', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-09-20', '2017-10-01', '2017-12-13', '2018-01-09', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', 'bb8ad047-eef3-4b78-a9d4-807d7fa7dd78', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '625509ff-b241-436d-b621-73380954d278', 'c44b11ce-4b62-4617-b6d2-bca1eb299bea', '65e31340-51fc-4b84-ba37-4d71d67009bf', 'f1be5c36-e74b-4190-98d3-67a3b809924f', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('26e6a4b7-ec7d-49fd-925c-c7952d6f7cb5', '2601170470', '02377b28-df2f-46d1-bc61-1c1633cdbf8b', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-01-05', '2017-08-01', '2017-08-02', '2018-08-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '072bd156-c88e-46df-9b9a-121dde8c0b11', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('27225630-47dd-4034-a642-20e8aea82469', '261800022', '5c1c328f-b4f5-4c38-bfa8-86531a683a3d', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-10', '2017-12-19', '2017-12-27', '2018-01-11', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', 'b1f90954-9b49-445f-99ad-951ba721fdc3', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('2bbb27e6-ef2b-412a-9816-760a745f4386', '021800001', '77fefbcf-808c-46f8-98a4-1278e90c9593', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2016-04-16', '2017-12-12', '2017-12-31', '2018-01-17', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, 'e2f2e464-814c-4044-b46b-75e6787b3025', '473f9a78-d1b2-41b0-bb61-c99232273fac', '7f093b81-c2c0-4d1e-9354-8cbdd773bcf8', '53eec9d0-8f75-4ed3-8332-11a8cf57053e', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('2d0c33dc-e99a-4a4a-950b-a090908c4056', '231800001', '7aba2001-2a44-48a1-9355-b9802eb3738e', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-01', '2017-12-20', '2017-12-20', '2018-01-02', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '2ad0e077-b677-4288-8427-4e50a8199d84', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('2f32a257-1217-4c5f-8385-01a7a7fa4f86', '231800009', '47f7afc0-62be-4bff-bfff-f8723f28bbff', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-03-10', '2017-11-21', '2017-10-30', '2018-01-08', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '1c7cec2a-d22d-43d1-8763-c5f6c5ef7c63', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('35209712-d07e-43ad-843a-02bf73cbbc70', '231800012', 'd5d9db79-261d-4678-881d-ef506e7e8c82', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-14', '2017-11-24', '2017-11-24', '2018-01-12', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '1baf8893-0ec2-4d1e-863e-d6485d54ea76', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('3859dc5a-d2a7-44ee-8113-d70f204a24ed', '261800018', 'a421cb74-ca2a-402b-9361-da54c9fdf621', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-15', '2018-01-10', '2018-01-11', '2018-01-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '6f1dacfe-9baf-4623-8124-82f9ea83ce8f', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('39395987-533e-4d82-b493-76b8c9a9c2b0', '221800002', 'afeb4d89-add2-49cc-bf39-66edb8efa408', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-20', '2018-01-10', '2018-01-11', '2018-01-15', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '8b69ab49-b1f2-4e4a-bf18-ed824e32c88e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'a7c2cbec-ad80-40a6-93b4-128ba0d53685', '2ad0e077-b677-4288-8427-4e50a8199d84', '854f9f44-2928-4742-a811-9f920a010876', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('3cd5c595-d539-47b6-8452-56a5d346fdb7', '261800013', '6e8dd472-9d14-4ebf-bc5c-498aca009240', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-28', '2018-01-02', '2018-01-03', '2018-01-15', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '07c02268-71ff-4e33-8675-45b24c26b1f6', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '41a1d70a-be52-4ed9-b5aa-f3d6b6fabc4e', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('3fe6bf0a-adbc-4664-bcb3-5fdd5afd2607', '261800038', 'e3609672-7d57-4a0c-be41-547a1ec0aa44', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-12-20', '2018-01-05', '2018-01-12', '2018-01-25', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '23594802-cbe1-4748-9257-f82928f13aa6', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('4560a533-6946-4c34-8e65-b841c4c1f974', '231800013', '23b35367-33fa-4763-bc7a-29c6a781c6c2', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-17', '2017-11-22', '2017-11-22', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '441b3724-e012-4756-8be0-e92ca5268d9c', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('466b213e-ef9c-4c41-8f6a-b69e7105ecce', '08180002', 'a766ace2-24a6-4dae-85cb-58dfcdb802aa', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-09-05', '2017-10-10', '2018-01-15', '2018-01-15', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '8b69ab49-b1f2-4e4a-bf18-ed824e32c88e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '735db745-97e6-4c35-93c7-6cf4e8f123c2', '2dfe1ebd-29e1-4ade-b32a-a286fbc0c11e', '2c69b4ce-902e-482a-97c6-d688b620409e', '016178e4-41aa-4ffb-8266-e432a23d629c', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('49c162ff-b8b6-40d5-ba71-b84d966c2517', '08180004', '6d2227f6-482f-4d7e-9e1a-9936d08ea855', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-09-08', '2017-10-14', '2018-01-11', '2018-01-16', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '59bc5c62-e029-4a4c-859e-96f95a5d9de5', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '735db745-97e6-4c35-93c7-6cf4e8f123c2', 'dfd526ad-0412-41d4-a938-bddea20da672', '1cfbe724-03d8-4805-aeef-f55c9894c9c1', '016178e4-41aa-4ffb-8266-e432a23d629c', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('4a0e10fb-93c9-44c8-8928-3c981ffe1dc4', '251800001', '5a56e2ec-298b-4cc2-8707-6e5ab4673437', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-20', '2017-11-29', '2018-01-03', '2018-01-03', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'a97b4ca4-8976-463f-83e8-5d207b3c25d1', '2ad0e077-b677-4288-8427-4e50a8199d84', '5cec10aa-c905-41bd-85a6-4b3c5fa8f0d3', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('51049078-40a4-4df0-be47-3cdab1b3215e', '231800024', '72112ccf-f1d2-4bf2-acf7-5a2653c7c2c6', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-01', '2017-11-17', '2017-11-20', '2018-01-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('558da0e5-be3b-4d0d-aa85-dc514efb1e47', '261800034', '6bfb32d2-400e-4beb-b797-3099ed28cb59', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-10', '2018-01-02', '2018-01-08', '2018-01-09', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '07c02268-71ff-4e33-8675-45b24c26b1f6', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('5d35c8b3-5b42-42a7-9f2d-c04dc943847a', '231800022', '8d0d0bdb-1767-4111-81ba-0b172d763156', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-31', '2018-01-13', '2018-01-13', '2018-01-16', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', 'bb8ad047-eef3-4b78-a9d4-807d7fa7dd78', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '00505521-2dbd-4b6a-a544-dbf2d2f2b171', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('5f42ef53-fe02-4860-8bbf-34082e4db4fb', '211800002', '35930c1e-54f1-4378-9492-31c22274b46a', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-01', '2017-12-01', '2017-12-30', '2018-01-01', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '8b69ab49-b1f2-4e4a-bf18-ed824e32c88e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '9e5ec3f2-24e5-40f9-8d53-36ecbbd2597b', '1fc8b6a3-60d7-47bb-a42a-601009481604', '38dd3f00-79d0-4ff1-af56-ac65a29d1d7a', 'a483cbf8-6420-4a1a-bae9-afc23fd59cdd', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('61ba20cc-c10a-4301-8e06-0f69d65fe933', '231800019', 'e940e35f-bbc9-411d-8ef0-21023468be6d', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-27', '2017-10-30', '2017-10-30', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '6f1dacfe-9baf-4623-8124-82f9ea83ce8f', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('61e0fbdc-494c-492f-93da-4c74c5abe558', '101800002', '43168007-6f97-4e75-b5bb-866ebd1d5d96', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-08-10', '2017-12-05', '2018-01-08', '2018-01-11', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '3ac594e6-4b77-4b68-aad9-89ca8639117e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0f20353e-032c-47ab-b2bc-5eaca84f19a8', '296a0125-fa52-409c-a0b7-719019c5b69b', 'c564ad1c-0e49-4b5c-9b15-202ebfa098a0', 'd4900182-5fdf-481c-9b45-93dbcdcaf1e6', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('665ea163-a8df-4b72-83e6-632cdb4097cb', '261800017', 'bda09251-6a09-4a0c-a52d-08e9a21723a1', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-01', '2017-11-23', '2017-11-23', '2018-01-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('67f382e6-73bc-4e07-807d-f2d3fe84aa65', '2200001', 'd976b39e-1af6-4ad7-9789-8f5ebbbcbe77', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2022-08-01', '2022-08-04', '2022-08-05', '2022-08-05', '2022-08-21', 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '2c0fe2d0-2f66-4fd0-baa7-69b3dbdd2b02', NULL, 'App\\Models\\AnalysisResult', 'eafd9648-c3bf-4a3f-ad35-1892c6c4a5f7', '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'yes', 3, 'yes', 'ea2b40fd-c939-4487-b97e-0d07711ab140', NULL, '[\"ced8951c-c4d6-4d27-aa0b-f2bda4c5b89f\", \"de43ba7e-9d18-4b6f-beea-c90b6b10592b\", \"83c85179-28b7-40ec-8156-8f9f11b556ae\"]', 'no', NULL, '247eab27-08b2-4e8c-b43b-8c4722a3003c', 2, 2, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '22c353e8-4a01-46cd-bb50-a802da41c18d', '131c70db-35ce-46b4-9ffe-7e3158c34aef', NULL, '4b4b9dbe-11e0-420f-b1e6-da950369430e', '2022-08-05 12:56:50', '2022-08-21 11:11:31'),
('6899c28d-4d8b-482e-8109-8a8701dcfd7d', '091800001', 'be9cf352-bbbd-40c7-93e3-e5c8b1a36085', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-02', '2017-12-28', '2018-01-03', '2018-01-04', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, 'bb9d8f4f-3971-4097-8167-d276934ce60e', '1fc8b6a3-60d7-47bb-a42a-601009481604', '02f8cf68-a111-46f6-89dc-6eabecd5d07c', 'ba7d4e25-d617-4dbf-ace9-362fa1d3dee0', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('7115ffac-e300-43af-9df8-ec049b1b658b', '231800011', 'f89b8a1d-a293-4b0b-880e-f6b0730e134e', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-07', '2017-11-11', '2017-11-11', '2018-01-10', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '9a0246c2-fb59-464a-bf46-a5bb8626c83b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '47a24423-9c3c-4c9d-a8da-de821eb72117', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('7525befb-1a6b-4d56-8ce3-60b1082cb8ab', '261800009', '855906b8-79a2-46b4-b4f9-3a79414da5e1', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-16', '2017-11-27', '2017-12-04', '2018-01-09', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '05d68fef-9dc4-4289-9e4d-3dab4ff49a7c', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('78e8e9a4-9dbd-4866-8f78-e99b3ca3ef42', '261800016', 'c634b5a9-5f57-413b-b2ca-b28602ae0dbc', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-10', '2018-01-08', '2018-01-16', '2018-01-18', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '1baf8893-0ec2-4d1e-863e-d6485d54ea76', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('7b8d4ecd-7c5e-47de-9bd1-d517f235be52', '261800027', 'f31e99f6-3b1f-49f6-b271-ef63b8cdc53e', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-05', '2017-10-16', '2017-10-31', '2018-01-22', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '23594802-cbe1-4748-9257-f82928f13aa6', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('7dd4890a-4efe-4428-807f-07d3a443a64c', '2200004', '0762b3b6-64ca-4489-a54b-67a38f2ab957', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2022-08-17', '2022-08-17', '2022-08-17', '2022-08-17', '2022-08-15', 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '16e4fadc-8cec-4587-ae8f-33b492d7fc6c', 'ы', NULL, NULL, '40add5e0-26f1-4df2-a86d-871ff7099cdd', 'no', 0, 'no', '3e66da05-fa69-463a-973b-83310f768fe4', NULL, '[\"04bcc331-875f-4c44-ba80-a9fda3c2ff1d\"]', 'no', NULL, '247eab27-08b2-4e8c-b43b-8c4722a3003c', 5, 1, '9e5ec3f2-24e5-40f9-8d53-36ecbbd2597b', '1c1e9a09-d74e-482b-bc14-a6df9adbeb78', 'd70bfb58-7c18-41be-8dc9-3a28250ef0ff', NULL, '1372b12e-8c02-43f6-ba78-8567cb289b7e', '2022-08-17 06:38:44', '2022-08-22 02:02:19'),
('8178abc4-ed1f-4ad7-8b34-bdaea77b047b', '261800007', 'cfa11dd7-9f8b-4bf7-bcf8-d4ccb0be36ad', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-15', '2017-12-25', '2018-01-02', '2018-01-03', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '07c02268-71ff-4e33-8675-45b24c26b1f6', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '00505521-2dbd-4b6a-a544-dbf2d2f2b171', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('8babbfae-755e-4e2f-9a23-56e48471c08d', '261800035', '7a003bab-dd47-4eda-a9b8-5855951aaddc', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-13', '2017-12-26', '2017-12-27', '2018-01-24', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('8c40b7a6-bfde-48a2-bfae-0d0a32ae5780', '091800006', 'b362759d-7b96-41d4-b31b-b1249180823c', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-12-10', '2017-12-15', '2017-12-22', '2018-01-11', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, 'bb9d8f4f-3971-4097-8167-d276934ce60e', '1fc8b6a3-60d7-47bb-a42a-601009481604', '08108042-eae5-4ce5-a99c-ddc0b4d40960', 'ba7d4e25-d617-4dbf-ace9-362fa1d3dee0', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('8e5e0c5f-70f9-43da-a7d1-b657f8b093de', '221800003', '11f6f591-ce30-4088-bd40-9e973e2c66ab', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-10-10', '2017-10-23', '2018-01-16', '2018-01-18', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'a7c2cbec-ad80-40a6-93b4-128ba0d53685', '05d68fef-9dc4-4289-9e4d-3dab4ff49a7c', '854f9f44-2928-4742-a811-9f920a010876', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('8ee86146-a19e-4512-9357-9420c8171558', '231800014', '1d188290-d366-4d9f-865e-8f6515e6ff80', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-25', '2018-01-10', '2018-01-10', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '00505521-2dbd-4b6a-a544-dbf2d2f2b171', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('93c4516a-2fa4-4031-9e0d-b072f411b662', '231800020', '683c58ec-802c-4b45-9d7c-e3d84798ed9d', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-01-12', '2018-01-15', '2018-01-15', '2018-01-16', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '7a4587a4-0a93-46f3-8932-524796f92689', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('93f4c494-6797-4493-851d-8ffa7e9dba4b', '211800003', '9623a494-c6a2-4db4-881f-d3892be6542f', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-22', '2017-12-28', '2017-12-28', '2018-01-02', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '07c02268-71ff-4e33-8675-45b24c26b1f6', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '9e5ec3f2-24e5-40f9-8d53-36ecbbd2597b', '1fc8b6a3-60d7-47bb-a42a-601009481604', '38dd3f00-79d0-4ff1-af56-ac65a29d1d7a', 'a483cbf8-6420-4a1a-bae9-afc23fd59cdd', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('959e2a98-7376-4ae4-8f0b-56493ddd69e5', '211800004', '507cee2e-ab87-4a75-ac3a-894cb6065e9f', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-05', '2018-01-05', '2018-01-05', '2018-01-05', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '9e5ec3f2-24e5-40f9-8d53-36ecbbd2597b', '00ba9f82-7e23-4c64-8bc6-5facf6a16ad4', '33bf4eb4-4409-45a3-82ce-18bb339cef1c', 'a483cbf8-6420-4a1a-bae9-afc23fd59cdd', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('95d38833-49f7-4691-bd95-9309975b9fc2', '261800029', 'bb9b8d1e-668b-4f9c-80d8-540cfb249c05', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-01-03', '2018-01-08', '2018-01-19', '2018-01-19', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '7b4dd404-50a0-4e0c-9b17-79feab0d8236', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('9af462c6-5580-494c-936a-a1ebb6ba5bef', '231800003', '66f5f688-1631-484c-856c-34f5341c88c6', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-22', '2017-11-22', '2017-11-22', '2018-01-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '40add5e0-26f1-4df2-a86d-871ff7099cdd', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '09dc5d72-636f-47d5-a54b-22ae7786d30b', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('9b133fca-b74c-4613-8983-bb79f8cdf055', '231800007', '1f399c4c-2467-4920-81f2-17b335d56737', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-20', '2018-01-05', '2018-01-08', '2018-01-23', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '3ac594e6-4b77-4b68-aad9-89ca8639117e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '34f5bf22-6ffa-4859-b528-f0cd8e9654e5', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('9dfac364-6bdc-4a97-86a2-40674185fc28', '231800002', 'a4ae7821-0265-4142-9728-ddc0dc82068a', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-12-08', '2017-12-11', '2017-12-11', '2018-01-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '3c4a8477-dca4-45c9-83f4-92d59146392f', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('a1647a97-9b29-4118-8c48-9720f3c27aa1', '08180001', 'c3b2bc8b-43bb-403b-a19d-3ce0725a8c5b', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-18', '2018-01-07', '2018-01-08', '2018-01-08', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', 'bb8ad047-eef3-4b78-a9d4-807d7fa7dd78', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '735db745-97e6-4c35-93c7-6cf4e8f123c2', '18cf0147-a150-4838-842d-3fddbd70533d', '08108042-eae5-4ce5-a99c-ddc0b4d40960', '016178e4-41aa-4ffb-8266-e432a23d629c', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('a1e69abc-0d54-4a5a-b837-c77b6f18ac3f', '08180003', 'f0b3e892-05d7-4c8b-9c18-25437c31bad7', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-01-28', '2017-12-28', '2018-01-15', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '735db745-97e6-4c35-93c7-6cf4e8f123c2', '2dfe1ebd-29e1-4ade-b32a-a286fbc0c11e', '2c69b4ce-902e-482a-97c6-d688b620409e', '016178e4-41aa-4ffb-8266-e432a23d629c', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('a4b65563-771d-494e-93f9-2346462df9c7', '261800031', '83f72dbe-bd67-4f5f-b125-eee68f99cf47', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-25', '2017-12-20', '2018-01-02', '2018-01-23', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '0ad15227-ee5b-4d49-a14f-e612c3310ad6', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('ab18657e-9351-4e44-839a-f8bc824bbd01', '261800033', '0199bdb3-a8c7-4c98-960d-9fd5a0058529', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-15', '2018-01-02', '2018-01-04', '2018-01-23', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '05d68fef-9dc4-4289-9e4d-3dab4ff49a7c', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('ac875873-60df-45b3-8c09-5246a0584d9f', '231800021', 'c9bb9042-daf2-4362-9d49-2fa90f83b8ce', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-01-12', '2018-01-05', '2018-01-15', '2018-01-16', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '7a4587a4-0a93-46f3-8932-524796f92689', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('b0165a77-6a25-41ae-a2f8-c5182c68c4ca', '241800032', '6641bf6f-1589-4869-a02f-1ce085fccd70', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-07', '2018-01-19', '2018-01-19', '2018-01-25', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '6235dd03-7f9a-4df7-bfdc-02e6033fa39a', '1b2caaea-afe9-4679-acf1-7cd8ecc31b02', '9dc9672f-2897-45c5-9094-51b27c6b7776', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('b4684e67-2538-45a1-8079-efe194b64d1f', '261800047', '7e915d3c-9768-4025-aebd-735fb5500ef1', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-25', '2018-01-03', '2018-01-08', '2018-01-29', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '8b69ab49-b1f2-4e4a-bf18-ed824e32c88e', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', 'b1f90954-9b49-445f-99ad-951ba721fdc3', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('b4b3ab56-a066-41ac-9b7b-209eb8396bd9', '241800014', 'f84c076a-85b4-418c-a1c1-c7d0d9b86661', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-24', '2017-11-24', '2017-11-24', '2018-01-10', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '6235dd03-7f9a-4df7-bfdc-02e6033fa39a', '32415c18-547b-4656-aad6-8a7f0d305f69', '9dc9672f-2897-45c5-9094-51b27c6b7776', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('ba2b450f-3c23-432b-b49b-a7367d5e6906', '261800003', 'e1fee7ab-76e7-40b5-9e9c-07b199e9bb59', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-05', '2017-11-20', '2017-11-20', '2018-01-03', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '2c4c6093-6bb5-4bf1-a862-f641d42409b4', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('c5bde7de-9c50-4276-8552-b32caaf99914', '261800024', '9de65c1f-b56a-44a5-b23b-e1fe4fd2efbb', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-15', '2017-12-20', '2017-12-27', '2018-01-19', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '2a4a87ce-aea1-4aa2-9142-01bd9ef27537', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('c8f01b96-2218-4033-853f-4a851f52ebe3', '231800018', '45d096bd-50fe-4488-af48-9f1dcc7ec566', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-20', '2017-12-19', '2017-12-19', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '23594802-cbe1-4748-9257-f82928f13aa6', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('cb98fdb3-58e8-40cc-9ee9-b8445960bd6d', '261800045', 'f041e8e3-f37c-411b-8ebb-ca64f61375b4', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-10', '2017-01-18', '2018-01-16', '2018-01-19', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '34f5bf22-6ffa-4859-b528-f0cd8e9654e5', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('cc3086a9-705e-4fb8-aca2-2f1fb45b4b30', '231800016', '6e4e916d-cc2a-489d-b26b-ad09eedd8d19', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-20', '2017-12-21', '2017-12-21', '2018-01-15', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '19c2ce0f-e2db-426f-b348-e5b746995515', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '008bbab0-9b59-4285-855e-21700f0dad4a', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('cec596e1-e10f-46e9-9ed1-e31e59e2fefc', '261800025', 'fe568f17-38ce-4ceb-b504-c29846ca2c50', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-16', '2018-01-15', '2018-01-18', '2018-01-19', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '0ad15227-ee5b-4d49-a14f-e612c3310ad6', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('d18d571f-d384-4c3d-8214-9605bb85a707', '261800011', 'ea9cd29e-a53c-49b4-a43e-79e2756896a1', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-20', '2017-12-27', '2017-12-27', '2018-01-12', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '0deabe72-7f10-45ce-99f6-b59b1378e0a9', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('d1bfa6c6-b5a6-472b-92ce-fd38bf62d756', '261800010', 'b1b15b28-4003-4914-a768-0db11980472f', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-11-25', '2017-12-18', '2017-12-29', '2018-01-09', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '18f513ad-0b25-4ab0-8a43-1dc08d55d1bb', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26');
INSERT INTO `tubis_cases` (`id`, `number`, `patient_id`, `category`, `resistant_level_1`, `resistant_level_2`, `resistant_level_3`, `case_index_id`, `case_description_id`, `start_date`, `survey_date`, `diagnose_date`, `register_date`, `treatment_date`, `tb_type_id`, `diag_id`, `diag_note`, `confrim_model`, `confrim_model_id`, `detection_method_id`, `is_cough`, `cough_days`, `has_vaccine`, `x_ray_result_id`, `x_ray_path`, `risk_factories`, `hiv`, `hiv_test`, `infection_source_id`, `contact_adult`, `contact_child`, `province_id`, `state_id`, `sub_state_id`, `organization_id`, `register_user_id`, `created_at`, `updated_at`) VALUES
('d24f08c1-52db-45c3-90c3-ef6f09c3559f', '261800008', '3f9e7507-1d3b-42f7-8f3d-fb62c5506b1c', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-06', '2017-11-13', '2018-01-03', '2018-01-08', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, 'c53cb27f-52eb-481e-a92e-f71c0b5afc4b', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '12b49c3d-c00f-4bbd-8759-3ee6c04545d2', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('d2531e9c-0bbf-4807-8107-4052fe7d7e6b', '261800021', '2d629869-13e8-46a4-918c-f7b41c753490', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-12-20', '2018-01-15', '2018-01-15', '2018-01-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '09dc5d72-636f-47d5-a54b-22ae7786d30b', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('d7128c8f-41e8-45be-b50b-95a1db022e4e', '231800017', 'd92833a1-3cc1-4211-9223-9e7d4415ecc9', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-04-06', '2017-12-15', '2017-12-15', '2018-01-15', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '2ad0e077-b677-4288-8427-4e50a8199d84', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('d86e00a0-21cc-407e-97f5-e4cfdbfeff4a', '2200003', 'b4095153-6bfb-4df7-b85e-5b8550922009', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2022-08-01', '2022-08-02', '2022-08-17', '2022-08-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, 'App\\Models\\AnalysisResult', '2de00507-fcb9-4804-9084-3bb65ab6f1b3', '40add5e0-26f1-4df2-a86d-871ff7099cdd', 'yes', 14, 'yes', 'd7ccb981-5cf1-4310-b09b-2889357551fd', NULL, '[\"3697bf86-6b2b-4b96-a0d0-d7122944585a\"]', 'unknown', NULL, '9f936be2-618d-4d0a-a035-1745ea6b5519', 1, 1, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', '7e5ac52d-10af-4a5c-bace-f82eb2cac7d3', NULL, 'eaa4a519-abff-4bd3-a256-b8b17ce38c73', '2022-08-17 02:07:36', '2022-08-17 02:07:36'),
('d9fc9cab-347c-45d9-9af5-91783d508c6a', '261800015', 'a851a7ef-5b88-4c67-b1ca-76d19f6a9438', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-10', '2017-11-17', '2017-11-22', '2018-01-16', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '07c02268-71ff-4e33-8675-45b24c26b1f6', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '1b2caaea-afe9-4679-acf1-7cd8ecc31b02', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('db296816-26d0-409d-bb7e-17032099aeb9', '261800036', 'f0ef006a-3bb1-4371-95e9-b460782c7aed', 'adverse', NULL, NULL, NULL, NULL, '4661a118-69b0-4ddc-9b23-556ee0d453c4', '2017-11-13', '2018-01-01', '2018-01-02', '2018-01-24', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', '725a8386-2e1a-45f2-bf7c-0ab2211bfd95', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '0deabe72-7f10-45ce-99f6-b59b1378e0a9', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('e03dcb3b-ef5b-4387-bfa1-c9528652411d', '261800001', 'dc5a81bc-90b8-41f0-8d5a-c9f5a1d68e59', 'resistant', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-09-20', '2017-10-02', '2017-11-10', '2018-01-09', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '09dc5d72-636f-47d5-a54b-22ae7786d30b', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('e1792abf-f66a-4cde-9bb8-63108c83c42b', '261800014', '0f19ff17-c9f3-42fe-bda9-7e5388ebcb22', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-15', '2018-01-05', '2018-01-11', '2018-01-15', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '24414d1f-c677-4a9a-a7db-a1a5a9c39449', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '1baf8893-0ec2-4d1e-863e-d6485d54ea76', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('e7a8c819-9b51-4f63-a4a1-eddaf96fe282', '011800005', '2b203751-7f00-4a44-b8ca-599f031f6101', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-08-20', '2018-01-19', '2018-12-20', '2018-01-22', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', 'f0d4cebf-b687-49a3-93a1-86ddc94b8c70', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '55e0c959-430e-4041-804c-39515a0c0074', '26a0cab3-5aea-4c98-a3bb-0bcb81802309', 'a8516a03-f7b7-4375-b94a-db55ab3f8234', '579362e6-1de2-40e6-83ce-9fd3faff155b', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('ed66f774-8230-4bed-af08-cc3628fc3111', '261800020', '459b62d9-2b95-4e34-a8c0-4be802e314ac', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-12-11', '2018-01-02', '2018-01-01', '2018-01-08', NULL, 'ebb8b080-0a19-4582-b9e0-9fb2c941e42e', 'bb8ad047-eef3-4b78-a9d4-807d7fa7dd78', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '34f5bf22-6ffa-4859-b528-f0cd8e9654e5', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('f75329fa-330b-49a6-a099-b195e41ad0fc', '261800026', 'f0f48049-e1ed-4c00-b617-d5765543cc10', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-11', '2018-01-10', '2018-01-12', '2018-01-19', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', 'da4851a6-1311-4093-aa13-8d88e196c42e', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('f960d24e-4398-4e31-9ba4-662d82e7d9dd', '211800001', '01cd3d31-0653-45a7-be38-1b440bb9881a', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-10', '2017-11-27', '2017-12-27', '2018-01-02', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '9e5ec3f2-24e5-40f9-8d53-36ecbbd2597b', '11081cd7-ecee-4c32-a7fb-6e4a45358e64', 'c210a710-85be-4a81-b997-d7fa9b8f3eec', 'a483cbf8-6420-4a1a-bae9-afc23fd59cdd', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('fa6519c3-a602-49e1-807b-16deeee21c68', '2200002', 'd976b39e-1af6-4ad7-9789-8f5ebbbcbe77', 'resistant', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2022-08-16', '2022-08-15', '2022-08-16', '2022-08-16', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '0136253e-7cc1-4c4d-91a9-262debffdc2c', NULL, 'App\\Models\\AnalysisResult', 'a3d7c1dc-9259-452f-958c-4610436c9c40', '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'yes', 'c7997c3b-4de0-46f4-985b-890100a700c4', NULL, '[\"0eee98f0-7544-42f9-b1a4-d176061a9d8e\", \"38d70bbf-a4b4-40dc-a166-e948b21f730c\", \"83c85179-28b7-40ec-8156-8f9f11b556ae\", \"ef9d3cdc-e781-4fb2-aa61-ca456f376843\"]', 'no', NULL, '247eab27-08b2-4e8c-b43b-8c4722a3003c', 2, 2, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '22c353e8-4a01-46cd-bb50-a802da41c18d', 'b93f65f4-bb7b-4a11-9a5f-8e60c06a5ff1', NULL, '4b4b9dbe-11e0-420f-b1e6-da950369430e', '2022-08-16 06:45:36', '2022-08-21 06:52:55'),
('fb1aad55-7c79-488f-ae26-1eb8d1d5df2c', '261800002', 'e8ec7fa9-f81a-4924-a5fb-5d50bb1e9859', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-10-25', '2017-12-20', '2017-12-28', '2018-01-03', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'c485c0b2-78c2-43a4-b182-d0eb7adff51c', '3d9f2dd3-ab4f-4bd2-9783-cae6c7110a65', '32b3ea79-cee0-4a62-a5a3-615c458eef48', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('fc96a8b2-98fe-4727-9fb4-35993c60ac10', '031800001', '60c62fcf-4c59-44b2-8c9b-6da075800a0d', 'resistant', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-05-01', '2017-12-19', '2017-12-28', '2018-01-10', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '72e6ea3c-e632-4832-ae1c-f950d078267b', 'e2e6a76a-deb3-451b-ba99-8bff8cc9bc97', '648a8929-2e71-4789-b57d-ab4f509c405a', '44594233-077d-4e7c-b234-ed773914b96e', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('febc3c36-cea6-4a20-ab03-8e0fb54788c9', '241800027', 'd8c52173-87dc-475b-9802-38069c680526', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2018-01-04', '2018-01-15', '2018-01-15', '2018-01-22', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '40add5e0-26f1-4df2-a86d-871ff7099cdd', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '44bbbe2e-b17e-4e69-b556-8db7e245dbd0', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '6235dd03-7f9a-4df7-bfdc-02e6033fa39a', '1b2caaea-afe9-4679-acf1-7cd8ecc31b02', '9dc9672f-2897-45c5-9094-51b27c6b7776', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26'),
('ff41962e-d7a3-474e-b9eb-e3e1dfebc416', '231800023', '89f91075-5482-478f-a3dd-8628810b0caa', 'adverse', NULL, NULL, NULL, NULL, '1838e102-f7d9-485d-94d3-73623da02329', '2017-11-10', '2017-12-27', '2018-01-12', '2018-01-17', NULL, 'c380cb8a-4e94-4199-a09b-4f9be9f833d9', '23501e45-c846-4235-b6bb-5d1346269715', NULL, NULL, NULL, '594e55a2-cb67-4ce8-83d7-33a2b4238d75', 'no', 0, 'no', NULL, NULL, NULL, 'unknown', NULL, '80da4ade-d668-4bca-97a8-ffab2f223c5c', 0, 0, '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '4e0ef187-9294-4d28-bc1c-05334ae694fc', '15f3c1a5-0e34-4e90-8071-a68555384aaf', 'a0129804-6ace-452c-b2f1-cbd17aee3974', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', '2022-08-29 00:26:26', '2022-08-29 00:26:26');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `profile_image`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
('1372b12e-8c02-43f6-ba78-8567cb289b7e', 'mmendee1031', NULL, 'mmendee1031@gmail.com', NULL, '$2y$10$4hp/hab.2rnJweW4cgfDTu9nnaSbs3MA1k3e.uyTvCBbZHdihMRAe', NULL, '2022-08-17 01:46:29', '2022-08-22 07:02:18'),
('30ac9042-2690-47b8-9ba9-cbc05e51630f', 'tsolmonboldo@gmail.com', NULL, 'tsolmonboldo@gmail.com', NULL, '$2y$10$cAsxAYnfOM6VCwlJMKaJpefooRj.Qu0j9upu5rDOpV7NIUppWz3b2', NULL, '2022-08-17 01:38:23', '2022-08-17 01:38:23'),
('32423f6c-2fb3-4522-937d-be65cfdcaeba', 'tsets888@yahoo.com', NULL, 'tsets888@yahoo.com', NULL, '$2y$10$xEkV19NvLieYPelCCiDAp.2VK5h3nL..vEs.vKmbxv/9xDbWXAWJG', NULL, '2022-08-17 01:58:58', '2022-08-17 01:58:58'),
('4b4b9dbe-11e0-420f-b1e6-da950369430e', 'Munkhsaikhan', NULL, 'admin@gov.com', '2022-08-05 10:04:18', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '7EOLm0xdjH', '2022-08-05 10:04:18', '2022-08-05 10:04:18'),
('4c1b9ad5-4462-40d3-a837-f3ad6ef305da', 'Baaska_5047@yahoo.co.uk', NULL, 'Baaska_5047@yahoo.co.uk', NULL, '$2y$10$3/9RC1QVkGZ7hV3Lg8PDGODubfGmOKqMCUEUFNjLGEIkLLOS/xpva', NULL, '2022-08-17 01:49:07', '2022-08-17 01:49:07'),
('4f97072a-2808-4162-8468-6d5ae09b85ff', 'ooyuntogs', NULL, 'ooyuntogs@yahoo.com', NULL, '$2y$10$t0FdkEqgSeCIKIE1sjAuVOCoi12Cx3pAnuXGffSBBbdoAhKyDSKIK', NULL, '2022-08-29 05:31:41', '2022-08-29 05:31:41'),
('76f7bb65-deea-4ecd-b532-8ea9eba119d6', 'dermee7@gmail.com', NULL, 'dermee7@gmail.com', NULL, '$2y$10$PQLi77KOibym6Bojr5XyHuZ/eEw/qrRO1rICMwACkndnZW3wO47Ve', NULL, '2022-08-17 01:35:12', '2022-08-17 01:35:12'),
('7aaa91b7-574e-4466-a7d6-60d9019e11e6', 'Mbilegmaa', NULL, 'Mbilegmaa@yahoo.com', NULL, '$2y$10$I4fDIsig1Fj2U3AuQUHrYeOOMe7leTgVQd0GbixiPyycF0PIijJAq', NULL, '2022-08-29 05:43:32', '2022-08-29 05:43:32'),
('941b7a8e-5a44-4e3b-bea9-8305059b5f1a', 'oyuntuya', NULL, 'oyuntuya@nccd.gov.mn', NULL, '$2y$10$7Q195YeexErpIfmjp2wD/eegetJzUsAsbtxm99Jq3aJwLC9Z.LmUS', NULL, '2022-08-08 04:35:20', '2022-08-08 04:35:20'),
('ac83da39-79fe-41ac-b722-ad5828ca3050', 'Tsermaa9246', NULL, 'Tsermaa9246@gmail.com', NULL, '$2y$10$8OgGQlTAJ7xhEek4Xw0k.OljlD/fICLDImsAbZslmxurtHw77Rw1u', NULL, '2022-08-29 05:39:48', '2022-08-29 05:39:48'),
('bc6a68ba-bef0-4fdc-87a5-db1efdc9e7b4', 'Erdenechimeg.d2020', NULL, 'Erdenechimeg.d2020@gmail.com', NULL, '$2y$10$YRecN7yyg3AG5R2sbZTczOFKd/paa9euqa5AQgWvcc.OI72PF8MoO', NULL, '2022-08-24 01:59:05', '2022-08-24 01:59:05'),
('e3492873-3b07-460d-87eb-321d13098f3d', 'janka_b2013', NULL, 'janka_b2013@yahoo.com', NULL, '$2y$10$H9iFfypzR9CfaZgS1IVv0u9obl6BhA2.7RF.W0iywM4BQiPPnZiUS', NULL, '2022-08-29 05:25:55', '2022-08-29 05:25:55'),
('eaa4a519-abff-4bd3-a256-b8b17ce38c73', 'enkhnaran2022@gmail.com', NULL, 'enkhnaran2022@gmail.com', NULL, '$2y$10$67ipz4RqRHTeyUsGyVlbAO9mkvBzDLEH1Cn7wnZtoLuRMsa9Fqfdq', NULL, '2022-08-16 07:33:09', '2022-08-16 07:33:09'),
('ee77c072-abe9-45a8-ae33-84837786c801', 'naraegi.1102@gmail.com', NULL, 'naraegi.1102@gmail.com', NULL, '$2y$10$PoXQGafvWURpQBHdEa8xQu5Ir48gr1i0NYtqE8QeFlvbMsQH0GfkS', NULL, '2022-08-17 02:38:21', '2022-08-18 01:07:30');

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

--
-- Table structure for table `user_employments`
--

CREATE TABLE `user_employments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_employments`
--

INSERT INTO `user_employments` (`id`, `model_type`, `model_id`, `employment_id`, `user_id`, `description`, `created_at`, `updated_at`) VALUES
('121b65b6-9e47-4c7c-badd-229e568c6373', 'App\\Models\\Organization', '579362e6-1de2-40e6-83ce-9fd3faff155b', 'c5e80fdf-15a1-452c-b05c-2b08d1565935', 'bc6a68ba-bef0-4fdc-87a5-db1efdc9e7b4', NULL, '2022-08-24 01:59:05', '2022-08-24 01:59:05'),
('1d0e6cdc-3b23-4772-878f-6380201bd363', 'App\\Models\\Organization', '332d4fda-d381-4287-a8d6-e6a14e8c822a', 'c5e80fdf-15a1-452c-b05c-2b08d1565935', 'ac83da39-79fe-41ac-b722-ad5828ca3050', NULL, '2022-08-29 05:39:48', '2022-08-29 05:39:48'),
('2280fd2b-6ca0-4724-98b3-df297a27ce3d', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', '3e18395a-ccf0-4b4c-b6c2-ef2a7c93d875', 'eaa4a519-abff-4bd3-a256-b8b17ce38c73', NULL, '2022-08-16 07:33:09', '2022-08-16 07:33:09'),
('60aaf408-e8a8-449b-9cf4-42f4d956fcc9', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', '35759d8a-ec8a-4d88-b401-ef8fe86dd6d8', '4c1b9ad5-4462-40d3-a837-f3ad6ef305da', NULL, '2022-08-17 01:49:07', '2022-08-17 01:49:07'),
('6ba40c92-48a0-43a3-a306-07491fc5cf81', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', '3e18395a-ccf0-4b4c-b6c2-ef2a7c93d875', '941b7a8e-5a44-4e3b-bea9-8305059b5f1a', NULL, '2022-08-08 04:35:20', '2022-08-08 04:35:20'),
('9700e6f2-702f-494f-9375-597c44a51d4e', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', '57b5b75a-5820-4341-a1d2-6823a6652979', '1372b12e-8c02-43f6-ba78-8567cb289b7e', NULL, '2022-08-17 01:46:29', '2022-08-17 01:46:29'),
('af88259e-75eb-416d-9699-592ac5aee407', 'App\\Models\\Organization', '2d065df0-3fa2-461c-ab98-d4b48df88cc4', '912abaef-72d3-4a89-8421-95a57cb7269f', 'ee77c072-abe9-45a8-ae33-84837786c801', NULL, '2022-08-17 02:38:21', '2022-08-18 01:07:30'),
('b7724df8-47d7-4de9-99f2-6f2fea413dd2', 'App\\Models\\Organization', '2d065df0-3fa2-461c-ab98-d4b48df88cc4', '35759d8a-ec8a-4d88-b401-ef8fe86dd6d8', '32423f6c-2fb3-4522-937d-be65cfdcaeba', NULL, '2022-08-17 01:58:58', '2022-08-17 01:58:58'),
('c7682b92-7b40-4010-93ed-2252c42ea6ce', 'App\\Models\\Organization', '016178e4-41aa-4ffb-8266-e432a23d629c', 'c5e80fdf-15a1-452c-b05c-2b08d1565935', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', NULL, '2022-08-29 05:43:32', '2022-08-29 05:43:32'),
('cc37c80e-be2a-43da-bdbd-707868b46c62', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', 'fc63730b-2832-4bb0-8790-45b9015f52a3', '76f7bb65-deea-4ecd-b532-8ea9eba119d6', NULL, '2022-08-17 01:35:12', '2022-08-17 01:35:12'),
('cc62a0e3-7584-48d0-9278-732c59eae23a', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', 'eb00a6af-4df2-4f48-8666-e76fdb3bb519', '30ac9042-2690-47b8-9ba9-cbc05e51630f', NULL, '2022-08-17 01:38:23', '2022-08-17 01:38:23'),
('da8b78c6-e6b5-45f8-8b08-f548d09375bd', 'App\\Models\\Organization', '199868d7-3d60-4aff-80da-9caa1612046b', 'c5e80fdf-15a1-452c-b05c-2b08d1565935', '4f97072a-2808-4162-8468-6d5ae09b85ff', NULL, '2022-08-29 05:31:41', '2022-08-29 05:31:41'),
('eb62f307-bd23-4a8e-8a6a-49323fc86c42', 'App\\Models\\Organization', '53eec9d0-8f75-4ed3-8332-11a8cf57053e', 'c5e80fdf-15a1-452c-b05c-2b08d1565935', 'e3492873-3b07-460d-87eb-321d13098f3d', NULL, '2022-08-29 05:25:55', '2022-08-29 05:25:55'),
('fc3da6fe-beba-4c63-a7f3-821ace7cbe4d', 'App\\Models\\Organization', '7eb0c20c-b565-4258-8965-293aa3bf5630', '3e18395a-ccf0-4b4c-b6c2-ef2a7c93d875', '4b4b9dbe-11e0-420f-b1e6-da950369430e', NULL, '2022-08-05 10:04:18', '2022-08-05 10:04:18');

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

--
-- Table structure for table `user_informations`
--

CREATE TABLE `user_informations` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `register_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_province_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_state_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_sub_state_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_numbers` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_phone_numbers` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_links` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_informations`
--

INSERT INTO `user_informations` (`id`, `user_id`, `family_name`, `last_name`, `first_name`, `register_number`, `address_province_id`, `address_state_id`, `address_sub_state_id`, `address`, `phone_numbers`, `work_phone_numbers`, `social_links`, `created_at`, `updated_at`) VALUES
('1e94b902-8625-4d9a-97ba-8ab955d29147', '4f97072a-2808-4162-8468-6d5ae09b85ff', 'сартуул', 'очирхуяг', 'оюунтөгс', 'ГЮ91081722', 'ab9a4205-9284-40d5-a7f8-6396476b7e12', '79d44c4c-d616-4ffb-9439-e1629db771f2', '50adbb0e-d530-4fd3-98e4-ae6cdb2fc7e5', 'Булган, Булган, 2-р баг, Хужирт хөх чулуут 12 гудамж 1228 тоот', '94098328', NULL, '[]', '2022-08-29 05:31:41', '2022-08-29 05:31:41'),
('449d4597-f9af-42c9-8413-1f4a76892ce8', '941b7a8e-5a44-4e3b-bea9-8305059b5f1a', 'Боржигон', 'Баатархүү', 'Оюунтуяа', 'ЦЗ84110962', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', 'c9dc76e0-f558-474a-9fa4-e38dab6f3d07', '133 -24', '99070498', NULL, '[]', '2022-08-08 04:35:20', '2022-08-08 04:35:20'),
('471ca47c-ec41-4963-adbc-e4bd40f4c733', 'ee77c072-abe9-45a8-ae33-84837786c801', 'Балдан', 'мягмар', 'энхнаран', 'ГЕ90110209', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '22c353e8-4a01-46cd-bb50-a802da41c18d', 'f51a3a0c-c5a2-42ca-b30b-f6645ea9db56', '11111', '88019852', NULL, '\"[]\"', '2022-08-17 02:38:21', '2022-08-18 01:07:30'),
('4e43f75f-247b-4cec-81c1-ae892f19a194', '76f7bb65-deea-4ecd-b532-8ea9eba119d6', '.', 'Раднаа', 'Дорждэрэм', 'ИИ86112807', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', 'a9d85f93-a968-43dd-9402-e5077c30776a', '1', '88000841', NULL, '[]', '2022-08-17 01:35:12', '2022-08-17 01:35:12'),
('4f657d77-1813-4f74-8cd6-8f7b53a7b2c0', '32423f6c-2fb3-4522-937d-be65cfdcaeba', ',', 'Боролзой', 'Цэцэгтуяа', 'АЮ83022161', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '22c353e8-4a01-46cd-bb50-a802da41c18d', 'd37cc924-a3cf-4966-bf3b-5ebe45a5d2e6', 'tsets888@yahoo.com', '88038892', NULL, '[]', '2022-08-17 01:58:58', '2022-08-17 01:58:58'),
('52351c0c-94c3-44ff-bf0d-e4aece6b77da', 'ac83da39-79fe-41ac-b722-ad5828ca3050', 'баатад', 'баасандорж', 'цэрмаа', 'ТК73052201', '6cd2889f-e443-432b-a7d8-8bb91c86ccc1', '4e7d2825-f943-4153-a580-bb8d6c4d4b30', '2f024671-13a2-4ebc-a022-bc80cab9ad0b', 'Дархан-Уул, Дархан 13-р баг, 1 хороолол 32 байр, 17 тоот', '99379246', NULL, '[]', '2022-08-29 05:39:48', '2022-08-29 05:39:48'),
('56f1ead8-62f5-4e17-aabb-d5eaf522dadf', '4c1b9ad5-4462-40d3-a837-f3ad6ef305da', ',', 'Эрхэмбаяр', 'Баасансүрэн', 'РЭ88062401', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', '9132caa3-d6c3-4d3a-b9f2-0ffb2f974a88', 'Baaska_5047@yahoo.co.uk', '88090938', NULL, '[]', '2022-08-17 01:49:07', '2022-08-17 01:49:07'),
('59bf2027-3ecd-491d-a1f5-2f9197dc3c89', 'eaa4a519-abff-4bd3-a256-b8b17ce38c73', 'балдан', 'Мягмар', 'Энхнаран', 'ГЕ90110209', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', '1b2caaea-afe9-4679-acf1-7cd8ecc31b02', 'УБ, Баянзүрх, 5-р хороо 15-р хороолол, хд 72 байр 188 тоот', '88019852', NULL, '[]', '2022-08-16 07:33:09', '2022-08-16 07:33:09'),
('5b332eb6-2a54-4e2d-9b4d-bba0ef388f5f', '30ac9042-2690-47b8-9ba9-cbc05e51630f', '.', 'Болдоо', 'Цолмон', 'ШЖ85041111', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', 'cd1c04bf-566d-495f-8f00-190c33414ffb', '94c0c649-ef46-47ba-92d3-9914ecff2a3c', 'tsolmonboldo@gmail.com', '96017688', NULL, '[]', '2022-08-17 01:38:23', '2022-08-17 01:38:23'),
('7397fa2d-b2aa-4d64-a56a-e1f0328b88a5', '1372b12e-8c02-43f6-ba78-8567cb289b7e', ',', 'Мөнхтөр', 'Мэнд-Амар', 'рй96112017', '0eabd3b9-5af4-46f3-b4c7-500e28f50348', '8a9b1207-ed48-4162-8521-e785a4f07f73', '09dc5d72-636f-47d5-a54b-22ae7786d30b', 'mmendee1031@gmail.com', '99013227 91222724', NULL, '\"[]\"', '2022-08-17 01:46:29', '2022-08-22 07:02:18'),
('7c6940f0-cec3-4bde-adf0-36eaaa3fb77d', '4b4b9dbe-11e0-420f-b1e6-da950369430e', NULL, 'Чимэдбазар', 'Мөнхсайхан', 'АЮ89060872', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-05 10:04:18', '2022-08-05 10:04:18'),
('95744d0d-8fc6-4d01-8a8a-d1f91689ba78', '7aaa91b7-574e-4466-a7d6-60d9019e11e6', 'дарханлам', 'мөнхөө', 'бэлэгмаа', 'ЗЮ75061124', '735db745-97e6-4c35-93c7-6cf4e8f123c2', '18cf0147-a150-4838-842d-3fddbd70533d', '3e4e33ad-c2cb-47f3-8f2f-1f44fed135d0', 'Дорноговь, Сайншанд, 3-р баг мааньзав гудамж, 29 байр 22 тоот', '96033739', NULL, '[]', '2022-08-29 05:43:32', '2022-08-29 05:43:32'),
('de12919c-578c-42f3-b034-7c97a63e0d6f', 'e3492873-3b07-460d-87eb-321d13098f3d', 'шерушисанырау', 'бакенай', 'жанбота', 'БЮ84052704', 'e2f2e464-814c-4044-b46b-75e6787b3025', 'b512e57c-b8d5-43c1-94d0-92d3bfeea2c2', 'd448f1b2-3e99-4599-be43-1d95308a5405', 'Баян-Өлгий, Өлгий, 11-р баг, Бүркит, 1/48 байр, 506 тоот', '99426335', NULL, '[]', '2022-08-29 05:25:55', '2022-08-29 05:25:55'),
('f25d9b09-285e-4039-bb6e-540a0426e79b', 'bc6a68ba-bef0-4fdc-87a5-db1efdc9e7b4', 'харчу', 'дашзэвэг', 'эрдэнэчимэг', 'ЦГ68120945', '55e0c959-430e-4041-804c-39515a0c0074', '83f1b494-a612-413a-85bc-65ab313d485c', '3e80044c-8d84-45d2-9e65-2e1bd9df3062', 'Архангай, Эрдэнэбулган 4-р баг, 23 байр 03 тоот', '99461680', NULL, '[]', '2022-08-24 01:59:05', '2022-08-24 01:59:05');

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

--
-- Table structure for table `work_types`
--

CREATE TABLE `work_types` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_types`
--

INSERT INTO `work_types` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
('04a4370b-d99e-45dc-92bd-626af08a57fd', 'Уул уурхай, олборлолт боловсруулах үйлдвэрлэл', '2', '2022-08-05 12:44:15', '2022-08-05 12:44:15'),
('09163eaf-f2e4-428c-b7ad-bce4d899ac05', 'Хөдөө аж ахуй, ойн аж ахуй, загас барилт, ан агнуур', '1', '2022-08-05 12:44:03', '2022-08-05 12:44:03'),
('09f9bc87-6c1d-4e3d-b6b9-eb8ffb12c924', 'Төрийн удирдлага, батлан хамгаалах үйл ажиллагаа,  албан журмын нийгмийн хамгаалал', '14', '2022-08-05 12:46:51', '2022-08-05 12:46:51'),
('0de0edc3-af0d-48c8-bf5a-406ec2a871d1', 'Зочид буудал, байр, сууц болон нийтийн хоолны  үйлчилгээ', '8', '2022-08-05 12:45:24', '2022-08-05 12:45:24'),
('165fc1b0-02da-4dd9-9f60-2a58ca0c7770', 'Санхүүгийн болон даатгалын үйл ажиллагаа', '10', '2022-08-05 12:46:09', '2022-08-05 12:46:09'),
('17034c0d-717a-4b7a-8ee1-67d89e2da610', 'Мэдээлэл, холбоо', '9', '2022-08-05 12:45:58', '2022-08-05 12:45:58'),
('33e653e3-b318-4238-b396-cf8b844d8c7b', 'Олон улсын байгууллага, суурин төлөөлөгчийн үйл  ажиллагаа', '20', '2022-08-05 12:48:02', '2022-08-05 12:48:02'),
('4b346559-cc0c-4674-9a19-915abea428cc', 'Үйлчилгээний бусад үйл ажиллагаа', '18', '2022-08-05 12:47:38', '2022-08-05 12:47:38'),
('4d367d05-d30a-451c-aa0d-fda3818d6c62', 'Удирдлагын болон дэмжлэг үзүүлэх үйл ажиллагаа', '13', '2022-08-05 12:46:41', '2022-08-05 12:46:41'),
('7d3abdb5-4a19-41cc-83cd-ed3d56cfaeaa', 'Хүн хөлслөн ажиллуулдаг өрхийн үйл ажиллагаа', '19', '2022-08-05 12:47:49', '2022-08-05 12:47:49'),
('918381cc-b88d-4d4b-b86d-539592e9a8b3', 'Үл хөдлөх хөрөнгийн үйл ажиллагаа', '11', '2022-08-05 12:46:19', '2022-08-05 12:46:19'),
('a801d308-1de1-4177-a20a-e2f0f106d959', 'Цахилгаан, хий, уур, агааржуулалт', '3', '2022-08-05 12:44:27', '2022-08-05 12:44:27'),
('a8e8191e-a61f-4cde-b86e-7b0625b95528', 'Боловсрол', '15', '2022-08-05 12:47:04', '2022-08-05 12:47:04'),
('b7ece687-f57b-4bd9-8565-4cbfd98b8122', 'Мэргэжлийн, шинжлэх ухаан болон техникийн үйл  ажиллагаа', '12', '2022-08-05 12:46:31', '2022-08-05 12:46:31'),
('bf4585aa-5b97-4c03-8e4b-c10f594f157a', 'Барилга', '5', '2022-08-05 12:44:50', '2022-08-05 12:44:50'),
('c1a8533d-3179-4a24-aa72-6ab1728f02de', 'Бөөний болон жижиглэн худалдаа; машин,  мотоциклийн засвар, үйлчилгээ', '6', '2022-08-05 12:45:00', '2022-08-05 12:45:00'),
('d06d2b23-ef92-40c6-a11c-1a48647f4879', 'Ус хангамж; сувагжилтын систем, хог хаягдал  зайлуулах болон хүрээлэн буй орчныг дахин сэргээх үйл  ажиллагаа', '4', '2022-08-05 12:44:39', '2022-08-05 12:44:39'),
('da235445-139b-488e-afda-b112b46cace9', 'Урлаг, үзвэр, тоглоом наадам', '17', '2022-08-05 12:47:26', '2022-08-05 12:47:26'),
('ee7102c1-d7c5-4aa8-8b79-a80bbbcb0d30', 'Тээвэр, агуулахын үйл ажиллагаа', '7', '2022-08-05 12:45:12', '2022-08-05 12:45:12'),
('fa8fb51a-699f-4ba9-bb1c-b453e6915b00', 'Хүний эрүүл мэнд, нийгмийн халамжийн үйл  ажиллагаа', '16', '2022-08-05 12:47:14', '2022-08-05 12:47:14');

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

--
-- Table structure for table `x_ray_results`
--

CREATE TABLE `x_ray_results` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `x_ray_results`
--

INSERT INTO `x_ray_results` (`id`, `name`, `created_at`, `updated_at`) VALUES
('38628d56-d874-4521-8fda-cfd2f15fff50', 'test', '2022-08-08 04:41:43', '2022-08-08 04:41:43'),
('3e66da05-fa69-463a-973b-83310f768fe4', 'Хэвийн бус-хөндийгүй', '2022-08-05 10:05:03', '2022-08-05 10:05:03'),
('475c0312-21ac-4fd7-8718-3dbd523ca619', '12222', '2022-08-08 04:41:53', '2022-08-08 04:41:53'),
('c7997c3b-4de0-46f4-985b-890100a700c4', 'Хэвийн бус-хөндийтэй', '2022-08-05 10:05:03', '2022-08-05 10:05:03'),
('d7ccb981-5cf1-4310-b09b-2889357551fd', 'Хэвийн', '2022-08-05 10:05:03', '2022-08-05 10:05:03'),
('ea2b40fd-c939-4487-b97e-0d07711ab140', 'Тодорхойгүй ', '2022-08-05 10:05:03', '2022-08-05 10:05:03'),
('fc9ee82a-fa0c-4c58-84df-6b7d4068de31', 'Хийгдээгү', '2022-08-05 10:05:03', '2022-08-05 10:05:03');

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

--
-- Table structure for table `years`
--

CREATE TABLE `years` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_locked` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `years`
--

INSERT INTO `years` (`id`, `value`, `is_locked`, `created_at`, `updated_at`) VALUES
('d9a6f97c-e422-4370-b794-c9ff659f881c', '2022', 0, '2022-08-15 04:00:50', '2022-08-15 04:00:57');

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

--
-- Structure for view `balances`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `balances`  AS  select `a`.`id` AS `id`,`a`.`account_id` AS `account_id`,`a`.`year_id` AS `year_id`,`a`.`drug_id` AS `drug_id`,`a`.`serial_number` AS `serial_number`,`a`.`manufactory_date` AS `manufactory_date`,`a`.`expire_date` AS `expire_date`,`a`.`unit_price` AS `unit_price`,`a`.`count` AS `count`,`a`.`status` AS `status`,`a`.`created_at` AS `created_at`,`a`.`updated_at` AS `updated_at`,((`a`.`count` - ifnull(`e`.`counts`,0)) + ifnull(`f`.`counts`,0)) AS `balance`,ifnull(`e`.`counts`,0) AS `credit`,ifnull(`f`.`counts`,0) AS `debit`,`b`.`number` AS `number`,`c`.`name` AS `name`,`c`.`brief_name` AS `brief_name`,`c`.`dosage` AS `dosage`,`c`.`drug_type` AS `drug_type`,`d`.`name` AS `org_name` from (((((`account_balances` `a` left join `accounts` `b` on((`a`.`account_id` = `b`.`id`))) left join `drugs` `c` on((`c`.`id` = `a`.`drug_id`))) left join `organizations` `d` on((`b`.`organization_id` = `d`.`id`))) left join (select sum(`transfers`.`count`) AS `counts`,`transfers`.`account_balance_id` AS `account_balance_id`,`transfers`.`year_id` AS `year_id`,`transfers`.`type` AS `type` from `transfers` group by `transfers`.`account_balance_id`,`transfers`.`year_id`,`transfers`.`type` having (`transfers`.`type` = 'credit')) `e` on(((`e`.`account_balance_id` = `a`.`id`) and (`e`.`year_id` = `a`.`year_id`)))) left join (select sum(`transfers`.`count`) AS `counts`,`transfers`.`account_balance_id` AS `account_balance_id`,`transfers`.`year_id` AS `year_id`,`transfers`.`type` AS `type` from `transfers` group by `transfers`.`account_balance_id`,`transfers`.`year_id`,`transfers`.`type` having (`transfers`.`type` = 'debit')) `f` on(((`f`.`account_balance_id` = `a`.`id`) and (`f`.`year_id` = `a`.`year_id`)))) ;

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

--
-- Structure for view `case_provinces`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `case_provinces`  AS  select `a`.`id` AS `id`,`a`.`category` AS `category`,`b`.`code` AS `code` from (`tubis_cases` `a` left join `provinces` `b` on((`a`.`province_id` = `b`.`id`))) ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accounts_organization_id_index` (`organization_id`);

--
-- Indexes for table `account_balances`
--
ALTER TABLE `account_balances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_balances_account_id_foreign` (`account_id`),
  ADD KEY `account_balances_year_id_foreign` (`year_id`),
  ADD KEY `account_balances_drug_id_foreign` (`drug_id`);

--
-- Indexes for table `active_detections`
--
ALTER TABLE `active_detections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `activities`
--
ALTER TABLE `activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activities_id_index` (`id`),
  ADD KEY `activities_root_id_index` (`root_id`);

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_user_id_index` (`user_id`);

--
-- Indexes for table `analyses`
--
ALTER TABLE `analyses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analyses_patient_id_index` (`patient_id`),
  ADD KEY `analyses_send_organization_id_index` (`send_organization_id`),
  ADD KEY `analyses_send_user_id_index` (`send_user_id`),
  ADD KEY `analyses_tb_type_id_index` (`tb_type_id`),
  ADD KEY `analyses_sample_type_id_index` (`sample_type_id`),
  ADD KEY `analyses_sample_quality_id_index` (`sample_quality_id`),
  ADD KEY `analyses_user_id_index` (`user_id`),
  ADD KEY `analyses_receipt_user_id_index` (`receipt_user_id`);

--
-- Indexes for table `analysis_items`
--
ALTER TABLE `analysis_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analysis_item_forms`
--
ALTER TABLE `analysis_item_forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analysis_item_forms_analysis_item_id_index` (`analysis_item_id`);

--
-- Indexes for table `analysis_item_parameters`
--
ALTER TABLE `analysis_item_parameters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analysis_item_parameters_analysis_item_id_index` (`analysis_item_id`);

--
-- Indexes for table `analysis_results`
--
ALTER TABLE `analysis_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analysis_results_analysis_item_id_index` (`analysis_item_id`),
  ADD KEY `analysis_results_organization_id_index` (`organization_id`),
  ADD KEY `analysis_results_user_id_index` (`user_id`),
  ADD KEY `analysis_results_analysis_id_index` (`analysis_id`),
  ADD KEY `analysis_results_status_user_id_index` (`status_user_id`);

--
-- Indexes for table `analysis_result_forms`
--
ALTER TABLE `analysis_result_forms`
  ADD PRIMARY KEY (`result_id`,`form_id`),
  ADD KEY `analysis_result_forms_result_id_index` (`result_id`),
  ADD KEY `analysis_result_forms_form_id_index` (`form_id`);

--
-- Indexes for table `analysis_result_parameters`
--
ALTER TABLE `analysis_result_parameters`
  ADD PRIMARY KEY (`result_id`,`parameter_id`),
  ADD KEY `analysis_result_parameters_result_id_index` (`result_id`),
  ADD KEY `analysis_result_parameters_parameter_id_index` (`parameter_id`);

--
-- Indexes for table `before_treatments`
--
ALTER TABLE `before_treatments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `before_treatments_before_treatment_section_id_index` (`before_treatment_section_id`),
  ADD KEY `before_treatments_before_treatment_result_id_index` (`before_treatment_result_id`);

--
-- Indexes for table `case_analyses`
--
ALTER TABLE `case_analyses`
  ADD PRIMARY KEY (`case_id`,`analysis_id`),
  ADD KEY `case_analyses_analysis_id_foreign` (`analysis_id`);

--
-- Indexes for table `case_descriptions`
--
ALTER TABLE `case_descriptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `case_indices`
--
ALTER TABLE `case_indices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `case_migrations`
--
ALTER TABLE `case_migrations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `case_migrations_case_id_index` (`case_id`),
  ADD KEY `case_migrations_from_organization_id_index` (`from_organization_id`),
  ADD KEY `case_migrations_send_user_id_index` (`send_user_id`),
  ADD KEY `case_migrations_to_organization_id_index` (`to_organization_id`),
  ADD KEY `case_migrations_register_user_id_index` (`register_user_id`);

--
-- Indexes for table `case_treatment_places`
--
ALTER TABLE `case_treatment_places`
  ADD PRIMARY KEY (`id`),
  ADD KEY `case_treatment_places_tubis_case_id_index` (`tubis_case_id`),
  ADD KEY `case_treatment_places_treatment_place_id_index` (`treatment_place_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contacts_analysis_id_foreign` (`analysis_id`),
  ADD KEY `contacts_patient_id_index` (`patient_id`),
  ADD KEY `contacts_family_type_id_index` (`family_type_id`),
  ADD KEY `contacts_x_ray_result_id_index` (`x_ray_result_id`),
  ADD KEY `contacts_case_index_id_index` (`case_index_id`),
  ADD KEY `contacts_case_id_index` (`case_id`);

--
-- Indexes for table `detection_methods`
--
ALTER TABLE `detection_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `diags`
--
ALTER TABLE `diags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `diags_code_unique` (`code`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `document_changers`
--
ALTER TABLE `document_changers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `document_changers_doc_id_foreign` (`doc_id`),
  ADD KEY `document_changers_user_id_index` (`user_id`);

--
-- Indexes for table `drugs`
--
ALTER TABLE `drugs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drugs_group_id_index` (`group_id`);

--
-- Indexes for table `drug_groups`
--
ALTER TABLE `drug_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `drug_orders`
--
ALTER TABLE `drug_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drug_orders_create_user_id_index` (`create_user_id`),
  ADD KEY `drug_orders_fill_user_id_index` (`fill_user_id`),
  ADD KEY `drug_orders_from_account_id_index` (`from_account_id`),
  ADD KEY `drug_orders_to_account_id_index` (`to_account_id`);

--
-- Indexes for table `drug_order_items`
--
ALTER TABLE `drug_order_items`
  ADD PRIMARY KEY (`drug_order_id`,`drug_id`),
  ADD KEY `drug_order_items_drug_order_id_index` (`drug_order_id`),
  ADD KEY `drug_order_items_drug_id_index` (`drug_id`);

--
-- Indexes for table `drug_returns`
--
ALTER TABLE `drug_returns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drug_returns_from_account_id_index` (`from_account_id`),
  ADD KEY `drug_returns_to_acccount_id_index` (`to_acccount_id`),
  ADD KEY `drug_returns_user_id_index` (`user_id`),
  ADD KEY `drug_returns_confirmed_user_id_index` (`confirmed_user_id`);

--
-- Indexes for table `drug_usages`
--
ALTER TABLE `drug_usages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drug_usages_drug_id_foreign` (`drug_id`);

--
-- Indexes for table `educations`
--
ALTER TABLE `educations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `employments`
--
ALTER TABLE `employments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employments_id_index` (`id`);

--
-- Indexes for table `employment_roles`
--
ALTER TABLE `employment_roles`
  ADD PRIMARY KEY (`employment_id`,`role_id`),
  ADD KEY `employment_roles_role_id_foreign` (`role_id`);

--
-- Indexes for table `examinations`
--
ALTER TABLE `examinations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `examinations_patient_id_index` (`patient_id`),
  ADD KEY `examinations_x_ray_result_id_index` (`x_ray_result_id`),
  ADD KEY `examinations_register_user_id_index` (`register_user_id`),
  ADD KEY `examinations_detection_method_id_index` (`detection_method_id`),
  ADD KEY `examinations_location_id_index` (`location_id`),
  ADD KEY `examinations_start_date_index` (`start_date`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `family_types`
--
ALTER TABLE `family_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `infection_sources`
--
ALTER TABLE `infection_sources`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nations`
--
ALTER TABLE `nations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `new_diagnoses`
--
ALTER TABLE `new_diagnoses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `organizations`
--
ALTER TABLE `organizations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `organizations_id_index` (`id`),
  ADD KEY `organizations_activity_id_index` (`activity_id`),
  ADD KEY `organizations_address_province_id_index` (`address_province_id`),
  ADD KEY `organizations_address_state_id_index` (`address_state_id`),
  ADD KEY `organizations_address_sub_state_id_index` (`address_sub_state_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `patients`
--
ALTER TABLE `patients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `patients_register_number_unique` (`register_number`),
  ADD KEY `patients_nation_id_index` (`nation_id`),
  ADD KEY `patients_address_province_id_index` (`address_province_id`),
  ADD KEY `patients_address_state_id_index` (`address_state_id`),
  ADD KEY `patients_address_sub_state_id_index` (`address_sub_state_id`),
  ADD KEY `patients_register_user_id_index` (`register_user_id`),
  ADD KEY `patients_relationship_id_foreign` (`relationship_id`),
  ADD KEY `patients_education_id_foreign` (`education_id`),
  ADD KEY `patients_work_type_id_index` (`work_type_id`),
  ADD KEY `patients_school_id_index` (`school_id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `provinces`
--
ALTER TABLE `provinces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `provinces_id_index` (`id`);

--
-- Indexes for table `relationships`
--
ALTER TABLE `relationships`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `resistant_levels`
--
ALTER TABLE `resistant_levels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `resistant_levels_root_id_foreign` (`root_id`);

--
-- Indexes for table `risk_factors`
--
ALTER TABLE `risk_factors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `roles_root_id_index` (`root_id`);

--
-- Indexes for table `sample_qualities`
--
ALTER TABLE `sample_qualities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sample_qualities_sample_type_id_index` (`sample_type_id`);

--
-- Indexes for table `sample_types`
--
ALTER TABLE `sample_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `schools`
--
ALTER TABLE `schools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `send_purposes`
--
ALTER TABLE `send_purposes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_id_index` (`id`),
  ADD KEY `states_province_id_index` (`province_id`);

--
-- Indexes for table `sub_states`
--
ALTER TABLE `sub_states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_states_id_index` (`id`),
  ADD KEY `sub_states_state_id_index` (`state_id`);

--
-- Indexes for table `tb_types`
--
ALTER TABLE `tb_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transfers_account_balance_id_foreign` (`account_balance_id`),
  ADD KEY `transfers_year_id_foreign` (`year_id`);

--
-- Indexes for table `treatments`
--
ALTER TABLE `treatments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `treatments_case_id_index` (`case_id`),
  ADD KEY `treatments_treatment_method_id_index` (`treatment_method_id`),
  ADD KEY `treatments_create_user_id_index` (`create_user_id`),
  ADD KEY `treatments_treatment_place_id_index` (`treatment_place_id`),
  ADD KEY `treatments_treatment_result_id_index` (`treatment_result_id`),
  ADD KEY `treatments_result_user_id_index` (`result_user_id`);

--
-- Indexes for table `treatment_controls`
--
ALTER TABLE `treatment_controls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `treatment_controls_treatment_section_id_index` (`treatment_section_id`),
  ADD KEY `treatment_controls_send_purpose_id_index` (`send_purpose_id`);

--
-- Indexes for table `treatment_methods`
--
ALTER TABLE `treatment_methods`
  ADD PRIMARY KEY (`id`),
  ADD KEY `treatment_methods_drug_group_id_index` (`drug_group_id`);

--
-- Indexes for table `treatment_places`
--
ALTER TABLE `treatment_places`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `treatment_processes`
--
ALTER TABLE `treatment_processes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `treatment_processes_treatment_id_index` (`treatment_id`),
  ADD KEY `treatment_processes_drug_id_index` (`drug_id`);

--
-- Indexes for table `treatment_results`
--
ALTER TABLE `treatment_results`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `treatment_sections`
--
ALTER TABLE `treatment_sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tubis_cases`
--
ALTER TABLE `tubis_cases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tubis_cases_patient_id_index` (`patient_id`),
  ADD KEY `tubis_cases_tb_type_id_index` (`tb_type_id`),
  ADD KEY `tubis_cases_diag_id_index` (`diag_id`),
  ADD KEY `tubis_cases_detection_method_id_index` (`detection_method_id`),
  ADD KEY `tubis_cases_x_ray_result_id_index` (`x_ray_result_id`),
  ADD KEY `tubis_cases_infection_source_id_index` (`infection_source_id`),
  ADD KEY `tubis_cases_register_user_id_index` (`register_user_id`),
  ADD KEY `tubis_cases_case_description_id_index` (`case_description_id`),
  ADD KEY `tubis_cases_province_id_index` (`province_id`),
  ADD KEY `tubis_cases_state_id_index` (`state_id`),
  ADD KEY `tubis_cases_sub_state_id_index` (`sub_state_id`),
  ADD KEY `tubis_cases_case_index_id_index` (`case_index_id`),
  ADD KEY `tubis_cases_resistant_level_1_foreign` (`resistant_level_1`),
  ADD KEY `tubis_cases_resistant_level_2_foreign` (`resistant_level_2`),
  ADD KEY `tubis_cases_resistant_level_3_foreign` (`resistant_level_3`),
  ADD KEY `tubis_cases_organization_id_index` (`organization_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_id_index` (`id`);

--
-- Indexes for table `user_employments`
--
ALTER TABLE `user_employments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_employments_id_index` (`id`),
  ADD KEY `user_employments_employment_id_index` (`employment_id`),
  ADD KEY `user_employments_user_id_index` (`user_id`);

--
-- Indexes for table `user_informations`
--
ALTER TABLE `user_informations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_informations_id_index` (`id`),
  ADD KEY `user_informations_user_id_index` (`user_id`),
  ADD KEY `user_informations_address_province_id_index` (`address_province_id`),
  ADD KEY `user_informations_address_state_id_index` (`address_state_id`),
  ADD KEY `user_informations_address_sub_state_id_index` (`address_sub_state_id`);

--
-- Indexes for table `work_types`
--
ALTER TABLE `work_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `x_ray_results`
--
ALTER TABLE `x_ray_results`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `years`
--
ALTER TABLE `years`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `accounts_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`);

--
-- Constraints for table `account_balances`
--
ALTER TABLE `account_balances`
  ADD CONSTRAINT `account_balances_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  ADD CONSTRAINT `account_balances_drug_id_foreign` FOREIGN KEY (`drug_id`) REFERENCES `drugs` (`id`),
  ADD CONSTRAINT `account_balances_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`);

--
-- Constraints for table `activities`
--
ALTER TABLE `activities`
  ADD CONSTRAINT `activities_root_id_foreign` FOREIGN KEY (`root_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `analyses`
--
ALTER TABLE `analyses`
  ADD CONSTRAINT `analyses_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `analyses_receipt_user_id_foreign` FOREIGN KEY (`receipt_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `analyses_sample_quality_id_foreign` FOREIGN KEY (`sample_quality_id`) REFERENCES `sample_qualities` (`id`),
  ADD CONSTRAINT `analyses_sample_type_id_foreign` FOREIGN KEY (`sample_type_id`) REFERENCES `sample_types` (`id`),
  ADD CONSTRAINT `analyses_send_organization_id_foreign` FOREIGN KEY (`send_organization_id`) REFERENCES `organizations` (`id`),
  ADD CONSTRAINT `analyses_send_user_id_foreign` FOREIGN KEY (`send_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `analyses_tb_type_id_foreign` FOREIGN KEY (`tb_type_id`) REFERENCES `tb_types` (`id`),
  ADD CONSTRAINT `analyses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `analysis_item_forms`
--
ALTER TABLE `analysis_item_forms`
  ADD CONSTRAINT `analysis_item_forms_analysis_item_id_foreign` FOREIGN KEY (`analysis_item_id`) REFERENCES `analysis_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `analysis_item_parameters`
--
ALTER TABLE `analysis_item_parameters`
  ADD CONSTRAINT `analysis_item_parameters_analysis_item_id_foreign` FOREIGN KEY (`analysis_item_id`) REFERENCES `analysis_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `analysis_results`
--
ALTER TABLE `analysis_results`
  ADD CONSTRAINT `analysis_results_analysis_id_foreign` FOREIGN KEY (`analysis_id`) REFERENCES `analyses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `analysis_results_analysis_item_id_foreign` FOREIGN KEY (`analysis_item_id`) REFERENCES `analysis_items` (`id`),
  ADD CONSTRAINT `analysis_results_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  ADD CONSTRAINT `analysis_results_status_user_id_foreign` FOREIGN KEY (`status_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `analysis_results_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `analysis_result_forms`
--
ALTER TABLE `analysis_result_forms`
  ADD CONSTRAINT `analysis_result_forms_form_id_foreign` FOREIGN KEY (`form_id`) REFERENCES `analysis_item_forms` (`id`),
  ADD CONSTRAINT `analysis_result_forms_result_id_foreign` FOREIGN KEY (`result_id`) REFERENCES `analysis_results` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `analysis_result_parameters`
--
ALTER TABLE `analysis_result_parameters`
  ADD CONSTRAINT `analysis_result_parameters_parameter_id_foreign` FOREIGN KEY (`parameter_id`) REFERENCES `analysis_item_parameters` (`id`),
  ADD CONSTRAINT `analysis_result_parameters_result_id_foreign` FOREIGN KEY (`result_id`) REFERENCES `analysis_results` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `before_treatments`
--
ALTER TABLE `before_treatments`
  ADD CONSTRAINT `before_treatments_before_treatment_result_id_foreign` FOREIGN KEY (`before_treatment_result_id`) REFERENCES `treatment_results` (`id`),
  ADD CONSTRAINT `before_treatments_before_treatment_section_id_foreign` FOREIGN KEY (`before_treatment_section_id`) REFERENCES `treatment_sections` (`id`);

--
-- Constraints for table `case_analyses`
--
ALTER TABLE `case_analyses`
  ADD CONSTRAINT `case_analyses_analysis_id_foreign` FOREIGN KEY (`analysis_id`) REFERENCES `analyses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `case_analyses_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `tubis_cases` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `case_migrations`
--
ALTER TABLE `case_migrations`
  ADD CONSTRAINT `case_migrations_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `tubis_cases` (`id`),
  ADD CONSTRAINT `case_migrations_from_organization_id_foreign` FOREIGN KEY (`from_organization_id`) REFERENCES `organizations` (`id`),
  ADD CONSTRAINT `case_migrations_register_user_id_foreign` FOREIGN KEY (`register_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `case_migrations_send_user_id_foreign` FOREIGN KEY (`send_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `case_migrations_to_organization_id_foreign` FOREIGN KEY (`to_organization_id`) REFERENCES `organizations` (`id`);

--
-- Constraints for table `case_treatment_places`
--
ALTER TABLE `case_treatment_places`
  ADD CONSTRAINT `case_treatment_places_treatment_place_id_foreign` FOREIGN KEY (`treatment_place_id`) REFERENCES `treatment_places` (`id`),
  ADD CONSTRAINT `case_treatment_places_tubis_case_id_foreign` FOREIGN KEY (`tubis_case_id`) REFERENCES `tubis_cases` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contacts`
--
ALTER TABLE `contacts`
  ADD CONSTRAINT `contacts_analysis_id_foreign` FOREIGN KEY (`analysis_id`) REFERENCES `analyses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `contacts_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `tubis_cases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contacts_case_index_id_foreign` FOREIGN KEY (`case_index_id`) REFERENCES `case_indices` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `contacts_family_type_id_foreign` FOREIGN KEY (`family_type_id`) REFERENCES `family_types` (`id`),
  ADD CONSTRAINT `contacts_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `contacts_x_ray_result_id_foreign` FOREIGN KEY (`x_ray_result_id`) REFERENCES `x_ray_results` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `document_changers`
--
ALTER TABLE `document_changers`
  ADD CONSTRAINT `document_changers_doc_id_foreign` FOREIGN KEY (`doc_id`) REFERENCES `documents` (`id`),
  ADD CONSTRAINT `document_changers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `drugs`
--
ALTER TABLE `drugs`
  ADD CONSTRAINT `drugs_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `drug_groups` (`id`);

--
-- Constraints for table `drug_orders`
--
ALTER TABLE `drug_orders`
  ADD CONSTRAINT `drug_orders_create_user_id_foreign` FOREIGN KEY (`create_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `drug_orders_fill_user_id_foreign` FOREIGN KEY (`fill_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `drug_orders_from_account_id_foreign` FOREIGN KEY (`from_account_id`) REFERENCES `accounts` (`id`),
  ADD CONSTRAINT `drug_orders_to_account_id_foreign` FOREIGN KEY (`to_account_id`) REFERENCES `accounts` (`id`);

--
-- Constraints for table `drug_order_items`
--
ALTER TABLE `drug_order_items`
  ADD CONSTRAINT `drug_order_items_drug_id_foreign` FOREIGN KEY (`drug_id`) REFERENCES `drugs` (`id`),
  ADD CONSTRAINT `drug_order_items_drug_order_id_foreign` FOREIGN KEY (`drug_order_id`) REFERENCES `drug_orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `drug_returns`
--
ALTER TABLE `drug_returns`
  ADD CONSTRAINT `drug_returns_confirmed_user_id_foreign` FOREIGN KEY (`confirmed_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `drug_returns_from_account_id_foreign` FOREIGN KEY (`from_account_id`) REFERENCES `accounts` (`id`),
  ADD CONSTRAINT `drug_returns_to_acccount_id_foreign` FOREIGN KEY (`to_acccount_id`) REFERENCES `accounts` (`id`),
  ADD CONSTRAINT `drug_returns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `drug_usages`
--
ALTER TABLE `drug_usages`
  ADD CONSTRAINT `drug_usages_drug_id_foreign` FOREIGN KEY (`drug_id`) REFERENCES `drugs` (`id`);

--
-- Constraints for table `employment_roles`
--
ALTER TABLE `employment_roles`
  ADD CONSTRAINT `employment_roles_employment_id_foreign` FOREIGN KEY (`employment_id`) REFERENCES `employments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `employment_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `examinations`
--
ALTER TABLE `examinations`
  ADD CONSTRAINT `examinations_detection_method_id_foreign` FOREIGN KEY (`detection_method_id`) REFERENCES `detection_methods` (`id`),
  ADD CONSTRAINT `examinations_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `treatment_places` (`id`),
  ADD CONSTRAINT `examinations_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `examinations_register_user_id_foreign` FOREIGN KEY (`register_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `examinations_x_ray_result_id_foreign` FOREIGN KEY (`x_ray_result_id`) REFERENCES `x_ray_results` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `organizations`
--
ALTER TABLE `organizations`
  ADD CONSTRAINT `organizations_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `organizations_address_province_id_foreign` FOREIGN KEY (`address_province_id`) REFERENCES `provinces` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `organizations_address_state_id_foreign` FOREIGN KEY (`address_state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `organizations_address_sub_state_id_foreign` FOREIGN KEY (`address_sub_state_id`) REFERENCES `sub_states` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `patients`
--
ALTER TABLE `patients`
  ADD CONSTRAINT `patients_address_province_id_foreign` FOREIGN KEY (`address_province_id`) REFERENCES `provinces` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_address_state_id_foreign` FOREIGN KEY (`address_state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_address_sub_state_id_foreign` FOREIGN KEY (`address_sub_state_id`) REFERENCES `sub_states` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_education_id_foreign` FOREIGN KEY (`education_id`) REFERENCES `educations` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_nation_id_foreign` FOREIGN KEY (`nation_id`) REFERENCES `nations` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_register_user_id_foreign` FOREIGN KEY (`register_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `patients_relationship_id_foreign` FOREIGN KEY (`relationship_id`) REFERENCES `relationships` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `patients_work_type_id_foreign` FOREIGN KEY (`work_type_id`) REFERENCES `work_types` (`id`);

--
-- Constraints for table `resistant_levels`
--
ALTER TABLE `resistant_levels`
  ADD CONSTRAINT `resistant_levels_root_id_foreign` FOREIGN KEY (`root_id`) REFERENCES `resistant_levels` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_root_id_foreign` FOREIGN KEY (`root_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `sample_qualities`
--
ALTER TABLE `sample_qualities`
  ADD CONSTRAINT `sample_qualities_sample_type_id_foreign` FOREIGN KEY (`sample_type_id`) REFERENCES `sample_types` (`id`);

--
-- Constraints for table `states`
--
ALTER TABLE `states`
  ADD CONSTRAINT `states_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`);

--
-- Constraints for table `sub_states`
--
ALTER TABLE `sub_states`
  ADD CONSTRAINT `sub_states_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);

--
-- Constraints for table `transfers`
--
ALTER TABLE `transfers`
  ADD CONSTRAINT `transfers_account_balance_id_foreign` FOREIGN KEY (`account_balance_id`) REFERENCES `account_balances` (`id`),
  ADD CONSTRAINT `transfers_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`);

--
-- Constraints for table `treatments`
--
ALTER TABLE `treatments`
  ADD CONSTRAINT `treatments_case_id_foreign` FOREIGN KEY (`case_id`) REFERENCES `tubis_cases` (`id`),
  ADD CONSTRAINT `treatments_create_user_id_foreign` FOREIGN KEY (`create_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `treatments_result_user_id_foreign` FOREIGN KEY (`result_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `treatments_treatment_method_id_foreign` FOREIGN KEY (`treatment_method_id`) REFERENCES `treatment_methods` (`id`),
  ADD CONSTRAINT `treatments_treatment_place_id_foreign` FOREIGN KEY (`treatment_place_id`) REFERENCES `treatment_places` (`id`),
  ADD CONSTRAINT `treatments_treatment_result_id_foreign` FOREIGN KEY (`treatment_result_id`) REFERENCES `treatment_results` (`id`);

--
-- Constraints for table `treatment_controls`
--
ALTER TABLE `treatment_controls`
  ADD CONSTRAINT `treatment_controls_send_purpose_id_foreign` FOREIGN KEY (`send_purpose_id`) REFERENCES `send_purposes` (`id`),
  ADD CONSTRAINT `treatment_controls_treatment_section_id_foreign` FOREIGN KEY (`treatment_section_id`) REFERENCES `treatment_sections` (`id`);

--
-- Constraints for table `treatment_methods`
--
ALTER TABLE `treatment_methods`
  ADD CONSTRAINT `treatment_methods_drug_group_id_foreign` FOREIGN KEY (`drug_group_id`) REFERENCES `drug_groups` (`id`);

--
-- Constraints for table `treatment_processes`
--
ALTER TABLE `treatment_processes`
  ADD CONSTRAINT `treatment_processes_drug_id_foreign` FOREIGN KEY (`drug_id`) REFERENCES `drugs` (`id`),
  ADD CONSTRAINT `treatment_processes_treatment_id_foreign` FOREIGN KEY (`treatment_id`) REFERENCES `treatments` (`id`);

--
-- Constraints for table `tubis_cases`
--
ALTER TABLE `tubis_cases`
  ADD CONSTRAINT `tubis_cases_case_description_id_foreign` FOREIGN KEY (`case_description_id`) REFERENCES `case_descriptions` (`id`),
  ADD CONSTRAINT `tubis_cases_case_index_id_foreign` FOREIGN KEY (`case_index_id`) REFERENCES `case_indices` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `tubis_cases_detection_method_id_foreign` FOREIGN KEY (`detection_method_id`) REFERENCES `detection_methods` (`id`),
  ADD CONSTRAINT `tubis_cases_diag_id_foreign` FOREIGN KEY (`diag_id`) REFERENCES `diags` (`id`),
  ADD CONSTRAINT `tubis_cases_infection_source_id_foreign` FOREIGN KEY (`infection_source_id`) REFERENCES `infection_sources` (`id`),
  ADD CONSTRAINT `tubis_cases_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  ADD CONSTRAINT `tubis_cases_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `tubis_cases_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`),
  ADD CONSTRAINT `tubis_cases_register_user_id_foreign` FOREIGN KEY (`register_user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tubis_cases_resistant_level_1_foreign` FOREIGN KEY (`resistant_level_1`) REFERENCES `resistant_levels` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `tubis_cases_resistant_level_2_foreign` FOREIGN KEY (`resistant_level_2`) REFERENCES `resistant_levels` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `tubis_cases_resistant_level_3_foreign` FOREIGN KEY (`resistant_level_3`) REFERENCES `resistant_levels` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `tubis_cases_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  ADD CONSTRAINT `tubis_cases_sub_state_id_foreign` FOREIGN KEY (`sub_state_id`) REFERENCES `sub_states` (`id`),
  ADD CONSTRAINT `tubis_cases_tb_type_id_foreign` FOREIGN KEY (`tb_type_id`) REFERENCES `tb_types` (`id`),
  ADD CONSTRAINT `tubis_cases_x_ray_result_id_foreign` FOREIGN KEY (`x_ray_result_id`) REFERENCES `x_ray_results` (`id`);

--
-- Constraints for table `user_employments`
--
ALTER TABLE `user_employments`
  ADD CONSTRAINT `user_employments_employment_id_foreign` FOREIGN KEY (`employment_id`) REFERENCES `employments` (`id`),
  ADD CONSTRAINT `user_employments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_informations`
--
ALTER TABLE `user_informations`
  ADD CONSTRAINT `user_informations_address_province_id_foreign` FOREIGN KEY (`address_province_id`) REFERENCES `provinces` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_informations_address_state_id_foreign` FOREIGN KEY (`address_state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_informations_address_sub_state_id_foreign` FOREIGN KEY (`address_sub_state_id`) REFERENCES `sub_states` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_informations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

