-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 11, 2023 at 06:22 AM
-- Server version: 5.7.43
-- PHP Version: 8.1.16
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `retrocubedev_welcare_diagnostics_qa`
--
-- --------------------------------------------------------
--
-- Table structure for table `application_setting`
--
CREATE TABLE `application_setting` (
`id` bigint(20) UNSIGNED NOT NULL,
`identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_file` tinyint(4) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `application_setting`
--
INSERT INTO `application_setting` (`id`, `identifier`, `meta_key`, `value`, `is_file`, `created_at`, `updated_at`, `deleted_at`) VALUES
(5, 'application_setting', 'logo', 'application_setting/9SyHqlhdPw5qttbhEKdMu7xC0IOInuesU2xM9W8M.png', 1, '2023-06-26 13:49:15', NULL, NULL),
(7, 'application_setting', 'application_name', 'Welcare Diagnostics', 0, '2023-07-04 10:20:51', NULL, NULL),
(8, 'application_setting', 'favicon', 'application_setting/0byhZbsKjZ5z9zcIQlHBCkT4t7tfM2UKCbFtk7CN.png', 1, '2023-07-04 10:20:51', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `booking`
--
CREATE TABLE `booking` (
`id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`booking_date` date NOT NULL,
`booking_time` time NOT NULL,
`insurance_provider_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`insurance_plan_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`member_id_no` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`group_no` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`effective_date` date DEFAULT NULL,
`expiration_date` date DEFAULT NULL,
`additional_info` text COLLATE utf8mb4_unicode_ci,
`checkin` datetime DEFAULT NULL,
`checkout` datetime DEFAULT NULL,
`booking_status` enum('pending','scheduled','completed','cancelled','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'scheduled',
`reason` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `booking_detail`
--
CREATE TABLE `booking_detail` (
`id` bigint(20) UNSIGNED NOT NULL,
`booking_id` bigint(20) UNSIGNED NOT NULL,
`service_id` bigint(20) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `booking_status_logs`
--
CREATE TABLE `booking_status_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`booking_id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`booking_status` enum('pending','scheduled','completed','cancelled','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `careers`
--
CREATE TABLE `careers` (
`id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`position_interest_in` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`job_start_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`cover_letter` text COLLATE utf8mb4_unicode_ci NOT NULL,
`file` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cms_modules`
--
CREATE TABLE `cms_modules` (
`id` bigint(20) UNSIGNED NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`route_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fa fa-list',
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`sort_order` decimal(5,2) NOT NULL DEFAULT '0.00',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `cms_modules`
--
INSERT INTO `cms_modules` (`id`, `parent_id`, `name`, `route_name`, `icon`, `status`, `sort_order`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 0, 'Cms Roles Management', 'cms-roles-management.index', 'fa fa-key', '1', 1.00, '2023-06-26 13:20:53', NULL, NULL),
(2, 0, 'Cms Users Management', 'cms-users-management.index', 'fa fa-users', '1', 2.00, '2023-06-26 13:20:53', NULL, NULL),
(3, 0, 'Lab Consultant', 'lab-consultant.index', 'fa fa-eyedropper', '1', 3.00, '2023-06-26 13:20:53', NULL, NULL),
(4, 0, 'Patient Management', 'app-users.index', 'fa fa-users', '1', 4.00, '2023-06-26 13:20:53', NULL, NULL),
(5, 0, 'Services', 'services.index', 'fa fa-plus-square-o', '1', 5.00, '2023-06-26 13:20:53', NULL, NULL),
(6, 0, 'Booking Management', 'booking-pending.index', 'fa fa-calendar', '1', 6.00, '2023-06-26 13:20:53', NULL, NULL),
(7, 6, 'Pending Booking', 'booking-pending.index', 'fa fa-calendar', '1', 6.10, '2023-06-26 13:20:53', NULL, NULL),
(8, 6, 'Schedule Booking', 'booking-schedule.index', 'fa fa-calendar', '1', 6.20, '2023-06-26 13:20:53', NULL, NULL),
(9, 6, 'Completed Booking', 'booking-completed.index', 'fa fa-calendar', '1', 6.30, '2023-06-26 13:20:53', NULL, NULL),
(10, 6, 'Cancelled Booking', 'booking-cancelled.index', 'fa fa-calendar', '1', 6.40, '2023-06-26 13:20:53', NULL, NULL),
(11, 0, 'Application Setting', 'admin.application-setting', 'fa fa-cog', '1', 7.00, '2023-06-26 13:20:53', NULL, NULL),
(12, 0, 'Content Management', 'content-management.index', 'fa fa-tasks', '1', 8.00, '2023-06-26 13:20:53', NULL, NULL),
(13, 0, 'FAQ`s', 'faq.index', 'fa fa-question-circle-o', '1', 9.00, '2023-06-26 13:20:53', NULL, NULL),
(14, 6, 'Rejected Booking', 'booking-rejected.index', 'fa fa-calendar', '1', 6.50, '2023-07-04 13:44:08', NULL, NULL),
(15, 0, 'Push Notification', 'push-notification.index', 'fa fa-bell', '1', 10.00, '2023-07-04 13:44:08', NULL, NULL),
(16, 0, 'Diagnostic Services', 'diagnostic_services.index', 'fa fa-list', '1', 11.00, '2023-07-04 13:37:12', NULL, NULL),
(17, 0, 'Specialities', 'speciality.index', 'fa fa-heartbeat', '1', 12.00, '2023-07-04 13:37:12', NULL, NULL),
(18, 0, 'Contact Us', 'contact-us.index', 'fa fa-phone', '1', 13.00, '2023-07-04 13:37:12', NULL, NULL),
(19, 0, 'Test Directory', 'test-directory.index', 'fa fa-folder', '1', 14.00, '2023-07-04 13:37:12', NULL, NULL),
(20, 0, 'Careers', 'career.index', 'fa fa-graduation-cap', '1', 15.00, '2023-07-04 13:37:12', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cms_module_permissions`
--
CREATE TABLE `cms_module_permissions` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`user_group_id` bigint(20) UNSIGNED NOT NULL,
`cms_module_id` bigint(20) UNSIGNED NOT NULL,
`is_add` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`is_view` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`is_update` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`is_delete` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `cms_module_permissions`
--
INSERT INTO `cms_module_permissions` (`id`, `user_id`, `user_group_id`, `cms_module_id`, `is_add`, `is_view`, `is_update`, `is_delete`, `created_at`, `updated_at`, `deleted_at`) VALUES
(58, 1, 2, 1, '0', '0', '0', '0', '2023-09-07 15:13:57', NULL, NULL),
(59, 1, 2, 2, '0', '0', '0', '0', '2023-09-07 15:13:57', NULL, NULL),
(60, 1, 2, 3, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(61, 1, 2, 4, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(62, 1, 2, 5, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(63, 1, 2, 7, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(64, 1, 2, 8, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(65, 1, 2, 9, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(66, 1, 2, 10, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(67, 1, 2, 14, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(68, 1, 2, 11, '0', '0', '0', '0', '2023-09-07 15:13:57', NULL, NULL),
(69, 1, 2, 12, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(70, 1, 2, 13, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(71, 1, 2, 15, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(72, 1, 2, 16, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(73, 1, 2, 17, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(74, 1, 2, 18, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(75, 1, 2, 19, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL),
(76, 1, 2, 20, '1', '1', '1', '1', '2023-09-07 15:13:57', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cms_widgets`
--
CREATE TABLE `cms_widgets` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icon` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`color` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`div_column_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`link` text COLLATE utf8mb4_unicode_ci NOT NULL,
`widget_type` enum('small_box','line_chart','bar_chat','pie_chart','map_chart') COLLATE utf8mb4_unicode_ci NOT NULL,
`sql` text COLLATE utf8mb4_unicode_ci NOT NULL,
`config` text COLLATE utf8mb4_unicode_ci,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `cms_widgets`
--
INSERT INTO `cms_widgets` (`id`, `title`, `slug`, `description`, `icon`, `color`, `div_column_class`, `link`, `widget_type`, `sql`, `config`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Total Patient', '168777125364995875a938d', NULL, 'fa fa-users', '#4b71fa', 'col-md-3', '/admin/app-users', 'small_box', 'Select count(*) from users where user_group_id = 3 limit 1', NULL, '1', NULL, NULL, NULL),
(2, 'Total Physician', '168777125364995875a9391', NULL, 'icon-people', '#7bcb4d', 'col-md-3', '/admin/lab-consultant', 'small_box', 'Select count(*) from users where user_group_id = 4 limit 1', NULL, '1', NULL, NULL, NULL),
(3, 'Total Service', '168777125364995875a9392', NULL, 'fa fa-plus-square-o', '#4b71fa', 'col-md-3', '/admin/services', 'small_box', 'Select count(*) from services limit 1', NULL, '1', NULL, NULL, NULL),
(4, 'Total Booking', '168777125364995875a9393', NULL, 'fa fa-calendar', '#7bcb4d ', 'col-md-3', '/admin/booking', 'small_box', 'Select count(*) from booking limit 1', NULL, '1', NULL, NULL, NULL),
(5, 'Users', '168777125364995875a9394', NULL, 'icon-user', '#fff', 'col-md-12', '/admin/app-users', 'line_chart', 'SELECT count(id) AS value, MONTHNAME(created_at) as label FROM users where YEAR(created_at) = YEAR(now()) group by MONTH(created_at) order by MONTH(created_at) asc', NULL, '1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cms_widget_role`
--
CREATE TABLE `cms_widget_role` (
`id` bigint(20) UNSIGNED NOT NULL,
`cms_widget_id` bigint(20) UNSIGNED NOT NULL,
`user_group_id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contact_us`
--
CREATE TABLE `contact_us` (
`id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`help` text COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`mobile_no` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`speciality` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `contact_us`
--
INSERT INTO `contact_us` (`id`, `slug`, `help`, `first_name`, `last_name`, `email`, `mobile_no`, `message`, `speciality`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'obekAJJIzSi3s6HnEkW8BGdiIq6Mq3lB2t5zSx3r6516d2df29dd5', 'Customer', 'Mari', 'sadasd', 'qegenutur@mailinator.com', '+1-4774649876', 'Repellendus Facere', 'Laboratory', '2023-09-29 17:36:31', '2023-09-29 17:36:31', NULL),
(2, 'MhK8fpGxhPBDe3trCvXf9nXWZt2qRtfUzyie9PZZ651aaad5c7daf', 'Physician', 'Sharon', 'Nicholson', 'xazy@mailinator.com', '+1-5618276542', 'Ullam anim laboriosa', 'Physician', '2023-10-02 15:34:45', '2023-10-02 15:34:45', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `content_management`
--
CREATE TABLE `content_management` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `content_management`
--
INSERT INTO `content_management` (`id`, `title`, `slug`, `content`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Terms Condition', 'terms_condition', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', '1', '2020-02-11 20:01:25', NULL, NULL),
(2, 'Privacy Policy', 'privacy_policy', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', '1', '2020-02-11 20:01:25', NULL, NULL),
(3, 'About Us', 'about_us', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', '1', '2020-02-11 20:01:25', NULL, NULL),
(4, 'Home Page Section 1', 'home_section_1', '
\r\n
\r\n The secret of success is AAA service:\r\n Affordable, Accurate and Accessible\r\n Clinical Laboratory Services\r\n
\r\n
\r\n Who we are?\r\n
\r\n
\r\n WelCare Diagnostics is a clinical\r\n laboratory that provide full range\r\n services to our clients. We are located\r\n in South Jersey and we are accredited by\r\n State of NJ, COLA and CLIA.\r\n
\r\n Welcome{\" \"}\r\n \r\n to the WELCARE DIAGNOSTICS Payment Page\r\n (the \"Page\").\r\n {\" \"}\r\n This Page is provided to welcare diagnostics\r\n patients to provide an easy mechanism to pay\r\n your invoice amounts.\r\n
\r\n
\r\n WELCARE DIGANOSTICS accepts payment via\r\n credit card/debit card–Via, Master Card,\r\n Visa, Discover American Express. Payments\r\n are collected by WELCARE DIAGNOSTICS\r\n directly. Please read these terms and\r\n conditions carefully before using this Page.\r\n By accessing or using the Page, you (the\r\n “User”) agree to be bound by these terms and\r\n conditions and understand that you will be\r\n asked to submit appropriate personal and\r\n financial information to welcare diagnostics\r\n so that the online payment can be processed.\r\n The provision of the online payment service\r\n by the owners and operators of WELCARE\r\n DIAGNOSTICS is subject to your agreement to\r\n the terms and conditions below.\r\n
\r\n
\r\n 1. Authorization of Payments By entering\r\n your credit card information, (i) you\r\n acknowledge that you are an authorized user\r\n of the credit card and that the associated\r\n info information entered (account holder\r\n name, account number, billing address, etc.)\r\n is accurate, and (ii) you authorize WELCARE\r\n DIAGNOSTICS to charge the amount you have\r\n requested to your credit card. Payment is\r\n not complete until you click the \"submit\"\r\n button. WELARE DIAGNOSTICS will send an\r\n electronic acknowledgement to out that the\r\n transaction has occurred. If you have opted\r\n out of receiving electronic communications,\r\n you will receive a formal receipt from\r\n WELCARE DIAGNOSTICS in the mail. It may take\r\n up to THREE business days to process a\r\n payment. WELCARE DIAGNOSTICS shall not be\r\n liable for any payments that. Are not\r\n properly processed. Due to you quoting\r\n incorrect personal details or due to your\r\n Credit/debit card supplier refusing or\r\n declining payment. For each transaction, in\r\n addition to the charge you have authorized,\r\n your credit card issuer and network may\r\n assess their customary transaction or\r\n handling charge, if any. If a charge is\r\n declined or reversed by the credit card\r\n issuer or network, you agree to pay a\r\n service charge and to reimburse all\r\n reasonable costs of collection. User ‘credit\r\n card issuer may also assess its customary\r\n charge for such transactions.\r\n
\r\n
\r\n 2. Information Security By agreeing to these\r\n terms and conditions, accept and consent to\r\n your personal data being provided to WELCARE\r\n DIAGNOSTICS for the sole purpose of offering\r\n and administering online payment. WELCARE\r\n DIAGNOSTICS respects the privacy of every\r\n individual who visits our site and the\r\n WELCARE DIAGNOSTICS website contains\r\n security measures which are in place to\r\n protect the loss, misuse, and alteration of\r\n the information under our control.\r\n Communications to and from the WELCARE\r\n DIAGNOSTICs are encrypted. WELCARE\r\n DIAGNOSTICS discloses only the last four\r\n digits of a user’s credit card numbers when\r\n confirming an order\r\n
\r\n
\r\n WELCARE DIAGNOSTIC uses a third-party\r\n payment site and we do not store any\r\n information on our systems.\r\n
\r\n
\r\n WELCARE DIAGNOSTICS will treat all health\r\n related information submitted by you as\r\n confidential information in accordance with\r\n WELCARE DIAGNOSTICS ‘S Privacy Policy and\r\n applicable federal and state laws. The\r\n purpose of our privacy policy is to identify\r\n the information we collect online, the steps\r\n we take to protect.\r\n
\r\n
\r\n 3. Right to Change Terms and Conditions\r\n WELCARE DIAGNOSTICS may, at any time and\r\n from time-to-time, change the terms and\r\n conditions described herein. Any changes to\r\n these terms and conditions will be effective\r\n immediately upon posting of the changed\r\n terms and conditions on the Page. Upon each\r\n submission of an online payment, you will be\r\n prompted to accept the terms and conditions\r\n as changed, and your continued use following\r\n any such change constitutes your agreement\r\n to be bound by such terms and conditions.\r\n
\r\n
\r\n 4. Termination The terms and conditions\r\n described herein are effective unless and\r\n until modified as noted above, or\r\n terminated, at any time, by WELCARE\r\n DIAGNOSTICS, if determines, in its sole\r\n discretion, that you have failed to comply\r\n with these terms and conditions, reserves\r\n the right terminate these terms and\r\n conditions without notice and deny you\r\n access to the Page. YOU AGREE THAT ALL\r\n DISPUTES BETWEEN YOU AND US (WHETHER OR NOT\r\n SUCH DISPUTE INVOLVES A THIRD PARTY) WITH\r\n REGARD TO YOUR ELATIONSHIP WITH US, YOUR USE\r\n OF THE PLATFORM, INCLUDING WITHOUT\r\n LIMITATION DISPUTES RELATED TO TERMS.\r\n
\r\n
\r\n Neither you nor we will participate in a\r\n class action or class wide arbitration for\r\n any claims covered by this agreement. YOU\r\n ARE GIVING UP YOUR RIGHT TO PARTICIPATE AS A\r\n CLASS REPRESENTATIVE OR CLASS MEMBER ON ANY\r\n CLASS CLAIM YOU MAY HAVE AGAINST US\r\n INCLUDING ANY RIGHT TO CLASS ARBITRATION OR\r\n ANY CONSOLIDATION OF INDIVIDUAL\r\n ARBITRATIONS.\r\n
\r\n
\r\n \r\n Important security note :\r\n \r\n never transmit credit card information by\r\n email.\r\n
\r\n This Privacy Policy (“Privacy Policy”) describes the\r\n types information WELCARE DIAGNOSTICS (“we,” “our,” or\r\n “us”) may collect from you or that you may provide when\r\n you visit the website located WELCAREDX.COM. This\r\n Privacy Policy is incorporated into our Terms &\r\n Conditions User Agreement (referred to as the\r\n “Agreement”), as appropriate. All capitalized terms used\r\n in this Privacy Policy, but not defined herein, have the\r\n meanings assigned to them in the Agreement. This Privacy\r\n Policy applies information collected through our website\r\n and/or Apps and does not apply to information collected\r\n by us offline or through any other means, including on\r\n any other website operated by WELCARE DIAGNOSTICS any\r\n third party, including through any application or\r\n content (including advertising) that may link to or be\r\n accessible from on the Website or Apps, which are\r\n governed by their own privacy policies. Please read this\r\n Privacy Policy carefully. By accessing or using the\r\n Website and Apps, you accept the practices and policies\r\n outlined in this Privacy Policy and you hereby consent\r\n that we will collect, use, and disclose your information\r\n as set forth in this Privacy Policy. If any term in this\r\n Privacy Policy is unacceptable to you, please do not use\r\n the Website download, install, or otherwise use heapsort\r\n to provide any personal information. This Privacy Policy\r\n may change from time to time (see Revisions to Our\r\n Privacy Policy) and your use of the Website and Apps\r\n after we make changes is deemed to be acceptance of\r\n those changes, so please check the policy periodically\r\n for updates. INFORMATION WE COLLECT ABOUT YOU AND HOW WE\r\n COLLECT - We collect several types of information from\r\n and about users of our Website and Apps, including.\r\n Information by which you may be personally identified,\r\n such about your-mail address, telephone number, country,\r\n or any other information collection on the Website or\r\n Apps that is defined as personal data or personally\r\n identifiable information under an applicable law\r\n (“personal information”);•that is about you, but\r\n individually does not identify you, such as whether you\r\n are a current user, product/service interests, or\r\n information related to your inquiry or request;•about\r\n your internet connection, the equipment you use to\r\n access our Website or Apps, Including your web browser,\r\n operating system, device unique identifier and usage\r\n details; and/or about your medical condition, treatment\r\n options, physician or other provider referrals,\r\n prescriptions, and lab results, including protected\r\n health information (“PHI”) or other related health\r\n information. Information collected automatically may\r\n include usage details, IP addresses, and information\r\n collected through cookies, web beacons, and other\r\n tracking technologies. From third parties’\r\n intermediaries, for example, the physicians, providers,\r\n and pharmacies with whom we partner to provide you with\r\n services. Information You Give to Us. The information we\r\n collect on or through our website or Apps may include:\r\n •Information that you provide on our website or Apps.\r\n This includes information provided when you sign up for\r\n our Services; when we process or respond to your\r\n inquiries related to requests for treatment, payment,\r\n customer service; and when you provide feedback on our\r\n website or Apps. Your responses to questions that we\r\n might ask you to complete for research purposes.\r\n •Details of transactions you carry out through our\r\n Website and Apps and of the fulfillment of your\r\n inquiries or requests. Your search queries on the\r\n Website. Information We Collect About You. As with many\r\n other Website and mobile applications, as you navigate\r\n through and interact with our Website or Apps, we may\r\n use automatic data collection technologies to collect\r\n certain information about your equipment, browsing\r\n actions, and patterns, including:•Details of your visits\r\n to our Website or Apps, including traffic data, location\r\n data, logs, language, date and time of access,\r\n frequency, and other communication data and the\r\n resources that you access and use on the Website or\r\n Apps. Information about your computer and internet\r\n connection, including your IP address, operating system,\r\n host domain, and browser type. Details of referring\r\n Website (URL). We also may use these technologies to\r\n collect information about your online activities over\r\n time and across third-party Website or other online\r\n services (behavioral tracking). The information we\r\n collect automatically is statistical data and may\r\n include personal information, or we may maintain it or\r\n associate it with personal information you provide to us\r\n or that we collect in other ways or receive from third\r\n parties. It helps us to improve our website or Apps and\r\n to deliver a better and more personalized service,\r\n including by enabling us to: Estimate our audience size\r\n and usage patterns. Store information about your\r\n preferences, allowing us to customize our website or\r\n Apps according to your individual interests. Speed up\r\n your searches Recognize you when you return to our\r\n website or Apps. Cookies Used on the Website. Our\r\n Website and Apps use two types of cookies:\r\n single-session (temporary) and multi-session\r\n (persistent). Temporary cookies last only as long as\r\n your web browser is open and are used for technical\r\n purposes such as enabling better navigation through our\r\n website or Apps. Once you close your browser, the cookie\r\n disappears. Persistent cookies are stored on your\r\n computer for longer periods and are used for purposes\r\n including tracking the number of unique visitors to our\r\n Web and information such as the number of views a page\r\n gets, how much time a user spends on a page, and other\r\n pertinent web statistics. We may not respond to ‘do not\r\n track’ signals in your browser. We may also collect data\r\n by using “pixel tags,” “web beacons,” “clear GIFs,” or\r\n similar means (collectively, “pixel tags”) that allow us\r\n to know when you visit our website or Apps. Through\r\n pixel tags, we obtain non-personal information or\r\n aggregate information that can be used to enhance your\r\n online experience and understand traffic patterns.\r\n Information We Receive from Other Sources. This\r\n information we receive about you if you use any of the\r\n other website we operate or the other Services we\r\n provide. We are working closely with third parties\r\n (including, for example, third parties intermediaries,\r\n such as the physicians, medical professionals, and\r\n pharmacies with whom we partner to provide you with\r\n services, sub-contractors in technical, advertising\r\n networks, analytics providers, and search information\r\n providers).HOW WE USE YOUR Information in connection\r\n with providing you with the Website, Apps, and Services,\r\n we may use, compile, analyze, and save your information\r\n in the following ways: To carry out the Services and, as\r\n applicable, facilitate the provision of health care\r\n services to you by physicians or other health care\r\n providers and ensure that the physicians or healthcare\r\n providers have the services and support necessary for\r\n health care operations. To communicate with you about\r\n the Website, Apps, and Services, or your use of the\r\n Website, Apps, and Services, and send you communications\r\n on behalf of physicians or other health care providers\r\n utilizing the Services to meet your needs. To provide\r\n you with information that you have requested or to\r\n respond to your inquiries. To provide you with technical\r\n support and to improve our Website, Apps, and Services.\r\n To verify your identity and administer your account,\r\n including processing your payments and fulfilling your\r\n orders. In order to ensure that content from our Website\r\n and Apps is presented in the most effective manner for\r\n you on your computer or mobile phone, to allow you to\r\n participate in interactive features of our Services\r\n (when you choose to do so), and as part of our efforts\r\n to keep our Website and Apps safe and secure. To\r\n communicate with you about our products and Services and\r\n those of our subsidiaries, affiliates, and parent\r\n companies and any of their related businesses and those\r\n of our thirdparty partners. To measure or understand the\r\n effectiveness of advertising we serve you and others,\r\n and to deliver relevant advertising to you. In the event\r\n of a sale, merger, consolidation, change in control,\r\n transfer of substantial assets, reorganization, or\r\n liquidation, we may transfer, sell, or assign to third\r\n parties information concerning your relationship with\r\n us, including, without limitation, personal information\r\n that you provide and other information concerning your\r\n relationship with us. To notify you about changes to our\r\n Website, Apps, or Services. For any purpose where you\r\n have given your consent). To comply with applicable\r\n federal and state law. Information We Receive from Other\r\n Sources. We will combine information we receive from\r\n other sources with information you give to us and\r\n information we collect about you.\r\n
\r\n
\r\n We will use this information and the combined\r\n information for the purposes set out above (depending on\r\n the types of information we receive).481051818918, v.\r\n 3DISCLOSURE OF YOUR Information We may disclose\r\n aggregated, deidentified information about our users,\r\n and information that does not identify any individual,\r\n without restriction. We may disclose your personal\r\n information to third parties in connection with the\r\n provision of our Services or as otherwise permitted or\r\n required by law. You agree that we have the right to\r\n disclose personal information that we collect, or you\r\n provide as described in this Privacy Policy, including\r\n Pursuant to your written instructions to any member of\r\n our group, which means our subsidiaries and affiliates,\r\n including our ultimate holding company and its\r\n subsidiaries. To health care providers (i) to provide\r\n health care services as part of the Services, such as\r\n providing your physician with your laboratory test\r\n results(ii) to whom you send messages through our\r\n Services, treatment, payment, or health care operations\r\n purposes, including pharmacy services, upon your\r\n request. To health care organizations, pharmacies,\r\n contractors, service providers, and other third parties\r\n we use to support our business or in connection with the\r\n administration and support of the Services. To our\r\n third-party service providers that provide services such\r\n as the hosting of our website or Apps, data analysis, IT\r\n services and infrastructure, customer service, e-mail\r\n delivery, auditing, and other similar services. To\r\n comply with any court order, law, legal process,\r\n including responding to any government or regulatory\r\n request, and to any third parties we believe necessary\r\n or appropriate to comply with applicable laws. To a\r\n buyer or other successor in the event of a merger,\r\n divestiture, restructuring, reorganization, dissolution,\r\n or other sale or transfer of some or all WELCARE\r\n DIAGNOTICS assets, whether as a going concern or as part\r\n of bankruptcy, liquidation, or similar proceeding, in\r\n which personal information held by WELCARE DIAGNOTICS\r\n about our website or App users is among the assets\r\n transferred. To fulfill the purpose for which you\r\n provide it. For example, if you email us asking us to\r\n contact a third party (including a medical\r\n professional), we may transmit the contents of your\r\n email to the recipient. For any other purpose disclosed\r\n by us when you provide the information or with your\r\n consent. If we are under a duty to disclose or share\r\n your personal information to comply with any legal\r\n obligation, or to enforce or apply our Agreement and\r\n other Agreement, including for billing and collection\r\n purposes; or to protect the rights, property, or safety\r\n of WELCARE DIAGNOTICS, our customers, or others. This\r\n may include exchanging information with other companies\r\n and organizations for the purposes of fraud protection\r\n and credit risk reduction. CHOICES ABOUT HOW WE USE AND\r\n DISCLOSE YOUR INFORMATION. We strive to provide you with\r\n choices regarding the personal information you provide\r\n to us. We have created mechanisms to provide you with\r\n the following control over your information. You can set\r\n your browser to refuse all or some browser cookies, or\r\n to alert you when cookies are being sent. If you disable\r\n or refuse cookies, please note that some parts of the\r\n Website or Apps may then be inaccessible or not function\r\n properly. Do Not Track We do not currently respond to\r\n “do not track” signals as we do not track our customers\r\n across third party websites, we do not control third\r\n parties’ collection or use of your information to serve\r\n interest-based advertising. However these third parties\r\n may provide you with ways to choose not to have your\r\n information collected or used in this way. ACCESSING,\r\n CORRECTING & DELETING YOUR Information You may contact\r\n us at the address below, or by emailing\r\n \r\n INFO@WELCAREDX.COM\r\n \r\n to request access to, correct, or delete any personal\r\n information that you have provided to us. We cannot\r\n delete your personal information except by also deleting\r\n your user account. If WELCARE DIAGNOTICS deletes your\r\n user account, medical providers and other affiliates may\r\n still have the right to retain information as required\r\n by applicable law, regulations, or their own retention\r\n policy. We may not accommodate a request to change\r\n information if we believe the change would violate any\r\n law or legal requirement or cause the information to be\r\n incorrect. Unless otherwise required by law, WELCARE\r\n DIAGNOTICS will also erase personal information when the\r\n personal information is no longer necessary in relation\r\n to the purposes for which was collected or otherwise\r\n processed; when you withdraw your consent (where\r\n lawfulness of processing was based on your consent) and\r\n there is no other legal ground for the processing; when\r\n you object to the processing and there are no overriding\r\n legitimate grounds for the processing; when your\r\n personal information has been unlawfully processed; and\r\n when it is necessary to comply with legal obligations.\r\n DATA SECURITY has implemented commercially reasonable\r\n security measures designed to secure your personal\r\n information from accidental loss and from unauthorized\r\n access, use, alteration, and disclosure. Where we have\r\n given you (or where you have chosen) a password that\r\n enables you to access certain parts of our Website and\r\n Apps, you are responsible for keeping this password\r\n confidential. We ask you not to share password with\r\n anyone. The information you share in public areas may be\r\n viewed by any user of the Website or Apps.\r\n Unfortunately, the transmission of information via the\r\n internet is not completely secure. Although we will do\r\n our best to protect your personal information, we cannot\r\n guarantee the security of your data transmitted to our\r\n website or Apps; any transmission is at your own risk.\r\n THIRD Parties This Privacy Policy does not address, and\r\n we are not responsible for, the privacy, information, or\r\n other practices, including data privacy and security\r\n process and standards of any third parties, including\r\n physicians and other health care providers using the\r\n Services, the manufacturer of your mobile device and\r\n other IT hardware and software, and any other third\r\n party mobile application or website to which our\r\n Website, Apps, or Services may contain a link. These\r\n third parties may at times gather information from or\r\n about you. PROTECTING HEALTH Information is committed to\r\n complying with the Standards and to protecting the\r\n confidentiality of every individual\'s laboratory test\r\n results and other Protected Health Information (PHI).To\r\n ensure protection of PHI, we have implemented strict\r\n policies and procedures to comply with the Security and\r\n Privacy Standards and other applicable federal and state\r\n laws and regulations. In addition, we continuously\r\n monitor and audit these processes for effectiveness and\r\n compliance. Our Patient Privacy Notice may be\r\n WELCAREDX.COM patient privacy policy Use BY Minors We do\r\n not knowingly collect information for individuals under\r\n the age of 18 for whom we have not obtained adequate\r\n consent as set forth below If you are under 18 years of\r\n age, we must obtain valid and verifiable consent by your\r\n parent or legal guardian to this Privacy Policy and our\r\n Agreement before you can use Website, Apps, and\r\n Services. Such consent will be obtained via reasonable\r\n methods, as determined by us in our sole discretion. If\r\n we determine that the consent obtained is inadequate, we\r\n will notify you and you may not use or access the\r\n Website, Apps, or Services at any time or in any manner.\r\n However, if you are a parent, legal guardian, or\r\n personal representative of a minor child under 18 years\r\n of age, you may, in compliance with the Agreement, use\r\n our Services on behalf of such minor child. Any\r\n information you provide us on behalf of your minor child\r\n will be treated in accordance with this Privacy Policy.\r\n If we learn that we have received any information for an\r\n individual under the age of 18 for whom we have not\r\n obtained adequate consent pursuant to the above, we will\r\n only use that information to respond directly to that\r\n child (or a parent, legal guardian or personal\r\n representative) to inform him or her that he or she\r\n cannot use our Service, and subsequently we will delete\r\n that information from our own servers. If you believe we\r\n might have any information about or about a child under\r\n 18, please contact our Privacy Officer. GENERAL DATA\r\n PROTECTION Regulation This Site is hosted on servers\r\n located in the United States. We will endeavor to meet\r\n those data protection laws and regulations (including\r\n the General Data Protection Regulation, or “GDPR”) to\r\n which we may be subject as and when applicable to the\r\n Services provided by us. The GDP was passed by the\r\n European Parliament and establishes a standard for data\r\n privacy for all member states of the European Economic\r\n Area (“EEA”) (“EU”). Its purpose is to give EEA\r\n residents (described as “data subjects” by the GDPR)\r\n certain rights over their Personal Information,\r\n including, the: Right of access: Individuals can ask for\r\n a copy of the Personal Information retained about them\r\n and an explanation of how it is being used. Right to\r\n rectification: Individuals have the right to correct,\r\n revise or remove any of the Personal Information\r\n retained about them at any time.\r\n
\r\n
\r\n Right to be forgotten: Individuals canask to delete\r\n their Personal Information. 3•Right to restrict\r\n processing: If an individual believes, for example, that\r\n their Personal Information is inaccurate or collected\r\n unlawfully, the individual may request limited use of\r\n their Personal Information. Right of portability:\r\n Individuals have the right to receive their Personal\r\n Information in a structured, commonly used and\r\n machine-readable format. Right to object: Where an\r\n individual decides that they no longer wish to allow\r\n their Personal Information to be included in analytics\r\n or to receive direct marketing emails or other\r\n personalized (targeted) marketing content at any time,\r\n the individual may opt out of use of their data for\r\n these purposes. REVISIONS TO OUR PRIVACY policy. We\r\n reserve the right to change this Privacy Policy at any\r\n time. It is our policy to post any changes we make to\r\n our Privacy Policy posted on this page. The date this\r\n Privacy Policy was last revised is identified at the top\r\n of the page. You are responsible for periodically\r\n monitoring and reviewing any updates to the Privacy\r\n Policy. Your continued use of our website or Apps after\r\n such amendments will be deemed your acknowledgment of\r\n these changes to this Privacy Policy. CONTACTING Us If\r\n you have any questions about this Privacy Policy, please\r\n contact our Privacy Officer, RINA MAKANI, at\r\n 856-685-7602 or via email at{\" \"}\r\n \r\n INFO@WELCAREDX.COM\r\n \r\n
\r\n 703 White Horse Rd , Suite - 4 ,\r\n Voorhees, NJ 08043\r\n
\r\n
\r\n Phone: 856-685-7602\r\n
\r\n
\r\n {\" \"}\r\n Email: info@welcaredx.com\r\n
\r\n
\r\n
\r\n Both Walk in and Appointments are available\r\n for laboratory services.\r\n
\r\n
\r\n We are open for 7 days a week with below\r\n hours:\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n SPECIMEN COLLECTION HOURS:\r\n
\r\n
\r\n
\r\n Monday To Friday: 7:00 AM To 2:00 PM\r\n
\r\n
\r\n Saturday: 7:00 AM To 2:00 PM\r\n
\r\n
\r\n Sunday: 7:00 AM To 12:00 PM\r\n
\r\n
\r\n
\r\n LAB/OFFICE HOURS:\r\n
\r\n
\r\n
\r\n Monday To Friday: 7:00 AM To 7:00 PM\r\n
\r\n
\r\n Saturday: 7:00 AM To 5:00 PM\r\n
\r\n
\r\n Sunday: 7:00 AM To 12:00 PM\r\n
\r\n
\r\n \r\n \r\n
\r\n COVID COLLECTION HOURS:\r\n
\r\n
\r\n
\r\n Monday To Sunday: 7:00 AM To 3:00 PM\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Do you have any questions or concerns that\r\n need to be answered?\r\n
\r\n
\r\n 24/7 CUSTOMER SUPPORT\r\n
\r\n
\r\n WelCare is committed to provide excellent\r\n customer support via Email:\r\n \r\n info@welcaredx.com\r\n {\" \"}\r\n or Phone:\r\n \r\n 856-685-7602\r\n \r\n . We recommend you to visit our website\r\n welcaredx.com to access your needs at\r\n anytime.\r\n
\r\n THIS NOTICE DESCRIBES HOW YOUR MEDICAL INFORMATION MAY\r\n BE USED AND DISCLOSED AND YOUR RIGHTS RELATED TO THIS\r\n INFORMATION. PLEASE REVIEW IT CAREFULLY\r\n
\r\n
\r\n WELCARE DIAGNOTICS is committed to protect the privacy\r\n of your identifiable health information. This\r\n information is known as “protected health information”\r\n or “PHI.” PHI includes laboratory test orders and test\r\n results as well as invoices for the healthcare services\r\n we provide. WELCARE DIAGNOSTICS is required by law to\r\n maintain the privacy of your PHI. We are also required\r\n to provide you with this notice of our legal duties and\r\n privacy practices upon request. It describes our legal\r\n duties, privacy practices and your patient rights as\r\n determined by the Health Insurance Portability and\r\n Accountability Act of 1996 (HIPAA). We are required to\r\n follow the terms of this notice currently in effect. We\r\n are required to notify affected individuals in the event\r\n of a breach involving unsecured protected health\r\n information. PHI is stored electronically and is subject\r\n to electronic disclosure. This notice does not apply to\r\n non-diagnostic services that we perform such as certain\r\n drugs of abuse testing services.\r\n
\r\n
\r\n How We May Use or Disclose Your Health Information: We\r\n use your PHI for treatment, payment, or healthcare\r\n operations purposes and for other purposes permitted or\r\n required by law. Not every use or disclosure is listed\r\n in this notice, but all our uses or disclosures of your\r\n health information will fall into one of the categories\r\n listed below. We need your written authorization to use\r\n or disclose your health information for any purpose not\r\n covered by one of the categories below. We will not\r\n disclose your PHI for marketing purposes or sell your\r\n PHI, unless you have signed an authorization. You may\r\n revoke any authorization you sign at any time. If you\r\n revoke your authorization, we will no longer use or\r\n disclose your health information for the reasons stated\r\n in your authorization except to the extent we have\r\n already acted based on your authorization. The law\r\n permits us to use and disclose your health Information\r\n for the following purposes: 1) Treatment WELCARE\r\n DIAGNOSTICS provides laboratory testing for physicians\r\n and other healthcare professionals, and we use your\r\n information in our testing process. We disclose your\r\n health information to authorized healthcare\r\n professionals who order tests or need access to your\r\n test results for treatment purposes. Examples of other\r\n treatment related purposes include disclosure to a\r\n pathologist to help interpret your test results or use\r\n of your information to contact you to obtain another\r\n specimen, if necessary. 2) Payment WELCARE DIAGNOSTICS\r\n will use and disclose your PHI for purposes of billing\r\n and payment. For example, we may disclose your PHI to\r\n health plans or other payers to determine whether you\r\n are enrolled with the payer or eligible for health\r\n benefits or to obtain payment for our services. If you\r\n are insured under another person’s health insurance\r\n policy (for example, parent, spouse, domestic partner,\r\n or a former spouse), we may also send invoices to the\r\n subscriber whose policy covers your health services.\r\n Healthcare Operational may use and disclose your PHI for\r\n activities necessary to support our healthcare\r\n operations, such as performing quality checks on our\r\n testing, internal audits, arranging for legal services\r\n or developing reference ranges for our tests. Business\r\n Associates may provide your PHI to other companies or\r\n individuals that need the information to provide\r\n services to us. These other entities, known as \"business\r\n associates,\" are required to maintain the privacy and\r\n security of PHI. For example, we may provide information\r\n to companies that assist us with the billing of our\r\n services. We may also use an outside collection agency\r\n to obtain payment when necessary. As Required by Law, we\r\n may use and disclose your PHI as required by law. Law\r\n Enforcement Activities and Legal Proceedings may use and\r\n disclose your PHI, if necessary, to prevent or lessen a\r\n serious threat to your health and safety or that of\r\n another person. We may also provide PHI to law\r\n enforcement officials, for example, in response to a\r\n warrant, investigative demand or similar legal process,\r\n or for officials to identify or locate a suspect,\r\n fugitive, material witness, or missing person. We may\r\n also disclose PHI to appropriate agencies if we\r\n reasonably believe an individual to be a victim of\r\n abuse, neglect, or domestic violence. We may disclose\r\n your PHI as required to comply with a court or\r\n administrative order. We may disclose your PHI in\r\n response to a subpoena, discovery request or other Legal\r\n process during a judicial or administrative proceeding,\r\n but only if efforts have been made to tell you about the\r\n request or to obtain an order of protection for the\r\n requested information. 3) Research We may disclose PHI\r\n for research purposes when an Institutional Review Board\r\n or privacy board has reviewed the research proposal and\r\n established protocols to ensure the privacy of your PHI\r\n and determined that the researcher does not need to\r\n obtain your authorization prior to using your PHI for\r\n research purposes. We may also disclose information\r\n about decedents to researchers under certain\r\n circumstances. Other Uses and Disclosures permitted by\r\n HIPAA; we may disclose your PHI to:\r\n
\r\n
\r\n
\r\n Public Health Authorities\r\n
\r\n
\r\n The Food and Drug Administration\r\n
\r\n
\r\n The Food and Drug Administration\r\n
\r\n
\r\n Military Command Authorities\r\n
\r\n
\r\n National Security and Intelligence Organizations\r\n
\r\n
\r\n Correctional Institutions\r\n
\r\n
\r\n Organ and Tissue Donation Organizations\r\n
\r\n
\r\n Coroners, Medical Examiners and Funeral Directors\r\n
\r\n
\r\n Workers Compensation Agents\r\n
\r\n
\r\n
\r\n We may also disclose relevant PHI to a family member,\r\n friend, or anyone else you designate for that person to\r\n be involved in your care or payment related to your\r\n care. We may also disclose PHI to those assisting in\r\n disaster relief efforts so that others can be notified\r\n about your condition, status, and location. Note\r\n Regarding State Law for all the above purposes, when\r\n state law is more restrictive than federal law, we are\r\n required to follow the more restrictive state law. Your\r\n Patient Rights to Receive Test Information have the\r\n right to access your PHI that we have created. You may\r\n request a copy of your results by visiting our website\r\n at WELCAREDX.COM. You may also call us on 862491535. If\r\n your request for test information is denied, you may\r\n request that the denial be reviewed. Amend Health\r\n Information You may request amendments to your PHI by\r\n making a written request. However, we may deny the\r\n request in some cases (such as if we determine the PHI\r\n is accurate). If we deny your request to change your\r\n PHI, we will provide you with a written explanation of\r\n the reason for the denial and additional information\r\n regarding further actions that you may take. Accounting\r\n of Disclosures, you have the right to receive a list of\r\n certain disclosures of your PHI made by WELCARE\r\n DIGANOSTICS in the past six years from the date of your\r\n written request. Under the law, this does not include\r\n disclosures made for purposes of treatment, payment, or\r\n healthcare operations or certain other purposes. Request\r\n Restrictions Note You may request that we agree to\r\n restrictions on certain uses and disclosures of your\r\n PHI. We are not required to agree to your request,\r\n except for requests to limit disclosures to your health\r\n plan for purposes of payment or healthcare operations\r\n when you have paid us for the item or service covered by\r\n the request out-of-pocket and in full and when the uses\r\n or disclosures are not required by law. Request\r\n Confidential Communications You have the right to\r\n request that we send your health information by\r\n alternative means or to an alternative address, and we\r\n will accommodate reasonable requests. Copy of this\r\n Notice You have the right to obtain a paper copy of this\r\n Notice upon request. How to Exercise Your Rights You may\r\n write or send an email to us with your specific request,\r\n including requesting a form to complete to obtain a copy\r\n of your test results. Complaints/Questions: If you\r\n believe your privacy rights have been violated, you have\r\n the right to file a complaint with us. You also have the\r\n right to file a complaint with the Secretary of the U.S.\r\n Department of Health and Human Services, Office for\r\n Civil Rights. WELCARE DIAGNOSTICS will not retaliate\r\n against any individual for filing a complaint. To file a\r\n complaint with us, or should you have any questions\r\n about this Notice, send an email to us at\r\n \r\n info@welcaredx.com\r\n \r\n or write to us at the following address:\r\n
\r\n
WELCARE DIAGNOSTICS LLC
\r\n
Attention/PRIVACY OFFICER:
\r\n
RINA MAKANI
\r\n
703 WHITE HORSE RD,
\r\n
UNITE-4,
\r\n
VOORHEES. NJ 08043
\r\n
\r\n We reserve the right to amend the terms of this notice\r\n to reflect changes in our privacy practices, and to make\r\n the new terms and practices applicable to all PHI that\r\n we maintain about you, including PHI created or received\r\n prior to the effective date of the Notice revision. Our\r\n Notice is displayed on our website and a copy is\r\n available upon request. Non-Discrimination Notice\r\n Incorporated and its subsidiaries complies with\r\n applicable Federal civil rights laws and does not\r\n discriminate based on race, color, national origin, age,\r\n disability, or sex. WelCare Diagnostics does not exclude\r\n people or treat them differently because of race, color,\r\n national origin, age, disability, or sex. If you believe\r\n that WELCARE DIAGNOTICS has failed to provide these\r\n services or discriminated in another way on the basis of\r\n race, color, national origin, age, disability, or sex,\r\n you can file a grievance with: WELCARE DIAGNOTICS.\r\n Attention: RINA MAKANI, Privacy Officer 703 WHITE HORSE\r\n RD, UNITE4, VOORHEES, NJ-08043, can file a grievance in\r\n person or by mail, fax, or email. You can also file a\r\n civil rights complaint with the U.S. Department of\r\n Health and Human Services, Office for Civil Rights,\r\n electronically through the Office for Civil Rights\r\n Complaint Portal, available at\r\n https://ocrportal.hhs.gov/ocr/portal/lobby.jsf,or by\r\n mail or phone at: U.S. Department of Health and Human\r\n Services, 200 Independence Avenue, SW Room 509F, HHH\r\n building, Washington, D.C. 202011.\r\n
\r\n In accordance with the Health Insurance Portability and\r\n Accountability Act of 1996, all employees will be\r\n trained and educated, as per the facility training\r\n guideline, on HIPAA guidelines and the applications to\r\n the laboratory setting.\r\n
\r\n
\r\n The final security rules apply exclusively to protected\r\n health information in electronic format, examples to\r\n include data stored on computers, mobile devices, USB\r\n and other electronic data storage formats. All\r\n established guidelines and rulings to insure protection\r\n of this information will be employed by the facility.\r\n Additional institution specific established guidelines\r\n and approaches to protect health information are as\r\n follows:\r\n
\r\n
\r\n
\r\n All records at the testing site containing patient\r\n identification information or laboratory results are\r\n protected from view at all times by storing\r\n overturned or in a folder or binder.\r\n
\r\n
\r\n Computer screens that are accessible for view by\r\n patients or other individuals who may be receiving\r\n treatment or conducting business within a laboratory\r\n or in a phlebotomy draw site setting will have a\r\n cover placed over the screen or monitor to protect\r\n all patient information from view by these\r\n individuals.\r\n
\r\n
\r\n A document or label containing patient information\r\n that is not filed or secured in the laboratory will\r\n be discarded by shredding.\r\n
\r\n
\r\n Laboratory requisitions or encounter forms will\r\n remain with testing personnel and at central company\r\n locations in each state; only laboratory employees\r\n have access to these files.\r\n
\r\n
\r\n All patient charts or records are maintained in the\r\n test site. All patient documents remain closed\r\n unless the patient record is to be supplemented with\r\n additional documentation concerning specimen draw or\r\n collection, or when there is necessity for\r\n transcription of laboratory results or laboratory\r\n reports are submitted to the patient’s medical\r\n record for physician review.\r\n
\r\n
\r\n The amendments modify the definition of “bleach” by\r\n providing that an impermissible use or disclosure of\r\n PHI is presumed to be a breach, unless it can be\r\n demonstrated that there is a low probability) that\r\n PHI has been compromised\r\n
\r\n
\r\n The amendments expanded the definition of a\r\n “business associate” to include subcontractors of\r\n business associates (and their subcontractors).\r\n
\r\n
\r\n The amendments expanded the definition of a\r\n “business associate” to include\r\n subcontractors of business associates (and\r\n their subcontractors).\r\n
\r\n
\r\n A covered entity must obtain satisfactory\r\n assurances in the form of a written contract\r\n or other arrangement from each business\r\n associate, and each business associates in\r\n turn must do the same with regard to each\r\n subcontractor that handles PHI on its\r\n behalf, no matter how far “down the chain”\r\n the PHI flows.\r\n
\r\n
\r\n
\r\n
\r\n Test results are to be released only to authorized\r\n person(s), the persons(s) responsible for using the\r\n test results, and of the lab that initially\r\n requested the test.\r\n
\r\n
\r\n Patient Access to Test Results: The laboratory may\r\n provide a copy of a patient\'s completed test results\r\n to the patient or the patient\'s personal\r\n representative upon request by the patient if the\r\n laboratory can authenticate the test results as\r\n belonging to the patient. (42CFR493.1291(1))\r\n
\r\n
\r\n
\r\n The laboratory must have a defined process for providing\r\n completed test results to patients or their\r\n representatives and a procedure for providing completed\r\n results to patients or their personal representatives\r\n including a defined authentication process to verify the\r\n identity of the patient or there representative. The\r\n laboratory must also have an electronic Health record\r\n (HER) system, patient portal or be a part of a health\r\n information exchange (HIV) to meet the new requirement\r\n for direct patient access.\r\n
\r\n
\r\n How do these changes effect the laboratory?\r\n
\r\n
\r\n
\r\n If requested by a patient, the laboratory may need\r\n to provide the patient (or the patient’s\r\n representative) with a copy of the patient’s\r\n completed test reports.\r\n
\r\n
\r\n The laboratory will need to define a process for\r\n providing the patient’s test results to the patient\r\n (or the patient’s representative)\r\n
\r\n
\r\n The laboratory will need to define a process for\r\n identity verification.\r\n
\r\n
\r\n Laboratories are not required to interpret test\r\n results. The lab will continue to refer patients\r\n back to their provider for interpretation.\r\n
\r\n
\r\n Laboratories have 30 clays to comply with a request\r\n for access.\r\n
\r\n
\r\n The laboratory is not required to provide results in\r\n a specific format.\r\n
\r\n
\r\n
\r\n Regulations are monitored and followed on a daily basis\r\n by the Laboratory Staff, and are under constant quality\r\n assessment evaluation for additional security.\r\n \r\n For more Information :\r\n {\" \"}\r\n \r\n HIPAA\r\n \r\n
\r\n
', '1', '2020-02-11 20:01:25', '2023-10-11 04:50:34', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `diagnostic_services`
--
CREATE TABLE `diagnostic_services` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`image_url` text COLLATE utf8mb4_unicode_ci,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `diagnostic_services`
--
INSERT INTO `diagnostic_services` (`id`, `title`, `slug`, `description`, `image_url`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Indpendent Advantage', '169406874064f9700485682', 'As a service oriented, independent and fully certified provider, Accurate Diagnostic Labs can streamline the process and put the focus where', 'diagnostic_services/lcg2fg3w5hiMZtnRSDtEX66J1RdSnFDb96YHjmK7.png', '1', '2023-09-07 10:39:00', '2023-09-07 10:39:00', NULL),
(2, 'CUSTOMIZED APPROACH', '169406879764f9703dd8db8', 'It can be something as simple as adding a bit of color to a printed report, but when a service provider is willing to go that extra step in', 'diagnostic_services/Ai3FYbiHqAzovofsLHnV9zJWXd1RW7rFJAoeB7m9.png', '1', '2023-09-07 10:39:57', '2023-09-07 10:39:57', NULL),
(3, 'SERVICE WITH A HUMAN TOUCH', '169406884164f970699e46c', 'The human touch is important in the relationship between the physician and the patient–and it’s an equally vital part of the long-standing', 'diagnostic_services/z9WCxHLo0avV9rhk1gJOd2W5m7x3nsFlQRm2ZRqb.png', '1', '2023-09-07 10:40:41', '2023-09-07 10:40:41', NULL),
(4, 'A WAY TO OPTIMIZE YOUR EFFICIENCY', '169406889164f9709b9d455', 'Our policy of speedy and efficient turnaround for our clients means fast access to the information you need via all forms of electronic transmittal', 'diagnostic_services/C5ViDvil9mcmfmYYdUDuw0GyYRUFqjtU3kOVDYL0.png', '1', '2023-09-07 10:41:31', '2023-09-07 10:41:31', NULL),
(5, 'WE’RE INTEGRATED TO YOUR OFFICE', '169406896464f970e4d98af', 'Our Patient Care Technicians are more than just phlebotomists. They’re members of your office family, trained to care for patients of all ages', 'diagnostic_services/vawpi6AbocbtKWttZxsk7aYG8H2xXjYvYvhKBPrY.png', '1', '2023-09-07 10:42:44', '2023-09-07 10:42:44', NULL),
(6, '24/7 SUPPORT', '169406899364f971019b0d3', 'Our 24/7 customer service team is also fully trained to recognize your specific needs. Hence no more hold time. We are on call when you are on call.', 'diagnostic_services/fS8UkZIurN4la8a7YWoDvQYm35RpAe3y0K39BXqy.png', '1', '2023-09-07 10:43:13', '2023-09-07 10:43:13', NULL),
(7, 'test service', '169417597464fb12e6b542a', 'test', 'diagnostic_services/2myaPFw90PdnXD7HPny3i9bwzojxezOBkSAZYPln.png', '1', '2023-09-08 16:26:14', '2023-09-08 16:26:55', '2023-09-08 16:26:55'),
(8, 'tests', '169418003664fb22c4413e6', 'test tehahdbahsdas dasnjdasjdjsad sadnasndasds asd asd sad asd asd sad sad asd asd sadas das Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem IpsumLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the releaprinter took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum testing 123 s', 'diagnostic_services/oa0P8yvfBDfG22QnhqrpKthnJOzL7qB9g27pLqkf.png', '1', '2023-09-08 17:33:56', '2023-09-08 17:43:09', '2023-09-08 17:43:09'),
(9, 'test', '169418135364fb27e93fe95', 'test', 'diagnostic_services/H4OyxJzKDYpuumQbJvTWSJgqC5fADUv3z5bqPpXX.png', '1', '2023-09-08 17:55:53', '2023-09-08 17:58:10', '2023-09-08 17:58:10');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `faqs`
--
CREATE TABLE `faqs` (
`id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`question` text COLLATE utf8mb4_unicode_ci NOT NULL,
`answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `faqs`
--
INSERT INTO `faqs` (`id`, `slug`, `question`, `answer`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '64995875aaa4364995875aaa44', 'How to change the language', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', '1', '2020-02-17 20:45:47', NULL, NULL),
(2, '64995875aaa4664995875aaa47', 'How to restore your chat history', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', '1', '2020-02-17 20:51:16', NULL, NULL),
(3, '649aa1cf521901687855567', 'test', 'test', '1', '2023-06-27 12:46:07', '2023-06-28 11:41:41', '2023-06-28 11:41:41'),
(4, '64f5f27d3948b1693839997', 'test question', 'test answer', '1', '2023-09-04 19:06:37', '2023-09-05 12:36:29', '2023-09-05 12:36:29');
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `media`
--
CREATE TABLE `media` (
`id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`module` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_id` int(11) NOT NULL,
`filename` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`original_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
`file_url_blur` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`thumbnail_url` text COLLATE utf8mb4_unicode_ci,
`mime_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`driver` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
`media_type` enum('public','private') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
`meta` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `media`
--
INSERT INTO `media` (`id`, `slug`, `module`, `module_id`, `filename`, `original_name`, `file_url`, `file_url_blur`, `thumbnail_url`, `mime_type`, `file_type`, `driver`, `media_type`, `meta`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '2652676f3bf3c4', 'test_directory', 0, 'xRXB9JIdVRwrPE2DZfQSiWrBnt5ePowJvSO1ZPtK.pdf', 'test-directory.pdf', 'test-directory/xRXB9JIdVRwrPE2DZfQSiWrBnt5ePowJvSO1ZPtK.pdf', NULL, NULL, 'pdf', 'pdf', 'public', 'public', NULL, '2023-10-11 14:20:35', '2023-10-11 14:20:35', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) 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
(85, '2019_08_19_000000_create_failed_jobs_table', 1),
(86, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(87, '2022_02_22_071424_create_user_groups_table', 1),
(88, '2022_02_22_081152_create_users_table', 1),
(89, '2022_02_22_081416_create_user_api_tokens_table', 1),
(90, '2022_02_22_085937_create_cms_modules_table', 1),
(91, '2022_02_22_085951_create_cms_module_permission_table', 1),
(92, '2022_02_22_090042_create_reset_password_table', 1),
(93, '2022_02_22_090056_create_application_setting_table', 1),
(94, '2022_02_22_090128_create_notifications_table', 1),
(95, '2022_02_22_090139_create_notification_setting_table', 1),
(96, '2022_02_22_090303_create_cms_widgets_table', 1),
(97, '2022_02_22_090319_create_cms_widget_role_table', 1),
(98, '2022_02_22_090354_create_content_management_table', 1),
(99, '2022_02_22_090407_create_faqs_table', 1),
(100, '2022_02_22_090419_create_media_table', 1),
(101, '2022_02_23_110217_create_jobs_table', 1),
(102, '2022_11_02_084349_create_user_cards_table', 1),
(103, '2022_11_02_101630_create_user_connect_account_table', 1),
(104, '2022_11_02_101750_create_user_external_account_table', 1),
(105, '2023_05_04_105501_create_services_table', 1),
(106, '2023_05_04_105635_create_booking_table', 1),
(107, '2023_05_04_105650_create_booking_detail_table', 1),
(108, '2023_05_04_112740_create_booking_status_logs_table', 1),
(109, '2023_08_23_104551_create_diagnostic_service_table', 2),
(110, '2023_08_24_055008_create_speciality_table', 2),
(111, '2023_08_25_052807_create_contact_us_table', 3),
(112, '2023_09_06_045750_create_careers_table', 3);
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` bigint(20) UNSIGNED NOT NULL,
`unique_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`actor_id` bigint(20) UNSIGNED NOT NULL,
`target_id` bigint(20) UNSIGNED NOT NULL,
`module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_id` int(11) NOT NULL,
`reference_id` int(11) DEFAULT NULL,
`reference_module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`web_redirect_link` text COLLATE utf8mb4_unicode_ci,
`is_read` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`is_view` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `notification_setting`
--
CREATE TABLE `notification_setting` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`meta_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_value` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci,
`last_used_at` timestamp NULL DEFAULT NULL,
`expires_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `reset_password`
--
CREATE TABLE `reset_password` (
`id` bigint(20) UNSIGNED NOT NULL,
`email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `services`
--
CREATE TABLE `services` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_url` text COLLATE utf8mb4_unicode_ci,
`description` text COLLATE utf8mb4_unicode_ci,
`amount` decimal(8,2) NOT NULL,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `services`
--
INSERT INTO `services` (`id`, `user_id`, `title`, `slug`, `image_url`, `description`, `amount`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'Vitamin D-Test', '168777327164996057751f0', 'services/BPM8jL2Hd3JPpj1m0KdbcxO57SSXddunCTWPjsTF.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 50.00, '1', '2023-06-26 13:54:31', '2023-09-29 18:16:15', '2023-09-29 18:16:15'),
(2, 2, 'Dexa Scan', '168777332864996090372f7', 'services/F9yMCcApWyMnTK5bv08xQExR2TqeBiRlc6t4PMFo.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 60.00, '1', '2023-06-26 13:55:28', '2023-09-29 18:16:15', '2023-09-29 18:16:15'),
(3, 2, 'cholesterol & lipid', '1687773394649960d282895', 'services/lRe67DolRNozmvTBDtZH6MhdOACEt2KMSJAt55OY.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 65.00, '1', '2023-06-26 13:56:34', '2023-09-29 18:16:15', '2023-09-29 18:16:15'),
(4, 2, 'Cardiac Enzymes', '1687773433649960f94a79f', 'services/K2JdrstwJvvs53b3V3sKQGmYbI3xHcVCUZr4fVTC.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 70.00, '1', '2023-06-26 13:57:13', '2023-09-29 18:16:15', '2023-09-29 18:16:15'),
(5, 2, 'D-timer Test', '168777345964996113d3a52', 'services/Eg8AEC0mWeMAx7qlQySmgDqFyQo85UlFUs1hFKBQ.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', 75.00, '1', '2023-06-26 13:57:39', '2023-09-29 18:15:44', '2023-09-29 18:15:44'),
(6, 2, 'BUN (Blood Urea Nitrogen) - Kidney (Renal) Function Panel', '168777349764996139b93e9', 'services/pSW908TaDWXpZ2280npu5EK0PiRt7mOEelrOOLmm.png', 'The BUN test measures the level of nitrogen in the blood derived from the waste product urea. Urea is produced when the body breaks down proteins. Elevated BUN levels may suggest kidney dysfunction, dehydration, or other medical conditions.', 0.00, '1', '2023-06-26 13:58:17', '2023-09-29 18:16:15', '2023-09-29 18:16:15'),
(7, 2, 'testing', '1687865033649ac6c98da26', 'services/faxVxvf07kFZaJSQpFXxPW5DeXByjpNPfdNZyNby.jpg', 'test description', 53.00, '1', '2023-06-27 15:23:53', '2023-06-28 11:38:30', '2023-06-28 11:38:30'),
(8, 2, 'Test', '16959175146515a5cabe09a', 'services/prd9Rr3P1tJUgdBWYzFtX5yPelJoSo6br7JrrviT.png', 'dsds', 50.00, '1', '2023-09-28 20:11:54', '2023-09-28 20:12:46', '2023-09-28 20:12:46'),
(9, 2, 'Glucose Test - BMP', '16959961596516d8ff292ba', 'services/MsNIFadHuyYZBNLvkKN0Xv5b78xEqIjQhKEC7zD1.jpg', 'The glucose test measures the concentration of glucose (sugar) in the blood. It is commonly used to diagnose and monitor diabetes mellitus, a condition characterized by high blood sugar levels. Abnormal glucose levels can also indicate other medical conditions.', 0.00, '1', '2023-09-29 18:02:39', '2023-09-29 18:16:54', NULL),
(10, 2, 'BUN (Blood Urea Nitrogen) Test - BMP', '16959975396516de63d7e02', 'services/nkxeSWzd6xYLNhF1oEYEsIKQqX01TRuy4JTnR8yl.jpg', 'The BUN test assesses the level of nitrogen in the blood that comes from the waste product urea. Urea is produced when the body breaks down proteins. Elevated BUN levels may suggest kidney dysfunction or dehydration, among other conditions.', 0.00, '1', '2023-09-29 18:25:39', '2023-09-29 18:25:39', NULL),
(11, 2, 'Creatinine Test - BMP', '16959975676516de7f62bff', 'services/McvvtuNVOtETfVuMMuQ8r1yanqsjgartE7asIaiV.jpg', 'The creatinine test measures the level of creatinine in the blood. Creatinine is a waste product generated by muscle metabolism. Elevated creatinine levels can be an indicator of impaired kidney function.', 0.00, '1', '2023-09-29 18:26:07', '2023-09-29 18:26:07', NULL),
(12, 2, 'Glucose Test - CMP', '16959975846516de90196b4', 'services/spqOP9BXQjCLzfLbjnOcZ1R4TLgWfT4KpLN2QITq.jpg', 'The glucose test measures the concentration of glucose (sugar) in the blood. It is commonly used to diagnose and monitor diabetes mellitus, a condition characterized by high blood sugar levels. Abnormal glucose levels can also indicate other medical conditions.', 0.00, '1', '2023-09-29 18:26:24', '2023-09-29 18:26:24', NULL),
(13, 2, 'GFR (Glomerular Filtration Rate) - BMP', '16959975936516de99d8155', 'services/0fR6yFQsMC49aMIWDxOVZLOr5AeIRWBb8sld9Nku.jpg', 'The GFR is not a standalone test but rather a calculated value derived from the results of the creatinine test and other factors. It provides an estimate of how well the kidneys are filtering waste from the blood. A lower GFR may indicate reduced kidney function.', 0.00, '1', '2023-09-29 18:26:33', '2023-09-29 18:26:33', NULL),
(14, 2, 'BUN (Blood Urea Nitrogen) Test - CMP', '16959976106516deaac80c4', 'services/YgORoD3MW0J4oM8GXEPZzVQTk6SLi5IhkHB11KPU.jpg', 'The BUN test assesses the level of nitrogen in the blood that comes from the waste product urea. Urea is produced when the body breaks down proteins. Elevated BUN levels may suggest kidney dysfunction or dehydration, among other conditions.', 0.00, '1', '2023-09-29 18:26:50', '2023-09-29 18:26:55', NULL),
(15, 2, 'BUN/Creatinine Ratio - BMP', '16959976216516deb5cd631', 'services/6LUezaFF4lalSw2trrBJogry1530AkaJRxomzaa8.jpg', 'The BUN-to-creatinine ratio is a calculated value that compares the levels of blood urea nitrogen (BUN) and creatinine. This ratio can help assess the potential causes of kidney dysfunction. An abnormal ratio can provide insights into kidney and other health issues.', 0.00, '1', '2023-09-29 18:27:01', '2023-09-29 18:27:01', NULL),
(16, 2, 'Sodium Test - BMP', '16959976466516dece0d209', 'services/BHXIGJC576syl4aohraKOsgr60MLLIhYW3A2gAhD.jpg', 'The sodium test measures the concentration of sodium in the blood. Sodium plays a crucial role in maintaining fluid balance and nerve function. Abnormal sodium levels can be indicative of various conditions, including dehydration, kidney problems, or certain hormonal disorders.', 0.00, '1', '2023-09-29 18:27:26', '2023-09-29 18:27:26', NULL),
(17, 2, 'Creatinine Test - CMP', '16959976466516dece9b0ab', 'services/6IsYgz2sveFDqrEGEQIZI9k1Pu4aP4LjIlrVjFQO.jpg', 'The creatinine test measures the level of creatinine in the blood. Creatinine is a waste product generated by muscle metabolism. Elevated creatinine levels can be an indicator of impaired kidney function.', 0.00, '1', '2023-09-29 18:27:26', '2023-09-29 18:27:26', NULL),
(18, 2, 'GFR (Glomerular Filtration Rate) - CMP', '16959976686516dee4353dd', 'services/6uZRUT7mxl1SzLZM5ifqeKBSHnVE0FrvUVFjlENM.jpg', 'The GFR is not a standalone test but rather a calculated value derived from the results of the creatinine test and other factors. It provides an estimate of how well the kidneys are filtering waste from the blood. A lower GFR may indicate reduced kidney function.', 0.00, '1', '2023-09-29 18:27:48', '2023-09-29 18:27:48', NULL),
(19, 2, 'Potassium Test - BMP', '16959976706516dee628eaa', 'services/EDYGXvLOpdqgOeY4Wbeq8qlo5vYWb23JmVHe3DLA.jpg', 'The potassium test determines the level of potassium in the blood. Potassium is vital for proper muscle and nerve function, as well as maintaining heart rhythm. Abnormal potassium levels can be associated with heart and muscle problems.', 0.00, '1', '2023-09-29 18:27:50', '2023-09-29 18:27:50', NULL),
(20, 2, 'BUN/Creatinine Ratio - CMP', '16959976866516def652f8e', 'services/moYgLMoVd0AeStNRuWv8p5pBSMlZm80mABI97gsF.jpg', 'The BUN-to-creatinine ratio is a calculated value that compares the levels of blood urea nitrogen (BUN) and creatinine. This ratio can help assess the potential causes of kidney dysfunction. An abnormal ratio can provide insights into kidney and other health issues.', 0.00, '1', '2023-09-29 18:28:06', '2023-09-29 18:28:06', NULL),
(21, 2, 'Chloride Test - BMP', '16959976916516defb7f76f', 'services/tSPNDzN13LPPwneFO7z4CUxf6uvaTkmnmYPRqDix.jpg', 'The chloride test measures the concentration of chloride ions in the blood. Chloride is an electrolyte that helps maintain proper fluid balance and plays a role in acid-base balance in the body. Abnormal chloride levels can indicate electrolyte imbalances.', 0.00, '1', '2023-09-29 18:28:11', '2023-09-29 18:28:11', NULL),
(22, 2, 'Albumin - Kidney (Renal) Function Panel', '16959976996516df036c596', 'services/LVcwTkDogKhP24MtRFyMZnfD323a1S5iwkovNAty.jpg', 'The albumin test measures the concentration of albumin, a protein produced by the liver, in the blood. Albumin plays a critical role in maintaining blood volume and transporting various substances, such as hormones and medications. Abnormal albumin levels can indicate liver or kidney disease and may reflect overall nutritional status.', 0.00, '1', '2023-09-29 18:28:19', '2023-09-29 18:28:19', NULL),
(23, 2, 'Sodium Test - CMP', '16959977026516df069fe3e', 'services/Fdp3wcAYQRWF0LrG53XQQyvIJgTu59FhH0m5cbsr.jpg', 'The sodium test measures the concentration of sodium in the blood. Sodium plays a crucial role in maintaining fluid balance and nerve function. Abnormal sodium levels can be indicative of various conditions, including dehydration, kidney problems, or certain hormonal disorders.', 0.00, '1', '2023-09-29 18:28:22', '2023-09-29 18:28:22', NULL),
(24, 2, 'Total Carbon Dioxide (Bicarbonate) Test - BMP', '16959977146516df12a00fb', 'services/AO7lfiocGvHsYrp7naZ7RFdCcJI4zZkHSkdRhCpQ.jpg', 'The total carbon dioxide (CO2) test measures the amount of bicarbonate in the blood. Bicarbonate is essential for maintaining the body\'s acid-base balance. Abnormal CO2 levels can suggest metabolic and respiratory disorders.', 0.00, '1', '2023-09-29 18:28:34', '2023-09-29 18:28:34', NULL),
(25, 2, 'Potassium Test - CMP', '16959977176516df1522a8f', 'services/5uH1WadftiDwY1wzBeR3Sw04fYWMhEh5SJOjh9Ck.jpg', 'The potassium test determines the level of potassium in the blood. Potassium is vital for proper muscle and nerve function, as well as maintaining heart rhythm. Abnormal potassium levels can be associated with heart and muscle problems.', 0.00, '1', '2023-09-29 18:28:37', '2023-09-29 18:28:37', NULL),
(26, 2, 'Chloride Test - CMP', '16959977346516df264722a', 'services/uHfP42ar7bT7PypTi8VrOUHDF0kiX71qHG7XLO77.jpg', 'The chloride test measures the concentration of chloride ions in the blood. Chloride is an electrolyte that helps maintain proper fluid balance and plays a role in acid-base balance in the body. Abnormal chloride levels can indicate electrolyte imbalances.', 0.00, '1', '2023-09-29 18:28:54', '2023-09-29 18:28:54', NULL),
(27, 2, 'Calcium Test - BMP', '16959977406516df2c08f01', 'services/6iBG7bduc2YdfE5JjUa9BwArARBJGOnkJuG7VRAH.jpg', 'The calcium test measures the concentration of calcium in the blood. Calcium is vital for various bodily functions, including bone health, muscle contraction, and blood clotting. Abnormal calcium levels can be indicative of a range of conditions, including bone disorders and parathyroid gland dysfunction.', 0.00, '1', '2023-09-29 18:29:00', '2023-09-29 18:29:00', NULL),
(28, 2, 'BUN (Blood Urea Nitrogen) - Kidney (Renal) Function Panel', '16959977486516df34b6215', 'services/T6Pz7o00fH2RRSOJ7iBqQNloFZJnJJD7FxoIN3LR.jpg', 'The BUN test measures the level of nitrogen in the blood derived from the waste product urea. Urea is produced when the body breaks down proteins. Elevated BUN levels may suggest kidney dysfunction, dehydration, or other medical conditions.', 0.00, '1', '2023-09-29 18:29:08', '2023-09-29 18:29:08', NULL),
(29, 2, 'Total Carbon Dioxide (Bicarbonate) Test - CMP', '16959977536516df3921157', 'services/3IS307GubSgCYjPdtzgi2LQMphyQjDtWLkvR7SNN.jpg', 'The total carbon dioxide (CO2) test measures the amount of bicarbonate in the blood. Bicarbonate is essential for maintaining the body\'s acid-base balance. Abnormal CO2 levels can suggest metabolic and respiratory disorders.', 0.00, '1', '2023-09-29 18:29:13', '2023-09-29 18:29:13', NULL),
(30, 2, 'Calcium Test - CMP', '16959977696516df492d022', 'services/EqD3KBi5VoeewN5iIXprxcwWmm52TfbK0Oi8LZlb.jpg', 'The calcium test measures the concentration of calcium in the blood. Calcium is vital for various bodily functions, including bone health, muscle contraction, and blood clotting. Abnormal calcium levels can be indicative of a range of conditions, including bone disorders and parathyroid gland dysfunction.', 0.00, '1', '2023-09-29 18:29:29', '2023-09-29 18:29:29', NULL),
(31, 2, 'Creatinine - Kidney (Renal) Function Panel', '16959977786516df524bd4a', 'services/69KZFC33NaZ4Cb1gRP7XHnC8mxpG0v4s2Cx4b4r3.jpg', 'The creatinine test measures the level of creatinine, a waste product generated by muscle metabolism, in the blood. Creatinine levels are used to assess kidney function, as the kidneys filter creatinine from the blood. Elevated creatinine levels can indicate impaired kidney function.', 0.00, '1', '2023-09-29 18:29:38', '2023-09-29 18:29:38', NULL),
(32, 2, 'Total Protein Test - CMP', '16959977866516df5a26595', 'services/apEe1W86pgBbppm6HuaZGCibnvQCbZo4HKZQ7J29.jpg', 'The total protein test measures the total concentration of proteins in the blood, including albumin and globulins. It helps evaluate overall nutritional status and liver or kidney function. Abnormal protein levels may indicate various medical conditions.', 0.00, '1', '2023-09-29 18:29:46', '2023-09-29 18:29:46', NULL),
(33, 2, 'Albumin Test - CMP', '16959978126516df74a3f68', 'services/dl3g5cGko6RipeRX16OseG4lAmBtDd7BCBhoekuQ.jpg', 'The albumin test specifically measures the concentration of albumin in the blood. Albumin is a key protein produced by the liver and plays a vital role in maintaining blood volume and transporting various substances in the blood. Low albumin levels can be associated with liver or kidney disease.', 0.00, '1', '2023-09-29 18:30:12', '2023-09-29 18:30:12', NULL),
(34, 2, 'Bilirubin, Total Test - CMP', '16959978306516df8612677', 'services/KU555cWwYMjAIijL76IsyANsgZyWe2q0KGYDfJBf.jpg', 'The total bilirubin test measures the total amount of bilirubin in the blood. Bilirubin is a waste product produced when red blood cells break down. Abnormal bilirubin levels can indicate liver or gallbladder problems and may cause jaundice (yellowing of the skin and eyes).', 0.00, '1', '2023-09-29 18:30:30', '2023-09-29 18:30:30', NULL),
(35, 2, 'Total Globulin Test - CMP', '16959978496516df9911414', 'services/9GgOZn8Rb6h8LS6WFULmbIhlPHYQMLfuMl0UvZ6v.jpg', 'The total globulin test measures the overall concentration of globulins in the blood. Globulins are a group of proteins that include antibodies and transport proteins. Changes in total globulin levels can provide insights into immune function and various medical conditions.', 0.00, '1', '2023-09-29 18:30:49', '2023-09-29 18:30:49', NULL),
(36, 2, 'BUN/Creatinine Ratio - Kidney (Renal) Function Panel', '16959978546516df9e9ddaa', 'services/4B6JN0jkdG6RZ4apMZ2R55EL5r1KSNl11smtq89c.jpg', 'The BUN-to-creatinine ratio is a calculated value that compares the levels of blood urea nitrogen (BUN) and creatinine. It helps healthcare providers assess kidney health and identify potential causes of dysfunction. Abnormal ratios can provide insights into kidney and other health issues.', 0.00, '1', '2023-09-29 18:30:54', '2023-09-29 18:30:54', NULL),
(37, 2, 'Alanine Aminotransferase (ALT/SGPT) - Liver (Hepatic) Function Panel', '16959978646516dfa8377ce', 'services/BhyCbdGHhbOjqXykfEhDm7V3xg7S2shdJHiJpdYt.jpg', 'ALT is an enzyme primarily found in liver cells. This test measures the level of ALT in the blood. Elevated ALT levels can be indicative of liver damage or disease, such as hepatitis or cirrhosis. It is an important marker for liver health.', 0.00, '1', '2023-09-29 18:31:04', '2023-09-29 18:31:04', NULL),
(38, 2, 'A/G (Albumin/Globulin) Ratio - CMP', '16959978686516dfac64657', 'services/BBJWR6SXsVDcGxmMeIJgRJfV89MtDJTXueFapjqi.jpg', 'The A/G ratio is a calculated value that compares the levels of albumin to globulins in the blood. It can help identify the underlying cause of changes in protein levels. An abnormal A/G ratio may suggest liver disease, kidney disease, or other health issues.', 0.00, '1', '2023-09-29 18:31:08', '2023-09-29 18:31:08', NULL),
(39, 2, 'AST (Aspartate Aminotransferase) Test - CMP', '16959978866516dfbe43d40', 'services/hU8ZbeifijmP0YkNn4O2T7VuQ2f2jhDxdTSToLWp.jpg', 'The AST test measures the level of the enzyme AST in the blood. AST is found in various tissues, including the liver, heart, and muscles. Elevated AST levels may indicate liver or heart damage, among other conditions.', 0.00, '1', '2023-09-29 18:31:26', '2023-09-29 18:31:26', NULL),
(40, 2, 'Albumin - Liver (Hepatic) Function Panel', '16959978866516dfbecac90', 'services/UpiyqH729ABXhSrzbN490b9ekYMu2ArZkgg1UWUG.jpg', 'The albumin test measures the concentration of albumin, a protein produced by the liver, in the blood. Albumin plays a critical role in maintaining blood volume and transporting various substances, such as hormones and medications. Low albumin levels can indicate liver or kidney disease and may reflect overall nutritional status.', 0.00, '1', '2023-09-29 18:31:26', '2023-09-29 18:31:26', NULL),
(41, 2, 'Calcium - Kidney (Renal) Function Panel', '16959978886516dfc043505', 'services/vNCwHmLhcl1Azs8cYqKfWb64KTQNOvEmMIAIgL0a.jpg', 'The calcium test measures the concentration of calcium in the blood. Calcium is essential for various bodily functions, including muscle contraction, nerve signaling, and blood clotting. Abnormal calcium levels can be indicative of a range of conditions, including bone disorders and parathyroid gland dysfunction.', 0.00, '1', '2023-09-29 18:31:28', '2023-09-29 18:31:28', NULL),
(42, 2, 'ALT (Alanine Aminotransferase) Test - CMP', '16959979036516dfcf16217', 'services/3cGPVIXxJbZabx9rnXxOCcJ7bERAuHW2ZxhYwYpB.jpg', 'The ALT test measures the level of the enzyme ALT in the blood. ALT is primarily found in the liver. Elevated ALT levels can be a sign of liver damage or disease, such as hepatitis or cirrhosis.', 0.00, '1', '2023-09-29 18:31:43', '2023-09-29 18:31:43', NULL),
(43, 2, 'Albumin/Globulin Ratio - Liver (Hepatic) Function Panel', '16959979116516dfd739099', 'services/kaFudnoFB9BBpevy7U22szgqb6IyerNPdJDKgAbO.jpg', 'The albumin/globulin ratio is a calculated value that compares the levels of albumin to globulins in the blood. It can help healthcare providers assess liver and immune system function. An abnormal ratio may suggest certain medical conditions.', 0.00, '1', '2023-09-29 18:31:51', '2023-09-29 18:31:51', NULL),
(44, 2, 'Alkaline Phosphatase (ALP) Test - CMP', '16959979216516dfe1dba6a', 'services/LYy3gbXC0AzVKSsA4IC7sz7lp7t3xHo0ho4BsgQ3.jpg', 'The ALP test measures the level of the enzyme ALP in the blood. ALP is found in various tissues, including the liver, bones, and intestines. Abnormal ALP levels may indicate liver or bone disorders, such as liver disease or bone growth problems.', 0.00, '1', '2023-09-29 18:32:01', '2023-09-29 18:32:01', NULL),
(45, 2, 'Carbon Dioxide - Kidney (Renal) Function Panel', '16959979246516dfe4ea1be', 'services/ovvetkW5jZaTlntjzLMwUkYuh2GmjyGJdIKK8Cy0.jpg', 'The carbon dioxide (CO2) test measures the amount of bicarbonate (HCO3-) in the blood, which is essential for maintaining the body\'s acid-base balance. Abnormal CO2 levels can suggest metabolic and respiratory disorders and provide insights into overall health.', 0.00, '1', '2023-09-29 18:32:04', '2023-09-29 18:32:04', NULL),
(46, 2, 'Alkaline Phosphatase (ALP) - Liver (Hepatic) Function Panel', '16959979366516dff0a1f7a', 'services/TGnsR74RvyX1dQJp1OjMger1NH1lNzaHzVaPy61r.jpg', 'ALP is an enzyme found in various tissues, including the liver, bones, and intestines. The ALP test measures the level of ALP in the blood. Elevated ALP levels can indicate liver or bone disorders, such as liver disease or bone growth problems.', 0.00, '1', '2023-09-29 18:32:16', '2023-09-29 18:32:16', NULL),
(47, 2, 'Amylase - Pancreas Panel', '16959979546516e002a0125', 'services/qG0VdEcYXonGn0uiAdTuz2TW0PMZF4TfJm6AQZMz.jpg', 'The amylase test measures the level of amylase, an enzyme produced by the pancreas and salivary glands, in the blood. Amylase plays a role in digesting carbohydrates. Elevated amylase levels can indicate pancreatitis (inflammation of the pancreas), among other conditions. This test helps assess pancreatic function.', 0.00, '1', '2023-09-29 18:32:34', '2023-09-29 18:32:34', NULL),
(48, 2, 'Aspartate Aminotransferase (AST/SGOT) - Liver (Hepatic) Function Panel', '16959979586516e0069598f', 'services/0AhITNr6nAxyfoF8FofC8B4foVWCARt361tAor4y.jpg', 'AST is an enzyme found in various tissues, including the liver and heart. The AST test measures the level of AST in the blood. Elevated AST levels may indicate liver or heart damage, among other conditions. It is often used in conjunction with ALT to assess liver function.', 0.00, '1', '2023-09-29 18:32:38', '2023-09-29 18:32:38', NULL),
(49, 2, 'Lipase - Pancreas Panel', '16959979716516e0132cd1b', 'services/HMfBVY2pKH6dwi17oDVl9hDPYr3wYQr39X5Sp9VT.jpg', 'The lipase test measures the level of lipase, an enzyme produced by the pancreas, in the blood. Lipase is involved in the digestion of fats. Elevated lipase levels are a marker for pancreatitis and can help diagnose and monitor this condition. Lipase testing is particularly useful in assessing pancreatic function and diagnosing pancreatic disorders.', 0.00, '1', '2023-09-29 18:32:51', '2023-09-29 18:32:51', NULL),
(50, 2, 'Bilirubin, Total - Liver (Hepatic) Function Panel', '16959979916516e0278c4cd', 'services/S7Z3qQELsjHYzDXfT8PcfifuDg3n0xaIWx2T9jEo.jpg', 'The total bilirubin test measures the overall amount of bilirubin in the blood. Bilirubin is a waste product produced when red blood cells break down. Abnormal total bilirubin levels can indicate liver or gallbladder problems and may cause jaundice (yellowing of the skin and eyes).', 0.00, '1', '2023-09-29 18:33:11', '2023-09-29 18:33:11', NULL),
(51, 2, 'Total Cholesterol - Lipid Panel', '16959979916516e027c28bd', 'services/FjthSJJPnF9QBByGhNIdibl2Wcg4QUN7NMjUcNyK.jpg', 'The total cholesterol test measures the total amount of cholesterol in the blood, including both high-density lipoprotein (HDL) and low-density lipoprotein (LDL) cholesterol. It is an important assessment of overall cholesterol levels in the body and is used to gauge cardiovascular health.', 0.00, '1', '2023-09-29 18:33:11', '2023-09-29 18:33:11', NULL),
(52, 2, 'Chloride - Kidney (Renal) Function Panel', '16959980086516e03817d25', 'services/toflT4VwF13FOynsAWe3XB5kzWhXaFYl9NR06n3c.jpg', 'The chloride test measures the concentration of chloride ions (Cl-) in the blood. Chloride is an electrolyte that helps maintain proper fluid balance and plays a role in acid-base balance in the body. Abnormal chloride levels can indicate electrolyte imbalances and certain medical conditions.', 0.00, '1', '2023-09-29 18:33:28', '2023-09-29 18:33:28', NULL),
(53, 2, 'Triglycerides - Lipid Panel', '16959980086516e03892dd9', 'services/JjOvwOlSSZmYyhXGlQPMiRGuyQeCAW8yn5Z8Ei1n.jpg', 'The triglycerides test measures the level of triglycerides, which are a type of fat (lipid) found in the blood. Elevated triglyceride levels can be associated with an increased risk of heart disease and are often assessed along with cholesterol levels in lipid panels.', 0.00, '1', '2023-09-29 18:33:28', '2023-09-29 18:33:28', NULL),
(54, 2, 'Bilirubin, Direct - Liver (Hepatic) Function Panel', '16959980156516e03f939cb', 'services/rTvlKaLIzMDIKkDUBZdxqdcLiXp91L4qlUVSq7Yi.jpg', 'The direct bilirubin test specifically measures the level of bilirubin that is directly conjugated (processed) by the liver. Elevated direct bilirubin levels can help identify the cause of jaundice and certain liver diseases.', 0.00, '1', '2023-09-29 18:33:35', '2023-09-29 18:33:35', NULL),
(55, 2, 'HDL Cholesterol (High-Density Lipoprotein Cholesterol) - Lipid Panel', '16959980246516e0481b3d2', 'services/HjREr6BBk7gXuAZb7eUFBuaqmw8CFq1DeJ31UAXU.jpg', 'The HDL cholesterol test measures the level of HDL cholesterol, often referred to as \"good\" cholesterol. HDL cholesterol helps remove excess cholesterol from the bloodstream, reducing the risk of cholesterol buildup in the arteries. Higher levels of HDL cholesterol are generally considered beneficial for heart health.', 0.00, '1', '2023-09-29 18:33:44', '2023-09-29 18:33:44', NULL),
(56, 2, 'Estimated Glomerular Filtration Rate (calculated) - Kidney (Renal) Function Panel', '16959980366516e05459863', 'services/9QlIlpsVBwUddp8AAd1gEGpJKtGKo9nagIKMfSYV.jpg', 'The estimated glomerular filtration rate (eGFR) is not a standalone test but rather a calculated value derived from the results of the creatinine test and other factors. It provides an estimate of how well the kidneys are filtering waste from the blood and serves as a key indicator of overall kidney function.', 0.00, '1', '2023-09-29 18:33:56', '2023-09-29 18:33:56', NULL),
(57, 2, 'Bilirubin, Indirect - Liver (Hepatic) Function Panel', '16959980406516e05804ad2', 'services/qenEXO5o5X12T8H2l3Ro3GFqrgjq4y43oRmO1KDY.jpg', 'The indirect bilirubin test calculates the level of bilirubin that is not directly conjugated by the liver. It is derived by subtracting the direct bilirubin from the total bilirubin. Elevated indirect bilirubin levels may indicate conditions affecting red blood cell breakdown.', 0.00, '1', '2023-09-29 18:34:00', '2023-09-29 18:34:00', NULL),
(58, 2, 'LDL Cholesterol (Low-Density Lipoprotein Cholesterol) - Lipid Panel', '16959980526516e0644f61c', 'services/p0a9jsNnBvPqvrYX42VQw2gfpLjwIfrqgazGnhfF.jpg', 'The LDL cholesterol test measures the level of LDL cholesterol, often referred to as \"bad\" cholesterol. LDL cholesterol can accumulate in the arteries and contribute to plaque formation, increasing the risk of heart disease. Lower LDL cholesterol levels are typically associated with better cardiovascular health.', 0.00, '1', '2023-09-29 18:34:12', '2023-09-29 18:34:12', NULL),
(59, 2, 'Glucose - Kidney (Renal) Function Panel', '16959980606516e06c119a4', 'services/IzNbN5NWE1vmrEi9JkCMqK769Xo44TTUz3dtzKKv.jpg', 'The glucose test measures the concentration of glucose (sugar) in the blood. It is commonly used to diagnose and monitor diabetes mellitus, a condition characterized by high blood sugar levels. Abnormal glucose levels can also indicate other medical conditions.', 0.00, '1', '2023-09-29 18:34:20', '2023-09-29 18:34:20', NULL),
(60, 2, 'Globulin - Liver (Hepatic) Function Panel', '16959980636516e06f4dd50', 'services/aIkZqViogGRmAlR8zn7OifFBYw7UOkiXRDRteC3x.jpg', 'The globulin test measures the concentration of globulins, a group of proteins that include antibodies and transport proteins, in the blood. Changes in total protein and globulin levels can provide insights into immune function and various medical conditions.', 0.00, '1', '2023-09-29 18:34:23', '2023-09-29 18:34:23', NULL),
(61, 2, 'VLDL Cholesterol (Very Low-Density Lipoprotein Cholesterol) - Lipid Panel', '16959980786516e07e9cdc5', 'services/OjLhScGTIHj45eUKAj7FsH0EDzBX0d3RICDcogYx.jpg', 'The VLDL cholesterol test measures the level of VLDL cholesterol, which is a type of lipoprotein that carries triglycerides in the blood. VLDL cholesterol levels are linked to triglyceride levels and can provide insights into the risk of heart disease.', 0.00, '1', '2023-09-29 18:34:38', '2023-09-29 18:34:38', NULL),
(62, 2, 'Total Protein - Liver (Hepatic) Function Panel', '16959980866516e0862ef8e', 'services/rSpLHD1fCf8PXkQoxxd0nnL3G6265w2Egqdp9bh2.jpg', 'The total protein test measures the total concentration of proteins, including albumin and globulins, in the blood. It helps evaluate overall nutritional status and liver or kidney function. Abnormal protein levels may indicate various medical conditions.', 0.00, '1', '2023-09-29 18:34:46', '2023-09-29 18:34:46', NULL),
(63, 2, 'Phosphorus - Kidney (Renal) Function Panel', '16959980936516e08d27e2e', 'services/HJ7NOMXbuMGky5rPezeVz8j5FRVztCTTVr9B3Po9.jpg', 'The phosphorus test measures the level of phosphorus in the blood. Phosphorus is essential for bone health, energy metabolism, and various cellular processes. Abnormal phosphorus levels can be associated with bone disorders, kidney disease, and other health conditions.', 0.00, '1', '2023-09-29 18:34:53', '2023-09-29 18:34:53', NULL),
(64, 2, 'T4 (Thyroxine) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959981376516e0b9aa285', 'services/OJmVGeHDrWkyD7TGlRDkSiC5RSzjcoOIMVBrvfex.jpg', 'The T4 test measures the level of thyroxine, a thyroid hormone produced by the thyroid gland. T4 plays a crucial role in regulating metabolism and overall body function. Abnormal T4 levels can indicate thyroid dysfunction, including hypothyroidism (low levels) or hyperthyroidism (high levels).', 0.00, '1', '2023-09-29 18:35:37', '2023-09-29 18:35:37', NULL),
(65, 2, 'Total Cholesterol - LIPID PANEL WITH LDL', '16959981556516e0cbcc24a', 'services/rbAG7cLtOM7TQ7fsR5XLN86IZpiTeO5jg2XUWqlX.jpg', 'The total cholesterol test measures the overall amount of cholesterol in the blood, including high-density lipoprotein (HDL), low-density lipoprotein (LDL), and very low-density lipoprotein (VLDL) cholesterol. It provides a comprehensive assessment of cholesterol levels in the body and is used to evaluate cardiovascular health.', 0.00, '1', '2023-09-29 18:35:55', '2023-09-29 18:35:55', NULL),
(66, 2, 'T3 (Triiodothyronine) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959981626516e0d27a00b', 'services/jRv2BL8oTXMi92jMIPr8iIrwEnxyyZ17BVNXGF1k.jpg', 'The T3 test measures the level of triiodothyronine, another thyroid hormone produced by the thyroid gland. T3 is responsible for controlling metabolism and energy production in the body. Abnormal T3 levels can be indicative of thyroid disorders.', 0.00, '1', '2023-09-29 18:36:02', '2023-09-29 18:36:02', NULL),
(67, 2, 'Triglycerides - LIPID PANEL WITH LDL', '16959981766516e0e035aa6', 'services/UUbCx2ccQxajUT3hzEZyw8ux57INmdPUR7nPDZWj.jpg', 'The triglycerides test measures the level of triglycerides, which are a type of fat (lipid) found in the blood. Elevated triglyceride levels can increase the risk of heart disease and are often assessed alongside cholesterol levels in lipid panels.', 0.00, '1', '2023-09-29 18:36:16', '2023-09-29 18:36:16', NULL),
(68, 2, 'Vitamin B12 Test - Male Hormone Panel (Comprehensive)', '16959981796516e0e307d21', 'services/JqDPJ4LwalRjNxGA8iFplbyjr62AF2Nc8GlViPUM.jpg', 'The Vitamin B12 test measures the level of vitamin B12 in the blood. Vitamin B12 is essential for various bodily functions, including nerve health and the production of red blood cells. Abnormal B12 levels can indicate deficiencies or other health issues.', 0.00, '1', '2023-09-29 18:36:19', '2023-09-29 18:36:19', NULL),
(69, 2, 'TSH (Thyroid-Stimulating Hormone) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959981846516e0e878d74', 'services/qwdyJ2G9fT27NyWmCmz0rG2rkcy49uBXJsLw3mHw.jpg', 'The TSH test measures the level of thyroid-stimulating hormone produced by the pituitary gland. TSH regulates the thyroid gland\'s production of T4 and T3. Elevated TSH levels often suggest hypothyroidism, while low TSH levels may indicate hyperthyroidism.', 0.00, '1', '2023-09-29 18:36:24', '2023-09-29 18:36:24', NULL),
(70, 2, 'HDL Cholesterol (High-Density Lipoprotein Cholesterol) - LIPID PANEL WITH LDL', '16959981996516e0f79583b', 'services/AzKFPoPG44mW3x11mOD8cZMthO1BltnNg1Bx15Zy.jpg', 'The HDL cholesterol test measures the level of HDL cholesterol, often referred to as \"good\" cholesterol. HDL cholesterol helps remove excess cholesterol from the bloodstream, reducing the risk of cholesterol buildup in the arteries. Higher levels of HDL cholesterol are generally considered beneficial for heart health.', 0.00, '1', '2023-09-29 18:36:39', '2023-09-29 18:36:39', NULL),
(71, 2, 'Folic Acid (Folate or Vitamin B9) Test - Male Hormone Panel (Comprehensive)', '16959982136516e1056cf51', 'services/GvD0HYVPa94cExp3TmEASFPazEKJyMHqO7NyDktL.jpg', 'The Folic Acid test measures the level of folic acid (vitamin B9) in the blood. Folate is vital for cell growth and the synthesis of DNA. Abnormal folate levels can impact overall health, especially during pregnancy.', 0.00, '1', '2023-09-29 18:36:53', '2023-09-29 18:37:16', NULL),
(72, 2, 'Free T3 (Free Triiodothyronine) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959982146516e10601659', 'services/0dt0mt7VMRnzkHdgBWAiGHUy0jzKN1ZIfMJMVUxw.jpg', 'The free T3 test measures the level of unbound or \"free\" triiodothyronine, which is the active form of thyroid hormone in the body. Free T3 levels help assess thyroid function and are particularly useful in diagnosing and monitoring hyperthyroidism.', 0.00, '1', '2023-09-29 18:36:54', '2023-09-29 18:36:54', NULL),
(73, 2, 'LDL Cholesterol (Low-Density Lipoprotein Cholesterol) - LIPID PANEL WITH LDL', '16959982156516e1070f23c', 'services/F271Qed6w7spLtWRCI9Eb0CsSyJJ1Wrmww2dl9rU.jpg', 'The LDL cholesterol test measures the level of LDL cholesterol, often referred to as \"bad\" cholesterol. LDL cholesterol can accumulate in the arteries and contribute to plaque formation, increasing the risk of heart disease. Lower LDL cholesterol levels are typically associated with better cardiovascular health.', 0.00, '1', '2023-09-29 18:36:55', '2023-09-29 18:36:55', NULL),
(74, 2, 'VLDL Cholesterol (Very Low-Density Lipoprotein Cholesterol) - LIPID PANEL WITH LDL', '16959982316516e1175a5df', 'services/hjXBzj7OEle5kTLr9JCzUwEIVPdTv1KrRle2l6VI.jpg', 'The VLDL cholesterol test measures the level of VLDL cholesterol, which is a type of lipoprotein that carries triglycerides in the blood. VLDL cholesterol levels are linked to triglyceride levels and can provide insights into the risk of heart disease.', 0.00, '1', '2023-09-29 18:37:11', '2023-09-29 18:37:35', '2023-09-29 18:37:35'),
(75, 2, 'VLDL Cholesterol (Very Low-Density Lipoprotein Cholesterol) - LIPID PANEL WITH LDL', '16959982316516e117db173', 'services/Wbgl95z9VXtcCHOOOd2I4M8QWHprB33t6ibzr6vF.jpg', 'The VLDL cholesterol test measures the level of VLDL cholesterol, which is a type of lipoprotein that carries triglycerides in the blood. VLDL cholesterol levels are linked to triglyceride levels and can provide insights into the risk of heart disease.', 0.00, '1', '2023-09-29 18:37:11', '2023-09-29 18:37:11', NULL),
(76, 2, 'Free T4 (Free Thyroxine) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959982376516e11d46d85', 'services/HdOni5yOel6lkmpZCo0pI5HF7JRecaE8wxk1x2Ob.jpg', 'The free T4 test measures the level of unbound or \"free\" thyroxine, which is the active form of thyroid hormone in the body. Free T4 levels are crucial for evaluating thyroid function and diagnosing hypothyroidism.', 0.00, '1', '2023-09-29 18:37:17', '2023-09-29 18:37:17', NULL),
(77, 2, 'Homocysteine Test - Male Hormone Panel (Comprehensive)', '16959982576516e13165963', 'services/ZFhezve1FDJfTbaYBU1ry3QSzUV9v8Qji2GfYys9.jpg', 'The Homocysteine test measures the level of homocysteine in the blood. Elevated homocysteine levels are associated with an increased risk of heart disease and may indicate certain vitamin deficiencies.', 0.00, '1', '2023-09-29 18:37:37', '2023-09-29 18:37:37', NULL),
(78, 2, 'T Uptake (Thyroid Uptake Test) - Thyroid Function Tests (TFTs) OR Thyroid Panel', '16959982616516e135ce816', 'services/WNenST0bM7UYIVitekllyJmQqH2qKTrNRpTYged8.jpg', 'The T uptake test measures how much radioactive iodine the thyroid gland takes up from the bloodstream. It is often used in conjunction with other thyroid tests to assess thyroid function and diagnose certain thyroid conditions, such as hyperthyroidism.', 0.00, '1', '2023-09-29 18:37:41', '2023-09-29 18:37:41', NULL),
(79, 2, 'High Sensitivity C-Reactive Protein (CRP) Test - Male Hormone Panel (Comprehensive)', '16959982876516e14f34e65', 'services/mbyIZqmNo7W09l7uOzz3fOKL04DByiaxg7fo2ViZ.jpg', 'The High Sensitivity CRP test measures the level of CRP, a marker of inflammation, in the blood. Elevated CRP levels can suggest underlying inflammation and may be a risk factor for cardiovascular disease.', 0.00, '1', '2023-09-29 18:38:07', '2023-09-29 18:38:07', NULL),
(80, 2, 'Anti TG (Anti Thyroglobulin Antibody – available upon request) - Thyroid Function Tests (TFTs)', '16959983146516e16a6e512', 'services/kY5nVZx488d3CAjADI1sxwAhoWI4gnXPXkIOb1qw.jpg', 'The anti-thyroglobulin antibody test detects antibodies against thyroglobulin, a protein produced by the thyroid gland. Elevated levels of anti-thyroglobulin antibodies are associated with autoimmune thyroid diseases, such as Hashimoto\'s thyroiditis.', 0.00, '1', '2023-09-29 18:38:34', '2023-09-29 18:38:34', NULL),
(81, 2, 'DIRECT LDL (Direct Low-Density Lipoprotein Cholesterol) - LIPID PANEL WITH LDL', '16959983346516e17e5bf45', 'services/fyLWnBJtl7Fyy8pv5MWnqJc4TKB6qTqhCfGRnJWX.jpg', 'The DIRECT LDL test measures LDL cholesterol directly, without relying on calculations. This method provides a more precise measurement of LDL cholesterol levels and is useful for evaluating cardiovascular risk. It is particularly valuable when LDL cholesterol levels are borderline or when accuracy is crucial for treatment decisions.', 0.00, '1', '2023-09-29 18:38:54', '2023-09-29 18:38:54', NULL),
(82, 2, 'Hemoglobin A1c (HBA1C) - Male Hormone Panel (Comprehensive)', '16959983506516e18ec38f9', 'services/VAP0U5euYnFvXIjR33moOB8xMFFxA5tyedPOAB9b.jpg', 'Hemoglobin A1c is a test that reflects the average blood sugar levels over the past two to three months. It is used to monitor and manage diabetes and assess long-term blood sugar control.', 0.00, '1', '2023-09-29 18:39:10', '2023-09-29 18:39:10', NULL),
(83, 2, 'Anti TPO (Anti Thyroid Peroxidase Antibody – available upon request) - Thyroid Function Tests (TFTs)', '16959983576516e1958c8f2', 'services/q8a7NIUVh6YoiiQsP0pBGDn1bWL7OIiNkEu3I3vN.jpg', 'The anti-thyroid peroxidase antibody test measures the level of antibodies against thyroid peroxidase, an enzyme involved in thyroid hormone production. Elevated levels of anti-TPO antibodies are often seen in autoimmune thyroid conditions, including Hashimoto\'s thyroiditis and Graves\' disease.', 0.00, '1', '2023-09-29 18:39:17', '2023-09-29 18:39:17', NULL),
(84, 2, 'Alanine Aminotransferase (ALT) Test - Male Hormone Panel (Comprehensive)', '16959983786516e1aa76d03', 'services/hMuga7WoUfP5silVUunzMfyDmn6abTlyP9biK2Nb.jpg', 'The ALT test measures the level of the enzyme ALT in the blood. ALT is primarily found in the liver, and elevated levels may indicate liver damage or disease.', 0.00, '1', '2023-09-29 18:39:38', '2023-09-29 18:39:38', NULL),
(85, 2, 'Lipid Panel - Female Hormone Panel (Comprehensive)', '16959983806516e1acae9be', 'services/98zfszYyOpAHDUXtNLZy1nU5pIC7eVrxBGzq0El3.jpg', 'The Lipid Panel assesses cholesterol levels in the blood, including total cholesterol, HDL cholesterol, LDL cholesterol, and triglycerides. It is used to evaluate cardiovascular health and the risk of heart disease.', 0.00, '1', '2023-09-29 18:39:40', '2023-09-29 18:39:40', NULL),
(86, 2, 'Lipid Panel - Cardiac Panel', '16959983896516e1b5d7f28', 'services/dLFWSJAdAHn4wXL7Bz7Oj1NvX35wW1zMlZaEYmlT.jpg', 'The Lipid Panel assesses cholesterol levels in the blood, including total cholesterol, HDL cholesterol, LDL cholesterol, and triglycerides. It is used to evaluate cardiovascular health and the risk of heart disease.', 0.00, '1', '2023-09-29 18:39:49', '2023-09-29 18:39:49', NULL),
(87, 2, 'Comprehensive Metabolic Panel (CMP) - Female Hormone Panel (Comprehensive)', '16959984036516e1c3866e1', 'services/5RFwahuR3sOXxp5OQMx25LHDGTbWRK3IHWyGML4q.jpg', 'The Comprehensive Metabolic Panel includes a series of tests that assess various aspects of metabolic health, such as glucose, electrolytes, and kidney function. It provides valuable information about overall health.', 0.00, '1', '2023-09-29 18:40:03', '2023-09-29 18:40:03', NULL),
(88, 2, 'Dehydroepiandrosterone (DHEA) Sulfate Test - Male Hormone Panel (Comprehensive)', '16959984066516e1c63b087', 'services/fozXlUhPDP3S9smxU2Hhv7kTdu2KMhfQYexeWic4.jpg', 'The DHEA-S test measures the level of DHEA sulfate, a hormone produced by the adrenal glands. It can provide insights into adrenal gland function and hormonal balance.', 0.00, '1', '2023-09-29 18:40:06', '2023-09-29 18:40:06', NULL),
(89, 2, 'Comprehensive Metabolic Panel (CMP) - Cardiac Panel', '16959984086516e1c837e93', 'services/6QOCH7YMaM0o6m8MOsvedvRC3UtlCr9qKe9UpmmZ.jpg', 'The Comprehensive Metabolic Panel includes a series of tests that assess various aspects of metabolic health, such as glucose, electrolytes, and kidney function. It provides valuable information about overall health.', 0.00, '1', '2023-09-29 18:40:08', '2023-09-29 18:40:08', NULL),
(90, 2, 'Complete Blood Count (CBC) - Female Hormone Panel (Comprehensive)', '16959984256516e1d932387', 'services/Cz6Sqiq3NfyRY0TvnWw4uT4NacU7HufSdKUIlqWa.jpg', 'The Complete Blood Count measures various components of the blood, including red blood cells, white blood cells, and platelets. It helps diagnose anemia, infection, and other blood disorders.', 0.00, '1', '2023-09-29 18:40:25', '2023-09-29 18:40:25', NULL),
(91, 2, 'Testosterone - Male Hormone Panel (Comprehensive)', '16959984296516e1dd5a26a', 'services/ga6wPx0FGvumP6ACA59ZQeQVHqXNMts0XlWDwvgL.jpg', 'The Testosterone test measures the level of testosterone, the primary male sex hormone. It is essential for various male characteristics, including muscle mass, bone density, and libido. Abnormal testosterone levels can indicate hormonal imbalances or other health conditions.', 0.00, '1', '2023-09-29 18:40:29', '2023-09-29 18:40:29', NULL),
(92, 2, 'Routine Urinalysis - Cardiac Panel', '16959984386516e1e6ddefe', 'services/HMGlaXEEqoumYDkF5VtnPMtiwoaVVx5XJrXU205k.jpg', 'Routine Urinalysis examines the physical and chemical properties of urine. It can help detect kidney disease, urinary tract infections, and other health conditions.', 0.00, '1', '2023-09-29 18:40:38', '2023-09-29 18:40:55', NULL),
(93, 2, 'Routine Urinalysis (UA) - Female Hormone Panel (Comprehensive)', '16959984456516e1ed26e22', 'services/SPTsgMzVESgbwvRJxDFpigwGR3JDErEtEkg2QczM.jpg', 'Routine Urinalysis examines the physical and chemical properties of urine. It can help detect kidney disease, urinary tract infections, and other health conditions.', 0.00, '1', '2023-09-29 18:40:45', '2023-09-29 18:40:45', NULL),
(94, 2, 'Testosterone - Female Hormone Panel (Comprehensive)', '16959984716516e20705000', 'services/12boXkBFTwmzMhQen5fB5JLd2bZOoB7wtuqIDXBA.jpg', 'The Testosterone test measures the level of testosterone, the primary male sex hormone. In females, it is essential for various functions, including maintaining bone density and libido. Abnormal testosterone levels can indicate hormonal imbalances or other health conditions.', 0.00, '1', '2023-09-29 18:41:11', '2023-09-29 18:41:11', NULL),
(95, 2, 'Complete Blood Count (CBC) - Cardiac Panel', '16959984746516e20a41fe5', 'services/1in6GJC71AwOlvpXIYAhyq7J5MW7z91F3W6TupCw.jpg', 'The Complete Blood Count measures various components of the blood, including red blood cells, white blood cells, and platelets. It helps diagnose anemia, infection, and other blood disorders.', 0.00, '1', '2023-09-29 18:41:14', '2023-09-29 18:41:14', NULL),
(96, 2, 'C-Reactive Protein (CRP) - Cardiac Panel', '16959984896516e2194a7b0', 'services/l4VlBeffl0hZD4vYn6bDZ4AyhsOyEjEkFtRPPAVH.jpg', 'The C-Reactive Protein (CRP) test measures the level of CRP, a marker of inflammation, in the blood. Elevated CRP levels can suggest underlying inflammation and may be a risk factor for cardiovascular disease.', 0.00, '1', '2023-09-29 18:41:29', '2023-09-29 18:41:29', NULL),
(97, 2, 'Estradiol - Female Hormone Panel (Comprehensive)', '16959984956516e21f00f80', 'services/cwePpbFKPiCvtitr8m1Qk0bC85E05MSibieP7N7A.jpg', 'The Estradiol test measures the level of estradiol, a form of estrogen, in the blood. Estradiol is a key hormone in the female reproductive system and plays a role in menstrual cycle regulation and bone health.', 0.00, '1', '2023-09-29 18:41:35', '2023-09-29 18:41:35', NULL),
(98, 2, 'Urine Pregnancy Test - Pregnancy Test', '16959984976516e221277da', 'services/vtlYNI7yigBzdTV0sHrHU6S8eVErW4WbYxvLuSLo.jpg', 'The Urine Pregnancy Test detects the presence of human chorionic gonadotropin (hCG), a hormone produced during pregnancy, in the urine. It is a common at-home pregnancy test.', 0.00, '1', '2023-09-29 18:41:37', '2023-09-29 18:41:37', NULL),
(99, 2, 'Troponin - Cardiac Panel', '16959985076516e22b7fd57', 'services/dW1PhVrBImMMABUCFSkZTpNnacXuyE1qaoJbkWr7.jpg', 'The Troponin test measures the level of troponin, a protein released into the bloodstream during heart muscle damage. It is a critical marker for diagnosing heart attacks and evaluating cardiac health.', 0.00, '1', '2023-09-29 18:41:47', '2023-09-29 18:41:47', NULL),
(100, 2, 'Thyroid Panel - Female Hormone Panel (Comprehensive)', '16959985206516e238087aa', 'services/llOTktuuuXdRfjGo5ZA8yOYfNzznn05la6q9zLkN.jpg', 'The Thyroid Panel includes tests such as TSH, T4, and T3 to assess thyroid function. Thyroid hormones play a critical role in metabolism and overall health.', 0.00, '1', '2023-09-29 18:42:00', '2023-09-29 18:42:00', NULL),
(101, 2, 'B HCG Qualitative (Beta Human Chorionic Gonadotropin) - Pregnancy Test', '16959985226516e23a144d3', 'services/zCb6ZYjNxIzO88O5632bpACfxf7Non95cBPjByK9.jpg', 'The B HCG Qualitative test confirms pregnancy by detecting the presence of hCG in the blood. It provides a simple \"yes\" or \"no\" result.', 0.00, '1', '2023-09-29 18:42:02', '2023-09-29 18:42:02', NULL),
(102, 2, 'Homocysteine - Cardiac Panel', '16959985256516e23d53328', 'services/6J147ZJv7E5LvO98VnxAGyy6McqTQ8DvgrtfOwoY.jpg', 'The Homocysteine test measures the level of homocysteine in the blood. Elevated homocysteine levels are associated with an increased risk of heart disease and may indicate certain vitamin deficiencies.', 0.00, '1', '2023-09-29 18:42:05', '2023-09-29 18:42:05', NULL),
(103, 2, 'Uric Acid - Female Hormone Panel (Comprehensive)', '16959985386516e24a8f362', 'services/nMU81y6gqpCBxkUHZEvHlxN1Y11YGBenHf62jmnK.jpg', 'The Uric Acid test measures the level of uric acid in the blood. Elevated uric acid levels are associated with gout and may indicate kidney dysfunction.', 0.00, '1', '2023-09-29 18:42:18', '2023-09-29 18:42:18', NULL),
(104, 2, 'Lipoprotein - Cardiac Panel', '16959985426516e24ee836e', 'services/43LshknO66EvjXAMgDcqXKNQQbJ08fqmpEWL6SEY.jpg', 'The Lipoprotein test assesses lipoprotein particles in the blood. It can provide detailed information about cholesterol and triglyceride levels, aiding in cardiovascular risk assessment.', 0.00, '1', '2023-09-29 18:42:22', '2023-09-29 18:42:22', NULL),
(105, 2, 'CK-MB (Creatine Kinase-MB) - Cardiac Panel', '16959985606516e2601c8bb', 'services/VsGfoBJHmfCsINlPoCZQxKsMrwTzkXst9XEHyHQh.jpg', 'The CK-MB test measures the level of creatine kinase-MB, an enzyme found in heart muscle cells. Elevated CK-MB levels can indicate heart muscle damage, such as a heart attack.', 0.00, '1', '2023-09-29 18:42:40', '2023-09-29 18:42:40', NULL),
(106, 2, 'Human Growth Hormone (hGH)/Growth Hormone (GH) - Female Hormone Panel (Comprehensive)', '16959985666516e2661ea78', 'services/TbqKobJE7Cuwu4BcMuoTtFZuXXKYailfaPl6mM3J.jpg', 'The hGH/GH test measures the level of human growth hormone. It is important for growth and development and can help diagnose growth disorders.', 0.00, '1', '2023-09-29 18:42:46', '2023-09-29 18:42:46', NULL),
(107, 2, 'Human Growth Hormone (hGH)/Growth Hormone (GH) - Female Hormone Panel (Comprehensive)', '16959985686516e268251fb', 'services/EmI9F289CQo3gtasfwZ8b8dsObXge9dqWkPUQdpo.jpg', 'The hGH/GH test measures the level of human growth hormone. It is important for growth and development and can help diagnose growth disorders.', 0.00, '1', '2023-09-29 18:42:48', '2023-09-29 19:13:29', '2023-09-29 19:13:29'),
(108, 2, 'B HCG Quantitative (Beta Human Chorionic Gonadotropin Quantitative) - Pregnancy Test', '16959985686516e268f19a6', 'services/APJofE1WFW6aLJUfzQdJAa6WZNjer8ruj0JCsTTb.jpg', 'The B HCG Quantitative test measures the precise level of hCG in the blood. It is used to monitor the progression of pregnancy and assess pregnancy complications.', 0.00, '1', '2023-09-29 18:42:48', '2023-09-29 18:42:48', NULL),
(109, 2, 'Estrogens - Female Hormone Panel (Comprehensive)', '16959985926516e280deb92', 'services/SrSkAmgcK8UCc97Kc5qp4bIE9LmNVdKhFcazYjaI.jpg', 'The Estrogens test measures the level of estrogen hormones, which are essential for female reproductive health and secondary sexual characteristics.', 0.00, '1', '2023-09-29 18:43:12', '2023-09-29 18:43:12', NULL),
(110, 2, 'Iron - Iron Studies', '16959986056516e28d7f7f1', 'services/7KfOyzixpm75ZRCfJsWnd55hgrIjPyNGt23s00OR.jpg', 'The Iron test measures the level of iron in the blood. Iron is essential for red blood cell production and overall health.', 0.00, '1', '2023-09-29 18:43:25', '2023-09-29 18:43:25', NULL),
(111, 2, 'Glucose Tolerance Test (GTT) ordered during pregnancy - Pregnancy Test', '16959986066516e28e0e4b6', 'services/VC6JWAI3vLofwWvWrtPfjxy2o3HiAvc4wIaVqDB3.jpg', 'The Glucose Tolerance Test evaluates how the body processes glucose (sugar) and is used to diagnose gestational diabetes during pregnancy.', 0.00, '1', '2023-09-29 18:43:26', '2023-09-29 18:43:26', NULL);
INSERT INTO `services` (`id`, `user_id`, `title`, `slug`, `image_url`, `description`, `amount`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(112, 2, 'Progesterone - Female Hormone Panel (Comprehensive)', '16959986146516e296b7ea5', 'services/vh1X70Q6PFSe1n1cgjOevZFxWw3CxdMIq05qPGp9.jpg', 'The Progesterone test measures the level of progesterone, a hormone involved in the menstrual cycle and pregnancy. It is essential for maintaining the uterine lining.', 0.00, '1', '2023-09-29 18:43:34', '2023-09-29 18:43:34', NULL),
(113, 2, 'Transferrin - Iron Studies', '16959986306516e2a62c3c2', 'services/R4q1eUba355w2tnDAISySzrq3d0e3Ewba42YfoFa.jpg', 'The Transferrin test measures the level of transferrin, a protein that transports iron in the blood. It can provide insights into iron metabolism.', 0.00, '1', '2023-09-29 18:43:50', '2023-09-29 18:43:50', NULL),
(114, 2, 'LH and FSH - Female Hormone Panel (Comprehensive)', '16959986726516e2d08c569', 'services/4FxkeheCLDywa1QP3iAykqDYPd3Pb9tYfozL853Y.jpg', 'LH and FSH tests measure the levels of these hormones, which play a role in regulating the menstrual cycle and reproductive health.', 0.00, '1', '2023-09-29 18:44:32', '2023-09-29 18:44:32', NULL),
(115, 2, 'Total Iron Binding Capacity (TIBC) - Iron Studies', '16959986736516e2d15097b', 'services/ZX8vtPaamePRUJtfGQT7X8uRDKTtQmVORL8Ap68H.jpg', 'The TIBC test assesses the blood\'s capacity to bind and transport iron. It is used to diagnose and monitor iron-related disorders.', 0.00, '1', '2023-09-29 18:44:33', '2023-09-29 18:44:33', NULL),
(116, 2, 'PT/INR (Prothrombin Time/International Normalized Ratio) - Coagulation Panel', '16959986866516e2ded5c44', 'services/5d9MlTnmw0TMMZt8f4WArPRaKPhtDAxSuS9a8amP.jpg', 'The PT/INR test measures blood clotting time and is used to monitor the effects of anticoagulant medications like warfarin.', 0.00, '1', '2023-09-29 18:44:46', '2023-09-29 18:44:46', NULL),
(117, 2, '% Saturation (Transferrin Saturation) - Iron Studies', '16959986936516e2e5727a3', 'services/cZEdE3trRdwWTtPTyKKFYx0udXB2rBe8bat4CrHY.jpg', 'The % Saturation test calculates the percentage of transferrin binding sites occupied by iron. It helps evaluate iron status and can be used to diagnose iron disorders.', 0.00, '1', '2023-09-29 18:44:53', '2023-09-29 18:44:53', NULL),
(118, 2, 'Hemoglobin A1 (HBA1C) - Female Hormone Panel (Comprehensive)', '16959986986516e2ea370e7', 'services/ZuFtTjmtxMM8q1j7jIcmR1a3TjWLWW9u93WFKj4f.jpg', 'Hemoglobin A1c is a test that reflects the average blood sugar levels over the past two to three months. It is used to monitor and manage diabetes and assess long-term blood sugar control.', 0.00, '1', '2023-09-29 18:44:58', '2023-09-29 18:44:58', NULL),
(119, 2, 'DHEA-S (Dehydroepiandrosterone Sulfate) - Female Hormone Panel (Comprehensive)', '16959987216516e301784f1', 'services/UL889osJbyDi0ZuejHEanL685Z4WCTvxGa0OIo7w.jpg', 'The DHEA-S test measures the level of DHEA sulfate, a hormone produced by the adrenal glands. It can provide insights into adrenal gland function and hormonal balance.', 0.00, '1', '2023-09-29 18:45:21', '2023-09-29 18:45:21', NULL),
(120, 2, 'Anti HBc (Antibodies to Hepatitis B Core Antigen) - Hepatitis Panel', '16959987276516e30796dfc', 'services/0cX67TpzGyHolOSv86Z3RNkyx0ziyfa9ogTdIWgY.jpg', 'The Anti HBc test detects antibodies to the hepatitis B core antigen and helps diagnose hepatitis B infection.', 0.00, '1', '2023-09-29 18:45:27', '2023-09-29 18:45:27', NULL),
(121, 2, 'APTT (Activated Partial Thromboplastin Time) - Coagulation Panel', '16959987306516e30a2c133', 'services/kGN0jtZf8U13Ff0WumVVfS3m4UOeO6DeJ1g8nmGx.jpg', 'The APTT test assesses blood clotting factors and helps diagnose bleeding disorders or monitor anticoagulant therapy.', 0.00, '1', '2023-09-29 18:45:30', '2023-09-29 18:45:30', NULL),
(122, 2, 'Anti-HBc IgM (IgM Antibodies to Hepatitis B Core Antigen) - Hepatitis Panel', '16959987426516e31655883', 'services/MTUAV8TyiGnNC6OQW2TacTQ4ieY1AA2ODnAk7PeH.jpg', 'The Anti-HBc IgM test specifically detects IgM antibodies to hepatitis B core antigen and is used to diagnose recent hepatitis B infection.', 0.00, '1', '2023-09-29 18:45:42', '2023-09-29 18:45:42', NULL),
(123, 2, 'Vitamin B12 - Female Hormone Panel (Comprehensive)', '16959987566516e32418804', 'services/0UAUyJPN7xvg8amwWo6ZlEalT4eHoVMxWIJnXDdR.jpg', 'The Vitamin B12 test measures the level of vitamin B12 in the blood. Vitamin B12 is essential for various bodily functions, including nerve health and the production of red blood cells. Abnormal B12 levels can indicate deficiencies or other health issues.', 0.00, '1', '2023-09-29 18:45:56', '2023-09-29 18:45:56', NULL),
(124, 2, 'CBC (Complete Blood Count) - Coagulation Panel', '16959987586516e326a4db4', 'services/DRd8IdVVT2rG7Bb9Pikr9kgULGAe34awJ8Xqbco6.jpg', 'The Complete Blood Count measures various components of the blood, including red blood cells, white blood cells, and platelets. It aids in diagnosing blood disorders.', 0.00, '1', '2023-09-29 18:45:58', '2023-09-29 18:45:58', NULL),
(125, 2, 'Anti-HBs (Antibodies to Hepatitis B Surface Antigen) - Hepatitis Panel', '16959987596516e3271a607', 'services/UiHLxzpbc5FT4mZTsHEQhFA7a2RdVkqEeKhI0l9S.jpg', 'The Anti-HBs test detects antibodies to the hepatitis B surface antigen and indicates immunity to hepatitis B or a prior vaccination.', 0.00, '1', '2023-09-29 18:45:59', '2023-09-29 18:45:59', NULL),
(126, 2, 'Folic Acid (Folates) - Female Hormone Panel (Comprehensive)', '16959987826516e33e0f4e3', 'services/4blkkkjOKmcZ4PXM5nC68b4Jca51zJvxJpLvxPg3.jpg', 'The Folic Acid test measures the level of folic acid (vitamin B9) in the blood. Folate is vital for cell growth and the synthesis of DNA. Abnormal folate levels can impact overall health, especially during pregnancy.', 0.00, '1', '2023-09-29 18:46:22', '2023-09-29 18:46:22', NULL),
(127, 2, 'Anti HCV (Antibodies to Hepatitis C Virus) - Hepatitis Panel', '16959987926516e34891ae8', 'services/G2J2BUoI2OKg4N7mfDvVBWNDWXzr0VvKDeEQ08cW.jpg', 'The Anti HCV test detects antibodies to hepatitis C virus and helps diagnose hepatitis C infection.', 0.00, '1', '2023-09-29 18:46:32', '2023-09-29 18:46:32', NULL),
(128, 2, 'Platelet - Coagulation Panel', '16959987926516e348ba976', 'services/wqhvpbbr9zDz8Y1DVa3KNyzUygmg249dPNaJWY2F.jpg', 'The Platelet count measures the number of platelets in the blood. Platelets are essential for blood clotting and wound healing.', 0.00, '1', '2023-09-29 18:46:32', '2023-09-29 18:46:32', NULL),
(129, 2, 'Homocysteine - Female Hormone Panel (Comprehensive)', '16959988036516e3538de2c', 'services/CfxP2ulPngPmC9Awjf3ASusT5R0sxO3Z44ZfCxd6.jpg', 'The Homocysteine test measures the level of homocysteine in the blood. Elevated homocysteine levels are associated with an increased risk of heart disease and may indicate certain vitamin deficiencies.', 0.00, '1', '2023-09-29 18:46:43', '2023-09-29 18:46:43', NULL),
(130, 2, 'C-Reactive Protein (CRP) - Female Hormone Panel (Comprehensive)', '16959988286516e36c08b0b', 'services/Jnky0eA8oHofQjY7ZCgrkCXXT8aV5pxUM29a8E8h.jpg', 'The C-Reactive Protein (CRP) test measures the level of CRP, a marker of inflammation, in the blood. Elevated CRP levels can suggest underlying inflammation and may be a risk factor for cardiovascular disease.', 0.00, '1', '2023-09-29 18:47:08', '2023-09-29 18:47:08', NULL),
(131, 2, 'B12 (Vitamin B12) - Vitamin Panel', '16959988626516e38e81382', 'services/ruv24Ow8jVMKtWO9URzDdDvTDItlhRRhWA6PKQuv.jpg', 'The B12 test measures the level of vitamin B12 in the blood. Vitamin B12 is essential for nerve function, red blood cell production, and overall health.', 0.00, '1', '2023-09-29 18:47:42', '2023-09-29 18:47:42', NULL),
(132, 2, 'AFP (Alpha-Fetoprotein) - Oncology Screening Panel', '16959988626516e38eb5ec3', 'services/AQMa1ZwOk8hOQI5qQTgkFnsxa4olJuFK4I6ewBGP.jpg', 'The AFP test measures the level of alpha-fetoprotein, a protein associated with certain cancers, including liver cancer and testicular cancer.', 0.00, '1', '2023-09-29 18:47:42', '2023-09-29 18:47:42', NULL),
(133, 2, 'Total PSA (Prostate-Specific Antigen) - Prostate Screening', '16959988656516e39161d75', 'services/okWqlHLGmNcOJix5Lgj3xGiZ5ijPEBcBKPc7XCiu.jpg', 'The Total PSA test measures the level of PSA in the blood. Elevated PSA levels may indicate prostate conditions, including prostate cancer.', 0.00, '1', '2023-09-29 18:47:45', '2023-09-29 18:47:45', NULL),
(134, 2, 'Vitamin D - Vitamin Panel', '16959988836516e3a39aead', 'services/PS285Az5a1p0masSBj0JldvFklweam8iExr3iwYj.jpg', 'The Vitamin D test measures the level of vitamin D in the blood. Vitamin D is crucial for bone health, immune function, and other bodily processes.', 0.00, '1', '2023-09-29 18:48:03', '2023-09-29 18:48:03', NULL),
(135, 2, 'Free PSA (Free Prostate-Specific Antigen) - Prostate Screening', '16959988876516e3a76dfda', 'services/E8ENH7mhvC8fiiYBWSUXJsgJdS80Ti1jN6j2SJCq.jpg', 'The Free PSA test measures the level of unbound PSA in the blood. It can help differentiate between benign prostate conditions and prostate cancer.', 0.00, '1', '2023-09-29 18:48:07', '2023-09-29 18:48:07', NULL),
(136, 2, 'CA 125 (Cancer Antigen 125) - Oncology Screening Panel', '16959989036516e3b731a29', 'services/pAVYMLW66fxXutZKYRXX9ZKin392y4kW277XtR07.jpg', 'The CA 125 test measures the level of CA 125 antigen, which is often elevated in ovarian cancer and other gynecological cancers.', 0.00, '1', '2023-09-29 18:48:23', '2023-09-29 18:48:23', NULL),
(137, 2, 'Folate - Vitamin Panel', '16959989076516e3bb5a258', 'services/TvQB3fFcGLqcMIs9wutydHe0tNT6fYHXCADkaJgP.jpg', 'The Folate test measures the level of folate (vitamin B9) in the blood. Folate is essential for cell growth and DNA synthesis.', 0.00, '1', '2023-09-29 18:48:27', '2023-09-29 18:48:27', NULL),
(138, 2, 'Folic Acid - Vitamin Panel', '16959989296516e3d16c0b9', 'services/abAFKpnYHlVs7zHV8AtkScrhJsbO3biRbDC9F59u.jpg', 'The Folic Acid test measures the level of folic acid (a synthetic form of folate) in the blood. It is used to assess folate status and is important during pregnancy.', 0.00, '1', '2023-09-29 18:48:49', '2023-09-29 18:48:49', NULL),
(139, 2, 'CA 15-3 (Cancer Antigen 15-3) - Oncology Screening Panel', '16959989326516e3d461211', 'services/eP9TAd0nfKzVmUmAqibwaatmaPsmfCgJBLt0kd7C.jpg', 'The CA 15-3 test measures the level of CA 15-3 antigen, which can be elevated in breast cancer.', 0.00, '1', '2023-09-29 18:48:52', '2023-09-29 18:48:52', NULL),
(140, 2, 'Cortisol - Hormones', '16959989616516e3f140008', 'services/MN6YkSpwWZnzN9UcYiMxDCUztfisqTB7fx649xD5.jpg', 'The Cortisol test measures the level of cortisol, a hormone produced by the adrenal glands involved in stress response and metabolism.', 0.00, '1', '2023-09-29 18:49:21', '2023-09-29 18:49:21', NULL),
(141, 2, 'CA 19-9 XR (Cancer Antigen 19-9) - Oncology Screening Panel', '16959989646516e3f497054', 'services/HKv3LOENCMBZi6gRGfaRRuhaHQMrynvQvh8Fslcv.jpg', 'The CA 19-9 XR test measures the level of CA 19-9 antigen, which can be elevated in pancreatic cancer and other gastrointestinal cancers.', 0.00, '1', '2023-09-29 18:49:24', '2023-09-29 18:49:24', NULL),
(142, 2, 'Antistreptolysin-O (ASO) - Immunology/Chemistry', '16959989676516e3f792190', 'services/wiaVFiPHHaroB09Z1u3WzNiv7RIqjeX9Aj7ksrOl.jpg', 'The ASO test measures the level of antibodies against streptolysin-O, which are produced in response to a streptococcal infection. It helps diagnose and monitor streptococcal infections, such as strep throat.', 0.00, '1', '2023-09-29 18:49:27', '2023-09-29 18:49:27', NULL),
(143, 2, 'C-peptide - Hormones', '16959989826516e4069ab2b', 'services/3vhWnCV1GeR2cjQbEKkfLFJ9FSfcIhg2hg4ODu6X.jpg', 'The C-peptide test measures the level of C-peptide, a fragment produced when insulin is processed. It can help assess insulin production in individuals with diabetes.', 0.00, '1', '2023-09-29 18:49:42', '2023-09-29 18:49:42', NULL),
(144, 2, 'B2 Microglobulin - Immunology/Chemistry', '16959989886516e40c33032', 'services/qgcjbFSciA4cbmuBtbQ4yuyzo8tSWucQnnSH5nPU.jpg', 'The B2 Microglobulin test measures the level of beta-2 microglobulin in the blood. Elevated levels may be associated with certain cancers and kidney diseases.', 0.00, '1', '2023-09-29 18:49:48', '2023-09-29 18:49:48', NULL),
(145, 2, 'CEA (Carcinoembryonic Antigen) - Oncology Screening Panel', '16959989896516e40d918c8', 'services/E3NBx6HPnuxNVXUUNQDonzljPoApJaQ7iFSUmJBg.jpg', 'The CEA test measures the level of CEA, a protein that may be elevated in colorectal cancer and other gastrointestinal cancers.', 0.00, '1', '2023-09-29 18:49:49', '2023-09-29 18:49:49', NULL),
(146, 2, 'Insulin - Hormones', '16959990076516e41f55bc6', 'services/74xI4Tut42GBhiohCSNpnOPsfDdZg8PCbZVgf7fz.jpg', 'The Insulin test measures the level of insulin in the blood. It is used to diagnose and monitor diabetes and assess insulin resistance.', 0.00, '1', '2023-09-29 18:50:07', '2023-09-29 18:50:07', NULL),
(147, 2, 'Intact PTH (Parathyroid Hormone) - Hormones', '16959990276516e4339a56c', 'services/aqcEoQi0hCFvQ96pawkIjzNVpbTFa8UxNh45cg44.jpg', 'The Intact PTH test measures the level of parathyroid hormone in the blood. It helps assess calcium and phosphate balance in the body.', 0.00, '1', '2023-09-29 18:50:27', '2023-09-29 18:50:27', NULL),
(148, 2, 'C Reactive Protein (CRP) - Immunology/Chemistry', '16959990376516e43dacaa9', 'services/rI3lJ4RoopMnextK33mpdJLnJ2mnHxizUWPCMFMq.jpg', 'The CRP test measures the level of C-reactive protein, a marker of inflammation in the blood. It is used to assess inflammatory conditions and the risk of cardiovascular disease.', 0.00, '1', '2023-09-29 18:50:37', '2023-09-29 18:50:37', NULL),
(149, 2, 'Myoglobin - Hormones', '16959990496516e44968da9', 'services/7FS9qWqDS7qTaTfDivxA4asQPCZ5qeeexR3ezNxC.jpg', 'The Myoglobin test measures the level of myoglobin, a protein found in muscle tissue. Elevated levels can indicate muscle injury or heart conditions.', 0.00, '1', '2023-09-29 18:50:49', '2023-09-29 18:50:49', NULL),
(150, 2, 'Creatine Kinase - Immunology/Chemistry', '16959990526516e44c3f30b', 'services/po019aGidU0M8EgSiGmvAdZA9tn3TOrSKlVhTWxj.jpg', 'The Creatine Kinase test measures the level of creatine kinase in the blood. It is an enzyme found in muscle tissue, and elevated levels may indicate muscle injury or heart conditions.', 0.00, '1', '2023-09-29 18:50:52', '2023-09-29 18:50:52', NULL),
(151, 2, 'Digoxin - Immunology/Chemistry', '16959990706516e45ec4413', 'services/oHVazaS9234qHRejrLln0AcPxITaD1GMKhWRuAEz.jpg', 'The Digoxin test measures the level of digoxin, a medication used to treat certain heart conditions. Monitoring digoxin levels helps ensure the medication\'s effectiveness and safety.', 0.00, '1', '2023-09-29 18:51:10', '2023-09-29 18:51:10', NULL),
(152, 2, 'Prolactin - Hormones', '16959990716516e45f2db40', 'services/BXNztiZjBVfL8NXklR9If0MXrczTvQhUWgIa5lcW.jpg', 'The Prolactin test measures the level of prolactin, a hormone involved in breast milk production and regulation of the menstrual cycle.', 0.00, '1', '2023-09-29 18:51:11', '2023-09-29 18:51:11', NULL),
(153, 2, 'Urinalysis (UA) - Urine Tests', '16959990716516e45f52f50', 'services/hOtspsR3cmkhGj6gsL3Y5pHYfmLHwQkC1tzJf1Kz.jpg', 'A urinalysis is a routine diagnostic test that examines the physical and chemical properties of urine. It assesses color, clarity, pH, specific gravity, and the presence of substances like glucose, protein, blood cells, and bacteria. It provides valuable insights into kidney function, hydration status, and various health conditions.', 0.00, '1', '2023-09-29 18:51:11', '2023-09-29 18:51:11', NULL),
(154, 2, 'Gamma-Glutamyl Transferase (GGT) - Immunology/Chemistry', '16959990826516e46adc393', 'services/ljYd1mnqiYd54ak9o6m5T8tvRigb5CWgzoXE6z4z.jpg', 'The GGT test measures the level of gamma-glutamyl transferase, an enzyme found in the liver and other tissues. It can help diagnose liver and biliary tract disorders.', 0.00, '1', '2023-09-29 18:51:22', '2023-09-29 18:51:22', NULL),
(155, 2, 'SHBG (Sex Hormone-Binding Globulin) - Hormones', '16959990946516e476f0c35', 'services/UMovC4xozCip6aWOmeUt8WOglJ3ETNqalejBkZO0.jpg', 'The SHBG test measures the level of SHBG, a protein that binds to sex hormones like testosterone and estrogen. It can provide insights into hormonal balance.', 0.00, '1', '2023-09-29 18:51:34', '2023-09-29 18:51:34', NULL),
(156, 2, 'UA with Microscopy - Urine Tests', '16959991006516e47c45e84', 'services/dCyQhl0U6KEvzMatr8bFPQIAXtKnx4O1DRiJU8v5.jpg', 'A urinalysis with microscopy includes a detailed examination of urine sediment under a microscope. This allows for the detection of red blood cells, white blood cells, crystals, and other microscopic elements. It aids in diagnosing kidney disorders, urinary tract infections, and certain diseases.', 0.00, '1', '2023-09-29 18:51:40', '2023-09-29 18:51:40', NULL),
(157, 2, 'Urine Drug Screen (UDS) - Urine Tests', '16959991406516e4a4eba74', 'services/Bca4TJPlfbIEEhrTUl1dfJu6Fitc3xXshytqaL8p.jpg', 'A Urine Drug Screen is a test that detects the presence of specific drugs or their metabolites in the urine. It is commonly used in workplace testing, clinical settings, and addiction treatment programs to monitor drug use.', 0.00, '1', '2023-09-29 18:52:20', '2023-09-29 18:52:20', NULL),
(158, 2, 'Urine HCG (Human Chorionic Gonadotropin) - Urine Tests', '16959991786516e4ca776be', 'services/uj2CnfSwWoQlePIeWRSbwhEuLlvIkeVwid1ESSjf.jpg', 'The Urine HCG test measures the presence of human chorionic gonadotropin (hCG), a hormone produced during pregnancy, in the urine. It is used to confirm pregnancy in a rapid and non-invasive manner.', 0.00, '1', '2023-09-29 18:52:58', '2023-09-29 18:52:58', NULL),
(159, 2, 'Haptoglobin - Immunology/Chemistry', '16959991826516e4ce1c787', 'services/QpTguCiI9nMa4n8AaArP84cibScYns8hicad3PpA.jpg', 'The Haptoglobin test measures the level of haptoglobin, a protein that binds to free hemoglobin in the blood. It is used to assess hemolytic anemia and other conditions.', 0.00, '1', '2023-09-29 18:53:02', '2023-09-29 18:53:02', NULL),
(160, 2, 'Urine Glucose - Urine Tests', '16959992036516e4e30d508', 'services/lfZsT6WnPdqi4Y085AYpfOSmdmXwI5cNFPxsiRFn.jpg', 'The Urine Glucose test measures the level of glucose (sugar) in the urine. Elevated levels may indicate uncontrolled diabetes or other health conditions affecting blood sugar levels.', 0.00, '1', '2023-09-29 18:53:23', '2023-09-29 18:53:23', NULL),
(161, 2, 'Urine Protein - Urine Tests', '16959992266516e4faa6014', 'services/bcerHXQT6HpcYJdi9rQK6ZCS9u1itwMAH2awc9la.jpg', 'The Urine Protein test detects the presence of protein in the urine. Elevated protein levels can suggest kidney disease or other conditions affecting kidney function.', 0.00, '1', '2023-09-29 18:53:46', '2023-09-29 18:53:46', NULL),
(162, 2, 'Urine Creatinine - Urine Tests', '16959992496516e51160f40', 'services/ABhguRX1wtsbr6RYVR54kjJE1Abje5Igzz00zc4f.jpg', 'The Urine Creatinine test measures the level of creatinine in the urine. It helps assess kidney function and is often used to calculate the urine protein/creatinine ratio.', 0.00, '1', '2023-09-29 18:54:09', '2023-09-29 18:54:09', NULL),
(163, 2, 'Ferritin - Immunology/Chemistry', '16959992496516e511f3b85', 'services/zHqM2reyezkYEA9Vzec2iFsPQwzkNtogP9V3gWtD.jpg', 'The Ferritin test measures the level of ferritin in the blood, which reflects the body\'s iron stores. It helps diagnose and monitor iron-deficiency anemia and iron overload disorders.', 0.00, '1', '2023-09-29 18:54:09', '2023-09-29 18:54:10', NULL),
(164, 2, 'Urine Protein/Creatinine Ratio - Urine Tests', '16959992706516e52640604', 'services/o0QUHNLbNomtDLJT3z0kAuqUwnTNyfVQ70CqVkw8.jpg', 'The Urine Protein/Creatinine Ratio compares the level of protein to the level of creatinine in the urine. It is used to evaluate and monitor kidney disease and proteinuria (excess protein in the urine).', 0.00, '1', '2023-09-29 18:54:30', '2023-09-29 18:54:30', NULL),
(165, 2, 'Immunoglobulin A (IgA), Immunoglobulin G (IgG) - Immunology/Chemistry', '16959992846516e5349f481', 'services/R4Ck6jEoltVu0Dx6OtDOLrwO5caHxSuE9Qlsvcut.jpg', 'These tests measure the levels of different types of immunoglobulins (antibodies) in the blood. They are used to evaluate the immune system\'s function and diagnose immune disorders.', 0.00, '1', '2023-09-29 18:54:44', '2023-09-29 18:54:44', NULL),
(166, 2, 'Urine Uric Acid - Urine Tests', '16959992936516e53d03fba', 'services/4eUKxTfuM6aSvqrDYG1fXR1X8cBm49KWATM6Jeuq.jpg', 'The Urine Uric Acid test measures the level of uric acid in the urine. Elevated levels can indicate gout or other conditions related to uric acid metabolism.', 0.00, '1', '2023-09-29 18:54:53', '2023-09-29 18:54:53', NULL),
(167, 2, 'Immunoglobulin G (IgG) - Immunology/Chemistry', '16959993016516e545d5a78', 'services/jTaToTFpErHwkV2cf05vaeYclN6JqjTVFU0yv1dd.jpg', 'These tests measure the levels of different types of immunoglobulins (antibodies) in the blood. They are used to evaluate the immune system\'s function and diagnose immune disorders.', 0.00, '1', '2023-09-29 18:55:01', '2023-09-29 18:55:01', NULL),
(168, 2, 'Immunoglobulin M (IgM) - Immunology/Chemistry', '16959993146516e552bc9ce', 'services/mMNDSYS4iSuaaBBmiQFSZv9S0fsKH0XdZnemycBv.jpg', 'These tests measure the levels of different types of immunoglobulins (antibodies) in the blood. They are used to evaluate the immune system\'s function and diagnose immune disorders.', 0.00, '1', '2023-09-29 18:55:14', '2023-09-29 18:55:14', NULL),
(169, 2, 'Urine Calcium - Urine Tests', '16959993226516e55a6573d', 'services/EMKunqzrk9zVLO4zN1BtprNhywzKw5BMgXK3QPre.jpg', 'The Urine Calcium test measures the level of calcium in the urine. It can help diagnose and monitor various metabolic and kidney disorders.', 0.00, '1', '2023-09-29 18:55:22', '2023-09-29 18:55:22', NULL),
(170, 2, 'Lactic Acid - Immunology/Chemistry', '16959993286516e560c77c7', 'services/EP4fE35UhMiDjqwO3PT2cfrKmJDSC3rqcqupHqTc.jpg', 'The Lactic Acid test measures the level of lactic acid in the blood. Elevated levels may indicate tissue hypoxia, shock, or certain medical conditions.', 0.00, '1', '2023-09-29 18:55:28', '2023-09-29 18:55:28', NULL),
(171, 2, 'Lactate Dehydrogenase (LDH) - Immunology/Chemistry', '16959993396516e56ba4e5e', 'services/xcPVlSTrFJhiebKXKqrWw5kLs5Fvpf4sBfdZ40QT.jpg', 'The LDH test measures the level of LDH, an enzyme found in many body tissues. Elevated LDH levels can indicate tissue damage or disease.', 0.00, '1', '2023-09-29 18:55:39', '2023-09-29 18:55:39', NULL),
(172, 2, 'Urine Albumin - Urine Tests', '16959993456516e571e1b4c', 'services/QPqTVr8qhFyAOLEEKQ2TZPsOtay2VCAqx6KCZEHA.jpg', 'The Urine Albumin test measures the level of albumin, a type of protein, in the urine. Elevated levels may indicate kidney damage or disease.', 0.00, '1', '2023-09-29 18:55:45', '2023-09-29 18:55:45', NULL),
(173, 2, 'Lithium - Immunology/Chemistry', '16959993556516e57b9a440', 'services/pc0pI5jt0KX9DRxotabnkDqA4uhOQSYwEofzVk54.jpg', 'The Lithium test measures the level of lithium in the blood. It is used to monitor lithium therapy in individuals with bipolar disorder.', 0.00, '1', '2023-09-29 18:55:55', '2023-09-29 18:55:55', NULL),
(174, 2, 'Urine Microalbumin - Urine Tests', '16959993686516e5885bbb9', 'services/e9a5cWS8CQyxjR04rucO7xpzDWTT3MGDeXILvtO4.jpg', 'The Urine Microalbumin test is a more sensitive version of the urine albumin test, designed to detect even trace amounts of albumin. It is often used to screen for early kidney disease in individuals with diabetes or hypertension.', 0.00, '1', '2023-09-29 18:56:08', '2023-09-29 18:56:08', NULL),
(175, 2, 'Magnesium - Immunology/Chemistry', '16959993686516e588e0835', 'services/IyNJoj0wITTbKMTlHhQ53fOrufoUaW1Ln0JOMTQg.jpg', 'The Magnesium test measures the level of magnesium in the blood. Magnesium is essential for various bodily functions, including muscle and nerve function.', 0.00, '1', '2023-09-29 18:56:08', '2023-09-29 18:56:08', NULL),
(176, 2, 'Rheumatoid Factor (RF) - Immunology/Chemistry', '16959993846516e5984d101', 'services/M0TMCcvdS8jK1TEdzoon8xjzeuUCHVBIOmOsBZSa.jpg', 'The Rheumatoid Factor test measures the level of RF antibodies in the blood. Elevated RF levels are associated with autoimmune diseases like rheumatoid arthritis.', 0.00, '1', '2023-09-29 18:56:24', '2023-09-29 18:56:24', NULL),
(177, 2, 'Urine Amylase - Urine Tests', '16959993936516e5a14c985', 'services/FErYTq3G47dYRmYld1MSquRSTTVTNYW8g7liyvYj.jpg', 'The Urine Amylase test measures the level of amylase, an enzyme produced by the pancreas, in the urine. Elevated levels may indicate pancreatic disorders or other health issues.', 0.00, '1', '2023-09-29 18:56:33', '2023-09-29 18:56:33', NULL),
(178, 2, 'Salicylate - Immunology/Chemistry', '16959993986516e5a6b2772', 'services/PJRNrkD0MpA62W2GCaNJ7c68ZYizUKW0RqnTRlvC.jpg', 'The Salicylate test measures the level of salicylate (aspirin) in the blood. It is used to monitor aspirin therapy and assess toxicity.', 0.00, '1', '2023-09-29 18:56:38', '2023-09-29 18:56:38', NULL),
(179, 2, 'Urine Microalbumin/Creatinine Ratio - Urine Tests', '16959994156516e5b7482f6', 'services/CxhRqMXd9J0KKnENVLE7F4fXPwrRGimutlr0alF5.jpg', 'The Urine Microalbumin/Creatinine Ratio combines the measurement of microalbumin and creatinine in the urine to assess kidney function and detect early signs of kidney disease.', 0.00, '1', '2023-09-29 18:56:55', '2023-09-29 18:56:55', NULL),
(180, 2, 'Urea Nitrogen - Immunology/Chemistry', '16959994186516e5ba70dc4', 'services/lQfthDBAKm5GQJSep1ZeQdMo3WyOAvuyehk0PF9V.jpg', 'The Urea Nitrogen test measures the level of urea nitrogen in the blood. It helps evaluate kidney function and hydration status.', 0.00, '1', '2023-09-29 18:56:58', '2023-09-29 18:56:58', NULL),
(181, 2, 'Uric Acid - Immunology/Chemistry', '16959994326516e5c88e9dc', 'services/1Gzd00GMmGVzJ8Irti15MDUsQWH4mHF1qsD7Pp4p.jpg', 'The Uric Acid test measures the level of uric acid in the blood. Elevated levels are associated with gout and certain kidney disorders.', 0.00, '1', '2023-09-29 18:57:12', '2023-09-29 18:57:12', NULL),
(182, 2, '24-Hour Protein - Urine Tests', '16959994406516e5d08db48', 'services/BVDMmUp752hyY0Ae3zsMtu6mfZTRYwGrRwzOcawY.jpg', 'The 24-Hour Protein test involves collecting all urine produced over a 24-hour period to measure the total protein excretion. It provides a comprehensive assessment of protein loss and is used in the diagnosis and monitoring of kidney disorders.', 0.00, '1', '2023-09-29 18:57:20', '2023-09-29 18:57:20', NULL),
(183, 2, 'Urine/CSF Protein - Immunology/Chemistry', '16959994476516e5d765537', 'services/imYlooDAJNEYkI8TGbf2LSzvISLBEjjYS91irH4B.jpg', 'The Urine/CSF Protein test measures protein levels in urine or cerebrospinal fluid. It is used to assess kidney function or diagnose neurological conditions.', 0.00, '1', '2023-09-29 18:57:27', '2023-09-29 18:57:27', NULL),
(184, 2, 'Valproic Acid - Immunology/Chemistry', '16959994636516e5e73c1fa', 'services/yAbfRJs4Rh0T3ChQUYlkhdXiM8vgcrN19xnqsbDW.jpg', 'The Valproic Acid test measures the level of valproic acid, a medication used to treat epilepsy and mood disorders. It helps monitor therapy and assess drug levels.', 0.00, '1', '2023-09-29 18:57:43', '2023-09-29 18:57:43', NULL),
(185, 2, '24-Hour Calcium - Urine Tests', '16959994656516e5e903acd', 'services/0dLG7nu9cnQqVOR695NrnQZTu2cgEnZ8fCO9nzso.jpg', 'The 24-Hour Calcium test measures the total amount of calcium excreted in urine over a 24-hour period. It aids in diagnosing calcium metabolism disorders and kidney stones.', 0.00, '1', '2023-09-29 18:57:45', '2023-09-29 18:57:45', NULL),
(186, 2, 'Vancomycin - Immunology/Chemistry', '16959994796516e5f7353c4', 'services/hfJOsaA2vq3dPdGM53UAy8Jnpofam79pF1EayCur.jpg', 'The Vancomycin test measures the level of vancomycin, an antibiotic used to treat bacterial infections. Monitoring vancomycin levels ensures effective treatment and avoids toxicity.', 0.00, '1', '2023-09-29 18:57:59', '2023-09-29 18:57:59', NULL),
(187, 2, '24-Hour Creatinine - Urine Tests', '16959994866516e5fe35f85', 'services/lgOtjInPsf2OpQjzn7LjuXy0UhoowGm7YZdYHE8q.jpg', 'The 24-Hour Creatinine test measures the total amount of creatinine excreted in urine over 24 hours. It is used to assess kidney function and calculate the creatinine clearance rate.', 0.00, '1', '2023-09-29 18:58:06', '2023-09-29 18:58:06', NULL),
(188, 2, 'Apolipoprotein A1 - Immunology/Chemistry', '16959994916516e60321021', 'services/dnCsNnlJgMQo3UgtiRoFerJLgXNSJTGPXEr5mue9.jpg', 'These tests measure the levels of apolipoproteins associated with lipoproteins. They provide additional information about cardiovascular risk beyond standard lipid panels.', 0.00, '1', '2023-09-29 18:58:11', '2023-09-29 18:58:11', NULL),
(189, 2, '24-Hour Sodium - Urine Tests', '16959995156516e61b0fd07', 'services/CXlhCrkWD28CiwZdQDeEL8ujr3o0I7AZZRsRnvpv.jpg', 'These tests measure the total amounts of sodium, potassium, and chloride excreted in urine over a 24-hour period. They help evaluate electrolyte balance and kidney function.', 0.00, '1', '2023-09-29 18:58:35', '2023-09-29 18:58:35', NULL),
(190, 2, 'Apolipoprotein B - Immunology/Chemistry', '16959995226516e62222551', 'services/uWMaTL18rWFb1owrgE454nGXxg9bUO1qsd0rXttw.jpg', 'These tests measure the levels of apolipoproteins associated with lipoproteins. They provide additional information about cardiovascular risk beyond standard lipid panels.', 0.00, '1', '2023-09-29 18:58:42', '2023-09-29 18:58:42', NULL),
(191, 2, '24-Hour Potassium - Urine Tests', '16959995406516e6342523c', 'services/Dw87gUEq1eufshxZ0DW5gYHh0ExsLVpp7W7cV8V5.jpg', 'These tests measure the total amounts of potassium, excreted in urine over a 24-hour period. They help evaluate electrolyte balance and kidney function.', 0.00, '1', '2023-09-29 18:59:00', '2023-09-29 18:59:00', NULL),
(192, 2, 'Prealbumin - Immunology/Chemistry', '16959995426516e6369092a', 'services/OkenjVVmzJrXSo69p3I1MYAHjJozIuRdJCRAuxPk.jpg', 'The Prealbumin test measures the level of prealbumin, a protein used to assess nutritional status and liver function.', 0.00, '1', '2023-09-29 18:59:02', '2023-09-29 18:59:02', NULL),
(193, 2, 'Procalcitonin - Immunology/Chemistry', '16959995546516e642a5342', 'services/yu8wLiCqLyC7JkOx088MqgpLF428042xWTdZkhgS.jpg', 'The Procalcitonin test measures the level of procalcitonin, a marker of systemic bacterial infection and sepsis.', 0.00, '1', '2023-09-29 18:59:14', '2023-09-29 18:59:14', NULL),
(194, 2, 'Troponin - Immunology/Chemistry', '16959995726516e654b0e2e', 'services/5PbwDiDKhUHtQwiaCQcPsYD90fsOsokpn5To0I2R.jpg', 'The Troponin test measures the level of troponin, a protein released into the bloodstream during heart muscle damage. It is a critical marker for diagnosing heart attacks and evaluating cardiac health.', 0.00, '1', '2023-09-29 18:59:32', '2023-09-29 18:59:32', NULL),
(195, 2, '24-Hour Chloride - Urine Tests', '16959996416516e69943c95', 'services/4YfV2fA5hSpRAoroGHlFSxQLRAzQbbdlye0tc6hl.jpg', 'These tests measure the total amounts of Chloride, excreted in urine over a 24-hour period. They help evaluate electrolyte balance and kidney function.', 0.00, '1', '2023-09-29 19:00:41', '2023-09-29 19:00:41', NULL),
(196, 2, '24-Hour Microalbumin - Urine Tests', '16959996846516e6c4cf028', 'services/kX7RL8hT5xWn8ydhrjGha2zAFtFuUiECnF8vic3b.jpg', 'The 24-Hour Microalbumin test measures the total amount of microalbumin excreted in urine over a 24-hour period. It is used for more precise monitoring of early kidney damage, especially in individuals with diabetes.', 0.00, '1', '2023-09-29 19:01:24', '2023-09-29 19:01:24', NULL),
(197, 2, '24-Hour Phosphorus - Urine Tests', '16959997116516e6dfb24fe', 'services/7d2rxY0n4IZR0CYIFfc9qMK1jLCQpjO4YrGePkmb.jpg', 'The 24-Hour Phosphorus test measures the total amount of phosphorus excreted in urine over a 24-hour period. It provides insights into phosphorus metabolism and related disorders.', 0.00, '1', '2023-09-29 19:01:51', '2023-09-29 19:01:51', NULL),
(198, 2, '24-Hour Urea Nitrogen - Urine Tests', '16959997406516e6fc5813e', 'services/Obu55lIyuOkqDpTIibfiXXjy2zpfh4DY8LLWe0Hk.jpg', 'The 24-Hour Urea Nitrogen test measures the total amount of urea nitrogen excreted in urine over a 24-hour period. It helps assess kidney function and protein metabolism.', 0.00, '1', '2023-09-29 19:02:20', '2023-09-29 19:02:20', NULL),
(199, 2, '24-Hour Magnesium - Urine Tests', '16959997666516e71647967', 'services/lfC2DPYpwmCkCXVehw66CIZWulFkX7eeG3iJ2FEj.jpg', 'The 24-Hour Magnesium test measures the total amount of magnesium excreted in urine over a 24-hour period. It provides information about magnesium balance and metabolism.', 0.00, '1', '2023-09-29 19:02:46', '2023-09-29 19:02:46', NULL),
(200, 2, '24-Hour Uric Acid - Urine Tests', '16959997866516e72a6c280', 'services/apwYDFrIYV47o7IwYjcALU0qm9fnbv3zGIOG9WS9.jpg', 'The 24-Hour Uric Acid test measures the total amount of uric acid excreted in urine over a 24-hour period. It is used in the diagnosis and management of gout and other uric acid-related conditions.', 0.00, '1', '2023-09-29 19:03:06', '2023-09-29 19:03:06', NULL),
(201, 2, 'Urine Urea Nitrogen/Creatinine Ratio - Urine Tests', '16959998136516e745831c8', 'services/fYQTGnWzttpzECqBl8SihXVWryZmzxr7p9FuQvna.jpg', 'The Urine Urea Nitrogen/Creatinine Ratio compares the levels of urea nitrogen and creatinine in the urine. It can help evaluate kidney function and nitrogen balance in the body.', 0.00, '1', '2023-09-29 19:03:33', '2023-09-29 19:03:33', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `specialities`
--
CREATE TABLE `specialities` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_url` text COLLATE utf8mb4_unicode_ci,
`description` text COLLATE utf8mb4_unicode_ci,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `specialities`
--
INSERT INTO `specialities` (`id`, `title`, `slug`, `image_url`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'GERIATRICS', '169406906264f9714683a4d', 'speciality/R0wmUkVSvFzmWpGjxpAZpAXhsYUXW2hPd2gSr6sT.png', NULL, '1', '2023-09-07 10:44:22', '2023-09-07 10:44:22', NULL),
(2, 'INFECTIOUS DISEASE', '169406908664f9715e282c2', 'speciality/8vmKcciFtpCzU4eaDrGSlEhJcm9QIkKndXoF60XY.png', NULL, '1', '2023-09-07 10:44:46', '2023-09-07 10:44:46', NULL),
(3, 'INTERNAL MEDICINE', '169406911964f9717fe937e', 'speciality/C5QBSXQPkoxWODs7TZO1LZVaJmvURDNwscrHtqtN.png', NULL, '1', '2023-09-07 10:45:19', '2023-09-07 10:45:19', NULL),
(4, 'NEPHROLOGY', '169406914464f971987756e', 'speciality/ggN87wfguJfOcQn5VESesEnbYPQT4LKLihN3s9UH.png', NULL, '1', '2023-09-07 10:45:44', '2023-09-07 10:45:44', NULL),
(5, 'OBGYN', '169406916764f971af2d954', 'speciality/yEw2Xm240feBLDPGkIcZjg5dRtKPQ5x4yiAsFeck.png', NULL, '1', '2023-09-07 10:46:07', '2023-09-07 10:46:07', NULL),
(6, 'test', '169417590264fb129e89e73', 'speciality/TVW4vMd97eC0IvhUxEgKuxxNViJ7SqaNmVQPIC3M.png', NULL, '1', '2023-09-08 16:25:02', '2023-09-08 16:25:27', '2023-09-08 16:25:27'),
(7, 'test', '169418039564fb242b2e6bb', 'speciality/UUnasPrxLgLCh3qAd5LKTBeI3hueNi7VY8vI0OaI.png', NULL, '1', '2023-09-08 17:39:55', '2023-09-08 17:42:22', '2023-09-08 17:42:22'),
(8, 'test', '169418069164fb2553c704a', 'speciality/kumvU32xXcMK42JINqM3TkRk8IDmX2T9gJ19yr12.png', NULL, '1', '2023-09-08 17:44:51', '2023-09-08 17:45:37', '2023-09-08 17:45:37');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_group_id` bigint(20) UNSIGNED NOT NULL,
`user_type` enum('admin','user') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_url` text COLLATE utf8mb4_unicode_ci,
`blur_image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`platform_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
`platform_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`is_email_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`email_verify_at` datetime DEFAULT NULL,
`is_mobile_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`mobile_verify_at` datetime DEFAULT NULL,
`country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zipcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`latitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`longitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`online_status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`mobile_otp` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_otp` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gateway_customer_id` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gateway_connect_id` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`notification_setting` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `user_group_id`, `user_type`, `name`, `username`, `slug`, `email`, `mobile_no`, `password`, `image_url`, `blur_image`, `platform_type`, `platform_id`, `status`, `is_email_verify`, `email_verify_at`, `is_mobile_verify`, `mobile_verify_at`, `country`, `city`, `state`, `zipcode`, `address`, `latitude`, `longitude`, `online_status`, `mobile_otp`, `email_otp`, `gateway_customer_id`, `gateway_connect_id`, `notification_setting`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'admin', 'RetroCube', 'retrocube', 'retrocube', 'admin@retrocube.com', '1-8882051816', '$2y$10$rZVqtu1gDfzlASd3zNLMUud9sntCAoP0hY.qeUvwNXpdVJ5eD1/Rq', NULL, NULL, 'custom', NULL, '1', '1', '2023-06-26 09:20:53', '1', '2023-06-26 09:20:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, '1', NULL, '2023-06-26 13:20:53', NULL, NULL),
(2, 2, 'admin', 'WelCare Diagnostics LLC', 'welCare-diagnostics-llc', 'welCare-diagnostics-llc', 'admin@welcarediagnostics.com', '1-8882051817', '$2y$10$FMyOcdv0r01xdNwUlZVPquAW/9iZNf4EDn8Lv0knoYmkmtlGkCPK.', NULL, NULL, 'custom', NULL, '1', '1', '2023-06-26 09:20:53', '1', '2023-06-26 09:20:53', NULL, NULL, NULL, NULL, '703 White Horse Rd suite 4, Voorhees, NJ 08043, USA', '39.846074', '-74.98966800000001', '0', NULL, NULL, NULL, NULL, '1', NULL, '2023-06-26 13:20:53', '2023-09-04 19:17:51', NULL),
(24, 3, 'user', 'Tyler Mccarter', 'tyler-mccarter', 'tyler-mccarter', 'tyler.mccarter@retrocubellc.com', '+1-4699406126', '$2y$10$6YkSh8re6FrbVKHT7qaaxuVO55OmVqkMbw/T2H0TfvVCrmGzzhvLa', NULL, NULL, 'custom', NULL, '1', '1', '2023-09-29 12:02:40', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, '1', NULL, '2023-09-29 16:02:12', '2023-09-29 17:03:35', NULL),
(25, 4, 'user', 'Tyler', 'tyler', 'tyler', 'Jake.branson@retrocubellc.com', '+1-4694055435', '$2y$10$8tkylfYeQvdHzXawdjCn3O2R.yrlVQhu/U6xhIPcaN1aecL1M3MS6', NULL, NULL, 'custom', NULL, '1', '1', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, '1', NULL, '2023-09-29 16:06:02', '2023-09-29 16:06:02', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `user_api_token`
--
CREATE TABLE `user_api_token` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`api_token` text COLLATE utf8mb4_unicode_ci NOT NULL,
`refresh_token` text COLLATE utf8mb4_unicode_ci,
`udid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`device_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_token` text COLLATE utf8mb4_unicode_ci,
`platform_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
`platform_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `user_api_token`
--
INSERT INTO `user_api_token` (`id`, `user_id`, `api_token`, `refresh_token`, `udid`, `device_type`, `device_token`, `platform_type`, `platform_id`, `ip_address`, `user_agent`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 22, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5ODg0MTcsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5ODg0MTcsImV4cCI6MTY5Njg1MjQxNywidXNlciI6eyJ1c2VyX2lkIjoyMiwiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMTo1MzozNy4wMDAwMDBaIn19.9_B0LBaENvf0dJMLy26ss7iSvmBdYw_wg9hqNVr5I3g', NULL, '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 15:53:37', NULL, NULL),
(2, 23, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5ODg0MzUsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5ODg0MzUsImV4cCI6MTY5Njg1MjQzNSwidXNlciI6eyJ1c2VyX2lkIjoyMywiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMTo1Mzo1NS4wMDAwMDBaIn19.AJIUEHTs04DaG2kDDbTa-Wn_wpdEqHmpdKyZZ0SZleA', NULL, '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 15:53:55', NULL, NULL),
(4, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5ODg5MzIsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5ODg5MzIsImV4cCI6MTY5Njg1MjkzMiwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41NS4yMTgiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.b8qnfRupv7JuK9npO7eQcO3a6I_hfxKVMitA8y_M1BQ', NULL, '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 16:02:12', NULL, NULL),
(6, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5OTI1NDEsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5OTI1NDEsImV4cCI6MTY5Njg1NjU0MSwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.tNrpTYEgyJxZOn7G8pm76pyz1t3XvhLBlKmnRe26NKU', '7b0456bf7aa0a9786e7a1a085a21f9b847bae2f852689b1fc703a7d3ebc271c5', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 17:02:21', '2023-09-29 17:02:21', NULL),
(7, 24, '$2y$10$6aIbufCb3g03EpZMn3VdGeq7SlDez7hzdpzL/s2zwCso/LB1pznCW', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'dCWqiJlclo9tcpY07UzT9h:APA91bGQ6geZUFPINB3B7UxQxSuR-xEC3jym-xUeleD5W6ehinH9zENC2a8v-VYBVS2sq4mKNC7xchcdeYXPzImlo4obMHT4CXFaVgDaY9U3_05oYQxkvO_Dw8lQhcRH_ZvL1BQdctt1', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 17:02:25', NULL, NULL),
(9, 25, '$2y$10$7Me2xlr1rNTbUqVO1c7e9O4y/gRLZfCveNiyFUMOUyHy33falpGxS', NULL, '8e296a067a37563370ded05f5a3bf3ec', 'web', 'dCWqiJlclo9tcpY07UzT9h:APA91bGQ6geZUFPINB3B7UxQxSuR-xEC3jym-xUeleD5W6ehinH9zENC2a8v-VYBVS2sq4mKNC7xchcdeYXPzImlo4obMHT4CXFaVgDaY9U3_05oYQxkvO_Dw8lQhcRH_ZvL1BQdctt1', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 17:05:33', NULL, NULL),
(13, 22, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5OTQ3MzcsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5OTQ3MzcsImV4cCI6MTY5Njg1ODczNywidXNlciI6eyJ1c2VyX2lkIjoyMiwiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMTo1MzozNy4wMDAwMDBaIn19.a_Xo_8fcIPEsGg6T3R_VqTueLncWlBlQykAokFMOfd0', '000b1fa010f73d15d51f8ef837d33584b17de560d458ab6150f2b9223576905f', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 17:38:57', '2023-09-29 17:38:57', NULL),
(14, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5OTQ4MDEsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5OTQ4MDEsImV4cCI6MTY5Njg1ODgwMSwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.xJI5_gfaLPBVCPPBVMsI2yaziiXx27mzgk40OMTRc8o', '090dd830704ad18d861e4d8c865277db9a11caa240ece719da124f8cc331c2f6', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/118.0', '2023-09-29 17:40:01', '2023-09-29 17:40:01', NULL),
(15, 24, '$2y$10$Xi2tO69VprEwFIdvwSBb4u7meb9/g4KOmbpEiwYLltHJ2NEGXbM5O', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fMPkQsg3SlcWPoEUyvw73o:APA91bHU16ugWmpZ1EFcs3oN2SFAcwWRZtnr-lukvvZGtb6Ch4MDkLWW-sRUolPwh5MoiHzZfJHEmclIT71ffUm1w3YWrbRP1XK6LoI3fDECPJDPLzpqif62PCeU8Em5E-9vbkiLK64M', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/118.0', '2023-09-29 17:40:07', NULL, NULL),
(16, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5OTQ5MTksImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5OTQ5MTksImV4cCI6MTY5Njg1ODkxOSwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41My4yNTAiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.1H90jfGhHxMYkKte2d37JjYd6_PNCZAMRhX5L5Axjgc', '90d0de3b12b50e007f57db2304135e0d79e0b2c4906cc35be6a3fa63fd5f53fe', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 17:41:59', '2023-09-29 17:41:59', NULL),
(17, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTU5OTUwNDEsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTU5OTUwNDEsImV4cCI6MTY5Njg1OTA0MSwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41NS4yMTgiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.ubtSfUBtIw1PaqKcI9zTQam8KLfnensxHmbFiskzO0U', 'e54b3c69c2333d299770fec52fadb564293b6dbe0b4761cb74aa789151749e3c', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 17:44:01', '2023-09-29 17:44:01', NULL),
(18, 24, '$2y$10$B5LYE.5YU0GsEhZZ1lhAreyYVq/mamP4b9dx0667bcj49ii9G6iOq', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bF4xHyZGLEWb2hfkvjF7wRNpvW02DdYkEjWnwI-v2OnaegWbyFNPIEVsfTPMhHMcvcahG0YTunaFyR1fMlrsXxF0kHfglhIncq-swxPuERmS9IrS_5ihfKi-c6JaVFHM_zJY5Ld', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 17:44:04', NULL, NULL),
(20, 2, '$2y$10$NVS8DPmbWu.gjMClACBt7u.qlhFI3JDlO5yZTfw37Ul40fwNuU8aW', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bGa3wFnqmnZjLWKvJHJeT0yufiJ-GS_I3-jQEPjb7-9UuNFDATQyaUdpBkfLFX3-D4uUY-ZzlmuA3h6IfnOtGsabgsicwUnRXqvq7iog9h9fqaXRyRKUOGLUpSr_4ANup0dtbTI', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 17:51:34', NULL, NULL),
(21, 24, '$2y$10$Ps2nrZ02pWDsVtrwEcaiduua6x/ryHUmUvjHSZX1CS9UZTR2mEhf2', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bF3IhwpCx27Dx1XcRNqJuGcwsBk_K1O0Xw0jpVKGDvVfyTYincwu9e8T9MNM3T6Caf54wOMq3Wh_N9mDzLF7IqOl9R_2UCR2vlXNss11ltn9yI7WwRFDkLP6CyTMGdgKK6lKEL7', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:12:57', NULL, NULL),
(22, 2, '$2y$10$4pb4ZRL6g9aV.p9iyDIuJO53tYeJnkweLD1HDWaUqChV/rmUhuMEu', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bEbq2rZZ0TENW4bkak0PbPTh4yoS4d-U__khjij_QtIqujzOjbzV4-3Eh9qX7T8Y0Kt8dJbLjmNP0q0pICFrC21kkayFHEjqeYqt6W6-F_rQQjLxz0OVnUX74PVtOYlo7L97vgZ', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:14:28', NULL, NULL),
(23, 24, '$2y$10$fsVPwy1rsAQhebwJRmJisuTeVlOZQjyTmPkLI9syL2gYrHVk62xAC', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bGWG4rKskXGfflsH64u6QqDziO4gFMAND_mphc7kizUueBYzlC_7oGxrLXcdpDdJ0yva5EtzSRfX88YCZ_B15LFPQkJ7LSK9MeTY76i4d5H9RaKYYpurhU6xwDe3Swa2_ous2m5', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:16:20', NULL, NULL),
(24, 2, '$2y$10$b06iec5qGC29DRBokBiTsO4jzrO1h.gD9gTcmYgjzUtFNhZ5nc2Y.', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bHukgvVDJr-XjkJuBoe4ykqZndFb3l3AoZkD4UFEHUQYdHmshxtBWqX29_lngBD5Io706DJIzKWLL5omrpx9GNLq9KJ6uTikuymIGYpsdvUHzKJP7UCYU3AR8cStIJLcLJDD_xO', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:16:35', NULL, NULL),
(25, 24, '$2y$10$h4bJaGL/r1TP4aQLIThKT.Enmg1KWx/eNoEjPpoKJq6GFDH/EaIE6', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bG_2wWXOR6R-5gei9HCvW0YBtWb0JqDA3z6LRINsE7l_Rl3tTUFE8_TWan8yVQWKV2t9OKDjv7kkBAnbgoz6HdUKfgug02yfhZPJyrDL5yVZUP_E59cEup2Bsqt5EGFF4lYXIv5', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:17:15', NULL, NULL),
(26, 2, '$2y$10$Gimj9sTnoM99tVoXxJNOs.3jkfRaSZgI8ZdSuw3amn0XZv5dfM7Fm', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bEH_GctLmlVAlH-OoYgaJ7uvHBOn-kd7CeP_m3lAD-t20OBkr-Hlz88BxrC5cdiCI21ak5JKUKpRXu7AgV_92stAyJWt5Dsd28AtWxN0iljaidvTFEd4J3qUGPLwGwVNwRTDkL9', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 18:17:17', NULL, NULL),
(27, 24, '$2y$10$/QD4Q3kMr3xC5LQTtOBU1eZdCja2O.0BmWBCTl4227WfLUqnBKSmy', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bGRQO_eO0Ik7T5AmDB8g4URt2pqP6XZWXLofD6v4PIx7iHHH_c0VVHIPJOd-Z-dnpJZN9xktHSe5OeEm8sX8WNhrYYXUcC4RADjYeVwQUJzd8U5Y_IXNS4S7nsLIxKFQBJJRPUc', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:04:08', NULL, NULL),
(28, 2, '$2y$10$RaOaR4LaNWxHZveoxm5mbe4LJwo6BWO6sveFgRPmXNnR8RRrluzHm', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bE88fTgvJAQoFAWJfuoYljCxdmm7XEkUxohq5h7DRRLitybjT-dK4kpzV8EQvmv1ppqiUryJ1qx_vsil5vDJ_iriLAXWSfrqjDFYRm3wvPfI2pPsgibN9GjpRcrT27l3LXUIqwB', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:13:48', NULL, NULL),
(29, 24, '$2y$10$1zo22ntFD0FnAvE5p5jt9Oj2xS7yN7uZ58Z.IeJ1P3w9X/ulsoHgm', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bGLxg6FkvvdAkf115f82VxQ5QEadt9axsyib2Je4x0q9-NgXRJW4iqglbV0MjdSj8vtjccgiMuZpPKirgM42O4sTarIVjsZVCix3HHvajbCOUdVb9RJsPj1WDXZJZ56dNR_Uiqg', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:14:41', NULL, NULL),
(30, 2, '$2y$10$sJIxcmoSTrak6kUk0gEdm.cQfHxThhYPM2zDNOVnWTVJoybO8k6b.', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bE0RadCgUTgyg_uTZKbxAY17Y-wEk5D3q-2dWy7EeafQBCXz91L7A_ZJCNnrHFDdRfySNFgm6xixbYeD2Yxob-claXJ31pVOQVfLO647miVQYpY_LhcgQ23J5D_qPgKbJdOgivJ', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:14:49', NULL, NULL),
(31, 24, '$2y$10$7vOC7iav6T/Baths9VehKus3b8jjLsL3oo2XB5a9Dvqpb.a4hHZhC', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bH9VWQdpv2MGTtYh9mnSFGz3vVIkVwRIVjap71T0FZk22zNxjTjk4ykS4FXOeWXFJ0P0cvVRe8HVCqiaFi9_IPjUbbPkesYvNMFzocBezsETSn5pVcSx9jmxyKiMIZUge8NghVC', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:15:08', NULL, NULL),
(33, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTYwMDEwNzcsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTYwMDEwNzcsImV4cCI6MTY5Njg2NTA3NywidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjExOS4xNTcuODQuMTIyIiwidWRpZCI6IjVRdUFXMi9ac3Bxbm00RzR5RmFBTjYwRVpVL1VkUDUzMVhXcHJtM1pNenhkVUFhN3JKZzQxeXg2Q20rNC80QUgiLCJkYXRldGltZSI6IjIwMjMtMDktMjlUMTI6MDI6MTIuMDAwMDAwWiJ9fQ.xMyAyiMo_OL3apIpGN114WRU2M1iDdqxnLhAlUyBDHI', 'd41bbba8dd679aaa00643dc93ba67e6d6e7c7e2ffa2c7073df65d16645b3e28d', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '119.157.84.122', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 19:24:37', '2023-09-29 19:24:37', NULL),
(34, 2, '$2y$10$zCAVH5vNCoaBX0Dm8q1.R.ognDxH/ynKwSTjhJV64i.FQ8PRrbxw.', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bHJdFz9GjllKg00PAJi7wcxsQ4zm0BnunxT9mJ-4Qk81gBADMR_Z6plXXIot-Di5BifWZn0-DPyleJeeo-qrjxqzQoCkFITcx2HSmdkgExYVKVYnbuWYVG_JMaBLuqXi1Qqua-k', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:25:23', NULL, NULL),
(35, 24, '$2y$10$GQlrSN7t26EGfa6nbF8OaOPvO9oXZSOFYcQIYGDkMbridnmz5w/12', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bGukEB3dOFk9OFQ5oZ2yjf3V7VULxEDWowlLSWXOlKJkO01dEjoxZpbRHayQbXdUpHp-D1EHjp_WZ1iXrC41ELXuQxiUdUUonStfv1n-DCgeetr2kTQaB9z1EWihNDwz7TSOCgk', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:25:51', NULL, NULL),
(36, 2, '$2y$10$oNMXmSjyfmNmYlrXS7ARXOcvhgoaXrXmM/szw7DUiSoHBW1J/f5ca', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bExZ3poZgX1D23AOUoOopHM0Esag516WXVII_BhHuzqRxcFSGf7c-DTwa4pj0TcT-CIodoDd8VcFiX7L8bBr1UznJ726vSNW7fTlXn-OjK_VVuQL3MsLut869JAICmHtlz32h_2', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:26:03', NULL, NULL),
(37, 24, '$2y$10$0jFsE4P7k9J7Nl6qdpYykeAVUR62gZLyk.oOsETsLg68XBDXbgRly', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fkFaizW_aicJwDcxGle2OA:APA91bHMAGNdPo_ptSPcPRKWon9VMKKeE7pgfyZm4o2Q9W0Uh_7gf1b1R6sWXxDD34nPKyOanLC0Su5TFBdSVlY-EK0fscjYrxDK3SGkJ0MZnIctHLU6mruTEGQgnXJXUy4lp7FGL2XF', 'custom', NULL, '119.157.84.122', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 19:27:44', NULL, NULL),
(38, 24, '$2y$10$V510P2GK7LdGBx3PvqubVOgfa5E/KWL/M6/Sz5i93YoTEQCHO9Oiu', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bHiQ8FQYBJSa8POgdRgcYQhIStAvFczgmicThXalt8BGth5kVkH-bMdxLQmTAbFRXUbMJRVUauBaQEU_PKzB9cZ0goR9OIeK2Qyjb7xGPxGHHcOwpK3L-FpeK3jBH8xs348X406', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 19:29:20', NULL, NULL),
(40, 24, '$2y$10$P8TZ3D0syQ4u/flFSQHZAOfgM2AeS.8cRzHthcKYHU1LcGfvr0Wn6', NULL, '1ff1de774005f8da13f42943881c655f', 'web', 'd2bRmVXbmCvYY2ciAkAlZY:APA91bG4VyQKdyOt67cpXO-HsYczBSO8itnCNie9RJf05KA9Io2SPPUjWj-iQYMbKVPIbF41kyn9pAPtzEtUciFOoVQncqJYafFPcA4YoDKqPUVdLc03H62J2A4b0o5fLif_bODv5Aex', 'custom', NULL, '103.86.53.250', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 19:45:04', NULL, NULL),
(41, 2, '$2y$10$dET029oxrtF3CGhWrWR0ge6ntKuKWW1.idTGhR1D6hCTjpODBc1lW', NULL, 'c81e728d9d4c2f636f067f89cc14862c', 'web', 'fg4KbjgtR0EcJL3T0wrh86:APA91bFNRw1C3katW3NTO_nik7bzoaj1xcsAi8LjYdwEoyM0Y7eyfVN4MlAOpTAfPYD4hO2ZatxFgxs-OkvDZtCy3k6EgPBwAeC3Mz72prlNxX5B5N5B7oIKoeEAdwG5to2F3DTPRmjL', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.43', '2023-09-29 20:12:58', NULL, NULL),
(43, 24, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2OTYwMDg1MjgsImlzcyI6IlcvRyR3fXNtLEclSyFrQFMkemVra21kdmhrbTtDaU1RaiphV3cjdjUiLCJuYmYiOjE2OTYwMDg1MjgsImV4cCI6MTY5Njg3MjUyOCwidXNlciI6eyJ1c2VyX2lkIjoyNCwiaXBfYWRkcmVzcyI6IjEwMy44Ni41NS4yMTgiLCJ1ZGlkIjoiNVF1QVcyL1pzcHFubTRHNHlGYUFONjBFWlUvVWRQNTMxWFdwcm0zWk16eGRVQWE3ckpnNDF5eDZDbSs0LzRBSCIsImRhdGV0aW1lIjoiMjAyMy0wOS0yOVQxMjowMjoxMi4wMDAwMDBaIn19.gJzBYVKseiVX6RacD4p7BUZpHg0nTRcBPVlXdGw1aXs', '30eea063442fc8a6c370628bbdff30bdf82c2569d775547fc459f61626893bdd', '5QuAW2/Zspqnm4G4yFaAN60EZU/UdP531XWprm3ZMzxdUAa7rJg41yx6Cm+4/4AH', 'web', '1234567890', 'custom', NULL, '103.86.55.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', '2023-09-29 21:28:48', '2023-09-29 21:28:48', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `user_cards`
--
CREATE TABLE `user_cards` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`card_id` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_4_digit` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`brand` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_default` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_connect_account`
--
CREATE TABLE `user_connect_account` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_of_birth` date NOT NULL,
`ssn` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`id_front` text COLLATE utf8mb4_unicode_ci NOT NULL,
`id_back` text COLLATE utf8mb4_unicode_ci NOT NULL,
`city` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`state` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`street` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`postal_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('pending','verified','unverified') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`due_fields` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_external_account`
--
CREATE TABLE `user_external_account` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`gateway_external_account_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`last4_digit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_default` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_groups`
--
CREATE TABLE `user_groups` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`type` enum('admin','user') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
`is_super_admin` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `user_groups`
--
INSERT INTO `user_groups` (`id`, `title`, `slug`, `description`, `type`, `is_super_admin`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Super Admin', 'super-admin', NULL, 'admin', '1', '1', '2023-06-26 13:20:53', NULL, NULL),
(2, 'Admin', 'admin', NULL, 'admin', '0', '1', '2023-06-26 13:20:53', '2023-09-07 15:13:57', NULL),
(3, 'Patient', 'patient', NULL, 'user', '0', '1', '2023-06-26 13:20:53', NULL, NULL),
(4, 'Lab Consultant', 'lab-consultant', NULL, 'user', '0', '1', '2023-06-26 13:20:53', NULL, NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `application_setting`
--
ALTER TABLE `application_setting`
ADD PRIMARY KEY (`id`),
ADD KEY `identifier` (`identifier`),
ADD KEY `meta_key` (`meta_key`);
--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `booking_slug_unique` (`slug`),
ADD KEY `booking_user_id_foreign` (`user_id`);
--
-- Indexes for table `booking_detail`
--
ALTER TABLE `booking_detail`
ADD PRIMARY KEY (`id`),
ADD KEY `booking_detail_booking_id_foreign` (`booking_id`),
ADD KEY `booking_detail_service_id_foreign` (`service_id`);
--
-- Indexes for table `booking_status_logs`
--
ALTER TABLE `booking_status_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `booking_status_logs_booking_id_foreign` (`booking_id`),
ADD KEY `booking_status_logs_user_id_foreign` (`user_id`);
--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `careers_slug_unique` (`slug`);
--
-- Indexes for table `cms_modules`
--
ALTER TABLE `cms_modules`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `cms_modules_name_unique` (`name`);
--
-- Indexes for table `cms_module_permissions`
--
ALTER TABLE `cms_module_permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `cms_module_permissions_user_id_foreign` (`user_id`),
ADD KEY `cms_module_permissions_user_group_id_foreign` (`user_group_id`),
ADD KEY `cms_module_permissions_cms_module_id_foreign` (`cms_module_id`);
--
-- Indexes for table `cms_widgets`
--
ALTER TABLE `cms_widgets`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `cms_widgets_slug_unique` (`slug`),
ADD KEY `cms_widgets_widget_type_index` (`widget_type`);
--
-- Indexes for table `cms_widget_role`
--
ALTER TABLE `cms_widget_role`
ADD PRIMARY KEY (`id`),
ADD KEY `cms_widget_role_cms_widget_id_foreign` (`cms_widget_id`),
ADD KEY `cms_widget_role_user_group_id_foreign` (`user_group_id`),
ADD KEY `cms_widget_role_user_id_foreign` (`user_id`);
--
-- Indexes for table `contact_us`
--
ALTER TABLE `contact_us`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `contact_us_slug_unique` (`slug`);
--
-- Indexes for table `content_management`
--
ALTER TABLE `content_management`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `content_management_slug_unique` (`slug`);
--
-- Indexes for table `diagnostic_services`
--
ALTER TABLE `diagnostic_services`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `diagnostic_services_slug_unique` (`slug`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `faqs_slug_unique` (`slug`);
--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`id`),
ADD KEY `jobs_queue_index` (`queue`);
--
-- Indexes for table `media`
--
ALTER TABLE `media`
ADD PRIMARY KEY (`id`),
ADD KEY `media_module_module_id_index` (`module`,`module_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `notifications_unique_id_unique` (`unique_id`),
ADD KEY `notifications_actor_id_foreign` (`actor_id`),
ADD KEY `notifications_target_id_foreign` (`target_id`),
ADD KEY `notifications_unique_id_identifier_target_id_index` (`unique_id`,`identifier`,`target_id`);
--
-- Indexes for table `notification_setting`
--
ALTER TABLE `notification_setting`
ADD PRIMARY KEY (`id`),
ADD KEY `notification_setting_user_id_foreign` (`user_id`);
--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);
--
-- Indexes for table `reset_password`
--
ALTER TABLE `reset_password`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `services_slug_unique` (`slug`),
ADD KEY `services_user_id_foreign` (`user_id`);
--
-- Indexes for table `specialities`
--
ALTER TABLE `specialities`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `specialities_slug_unique` (`slug`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_username_unique` (`username`),
ADD UNIQUE KEY `users_slug_unique` (`slug`),
ADD UNIQUE KEY `users_email_unique` (`email`),
ADD UNIQUE KEY `users_mobile_no_unique` (`mobile_no`),
ADD KEY `index1` (`user_group_id`,`slug`,`email`,`mobile_no`,`is_email_verify`,`status`);
--
-- Indexes for table `user_api_token`
--
ALTER TABLE `user_api_token`
ADD PRIMARY KEY (`id`),
ADD KEY `user_api_token_user_id_foreign` (`user_id`);
--
-- Indexes for table `user_cards`
--
ALTER TABLE `user_cards`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `user_cards_slug_unique` (`slug`),
ADD KEY `user_cards_user_id_foreign` (`user_id`);
--
-- Indexes for table `user_connect_account`
--
ALTER TABLE `user_connect_account`
ADD PRIMARY KEY (`id`),
ADD KEY `user_connect_account_user_id_foreign` (`user_id`);
--
-- Indexes for table `user_external_account`
--
ALTER TABLE `user_external_account`
ADD PRIMARY KEY (`id`),
ADD KEY `user_external_account_user_id_foreign` (`user_id`);
--
-- Indexes for table `user_groups`
--
ALTER TABLE `user_groups`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `user_groups_title_unique` (`title`),
ADD UNIQUE KEY `user_groups_slug_unique` (`slug`),
ADD KEY `user_groups_slug_status_index` (`slug`,`status`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `application_setting`
--
ALTER TABLE `application_setting`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `booking_detail`
--
ALTER TABLE `booking_detail`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `booking_status_logs`
--
ALTER TABLE `booking_status_logs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cms_modules`
--
ALTER TABLE `cms_modules`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `cms_module_permissions`
--
ALTER TABLE `cms_module_permissions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
--
-- AUTO_INCREMENT for table `cms_widgets`
--
ALTER TABLE `cms_widgets`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `cms_widget_role`
--
ALTER TABLE `cms_widget_role`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `content_management`
--
ALTER TABLE `content_management`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `diagnostic_services`
--
ALTER TABLE `diagnostic_services`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `notification_setting`
--
ALTER TABLE `notification_setting`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `reset_password`
--
ALTER TABLE `reset_password`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=202;
--
-- AUTO_INCREMENT for table `specialities`
--
ALTER TABLE `specialities`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `user_api_token`
--
ALTER TABLE `user_api_token`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT for table `user_cards`
--
ALTER TABLE `user_cards`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_connect_account`
--
ALTER TABLE `user_connect_account`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_external_account`
--
ALTER TABLE `user_external_account`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_groups`
--
ALTER TABLE `user_groups`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `booking`
--
ALTER TABLE `booking`
ADD CONSTRAINT `booking_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `booking_detail`
--
ALTER TABLE `booking_detail`
ADD CONSTRAINT `booking_detail_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `booking_detail_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `booking_status_logs`
--
ALTER TABLE `booking_status_logs`
ADD CONSTRAINT `booking_status_logs_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `booking_status_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `cms_module_permissions`
--
ALTER TABLE `cms_module_permissions`
ADD CONSTRAINT `cms_module_permissions_cms_module_id_foreign` FOREIGN KEY (`cms_module_id`) REFERENCES `cms_modules` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `cms_module_permissions_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `cms_module_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `cms_widget_role`
--
ALTER TABLE `cms_widget_role`
ADD CONSTRAINT `cms_widget_role_cms_widget_id_foreign` FOREIGN KEY (`cms_widget_id`) REFERENCES `cms_widgets` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `cms_widget_role_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `cms_widget_role_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
ADD CONSTRAINT `notifications_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `notifications_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `notification_setting`
--
ALTER TABLE `notification_setting`
ADD CONSTRAINT `notification_setting_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `services`
--
ALTER TABLE `services`
ADD CONSTRAINT `services_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `user_api_token`
--
ALTER TABLE `user_api_token`
ADD CONSTRAINT `user_api_token_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `user_cards`
--
ALTER TABLE `user_cards`
ADD CONSTRAINT `user_cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `user_connect_account`
--
ALTER TABLE `user_connect_account`
ADD CONSTRAINT `user_connect_account_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `user_external_account`
--
ALTER TABLE `user_external_account`
ADD CONSTRAINT `user_external_account_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
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 */;
![\"\"](\"/images/black-check.png\")
\r\n