text: -- phpMyAdmin SQL Dump
  -- version 4.8.0
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Mar 20, 2022 at 07:35 PM
  -- Server version: 10.1.31-MariaDB
  -- PHP Version: 7.2.4
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `hms`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `departments`
  --
  
  CREATE TABLE `departments` (
    `department_id` int(10) UNSIGNED NOT NULL,
    `department_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `departments`
  --
  
  INSERT INTO `departments` (`department_id`, `department_name`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Gastrology', 1, '2019-02-09 03:35:23', '2019-02-13 19:39:00', 1, 1),
  (2, 'Radiology', 1, '2019-02-08 21:41:19', '2019-02-13 19:39:03', 1, 1),
  (3, 'Surgery', 1, '2019-02-13 23:22:34', NULL, 1, NULL),
  (4, 'X-Ray', 1, '2019-02-13 23:22:34', NULL, 1, NULL),
  (5, 'asdad', 1, '2019-02-18 00:40:52', NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `designations`
  --
  
  CREATE TABLE `designations` (
    `designation_id` int(10) UNSIGNED NOT NULL,
    `designation_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `designation_type` tinyint(4) NOT NULL DEFAULT '1',
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `designations`
  --
  
  INSERT INTO `designations` (`designation_id`, `designation_name`, `designation_type`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Sales Manager', 2, 1, '2019-02-06 03:15:22', '2019-02-13 23:38:23', 1, 1),
  (2, 'Receptionist', 1, 1, '2019-02-06 03:15:51', '2019-02-13 23:38:26', 1, 1),
  (3, 'HR', 1, 1, '2019-02-06 03:15:57', '2019-02-13 19:39:25', 1, 1),
  (4, 'Duty Doctor', 1, 1, '2019-02-14 01:39:21', '2019-02-13 19:39:30', 0, 1),
  (6, 'Admin Officer', 1, 1, '2019-02-22 22:49:50', NULL, 1, NULL),
  (8, 'Duty Doctor', 2, 2, '2019-02-24 19:10:57', '2019-02-24 19:11:03', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `diagnostic_tests`
  --
  
  CREATE TABLE `diagnostic_tests` (
    `diagnostic_test_id` int(10) UNSIGNED NOT NULL,
    `diagnostic_test_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `diagnostic_test_price` double(12,3) NOT NULL DEFAULT '0.000',
    `diagnostic_test_sale_price` double(12,3) NOT NULL DEFAULT '0.000',
    `service_category_id` tinyint(4) NOT NULL,
    `service_sub_category_id` tinyint(4) DEFAULT NULL,
    `diagnostic_test_result_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=> Positive/Negative, 2=> Yes/No, 3 => Unit Base',
    `diagnostic_test_normal_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `diagnostic_test_result_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `diagnostic_tests`
  --
  
  INSERT INTO `diagnostic_tests` (`diagnostic_test_id`, `diagnostic_test_name`, `diagnostic_test_price`, `diagnostic_test_sale_price`, `service_category_id`, `service_sub_category_id`, `diagnostic_test_result_type`, `diagnostic_test_normal_value`, `diagnostic_test_result_unit`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Dr. Jermey Walsh', 342.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (2, 'Tyrese Wiza DDS', 4320.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (3, 'Zola Schinner', 2304.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (4, 'Eryn Fay III', 423.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (5, 'Dr. Buford Hudson', 324.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (6, 'Abigayle Klocko', 4302.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (7, 'Jamel Leffler', 3024.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (8, 'Osvaldo Feil', 3024.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (9, 'Theodora Kilback', 4032.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:12', '2019-03-03 18:45:12', 1, NULL),
  (10, 'Amya Murphy', 4203.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (11, 'Belle Kovacek', 2034.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (12, 'Mrs. Linnie Mraz', 2034.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (13, 'Adella Schroeder', 3402.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (14, 'Ms. Izabella Cummings Jr.', 432.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (15, 'Prof. Travis Armstrong', 234.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (16, 'Christopher Dietrich Jr.', 3024.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (17, 'Bernita Schmidt', 3240.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (18, 'Santos Powlowski', 3240.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (19, 'Carmel Robel IV', 432.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (20, 'Kamille Hamill', 234.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (21, 'Telly Cole', 3042.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (22, 'Mr. Emanuel Parker PhD', 4032.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (23, 'Mara Nicolas', 3042.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (24, 'Cole Larson', 4320.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (25, 'Gregoria Huels', 4320.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (26, 'Cassidy Torp', 4320.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (27, 'Trent DuBuque', 342.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (28, 'Mr. Louisa Bednar', 4302.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (29, 'Chandler Konopelski PhD', 423.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (30, 'Santina Johnston', 4302.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (31, 'Prof. Otho Kreiger', 432.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (32, 'Ashley O\'Keefe DDS', 4230.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (33, 'Ms. Ardella Runolfsson Sr.', 4203.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (34, 'Mackenzie Jacobi', 2043.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (35, 'Cielo Hintz', 342.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (36, 'Dr. Cornell McCullough II', 2304.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (37, 'Jude Rippin', 2043.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:13', '2019-03-03 18:45:13', 1, NULL),
  (38, 'Jackeline Waters', 3024.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (39, 'Luisa Dooley', 423.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (40, 'Joe Kilback', 4320.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (41, 'Ruthie Shields', 4023.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (42, 'Tianna Satterfield', 4023.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (43, 'Estella Reilly III', 4203.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (44, 'Cristal Ratke', 4320.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (45, 'Amanda Hirthe', 2403.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (46, 'Julia Howell', 4230.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (47, 'Autumn Wyman', 2430.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (48, 'Susie Thompson', 2430.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (49, 'Pete Koelpin', 2430.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (50, 'Miss Laurie Parker', 2304.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (51, 'Maximillian Murazik Sr.', 3420.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (52, 'Mr. Enid Windler', 423.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (53, 'Prof. Ethel Hudson', 4023.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (54, 'Erwin Marks II', 2034.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (55, 'Dr. Afton Ryan', 2034.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (56, 'Dr. Jazlyn Champlin', 2403.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (57, 'Terrence Kutch', 4230.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (58, 'Caesar Huel V', 234.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (59, 'Mr. Nigel Stark DDS', 342.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (60, 'Prof. Alysson Stoltenberg IV', 432.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (61, 'Dr. Alice Wisozk Sr.', 3204.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (62, 'Ms. Emmy Langosh I', 4023.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (63, 'Rachael Satterfield', 2340.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (64, 'Austin Barrows', 2403.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (65, 'Tyler Okuneva', 3420.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (66, 'Dr. Connor Moen DDS', 3042.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:14', '2019-03-03 18:45:14', 1, NULL),
  (67, 'Adeline Olson', 3204.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (68, 'Zakary Bosco', 2043.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (69, 'Prof. Lois Hermiston MD', 2340.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (70, 'Dr. Nathan Homenick', 3024.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (71, 'Ethan Smitham', 2034.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (72, 'Dr. Larry Fadel', 4032.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (73, 'Paris Spencer', 4320.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (74, 'Jeremy McGlynn', 2034.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (75, 'Dagmar Nikolaus I', 4032.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (76, 'Mr. Jamil Rippin Jr.', 423.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (77, 'Wiley Schamberger', 234.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (78, 'Herminio Ortiz', 3024.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (79, 'Janis Keebler', 4320.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (80, 'Miss Kariane Gleichner III', 2403.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (81, 'Nico Erdman', 4320.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (82, 'Clement Ebert', 2304.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (83, 'Kolby Wunsch', 2304.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (84, 'Mr. Dario Glover MD', 3402.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (85, 'Gayle O\'Keefe', 432.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (86, 'Brigitte Runolfsdottir V', 4203.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (87, 'Heloise Kilback', 2403.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (88, 'Dr. Kelvin Reinger Jr.', 4320.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (89, 'Sabina Adams Sr.', 423.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (90, 'Mr. Marshall Jenkins V', 243.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (91, 'Dr. Russel Ankunding', 234.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (92, 'Mateo Franecki', 3402.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (93, 'Jamarcus Kshlerin I', 432.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (94, 'Dr. Hailey Larson', 2403.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:15', '2019-03-03 18:45:15', 1, NULL),
  (95, 'Retta Luettgen', 4320.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (96, 'Maya Ferry II', 3420.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (97, 'Prof. Garrison Ortiz', 423.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (98, 'Jarred Price', 4203.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (99, 'Prof. Sonny Blanda I', 234.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (100, 'Dr. Tyree Kling II', 324.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (101, 'Ayla Jaskolski', 3024.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (102, 'Cora Hegmann', 2340.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (103, 'Tony Zboncak', 2430.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (104, 'Caitlyn Johns', 3042.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (105, 'Marisa Walsh', 342.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (106, 'Isaias Emmerich', 234.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (107, 'Quinton Hand', 2403.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (108, 'Prof. Terrance Tillman V', 2304.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (109, 'Destiny Kerluke', 3024.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (110, 'Prof. Giovanny Prohaska', 2034.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (111, 'Talon Schmitt', 234.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (112, 'Christine Ratke', 4230.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (113, 'Elwyn McCullough', 324.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (114, 'Miss Elisha Yost', 234.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (115, 'Miss Mariana Langworth II', 2043.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (116, 'Melyssa Rosenbaum', 243.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (117, 'Frank Ernser', 2340.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (118, 'Maureen Powlowski Jr.', 3042.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (119, 'Laurie Friesen', 4302.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (120, 'Miss Dena Satterfield MD', 324.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (121, 'Mr. Eldred Davis', 4302.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (122, 'Ernest Schmitt', 3024.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (123, 'Shaina Green', 4203.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:16', '2019-03-03 18:45:16', 1, NULL),
  (124, 'Idella Langworth DVM', 3420.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (125, 'Rowan Skiles MD', 4320.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (126, 'Prof. Kenya Lynch Jr.', 2304.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (127, 'Andre Hills', 4203.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (128, 'Jazlyn Rice', 234.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (129, 'Laurianne Huels', 2043.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (130, 'Dr. Theo Yost', 432.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (131, 'Amara Runte', 2304.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (132, 'Daisy Kautzer', 3204.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (133, 'Quinton Prohaska DDS', 2403.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (134, 'Mrs. Ila Cummerata', 2430.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (135, 'Joshua Marks', 4320.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (136, 'Prof. Braden Hackett', 324.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (137, 'Carroll Runolfsson', 432.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (138, 'Roslyn Schumm', 2430.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (139, 'Oceane Moore', 4302.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (140, 'Ms. Leann Dibbert', 4230.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (141, 'Liam Kiehn', 3042.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (142, 'Mr. Trey Herman I', 4320.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (143, 'Zaria Considine', 3024.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (144, 'Mr. Demetrius Skiles', 2340.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (145, 'Mr. Emerald Farrell', 4032.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (146, 'Bryon Halvorson', 324.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (147, 'Silas Gleichner', 324.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (148, 'Shanelle Jenkins Sr.', 342.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (149, 'Helene Hoppe DDS', 234.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (150, 'Kirk Heathcote', 2043.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (151, 'Viva Maggio PhD', 3042.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (152, 'Mrs. Margaretta Stokes Jr.', 2304.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:17', '2019-03-03 18:45:17', 1, NULL),
  (153, 'Concepcion Feest', 4302.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (154, 'Hermann Larson', 423.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (155, 'Esteban Hickle', 3420.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (156, 'Bernhard Batz', 3240.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (157, 'Grayson Orn', 2304.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (158, 'Dr. Jordy Rippin', 3420.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (159, 'Dr. Leif Collier', 342.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (160, 'Fae Schinner', 3042.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (161, 'Annalise Cole', 2043.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (162, 'Rickey Kulas', 4032.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (163, 'Kevin Vandervort', 2043.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (164, 'Demario Cummings', 2304.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (165, 'Ms. Nova Abshire I', 4230.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (166, 'Kenya Rath II', 4023.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (167, 'Ignacio Leffler', 243.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (168, 'Demond Welch', 4023.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (169, 'Joelle Donnelly III', 4302.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (170, 'Meda Trantow', 423.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (171, 'Prof. Micaela Keeling', 432.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (172, 'Enrique Nikolaus', 3420.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (173, 'Dr. Nils Lemke', 243.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:18', '2019-03-03 18:45:18', 1, NULL),
  (174, 'Shanon Homenick', 4320.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (175, 'Manley Harvey', 342.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (176, 'Abbigail Ferry III', 423.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (177, 'Hadley Dooley', 2403.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (178, 'Carter Rodriguez III', 3204.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (179, 'Dolly Kihn', 3024.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (180, 'Oceane Hirthe', 2304.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (181, 'Fiona Donnelly', 423.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (182, 'Prof. Lenny Roberts', 342.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (183, 'Werner Zulauf I', 3042.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (184, 'Miss Marilie Carroll', 3042.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (185, 'Buster Swift', 3402.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (186, 'Stanford Tromp', 3402.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (187, 'Estella Tromp', 243.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (188, 'Miss Heaven Mann', 2304.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (189, 'Marlee Shanahan PhD', 2340.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (190, 'Derek Bashirian', 4203.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (191, 'Prof. Eden Cummings IV', 3024.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (192, 'Alberto Armstrong V', 3240.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (193, 'Dr. Brittany Howe', 4302.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (194, 'Russell Abernathy DVM', 324.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (195, 'Joanny Stehr II', 3024.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (196, 'Adan Prohaska III', 3240.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (197, 'Ms. Evelyn Leffler', 423.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (198, 'Prof. Edison Gaylord', 4203.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (199, 'Prof. Charles Tremblay II', 324.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (200, 'Prince Maggio', 3420.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (201, 'Nathanial Gutkowski', 3240.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (202, 'Miss Rosalyn Jerde', 3204.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (203, 'Khalil Pouros', 4203.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:19', '2019-03-03 18:45:19', 1, NULL),
  (204, 'Donny Powlowski', 3204.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (205, 'Jimmie Ullrich PhD', 2403.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (206, 'Araceli Kautzer', 4203.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (207, 'Forest Heller', 2034.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (208, 'Damian Torphy II', 3240.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (209, 'Rosemary Smitham Sr.', 3024.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (210, 'Mr. Sherman Windler II', 3402.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (211, 'Donna Hoeger', 2304.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (212, 'Mr. Colton Murphy Sr.', 4203.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (213, 'Leland White Sr.', 2304.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (214, 'Raleigh Schultz IV', 2304.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (215, 'Prof. Noemy Zboncak', 3240.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (216, 'Garfield Treutel', 4203.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (217, 'Rosalind Lynch', 4203.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (218, 'Everett Kihn', 4023.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (219, 'Alysson Zieme', 243.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (220, 'Beulah Buckridge', 3420.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (221, 'Mrs. Kailyn Fadel Sr.', 4302.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (222, 'Bradly Kessler', 4302.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (223, 'Jazmyne Franecki', 3240.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:20', '2019-03-03 18:45:20', 1, NULL),
  (224, 'Ralph O\'Reilly', 2034.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (225, 'Ms. Ofelia Tromp V', 3024.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (226, 'Dr. Maybell Reinger', 4032.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (227, 'Shany Leannon', 2034.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (228, 'Bailee Ernser', 432.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (229, 'Kali Stokes', 2043.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (230, 'Herminio Kassulke', 2430.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (231, 'Eleonore Hyatt', 3204.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (232, 'Ramiro Barton', 234.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (233, 'Dr. Dejah Borer III', 2043.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (234, 'Icie Wolf', 3204.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (235, 'Vivian Conroy III', 2340.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (236, 'Providenci Nikolaus', 2340.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (237, 'Prof. Ronaldo Lind MD', 3240.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (238, 'Dr. Anthony Ankunding III', 3042.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (239, 'Curtis Leannon', 2430.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (240, 'Antonietta Daugherty Sr.', 4203.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (241, 'Dr. Boris Medhurst', 342.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (242, 'Madonna Reinger V', 3204.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (243, 'Kayli Conn', 2304.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (244, 'Sigrid Armstrong', 2034.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (245, 'Heath Terry', 3024.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (246, 'Elfrieda Jaskolski', 432.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (247, 'Simone Klocko', 2304.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:21', '2019-03-03 18:45:21', 1, NULL),
  (248, 'Mr. Timothy Rempel', 2304.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (249, 'Kaycee Wilderman', 423.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (250, 'Lauren Littel', 2034.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (251, 'Dr. Ova Gibson', 3402.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (252, 'Blanche Zemlak', 4023.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (253, 'Prof. Dejon Schaefer', 3402.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (254, 'Mr. Reymundo McLaughlin', 4230.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (255, 'Bennie Cole', 3042.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (256, 'Ines Wilkinson II', 2304.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (257, 'Luther Swaniawski', 243.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (258, 'Jameson Becker', 342.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (259, 'Steve Pfannerstill', 423.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (260, 'Monique Langworth', 3240.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (261, 'Damaris Dicki DVM', 2403.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (262, 'Sidney Maggio', 2403.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (263, 'Ernest Marvin', 4302.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (264, 'Kraig Bergnaum', 432.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (265, 'Trevion Weimann', 3024.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (266, 'Katelin Jacobson', 2340.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (267, 'Terry Heathcote', 2340.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (268, 'Allie Koch', 243.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (269, 'Dr. Jenifer McKenzie Jr.', 342.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:22', '2019-03-03 18:45:22', 1, NULL),
  (270, 'Magali Roob', 2340.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (271, 'Shana Kautzer', 2340.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (272, 'Verona Kilback', 3240.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (273, 'Francesca Lockman', 4302.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (274, 'Ross Prohaska', 324.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (275, 'Gladys Bartell', 2430.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (276, 'Prof. Vada Sanford DDS', 2043.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (277, 'Selmer Dickinson', 234.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (278, 'Dr. Lois Turner IV', 4302.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (279, 'Dr. Angelina Friesen III', 324.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (280, 'Linnie Schinner', 3042.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (281, 'Carissa Koelpin', 234.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (282, 'Mr. Macey Grady', 324.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (283, 'Mr. Benjamin Stanton', 234.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (284, 'Tina Treutel DDS', 4023.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (285, 'Dr. Jayden Bergnaum', 4302.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (286, 'Kennedy Davis Sr.', 4302.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (287, 'Vena Botsford', 4032.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (288, 'Katherine Cole', 4203.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (289, 'Constance Eichmann', 2430.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (290, 'Chris Orn Jr.', 4302.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (291, 'Adan Veum', 4032.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (292, 'Michel O\'Keefe', 432.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (293, 'Aileen Hahn', 4230.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (294, 'Prof. Bradly Harvey II', 324.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (295, 'Alta Gerlach', 3024.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (296, 'Sonny Ernser', 2034.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (297, 'Dr. Damaris Hirthe Jr.', 4320.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:23', '2019-03-03 18:45:23', 1, NULL),
  (298, 'Enrique Padberg MD', 3420.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (299, 'Kurt Hansen', 243.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (300, 'Carley Sawayn', 2034.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (301, 'Mr. Cordelia Blanda II', 2034.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (302, 'Domenic Kessler', 3240.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (303, 'Dr. Stewart Mosciski III', 4032.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (304, 'Benton Tillman', 423.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (305, 'Jodie Langworth', 3420.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (306, 'Astrid Kessler', 3240.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (307, 'Mr. Turner Funk', 4032.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (308, 'Keegan Beatty DDS', 3240.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (309, 'Constance Schneider', 3042.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (310, 'Ernestine Yost PhD', 2043.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (311, 'Dr. Adolf Osinski I', 234.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (312, 'Mr. Eriberto Abernathy', 243.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (313, 'Ernest Braun', 3024.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (314, 'Daisy O\'Connell V', 3042.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (315, 'Kurtis Baumbach', 3042.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (316, 'Makenna Rice', 2403.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (317, 'Dr. Meagan Lubowitz', 3042.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (318, 'Devin Bernier', 423.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (319, 'Ms. Arlie Durgan DDS', 423.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (320, 'Breanne Block', 2403.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:24', '2019-03-03 18:45:24', 1, NULL),
  (321, 'Cary Goyette', 2403.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (322, 'Dr. Madilyn Bechtelar', 2304.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (323, 'Orval Kirlin', 4032.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (324, 'Dr. Melyna Legros', 2043.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (325, 'Gino Glover', 432.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (326, 'Damion Pollich', 2403.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (327, 'Dr. Jessie Grant', 3024.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (328, 'Dr. Malika Swift I', 4320.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (329, 'Ashley Jones II', 3042.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (330, 'Mr. Axel Farrell', 243.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (331, 'Andre Nitzsche', 2304.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (332, 'Stephania Friesen', 423.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (333, 'Sasha Wolf', 3204.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (334, 'Darrin Lesch', 4203.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (335, 'Bailey Cormier', 234.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (336, 'Itzel Walter', 3240.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (337, 'Jordi Abernathy', 3402.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (338, 'Prof. Emelie Huels', 3024.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (339, 'Jovanny Osinski', 3402.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (340, 'Sallie Murray', 234.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (341, 'Jayden Stokes', 4032.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (342, 'Prof. Matt Jacobi Sr.', 423.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (343, 'Eduardo Swaniawski', 3042.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (344, 'Woodrow Toy', 2034.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (345, 'Dr. Agustin Mante', 2034.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (346, 'Antone Braun', 3420.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (347, 'Prof. Lilliana Dare', 243.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:25', '2019-03-03 18:45:25', 1, NULL),
  (348, 'Prof. Timothy Lang III', 3204.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (349, 'Brain Hahn', 423.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (350, 'Dr. Francesca Simonis V', 342.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (351, 'Myrl Kertzmann', 3042.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (352, 'Marietta Windler', 3204.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (353, 'Evan Vandervort', 4302.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (354, 'Alfred Simonis', 234.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (355, 'John Corkery', 3204.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (356, 'Cindy VonRueden', 243.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (357, 'Janis Predovic I', 4032.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (358, 'Mrs. Ashlynn Pouros', 3240.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (359, 'Ernesto D\'Amore', 2340.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (360, 'Gunner Koelpin', 234.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (361, 'Karlie Mueller', 4320.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (362, 'Abigail Tremblay', 3024.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (363, 'Prof. Julia Cummings PhD', 4032.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (364, 'Eliza Brown', 3420.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (365, 'Kadin Will I', 3042.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (366, 'Bert Crooks PhD', 3420.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (367, 'Rosario Bayer', 3420.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (368, 'Mr. Leonard Feeney', 2340.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (369, 'Reymundo Hoeger', 2043.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (370, 'Ms. Mozelle Hansen Jr.', 342.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (371, 'Carmine Bruen DVM', 4302.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:26', '2019-03-03 18:45:26', 1, NULL),
  (372, 'Alexys Stehr', 4032.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (373, 'Rylee Pagac', 3402.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (374, 'Armand Murazik', 4032.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (375, 'Dorris Christiansen', 2430.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (376, 'Danika Heathcote', 4230.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (377, 'Ms. Elody Casper II', 324.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (378, 'Darrin Fay DVM', 423.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (379, 'Dawson Flatley', 432.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (380, 'Tyrese Abernathy', 3024.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (381, 'Dr. Ransom Wyman', 2034.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (382, 'Mrs. Adela Lesch III', 3240.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (383, 'Lia Jacobs', 3042.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (384, 'Garry Johnston', 2043.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (385, 'Antonina Russel DDS', 4320.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (386, 'Mrs. Isabella Erdman', 2430.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (387, 'Denis Schroeder PhD', 4203.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (388, 'Gerry Hagenes', 234.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:27', '2019-03-03 18:45:27', 1, NULL),
  (389, 'Rory King', 3204.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (390, 'Fermin Watsica III', 4320.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (391, 'Guiseppe Goodwin', 3402.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (392, 'Lee Hahn', 3240.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (393, 'Lydia Nienow', 432.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (394, 'Eusebio Funk', 2403.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (395, 'Cleora Rosenbaum', 3420.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (396, 'Mrs. Laurianne Zboncak', 4032.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (397, 'Linnea Gutkowski', 4023.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (398, 'Eusebio DuBuque', 2304.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (399, 'Juana Hagenes', 2304.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (400, 'Reyes Moen I', 3024.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (401, 'Evelyn Eichmann', 4023.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (402, 'Dino Purdy', 3240.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL);
  INSERT INTO `diagnostic_tests` (`diagnostic_test_id`, `diagnostic_test_name`, `diagnostic_test_price`, `diagnostic_test_sale_price`, `service_category_id`, `service_sub_category_id`, `diagnostic_test_result_type`, `diagnostic_test_normal_value`, `diagnostic_test_result_unit`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (403, 'Arianna Fadel', 3042.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (404, 'Khalid Nicolas', 3042.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (405, 'Caden Kuvalis', 3042.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (406, 'Enos Wolf DVM', 234.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (407, 'Stanford Ryan', 243.000, 3294.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (408, 'Kayden Bogisich', 4023.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:28', '2019-03-03 18:45:28', 1, NULL),
  (409, 'Vicente Klein', 3420.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (410, 'Agustina Thiel', 4320.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (411, 'Prof. Trystan Smith', 432.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (412, 'Burnice Kutch', 423.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (413, 'Tyra Maggio', 3402.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (414, 'Dr. Filiberto Sanford', 2403.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (415, 'Mr. Immanuel Quigley V', 3204.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (416, 'Prof. Lurline Abbott', 432.000, 4293.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (417, 'Howard Stehr', 3204.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (418, 'Maybell Ledner', 432.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (419, 'Frederique Buckridge', 3024.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (420, 'Chesley Haag', 3402.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (421, 'Beau Kulas I', 4032.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (422, 'Mia Vandervort II', 3042.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (423, 'Dawson King', 4230.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (424, 'Mitchel Emmerich DVM', 3024.000, 2934.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (425, 'Asia Fahey IV', 2403.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (426, 'Tomas Rippin', 2043.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (427, 'Jaquan Howe Jr.', 2340.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (428, 'Miss Marisol Pouros III', 4032.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:29', '2019-03-03 18:45:29', 1, NULL),
  (429, 'Darius Kshlerin', 4320.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (430, 'Zack Trantow', 4032.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (431, 'Dr. Alysson Marquardt', 4032.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (432, 'Jason Abernathy', 234.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (433, 'Jamal Smith', 4032.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (434, 'Marco Heidenreich', 4320.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (435, 'Alexandro Lynch', 3204.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (436, 'Dr. Cordia Beatty', 243.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (437, 'Jasen Cole', 3402.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (438, 'Wava Kulas', 2403.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (439, 'Ressie Purdy', 243.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (440, 'Kellie Ortiz', 2043.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (441, 'Ebba Eichmann', 4320.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (442, 'Joelle Hammes', 2304.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (443, 'Melvin Hammes', 243.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (444, 'Dr. Randy Doyle', 3204.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (445, 'Lura Lueilwitz', 432.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (446, 'Ms. Rosemarie Hickle DDS', 2304.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (447, 'Miss Elisha Larkin', 4320.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (448, 'Miss Danielle Little', 2304.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:30', '2019-03-03 18:45:30', 1, NULL),
  (449, 'Marion Tromp', 3024.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (450, 'Mrs. Eleanore Nienow I', 2403.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (451, 'Jakayla Becker', 3042.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (452, 'Dr. Hobart Klocko III', 243.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (453, 'Melisa Lemke', 243.000, 3249.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (454, 'Dana Homenick', 3420.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (455, 'Mr. Fabian Herman PhD', 423.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (456, 'Prof. Chase Gerhold', 4320.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (457, 'Mr. Isai Mosciski PhD', 234.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (458, 'Sienna Muller MD', 3204.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (459, 'Hillary Leuschke', 2034.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (460, 'Toby Krajcik PhD', 3402.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (461, 'Prof. Duncan Windler', 342.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (462, 'Haven Hammes', 243.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (463, 'Ms. Joy Price MD', 3042.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (464, 'Ms. Katelynn Hintz V', 3204.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (465, 'Mr. Sage Kunde', 342.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (466, 'Gideon Reilly', 3204.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (467, 'Vance Veum IV', 2034.000, 9423.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (468, 'Dr. Amely Strosin', 342.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (469, 'Prof. Catharine Cole', 2403.000, 9342.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:31', '2019-03-03 18:45:31', 1, NULL),
  (470, 'Gretchen Thompson', 4320.000, 3924.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (471, 'Kianna Schowalter', 432.000, 9234.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (472, 'Rhoda Donnelly', 4320.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (473, 'Kaden Hickle', 2043.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (474, 'Gerson Lubowitz I', 423.000, 9324.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (475, 'Aaron Aufderhar', 432.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (476, 'Lola Stark V', 2403.000, 2394.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (477, 'Mr. Hadley Dickens Jr.', 423.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (478, 'Kyleigh Wilkinson', 4203.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (479, 'Jada Cartwright V', 2340.000, 2943.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (480, 'Dr. Camden O\'Keefe', 2304.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (481, 'Prof. Ebony McClure PhD', 324.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (482, 'Adrianna Wilderman', 3420.000, 3942.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (483, 'Reilly Bradtke', 324.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (484, 'Helen Kuhlman', 3420.000, 9243.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (485, 'Chase Borer', 3024.000, 3492.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (486, 'Joana Blanda', 3240.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (487, 'Lacey Grimes', 2034.000, 4932.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (488, 'Maia Hayes', 3024.000, 2493.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (489, 'Guy Volkman', 2430.000, 4239.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (490, 'Prof. Izaiah Wilderman', 2043.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (491, 'Jeremie Toy', 342.000, 4392.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:32', '2019-03-03 18:45:32', 1, NULL),
  (492, 'Mr. Quinn Hessel', 3240.000, 9432.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (493, 'Justus O\'Keefe', 4302.000, 4329.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (494, 'Ari Gerhold', 4023.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (495, 'Adelbert Cartwright', 2043.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (496, 'Colby Dicki Sr.', 3240.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (497, 'Lelah Shields', 3204.000, 4923.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (498, 'Reymundo Corkery', 4230.000, 3429.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (499, 'Justen Frami II', 3420.000, 2439.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL),
  (500, 'Alexzander Cummings', 2340.000, 2349.000, 1, 1, 1, NULL, NULL, 1, '2019-03-03 18:45:33', '2019-03-03 18:45:33', 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `doctors`
  --
  
  CREATE TABLE `doctors` (
    `doctor_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `department_id` int(10) UNSIGNED NOT NULL,
    `designation_id` int(10) UNSIGNED NOT NULL,
    `educational_qualification_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `medical_degree_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `speciality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `allow_prescription_fee` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=>Not Allowed, 1=>Allowed',
    `prescription_fee` decimal(9,3) NOT NULL DEFAULT '0.000',
    `payment_receiving_process` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=>Received By Hospital With Appointment, 2=>Received By Doctor With Appointment',
    `commission_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=>Type 1, 2=>Type 2',
    `commission` decimal(9,3) NOT NULL DEFAULT '0.000',
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `doctors`
  --
  
  INSERT INTO `doctors` (`doctor_id`, `user_id`, `department_id`, `designation_id`, `educational_qualification_id`, `medical_degree_id`, `speciality`, `allow_prescription_fee`, `prescription_fee`, `payment_receiving_process`, `commission_type`, `commission`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 21, 2, 1, '1', '1', 'Speciality', 1, '56.000', 1, 1, '10.000', 1, NULL, '2019-02-08 22:27:02', 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `educational_qualifications`
  --
  
  CREATE TABLE `educational_qualifications` (
    `educational_qualification_id` int(10) UNSIGNED NOT NULL,
    `educational_qualification_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `educational_qualifications`
  --
  
  INSERT INTO `educational_qualifications` (`educational_qualification_id`, `educational_qualification_name`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'MBBS', 1, '2019-02-14 01:38:31', '2019-02-13 19:38:39', 0, 1),
  (4, 'SSC', 1, '2019-02-13 23:18:29', NULL, 1, NULL),
  (5, 'HSC', 1, '2019-02-13 23:18:29', NULL, 1, NULL),
  (6, 'MBA', 1, '2019-02-13 23:18:29', NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `employee_infos`
  --
  
  CREATE TABLE `employee_infos` (
    `employee_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `designation_id` int(10) UNSIGNED NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `employee_infos`
  --
  
  INSERT INTO `employee_infos` (`employee_id`, `user_id`, `designation_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (2, 14, 6, 1, '2019-02-07 22:22:46', '2019-02-26 21:36:00', 1, 1),
  (3, 15, 6, 1, '2019-02-07 22:22:56', '2019-02-26 21:35:53', 1, 1),
  (4, 19, 3, 2, '2019-02-07 22:23:05', '2019-02-19 22:00:15', 1, 1),
  (5, 22, 2, 0, NULL, '2019-02-26 23:27:04', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `medical_degrees`
  --
  
  CREATE TABLE `medical_degrees` (
    `medical_degree_id` int(10) UNSIGNED NOT NULL,
    `medical_degree_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `medical_degrees`
  --
  
  INSERT INTO `medical_degrees` (`medical_degree_id`, `medical_degree_name`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'FCPS', 1, '2019-02-10 00:26:27', '2019-02-13 21:33:14', 1, 1),
  (5, 'MBBS', 1, '2019-02-13 22:15:48', NULL, 1, NULL),
  (6, 'FRCS', 1, '2019-02-13 22:15:48', NULL, 1, NULL),
  (7, 'BSS', 1, '2019-02-13 22:21:44', NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (22, '2014_10_12_000000_create_users_table', 1),
  (23, '2019_02_05_083536_create_doctors_table', 1),
  (24, '2019_02_05_084003_create_departments_table', 1),
  (25, '2019_02_05_084020_create_designations_table', 1),
  (26, '2019_02_05_084052_employee', 1),
  (27, '2019_02_05_114133_create_salary_infos_table', 1),
  (28, '2019_02_09_070526_educational_qualifications', 1),
  (29, '2019_02_09_070742_medical_degree', 1),
  (30, '2019_02_15_064236_create_diagnostic_tests_table', 1),
  (31, '2019_02_18_063446_create_patients_table', 1),
  (32, '2019_02_20_075428_create_schedules_table', 1),
  (33, '2019_02_20_075447_create_schedule_blocks_table', 1),
  (34, '2019_02_20_075500_create_schedule_slots_table', 1),
  (35, '2019_02_27_100352_create_service_categories_table', 1),
  (36, '2019_02_27_100403_create_service_sub_categories_table', 1),
  (37, '2019_03_04_092248_create_service_groups_table', 1),
  (38, '2019_03_04_092430_create_service_group_items_table', 1),
  (39, '2019_03_14_093429_create_service_packages_table', 1),
  (40, '2019_03_14_093446_create_service_package_items_table', 1),
  (41, '2019_05_04_054435_create_sale_invoices_table', 1),
  (42, '2019_05_04_055453_create_sale_invoice_details_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `patients`
  --
  
  CREATE TABLE `patients` (
    `patient_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `blood_group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `age` tinyint(4) NOT NULL DEFAULT '0',
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `patients`
  --
  
  INSERT INTO `patients` (`patient_id`, `user_id`, `blood_group`, `age`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (2, 24, '1', 0, 1, NULL, NULL, 1, NULL),
  (3, 25, '2', 0, 1, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `salary_infos`
  --
  
  CREATE TABLE `salary_infos` (
    `salary_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `salary_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=>Full Time,2=>Part Time,3=>Commission based',
    `salary_amount` double(12,3) NOT NULL,
    `due` double(12,3) NOT NULL,
    `advanced` double(12,3) NOT NULL,
    `last_payment_amount` double(12,3) NOT NULL,
    `last_payment_date` datetime NOT NULL,
    `last_payment_by` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sale_invoices`
  --
  
  CREATE TABLE `sale_invoices` (
    `sale_id` int(10) UNSIGNED NOT NULL,
    `sale_invoice_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `cus_id` int(11) DEFAULT NULL,
    `payment_type_id` int(11) DEFAULT NULL,
    `discount` double(12,2) NOT NULL DEFAULT '0.00',
    `amount` double(12,2) NOT NULL DEFAULT '0.00',
    `pay` double(12,2) NOT NULL DEFAULT '0.00',
    `due` double(12,2) NOT NULL DEFAULT '0.00',
    `pay_note` int(11) NOT NULL DEFAULT '0',
    `date` date DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'o = > Inactive, 1 = > Active',
    `year` smallint(6) NOT NULL DEFAULT '2019',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `sale_invoices`
  --
  
  INSERT INTO `sale_invoices` (`sale_id`, `sale_invoice_id`, `cus_id`, `payment_type_id`, `discount`, `amount`, `pay`, `due`, `pay_note`, `date`, `status`, `year`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, '190504072015', 1, 1, 0.00, 29475.00, 29475.00, 0.00, 30000, '2019-05-04', 0, 2019, NULL, NULL, 14, NULL),
  (2, '190504110319', 1, 1, 0.00, 13761.00, 13761.00, 0.00, 13761, '2019-05-03', 0, 2019, NULL, NULL, 14, NULL),
  (3, '190504110324', 1, 1, 0.00, 13761.00, 13761.00, 0.00, 13761, '2019-05-03', 0, 2019, NULL, NULL, 14, NULL),
  (4, '190508061755', 1, 1, 0.00, 13554.00, 13554.00, 0.00, 13554, '2019-05-06', 0, 2019, NULL, NULL, 14, NULL),
  (5, '190508061826', 1, 1, 0.00, 13941.00, 13941.00, 0.00, 13941, '2019-05-07', 0, 2019, NULL, NULL, 14, NULL),
  (6, '190508061858', 1, 1, 0.00, 26451.00, 26451.00, 0.00, 26451, '2019-05-08', 0, 2019, NULL, NULL, 14, NULL),
  (7, '190508061921', 1, 1, 0.00, 18000.00, 18000.00, 0.00, 18000, '2019-05-08', 0, 2019, NULL, NULL, 14, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sale_invoice_details`
  --
  
  CREATE TABLE `sale_invoice_details` (
    `sale_details_id` int(10) UNSIGNED NOT NULL,
    `sale_invoice_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `package_id` int(11) DEFAULT NULL,
    `group_id` int(11) DEFAULT NULL,
    `diagnostic_test_id` int(10) UNSIGNED NOT NULL,
    `quantity` int(10) UNSIGNED NOT NULL,
    `discount` double(12,2) NOT NULL DEFAULT '0.00',
    `tax` double(12,2) NOT NULL DEFAULT '0.00',
    `amount` double(12,2) NOT NULL DEFAULT '0.00',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 => Inactive, 1 = > Active',
    `year` smallint(6) NOT NULL DEFAULT '2019',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `sale_invoice_details`
  --
  
  INSERT INTO `sale_invoice_details` (`sale_details_id`, `sale_invoice_id`, `package_id`, `group_id`, `diagnostic_test_id`, `quantity`, `discount`, `tax`, `amount`, `status`, `year`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, '190504072015', 0, 0, 101, 1, 0.00, 0.00, 2493.00, 1, 2019, NULL, NULL, 14, NULL),
  (2, '190504072015', 0, 0, 495, 1, 0.00, 0.00, 3429.00, 1, 2019, NULL, NULL, 14, NULL),
  (3, '190504072015', 0, 3, 1, 1, 0.00, 0.00, 2394.00, 1, 2019, NULL, NULL, 14, NULL),
  (4, '190504072015', 0, 3, 2, 1, 0.00, 0.00, 3294.00, 1, 2019, NULL, NULL, 14, NULL),
  (5, '190504072015', 0, 3, 3, 1, 0.00, 0.00, 3924.00, 1, 2019, NULL, NULL, 14, NULL),
  (6, '190504072015', 2, 0, 10, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (7, '190504072015', 2, 2, 1, 1, 0.00, 0.00, 2394.00, 1, 2019, NULL, NULL, 14, NULL),
  (8, '190504072015', 2, 2, 2, 1, 0.00, 0.00, 3294.00, 1, 2019, NULL, NULL, 14, NULL),
  (9, '190504072015', 2, 2, 3, 1, 0.00, 0.00, 3924.00, 1, 2019, NULL, NULL, 14, NULL),
  (10, '190504110319', 0, 0, 475, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (11, '190504110319', 0, 0, 362, 1, 0.00, 0.00, 9432.00, 1, 2019, NULL, NULL, 14, NULL),
  (12, '190504110324', 0, 0, 475, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (13, '190504110324', 0, 0, 362, 1, 0.00, 0.00, 9432.00, 1, 2019, NULL, NULL, 14, NULL),
  (14, '190508061755', 0, 1, 4, 1, 0.00, 0.00, 3942.00, 1, 2019, NULL, NULL, 14, NULL),
  (15, '190508061755', 0, 3, 1, 1, 0.00, 0.00, 2394.00, 1, 2019, NULL, NULL, 14, NULL),
  (16, '190508061755', 0, 3, 2, 1, 0.00, 0.00, 3294.00, 1, 2019, NULL, NULL, 14, NULL),
  (17, '190508061755', 0, 3, 3, 1, 0.00, 0.00, 3924.00, 1, 2019, NULL, NULL, 14, NULL),
  (18, '190508061826', 2, 0, 10, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (19, '190508061826', 2, 2, 1, 1, 0.00, 0.00, 2394.00, 1, 2019, NULL, NULL, 14, NULL),
  (20, '190508061826', 2, 2, 2, 1, 0.00, 0.00, 3294.00, 1, 2019, NULL, NULL, 14, NULL),
  (21, '190508061826', 2, 2, 3, 1, 0.00, 0.00, 3924.00, 1, 2019, NULL, NULL, 14, NULL),
  (22, '190508061858', 0, 0, 475, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (23, '190508061858', 0, 0, 176, 1, 0.00, 0.00, 4239.00, 1, 2019, NULL, NULL, 14, NULL),
  (24, '190508061858', 2, 0, 10, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (25, '190508061858', 2, 2, 1, 1, 0.00, 0.00, 2394.00, 1, 2019, NULL, NULL, 14, NULL),
  (26, '190508061858', 2, 2, 2, 1, 0.00, 0.00, 3294.00, 1, 2019, NULL, NULL, 14, NULL),
  (27, '190508061858', 2, 2, 3, 1, 0.00, 0.00, 3924.00, 1, 2019, NULL, NULL, 14, NULL),
  (28, '190508061858', 0, 2, 4, 1, 0.00, 0.00, 3942.00, 1, 2019, NULL, NULL, 14, NULL),
  (29, '190508061921', 0, 0, 475, 1, 0.00, 0.00, 4329.00, 1, 2019, NULL, NULL, 14, NULL),
  (30, '190508061921', 0, 0, 176, 1, 0.00, 0.00, 4239.00, 1, 2019, NULL, NULL, 14, NULL),
  (31, '190508061921', 0, 0, 362, 1, 0.00, 0.00, 9432.00, 1, 2019, NULL, NULL, 14, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `schedules`
  --
  
  CREATE TABLE `schedules` (
    `schedule_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `schedule_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `schedules`
  --
  
  INSERT INTO `schedules` (`schedule_id`, `user_id`, `schedule_date`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 21, 'Saturday', 2, NULL, '2019-02-19 22:01:44', 1, 1),
  (2, 21, 'Wednesday', 2, NULL, '2019-02-19 22:04:29', 1, 1),
  (3, 21, 'Tuesday', 2, NULL, '2019-02-21 17:14:54', 1, 1),
  (4, 21, 'Saturday', 1, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `schedule_blocks`
  --
  
  CREATE TABLE `schedule_blocks` (
    `schedule_block_id` int(10) UNSIGNED NOT NULL,
    `schedule_slot_id` int(10) UNSIGNED NOT NULL,
    `schedule_block_date` date NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `schedule_blocks`
  --
  
  INSERT INTO `schedule_blocks` (`schedule_block_id`, `schedule_slot_id`, `schedule_block_date`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 1, '2019-02-17', 1, '2019-02-19 21:33:56', '2019-02-19 21:33:56', 1, NULL),
  (2, 1, '2019-02-24', 1, '2019-02-19 21:34:07', '2019-02-19 21:34:07', 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `schedule_slots`
  --
  
  CREATE TABLE `schedule_slots` (
    `schedule_slot_id` int(10) UNSIGNED NOT NULL,
    `schedule_id` int(10) UNSIGNED NOT NULL,
    `start_time` time NOT NULL,
    `end_time` time NOT NULL,
    `visitor_limit` tinyint(4) NOT NULL DEFAULT '10',
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `schedule_slots`
  --
  
  INSERT INTO `schedule_slots` (`schedule_slot_id`, `schedule_id`, `start_time`, `end_time`, `visitor_limit`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 1, '14:30:00', '17:30:00', 7, 1, NULL, '2019-02-19 21:41:09', 21, NULL),
  (2, 2, '14:15:00', '18:15:00', 32, 1, NULL, NULL, 21, NULL),
  (3, 3, '09:15:00', '15:15:00', 1, 1, NULL, NULL, 21, NULL),
  (4, 4, '11:30:00', '11:30:00', 1, 1, NULL, NULL, 21, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_categories`
  --
  
  CREATE TABLE `service_categories` (
    `service_category_id` int(10) UNSIGNED NOT NULL,
    `service_category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_categories`
  --
  
  INSERT INTO `service_categories` (`service_category_id`, `service_category_name`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Hematology', 1, '2019-02-27 05:04:40', '2019-02-27 00:58:31', 0, 1),
  (2, 'Diabetes', 1, '2019-02-27 00:55:10', '2019-02-27 00:58:28', 1, 1),
  (3, 'Thalassemia', 1, '2019-02-27 00:57:02', '2019-02-27 00:58:32', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_groups`
  --
  
  CREATE TABLE `service_groups` (
    `service_group_id` int(10) UNSIGNED NOT NULL,
    `service_group_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `service_category_id` int(11) NOT NULL,
    `service_sub_category_id` int(11) NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_groups`
  --
  
  INSERT INTO `service_groups` (`service_group_id`, `service_group_name`, `service_category_id`, `service_sub_category_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Hematology Group', 1, 1, 1, NULL, NULL, 1, NULL),
  (2, 'Group 2', 1, 1, 1, NULL, NULL, 1, NULL),
  (3, 'Group 3', 1, 1, 1, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_group_items`
  --
  
  CREATE TABLE `service_group_items` (
    `service_group_item_id` int(10) UNSIGNED NOT NULL,
    `service_group_id` int(11) NOT NULL,
    `diagnostic_test_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_group_items`
  --
  
  INSERT INTO `service_group_items` (`service_group_item_id`, `service_group_id`, `diagnostic_test_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 1, 4, NULL, NULL, 1, NULL),
  (2, 2, 4, NULL, NULL, 1, NULL),
  (3, 3, 1, NULL, NULL, 1, NULL),
  (4, 3, 2, NULL, NULL, 1, NULL),
  (5, 3, 3, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_packages`
  --
  
  CREATE TABLE `service_packages` (
    `service_package_id` int(10) UNSIGNED NOT NULL,
    `service_package_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_packages`
  --
  
  INSERT INTO `service_packages` (`service_package_id`, `service_package_name`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'Packege 1', 1, NULL, NULL, 1, NULL),
  (2, 'Packege 2', 1, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_package_items`
  --
  
  CREATE TABLE `service_package_items` (
    `service_package_item_id` int(10) UNSIGNED NOT NULL,
    `service_package_id` int(11) NOT NULL,
    `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 = > Service, 2 => Service Group, 3 =. Service Package',
    `service_item_id` int(10) UNSIGNED NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_package_items`
  --
  
  INSERT INTO `service_package_items` (`service_package_item_id`, `service_package_id`, `type`, `service_item_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 1, 1, 10, 1, NULL, NULL, 1, NULL),
  (3, 1, 2, 3, 1, NULL, NULL, 1, NULL),
  (4, 2, 1, 9, 1, NULL, NULL, 1, NULL),
  (5, 2, 1, 10, 1, NULL, NULL, 1, NULL),
  (6, 2, 2, 3, 1, NULL, NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_sub_categories`
  --
  
  CREATE TABLE `service_sub_categories` (
    `service_sub_category_id` int(10) UNSIGNED NOT NULL,
    `service_sub_category_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `service_category_id` int(11) DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `service_sub_categories`
  --
  
  INSERT INTO `service_sub_categories` (`service_sub_category_id`, `service_sub_category_name`, `service_category_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (1, 'CBC', 1, 1, '2019-02-27 01:47:43', '2019-02-27 02:05:49', 1, 1),
  (2, 'HbA1c', 2, 1, '2019-02-27 01:49:41', '2019-02-27 02:05:47', 1, 1),
  (3, 'Hb Electroporesis', 3, 1, '2019-02-27 02:07:40', NULL, 1, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `branch_id` int(10) UNSIGNED NOT NULL,
    `full_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `father_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mother_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `profile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `present_address` text COLLATE utf8mb4_unicode_ci,
    `permanent_address` text COLLATE utf8mb4_unicode_ci,
    `mobile_no` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `gender` tinyint(4) NOT NULL DEFAULT '1',
    `dob` date DEFAULT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0=>Inactive,1=Active,2=Deleted',
    `user_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=>Employee,2=Doctor,3=Patient',
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED NOT NULL,
    `updated_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`user_id`, `branch_id`, `full_name`, `father_name`, `user_name`, `mother_name`, `profile_image`, `present_address`, `permanent_address`, `mobile_no`, `gender`, `dob`, `email`, `email_verified_at`, `password`, `status`, `user_type`, `remember_token`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
  (14, 1, 'Azim Uddin', 'Father', 'azim_uddin', 'Mother', '14-20190214012322870E.jpg', 'Dhaka\r\nDhaka', 'Dhaka\r\nDhaka', '0181100000001', 1, '2019-02-06', 'azim@gmail.com', NULL, '$2y$10$9nylqXgGVU8kM3.OKczXXeaqWyjB76jpIGeGMMk6Ca.DixkOmv60y', 1, 1, 'JdPh5xn0aK7HC7UlX9OXBe76GWZWMvV0N1OQfcus', NULL, '2019-02-26 21:36:00', 1, 1),
  (15, 1, 'Taki Ahmad', 'Father', 'taki_ahmad', 'Mother', '15-20190214012347E9A1.jpg', 'Dhaka\r\nDhaka', 'Dhaka\r\nDhaka', '0181100000002', 1, '2019-02-06', 'taki@gmail.com', NULL, '$2y$10$2DnsD9kGqJfY39uwgHQfdefcFKNdQdg20tcAQ16KQPvo0jMHRXKkO', 1, 1, 'JdPh5xn0aK7HC7UlX9OXBe76GWZWMvV0N1OQfcus', NULL, '2019-02-26 21:35:53', 1, 1),
  (19, 1, 'Mr. X aa', 'Father', 'mr_x', 'Mother', '19-20190214012132D9D9.jpg', 'Dhaka\r\nDhaka', 'Dhaka\r\nDhaka', '01245789124', 1, '2019-02-12', 'mrx@gmail.com', NULL, '$2y$10$5FpKqMVQ0aetcT1avELfB.vr2MLoet28VA0l8gr5PXnwpCfNTOa72', 2, 1, 'JdPh5xn0aK7HC7UlX9OXBe76GWZWMvV0N1OQfcus', NULL, '2019-02-19 22:00:15', 1, 1),
  (21, 1, 'Doctor', 'Father', 'doctor', 'Mother', '21-201902081149366A8B.jpg', NULL, NULL, '01717649922', 1, '2019-02-20', 'buzzard351@gmail.com', NULL, '$2y$10$Wx.zY08/2l0u2if4xQIN4ul3Wv4ARIQnzv/Pf.jjATpyqVpEW7mHS', 1, 1, 'fkZ7QFSpcEbXvzaRdyE2UchBq0DHBc5GCw7tDMsG', NULL, '2019-02-08 22:27:02', 1, 1),
  (22, 1, 'asd', 'asd', 'asd', 'asd', '22-20190214012445CB67.jpg', 'asd', 'asd', '23423', 2, '2019-02-21', 'asd@asd.asd', NULL, '$2y$10$55LKB55Yq7bYLjg0dbu.1eBkPphmD8PhH/cMQwS6Mrt9OtgBZOyqq', 0, 1, 'Cw40sHWq2I5WFXOqmY0fnJDa3lBRlnmQ3PMIjQCM', NULL, '2019-02-26 23:27:04', 1, 1),
  (24, 1, 'Mr Patient X', 'Father', 'patient_x', 'Mother', '24-201904291059447AE8.jpg', NULL, NULL, '11548754657', 1, '2019-05-09', 'patientx@gmail.com', NULL, '$2y$10$Isfx9DBPaNQVKtOk/C4Wau6BWd0GORATmpJBf3wIX/h3QQ0Lt68bC', 1, 1, 'ontsSV848qxt2TZqNyUXajTcpe7iaudMf3GUVbhK', NULL, '2019-04-28 22:59:44', 1, 1),
  (25, 1, 'Mr Patient Y', 'Father', 'patient_y', 'Mother', '25-201904291101475AF4.jpg', NULL, NULL, '115487544785', 1, '2018-05-16', 'patienty@gmail.com', NULL, '$2y$10$xIuIn5NszgZwcFzJ0nTnD.lRfW7d5SQcjhuaXA1JTLhUHFT9fSdVi', 1, 1, 'ontsSV848qxt2TZqNyUXajTcpe7iaudMf3GUVbhK', NULL, '2019-04-28 23:01:47', 1, 1),
  (26, 1, 'Masud parbhez', 'frsh', 'ewemasud.affb@gmail.com', 'erty', NULL, NULL, NULL, '3456', 2, '2019-05-31', 'masueeretd.affb@gmail.com', NULL, '$2y$10$t9rrlu6fNpzvLnmDctgGZ.W2xK2BhHETleZ3txVjBLdJjvO0F7a3.', 1, 1, 'sTsFQCYO0mM9w76WNA8j9XB6uc4UsQ94ogAP9x2t', NULL, NULL, 1, NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `departments`
  --
  ALTER TABLE `departments`
    ADD PRIMARY KEY (`department_id`);
  
  --
  -- Indexes for table `designations`
  --
  ALTER TABLE `designations`
    ADD PRIMARY KEY (`designation_id`);
  
  --
  -- Indexes for table `diagnostic_tests`
  --
  ALTER TABLE `diagnostic_tests`
    ADD PRIMARY KEY (`diagnostic_test_id`),
    ADD UNIQUE KEY `diagnostic_tests_diagnostic_test_name_unique` (`diagnostic_test_name`);
  
  --
  -- Indexes for table `doctors`
  --
  ALTER TABLE `doctors`
    ADD PRIMARY KEY (`doctor_id`);
  
  --
  -- Indexes for table `educational_qualifications`
  --
  ALTER TABLE `educational_qualifications`
    ADD PRIMARY KEY (`educational_qualification_id`);
  
  --
  -- Indexes for table `employee_infos`
  --
  ALTER TABLE `employee_infos`
    ADD PRIMARY KEY (`employee_id`);
  
  --
  -- Indexes for table `medical_degrees`
  --
  ALTER TABLE `medical_degrees`
    ADD PRIMARY KEY (`medical_degree_id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `patients`
  --
  ALTER TABLE `patients`
    ADD PRIMARY KEY (`patient_id`);
  
  --
  -- Indexes for table `salary_infos`
  --
  ALTER TABLE `salary_infos`
    ADD PRIMARY KEY (`salary_id`);
  
  --
  -- Indexes for table `sale_invoices`
  --
  ALTER TABLE `sale_invoices`
    ADD PRIMARY KEY (`sale_id`),
    ADD KEY `sale_invoices_sale_invoice_id_index` (`sale_invoice_id`);
  
  --
  -- Indexes for table `sale_invoice_details`
  --
  ALTER TABLE `sale_invoice_details`
    ADD PRIMARY KEY (`sale_details_id`),
    ADD KEY `sale_invoice_details_sale_details_id_index` (`sale_details_id`),
    ADD KEY `sale_invoice_details_sale_invoice_id_index` (`sale_invoice_id`);
  
  --
  -- Indexes for table `schedules`
  --
  ALTER TABLE `schedules`
    ADD PRIMARY KEY (`schedule_id`);
  
  --
  -- Indexes for table `schedule_blocks`
  --
  ALTER TABLE `schedule_blocks`
    ADD PRIMARY KEY (`schedule_block_id`);
  
  --
  -- Indexes for table `schedule_slots`
  --
  ALTER TABLE `schedule_slots`
    ADD PRIMARY KEY (`schedule_slot_id`);
  
  --
  -- Indexes for table `service_categories`
  --
  ALTER TABLE `service_categories`
    ADD PRIMARY KEY (`service_category_id`);
  
  --
  -- Indexes for table `service_groups`
  --
  ALTER TABLE `service_groups`
    ADD PRIMARY KEY (`service_group_id`);
  
  --
  -- Indexes for table `service_group_items`
  --
  ALTER TABLE `service_group_items`
    ADD PRIMARY KEY (`service_group_item_id`);
  
  --
  -- Indexes for table `service_packages`
  --
  ALTER TABLE `service_packages`
    ADD PRIMARY KEY (`service_package_id`);
  
  --
  -- Indexes for table `service_package_items`
  --
  ALTER TABLE `service_package_items`
    ADD PRIMARY KEY (`service_package_item_id`);
  
  --
  -- Indexes for table `service_sub_categories`
  --
  ALTER TABLE `service_sub_categories`
    ADD PRIMARY KEY (`service_sub_category_id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`user_id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `departments`
  --
  ALTER TABLE `departments`
    MODIFY `department_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `designations`
  --
  ALTER TABLE `designations`
    MODIFY `designation_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `diagnostic_tests`
  --
  ALTER TABLE `diagnostic_tests`
    MODIFY `diagnostic_test_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=501;
  
  --
  -- AUTO_INCREMENT for table `doctors`
  --
  ALTER TABLE `doctors`
    MODIFY `doctor_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `educational_qualifications`
  --
  ALTER TABLE `educational_qualifications`
    MODIFY `educational_qualification_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `employee_infos`
  --
  ALTER TABLE `employee_infos`
    MODIFY `employee_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `medical_degrees`
  --
  ALTER TABLE `medical_degrees`
    MODIFY `medical_degree_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
  
  --
  -- AUTO_INCREMENT for table `patients`
  --
  ALTER TABLE `patients`
    MODIFY `patient_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `salary_infos`
  --
  ALTER TABLE `salary_infos`
    MODIFY `salary_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `sale_invoices`
  --
  ALTER TABLE `sale_invoices`
    MODIFY `sale_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `sale_invoice_details`
  --
  ALTER TABLE `sale_invoice_details`
    MODIFY `sale_details_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
  
  --
  -- AUTO_INCREMENT for table `schedules`
  --
  ALTER TABLE `schedules`
    MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `schedule_blocks`
  --
  ALTER TABLE `schedule_blocks`
    MODIFY `schedule_block_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `schedule_slots`
  --
  ALTER TABLE `schedule_slots`
    MODIFY `schedule_slot_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `service_categories`
  --
  ALTER TABLE `service_categories`
    MODIFY `service_category_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `service_groups`
  --
  ALTER TABLE `service_groups`
    MODIFY `service_group_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `service_group_items`
  --
  ALTER TABLE `service_group_items`
    MODIFY `service_group_item_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `service_packages`
  --
  ALTER TABLE `service_packages`
    MODIFY `service_package_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `service_package_items`
  --
  ALTER TABLE `service_package_items`
    MODIFY `service_package_item_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `service_sub_categories`
  --
  ALTER TABLE `service_sub_categories`
    MODIFY `service_sub_category_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  