-- Table structure for table `clinic`
--

CREATE TABLE `clinic` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `system_service_category` bigint unsigned DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `contact_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` int DEFAULT NULL,
  `state` int DEFAULT NULL,
  `country` int DEFAULT NULL,
  `pincode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `time_slot` int DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinic`
--

INSERT INTO `clinic` VALUES (1,'HeartCare & OrthoCare Center','heartcare_orthocare_center@gmail.com','heartcare-orthocare-center',1,'Specialized medical services tailored to specific health needs and conditions. 🏥👩‍⚕️','1-63852598','349 Oak Avenue',42594,3919,231,NULL,NULL,NULL,1,5,1,NULL,NULL,NULL,'2024-09-03 23:48:35','2024-09-23 11:55:54','2024-09-23 11:55:54'),(2,'Harmony Medical Center','heartcare_orthocare_center@gmail.com','harmony-medical-center',2,'Comprehensive healthcare for common illnesses and preventive care. 🩺💊','1-52638596','178 Main Street',42594,3919,231,NULL,NULL,NULL,1,5,1,NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-23 11:56:02','2024-09-23 11:56:02'),(3,'Wellness Dental Clinic','heartcare_orthocare_center@gmail.com','wellness-dental-clinic',3,'Services focused on oral health and hygiene, including examinations and treatments. 🦷😁','1-78538597','466 Elm Street',42594,3919,231,NULL,NULL,NULL,1,5,1,NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-23 11:56:10','2024-09-23 11:56:10'),(4,'Dermatology Associates','heartcare_orthocare_center@gmail.com','dermatology-associates',1,'Specialized medical care provided by expert clinicians in various fields. 🏥👨‍⚕️','1-58592639','901 Pine Street',42594,3919,231,NULL,NULL,NULL,1,5,3,NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(5,'VisionPlus Eye Clinic','heartcare_orthocare_center@gmail.com','visionplus-eye-clinic',1,'Specialized healthcare services offering cutting-edge treatments and personalized care plans. 🏥👩‍⚕️','1-26385601','561 Cedar Street',42594,3919,231,NULL,NULL,NULL,1,5,4,NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(6,'Hello Test','hello@yopmail.com','hello-test',1,'test','7896541230','abc,xyz',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1,1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:10','2024-09-05 12:31:10'),(7,'Hello Test','hello@yopmail.com','hello-test',1,'test','7896541230','abc,xyz',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1,1,1,NULL,'2024-09-05 12:32:24','2024-09-23 11:55:42','2024-09-23 11:55:42'),(8,'Cognition Demo','russ@cognition-healthcare.com','cognition-demo',NULL,NULL,'+44 7903 284827','123, Overhere Road, Overhere. Staffordshire WS12 5ZZ',41396,3805,230,NULL,NULL,NULL,1,5,1,1,1,NULL,'2024-09-24 09:30:25','2024-09-24 09:31:58','2024-09-24 09:31:58'),(9,'Darshit Goti','demo@yopmail.com','darshit-goti',NULL,NULL,'+44 70 4386 1703','Surat, Gujarat',1041,12,101,'395006',NULL,NULL,1,5,1,1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:29','2024-09-24 09:32:29'),(10,'Dr. Bharta','drb@yopmail.com','dr-bharta',1,NULL,'+91 11 4477 8855','Test',1041,12,101,'998989',NULL,NULL,1,5,2,2,2,NULL,'2024-09-24 10:38:02','2024-09-24 19:06:37','2024-09-24 19:06:37'),(11,'Sun Clinic','sunclinic@yopmail.com','sun-clinic',1,'Sun ClinicSun ClinicSun Clinic','+91 76219 08664','katargam',1041,12,101,NULL,NULL,NULL,1,15,1,1,1,NULL,'2024-09-26 11:57:33','2024-10-09 11:02:56','2024-10-09 11:02:56'),(12,'test clinic','test@yopmail.com','test-clinic',4,'test clinic','+91 1234 567 890','test',1041,12,101,NULL,NULL,NULL,1,20,1,1,1,NULL,'2024-09-27 04:45:01','2024-09-28 09:25:06','2024-09-28 09:25:06'),(13,'test clinic1','testclinic@yopmail.com','test-clinic1',NULL,'5e5e','+91 1234 567 890','test',1041,12,101,NULL,NULL,NULL,1,5,1,1,1,NULL,'2024-09-28 09:26:09','2024-10-09 11:02:46','2024-10-09 11:02:46'),(14,'Cognition Demo Clinic','russcognitionhealthcare@gmail.com','cognition-demo-clinic',1,'Demo','+44 1234 597584','123 Health Drive\r\nAbbey Green\r\nStaffordshire\r\nB77 1LJ',21,13,1,NULL,NULL,NULL,1,5,1,1,1,NULL,'2024-10-09 11:02:36','2024-10-09 11:41:10',NULL);

--
-- Table structure for table `clinic_appointments`
--

CREATE TABLE `clinic_appointments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clinic_id` int NOT NULL,
  `appointment_date` datetime DEFAULT NULL,
  `appointment_time` datetime DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `doctor_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinic_appointments`
--


--
-- Table structure for table `clinic_gallery`
--

CREATE TABLE `clinic_gallery` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clinic_id` bigint unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `full_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinic_gallery`
--


--
-- Table structure for table `clinic_service_mapping`
--

CREATE TABLE `clinic_service_mapping` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `service_id` int DEFAULT NULL,
  `clinic_id` int DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinic_service_mapping`
--

INSERT INTO `clinic_service_mapping` VALUES (1,1,1,NULL,NULL,NULL,'2024-09-03 23:49:02','2024-09-23 15:24:13','2024-09-23 15:24:13'),(2,2,1,NULL,NULL,NULL,'2024-09-03 23:49:05','2024-09-23 15:24:27','2024-09-23 15:24:27'),(3,3,1,NULL,NULL,NULL,'2024-09-03 23:49:07','2024-09-23 15:24:18','2024-09-23 15:24:18'),(4,4,1,NULL,NULL,NULL,'2024-09-03 23:49:08','2024-09-23 15:24:07','2024-09-23 15:24:07'),(5,5,1,NULL,NULL,NULL,'2024-09-03 23:49:10','2024-09-23 15:24:02','2024-09-23 15:24:02'),(6,6,1,NULL,NULL,NULL,'2024-09-03 23:49:11','2024-09-23 15:23:57','2024-09-23 15:23:57'),(7,7,1,NULL,NULL,NULL,'2024-09-03 23:49:14','2024-09-23 15:23:51','2024-09-23 15:23:51'),(8,8,1,NULL,NULL,NULL,'2024-09-03 23:49:16','2024-09-23 15:23:46','2024-09-23 15:23:46'),(9,9,1,NULL,NULL,NULL,'2024-09-03 23:49:18','2024-09-23 15:23:41','2024-09-23 15:23:41'),(10,10,1,NULL,NULL,NULL,'2024-09-03 23:49:20','2024-09-23 15:23:36','2024-09-23 15:23:36'),(11,11,1,NULL,NULL,NULL,'2024-09-03 23:49:21','2024-09-23 15:23:31','2024-09-23 15:23:31'),(12,12,1,NULL,NULL,NULL,'2024-09-03 23:49:22','2024-09-23 15:23:26','2024-09-23 15:23:26'),(13,13,1,NULL,NULL,NULL,'2024-09-03 23:49:26','2024-09-23 15:23:21','2024-09-23 15:23:21'),(14,14,1,NULL,NULL,NULL,'2024-09-03 23:49:29','2024-09-23 15:23:15','2024-09-23 15:23:15'),(15,15,1,NULL,NULL,NULL,'2024-09-03 23:49:31','2024-09-23 15:23:09','2024-09-23 15:23:09'),(16,16,1,NULL,NULL,NULL,'2024-09-03 23:49:33','2024-09-23 15:23:05','2024-09-23 15:23:05'),(17,17,1,NULL,NULL,NULL,'2024-09-03 23:49:35','2024-09-23 15:23:00','2024-09-23 15:23:00'),(18,18,1,NULL,NULL,NULL,'2024-09-03 23:49:37','2024-09-23 15:22:39','2024-09-23 15:22:39'),(19,19,1,NULL,NULL,NULL,'2024-09-03 23:49:38','2024-09-23 15:22:55','2024-09-23 15:22:55'),(20,20,1,NULL,NULL,NULL,'2024-09-03 23:49:41','2024-09-23 15:24:22','2024-09-23 15:24:22'),(21,21,1,NULL,NULL,NULL,'2024-09-03 23:49:44','2024-09-23 15:22:50','2024-09-23 15:22:50'),(22,22,1,NULL,NULL,NULL,'2024-09-03 23:49:46','2024-09-23 15:22:46','2024-09-23 15:22:46'),(23,23,1,NULL,NULL,NULL,'2024-09-03 23:49:48','2024-09-23 15:24:31','2024-09-23 15:24:31'),(24,24,1,NULL,NULL,NULL,'2024-09-03 23:49:49','2024-09-23 15:22:27','2024-09-23 15:22:27'),(25,25,1,NULL,NULL,NULL,'2024-09-03 23:49:50','2024-09-23 15:22:23','2024-09-23 15:22:23'),(26,26,1,NULL,NULL,NULL,'2024-09-03 23:49:53','2024-09-23 15:22:17','2024-09-23 15:22:17'),(27,27,1,NULL,NULL,NULL,'2024-09-03 23:49:56','2024-09-23 15:22:12','2024-09-23 15:22:12'),(28,28,1,NULL,NULL,NULL,'2024-09-03 23:49:58','2024-09-23 15:22:08','2024-09-23 15:22:08'),(29,29,1,NULL,NULL,NULL,'2024-09-03 23:50:00','2024-09-23 15:22:03','2024-09-23 15:22:03'),(30,30,2,NULL,NULL,NULL,'2024-09-03 23:50:01','2024-09-23 15:21:57','2024-09-23 15:21:57'),(31,31,2,NULL,NULL,NULL,'2024-09-03 23:50:02','2024-09-23 15:21:51','2024-09-23 15:21:51'),(32,32,2,NULL,NULL,NULL,'2024-09-03 23:50:06','2024-09-23 15:21:46','2024-09-23 15:21:46'),(33,33,2,NULL,NULL,NULL,'2024-09-03 23:50:08','2024-09-23 15:21:41','2024-09-23 15:21:41'),(34,34,2,NULL,NULL,NULL,'2024-09-03 23:50:10','2024-09-23 15:21:36','2024-09-23 15:21:36'),(35,35,2,NULL,NULL,NULL,'2024-09-03 23:50:12','2024-09-23 15:21:32','2024-09-23 15:21:32'),(36,36,2,NULL,NULL,NULL,'2024-09-03 23:50:13','2024-09-23 15:21:28','2024-09-23 15:21:28'),(37,37,3,NULL,NULL,NULL,'2024-09-03 23:50:15','2024-09-23 15:21:24','2024-09-23 15:21:24'),(38,38,3,NULL,NULL,NULL,'2024-09-03 23:50:18','2024-09-23 15:21:19','2024-09-23 15:21:19'),(39,39,3,NULL,NULL,NULL,'2024-09-03 23:50:20','2024-09-23 15:21:15','2024-09-23 15:21:15'),(40,40,3,NULL,NULL,NULL,'2024-09-03 23:50:22','2024-09-23 15:21:10','2024-09-23 15:21:10'),(41,41,3,NULL,NULL,NULL,'2024-09-03 23:50:24','2024-09-23 15:21:03','2024-09-23 15:21:03'),(42,42,4,NULL,NULL,NULL,'2024-09-03 23:50:25','2024-09-03 23:50:25',NULL),(43,43,4,NULL,NULL,NULL,'2024-09-03 23:50:27','2024-09-03 23:50:27',NULL),(44,44,4,NULL,NULL,NULL,'2024-09-03 23:50:30','2024-09-03 23:50:30',NULL),(45,45,4,NULL,NULL,NULL,'2024-09-03 23:50:33','2024-09-03 23:50:33',NULL),(46,46,5,NULL,NULL,NULL,'2024-09-03 23:50:35','2024-09-03 23:50:35',NULL),(47,47,5,NULL,NULL,NULL,'2024-09-03 23:50:37','2024-09-03 23:50:37',NULL),(48,48,5,NULL,NULL,NULL,'2024-09-03 23:50:38','2024-09-03 23:50:38',NULL),(49,49,5,NULL,NULL,NULL,'2024-09-03 23:50:40','2024-09-03 23:50:40',NULL),(50,50,10,2,2,NULL,'2024-09-24 11:23:08','2024-09-24 11:23:08',NULL),(51,51,11,1,1,NULL,'2024-09-26 12:01:20','2024-09-26 12:01:20',NULL),(54,52,12,1,1,NULL,'2024-09-28 09:29:40','2024-09-28 09:30:28','2024-09-28 09:30:28'),(55,52,13,1,1,NULL,'2024-09-28 09:29:40','2024-09-28 09:30:28','2024-09-28 09:30:28'),(57,53,13,1,1,NULL,'2024-09-28 09:54:47','2024-09-28 09:54:47',NULL);

--
-- Table structure for table `clinic_session`
--

CREATE TABLE `clinic_session` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clinic_id` int DEFAULT NULL,
  `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_holiday` tinyint DEFAULT NULL,
  `breaks` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinic_session`
--

INSERT INTO `clinic_session` VALUES (1,1,'monday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(2,1,'tuesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(3,1,'wednesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(4,1,'thursday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(5,1,'friday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(6,1,'saturday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(7,1,'sunday','09:00:00','18:00:00',1,'[]',NULL,NULL,NULL,'2024-09-03 23:48:37','2024-09-03 23:48:37',NULL),(8,2,'monday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(9,2,'tuesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(10,2,'wednesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(11,2,'thursday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(12,2,'friday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(13,2,'saturday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(14,2,'sunday','09:00:00','18:00:00',1,'[]',NULL,NULL,NULL,'2024-09-03 23:48:38','2024-09-03 23:48:38',NULL),(15,3,'monday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(16,3,'tuesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(17,3,'wednesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(18,3,'thursday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(19,3,'friday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(20,3,'saturday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(21,3,'sunday','09:00:00','18:00:00',1,'[]',NULL,NULL,NULL,'2024-09-03 23:48:39','2024-09-03 23:48:39',NULL),(22,4,'monday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(23,4,'tuesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(24,4,'wednesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(25,4,'thursday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(26,4,'friday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(27,4,'saturday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(28,4,'sunday','09:00:00','18:00:00',1,'[]',NULL,NULL,NULL,'2024-09-03 23:48:40','2024-09-03 23:48:40',NULL),(29,5,'monday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(30,5,'tuesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(31,5,'wednesday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(32,5,'thursday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(33,5,'friday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(34,5,'saturday','09:00:00','18:00:00',0,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(35,5,'sunday','09:00:00','18:00:00',1,'[]',NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-03 23:48:42',NULL),(36,6,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(37,6,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(38,6,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(39,6,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(40,6,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(41,6,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(42,6,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-05 12:31:00','2024-09-05 12:31:00',NULL),(43,7,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(44,7,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(45,7,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(46,7,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(47,7,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(48,7,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(49,7,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-05 12:32:24','2024-09-05 12:32:24',NULL),(50,8,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(51,8,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(52,8,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(53,8,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(54,8,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(55,8,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(56,8,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-24 09:31:40','2024-09-24 09:31:40',NULL),(57,9,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(58,9,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(59,9,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(60,9,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(61,9,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(62,9,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(63,9,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-24 09:32:22','2024-09-24 09:32:22',NULL),(64,10,'monday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(65,10,'tuesday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(66,10,'wednesday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(67,10,'thursday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(68,10,'friday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(69,10,'saturday','09:00:00','18:00:00',0,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(70,10,'sunday','09:00:00','18:00:00',1,'[]',2,2,NULL,'2024-09-24 10:38:03','2024-09-24 10:38:03',NULL),(71,11,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(72,11,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(73,11,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(74,11,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(75,11,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(76,11,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(77,11,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-26 11:57:34','2024-09-26 11:57:34',NULL),(78,12,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(79,12,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(80,12,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(81,12,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(82,12,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(83,12,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(84,12,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-27 04:45:01','2024-09-27 04:45:01',NULL),(85,13,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(86,13,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(87,13,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(88,13,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(89,13,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(90,13,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(91,13,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-09-28 09:26:09','2024-09-28 09:26:09',NULL),(92,14,'monday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(93,14,'tuesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(94,14,'wednesday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(95,14,'thursday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(96,14,'friday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(97,14,'saturday','09:00:00','18:00:00',0,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL),(98,14,'sunday','09:00:00','18:00:00',1,'[]',1,1,NULL,'2024-10-09 11:02:37','2024-10-09 11:02:37',NULL);

--
-- Table structure for table `clinichours`
--

CREATE TABLE `clinichours` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clinic_id` int NOT NULL,
  `vendor_id` int DEFAULT NULL,
  `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_holiday` tinyint DEFAULT NULL,
  `breaks` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinichours`
--


--
-- Table structure for table `clinics_categories`
--

CREATE TABLE `clinics_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `parent_id` bigint unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinics_categories`
--

INSERT INTO `clinics_categories` VALUES (1,'cardiology','Cardiology',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:42','2024-09-23 18:20:45','2024-09-23 18:20:45'),(2,'electrophysiology','Electrophysiology',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:43','2024-09-23 18:20:30','2024-09-23 18:20:30'),(3,'heart-monitoring','Heart Monitoring',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:44','2024-09-23 18:20:22','2024-09-23 18:20:22'),(4,'coronary-angiography','Coronary Angiography',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:45','2024-09-23 18:20:04','2024-09-23 18:20:04'),(5,'genetic-cardiology-services','Genetic Cardiology Services',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:45','2024-09-23 18:20:13','2024-09-23 18:20:13'),(6,'orthotics-and-prosthetics','Orthotics and Prosthetics',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:46','2024-09-23 18:20:53','2024-09-23 18:20:53'),(7,'joint-replacement','Joint Replacement',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:47','2024-09-23 18:21:00','2024-09-23 18:21:00'),(8,'spine-care','Spine Care',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:49','2024-09-03 23:48:49',NULL),(9,'osteoporosis','Osteoporosis',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:50','2024-09-23 18:19:57','2024-09-23 18:19:57'),(10,'minimally-invasive-surgery','Minimally Invasive Surgery',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:51','2024-09-23 18:21:10','2024-09-23 18:21:10'),(11,'primary-care','Primary Care',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:52','2024-09-23 15:25:28','2024-09-23 15:25:28'),(12,'integrative-health','Integrative Health',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:53','2024-09-23 15:25:23','2024-09-23 15:25:23'),(13,'pediatrics','Pediatrics',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:54','2024-09-23 15:25:15','2024-09-23 15:25:15'),(14,'general-dentistry','General Dentistry',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:55','2024-09-23 15:25:09','2024-09-23 15:25:09'),(15,'oral-surgery','Oral Surgery',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:56','2024-09-23 15:25:06','2024-09-23 15:25:06'),(16,'cosmetic-dermatology','Cosmetic Dermatology',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:57','2024-09-23 15:25:01','2024-09-23 15:25:01'),(17,'mohs-surgery','Mohs Surgery',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:57','2024-09-23 15:24:55','2024-09-23 15:24:55'),(18,'ophthalmology','Ophthalmology',NULL,NULL,1,0,NULL,NULL,NULL,'2024-09-03 23:48:58','2024-09-23 15:24:50','2024-09-23 15:24:50'),(19,'optometry','Optometry',NULL,NULL,1,1,NULL,NULL,NULL,'2024-09-03 23:48:59','2024-09-23 15:24:45','2024-09-23 15:24:45'),(20,'test','test','test',NULL,1,0,1,1,NULL,'2024-09-28 09:24:08','2024-09-28 09:24:08',NULL);

--
-- Table structure for table `clinics_services`
--

CREATE TABLE `clinics_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `system_service_id` bigint unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'in_clinic',
  `is_video_consultancy` tinyint NOT NULL DEFAULT '0',
  `charges` double NOT NULL DEFAULT '0',
  `category_id` bigint unsigned DEFAULT NULL,
  `subcategory_id` bigint unsigned DEFAULT NULL,
  `vendor_id` bigint unsigned DEFAULT NULL,
  `duration_min` bigint NOT NULL DEFAULT '15',
  `time_slot` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '15',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `discount` tinyint(1) NOT NULL DEFAULT '0',
  `discount_value` double DEFAULT NULL,
  `discount_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinics_services`
--

INSERT INTO `clinics_services` VALUES (1,1,'Cardiac Consultation','Expert consultation for heart health concerns. 💔','in_clinic',0,100,1,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:01','2024-09-23 15:24:13','2024-09-23 15:24:13'),(2,2,'Echocardiography','Non-invasive imaging to assess heart function. 🩺','in_clinic',0,100,1,NULL,1,60,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:04','2024-09-23 15:24:27','2024-09-23 15:24:27'),(3,3,'Angioplasty','Procedure to widen narrowed or blocked blood vessels. 🩸','in_clinic',0,100,1,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:06','2024-09-23 15:24:18','2024-09-23 15:24:18'),(4,4,'Electrophysiology Study (EPS)','Diagnostic procedure to evaluate heart rhythm abnormalities. ⚡','in_clinic',0,100,2,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:08','2024-09-23 15:24:07','2024-09-23 15:24:07'),(5,5,'Cardiac Ablation','Treatment to correct heart rhythm problems by destroying abnormal heart tissue. 🔥','in_clinic',0,100,2,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:09','2024-09-23 15:24:02','2024-09-23 15:24:02'),(6,6,'Implantable Cardioverter Defibrillator (ICD) Placement','Surgical procedure to implant a device that corrects dangerous heart rhythms. 💓','in_clinic',0,100,2,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:10','2024-09-23 15:23:57','2024-09-23 15:23:57'),(7,7,'Holter Monitoring','Continuous heart rhythm monitoring over a period of time using a portable device. 📈','in_clinic',0,100,3,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:12','2024-09-23 15:23:51','2024-09-23 15:23:51'),(8,8,'Event Monitoring','Recording of heart activity during specific events or symptoms using a portable device. 📊','in_clinic',0,100,3,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:15','2024-09-23 15:23:46','2024-09-23 15:23:46'),(9,9,'Implantable Loop Recorder (ILR)','Long-term monitoring of heart rhythm with a small device implanted under the skin. ⏰','in_clinic',0,100,3,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:17','2024-09-23 15:23:41','2024-09-23 15:23:41'),(10,10,'Hypertension Screening','Evaluation of blood pressure to detect and assess hypertension. 🩺','in_clinic',0,100,3,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:19','2024-09-23 15:23:36','2024-09-23 15:23:36'),(11,11,'Diagnostic Coronary Angiography','Procedure to visualize and assess coronary artery blockages. 🩺','in_clinic',0,100,4,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:20','2024-09-23 15:23:31','2024-09-23 15:23:31'),(12,12,'Percutaneous Coronary Intervention (PCI)','Minimally invasive procedure to open blocked coronary arteries. ⚡','in_clinic',0,100,4,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:22','2024-09-23 15:23:26','2024-09-23 15:23:26'),(13,13,'Coronary Artery Bypass Grafting (CABG)','Surgical procedure to bypass blocked coronary arteries. ✂️','in_clinic',0,100,4,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:25','2024-09-23 15:23:21','2024-09-23 15:23:21'),(14,14,'Genetic Testing for Cardiac Conditions','Screening for genetic factors contributing to heart diseases. 🧬','in_clinic',0,100,5,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:28','2024-09-23 15:23:15','2024-09-23 15:23:15'),(15,15,'Genetic Counseling for Heart Diseases','Counseling to understand and manage genetic risks of heart disorders. 💬','in_clinic',0,100,5,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:30','2024-09-23 15:23:09','2024-09-23 15:23:09'),(16,16,'Family Screening for Inherited Heart Disorders','Screening family members for inherited heart conditions. 👨‍👩‍👧‍👦','in_clinic',0,100,5,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:32','2024-09-23 15:23:05','2024-09-23 15:23:05'),(17,17,'Orthopedic Sergery','Comprehensive surgical procedures for musculoskeletal conditions. 🏥','in_clinic',0,100,6,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:34','2024-09-23 15:23:00','2024-09-23 15:23:00'),(18,18,'Prosthetic Limb Fitting','Fitting and adjustment of prosthetic limbs for mobility and function. 🦿','in_clinic',0,100,6,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:36','2024-09-23 15:22:39','2024-09-23 15:22:39'),(19,19,'hip-replacement','Surgical procedure to replace a damaged hip joint with an artificial one. 🦵','in_clinic',0,100,7,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:37','2024-09-23 15:22:55','2024-09-23 15:22:55'),(20,20,'Knee Replacement','Surgery to replace a damaged knee joint with a prosthetic implant. 🦵','in_clinic',0,100,7,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:40','2024-09-23 15:24:22','2024-09-23 15:24:22'),(21,21,'Shoulder Replacement','Surgical procedure to replace a damaged shoulder joint with an artificial one. 🦋','in_clinic',0,100,7,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:42','2024-09-23 15:22:50','2024-09-23 15:22:50'),(22,22,'Spinal Fusion Surgery','Surgical technique to join two or more vertebrae in the spine. ⛓️','in_clinic',0,100,8,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:45','2024-09-23 15:22:46','2024-09-23 15:22:46'),(23,23,'Discectomy','Surgical removal of herniated disc material pressing on a nerve root or the spinal cord. 🔪','in_clinic',0,100,8,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:47','2024-09-23 15:24:31','2024-09-23 15:24:31'),(24,24,'Spinal Decompression Treatment','Non-surgical treatment to relieve pressure on spinal discs and nerves. 🌀','in_clinic',0,100,8,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:48','2024-09-23 15:22:27','2024-09-23 15:22:27'),(25,25,'Bone Density Testing','Diagnostic test to measure bone density and assess the risk of fractures. 💀','in_clinic',0,100,9,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:50','2024-09-23 15:22:23','2024-09-23 15:22:23'),(26,26,'Osteoporosis Medication Treatment','Treatment plan to manage osteoporosis and prevent bone loss. 💊','in_clinic',0,100,9,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:52','2024-09-23 15:22:17','2024-09-23 15:22:17'),(27,27,'Laparoscopic Surgery','Minimally invasive surgical technique using small incisions and a camera. 🩹','in_clinic',0,100,10,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:54','2024-09-23 15:22:12','2024-09-23 15:22:12'),(28,28,'Endoscopic Surgery','Surgical procedure performed through a small incision with an endoscope. 🩹','in_clinic',0,100,10,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:57','2024-09-23 15:22:08','2024-09-23 15:22:08'),(29,29,'Robotic Surgery','Surgical technique performed with the assistance of robotic arms controlled by a surgeon. 🤖','in_clinic',0,100,10,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:49:59','2024-09-23 15:22:03','2024-09-23 15:22:03'),(30,30,'Routine Check-ups and Physical Examinations','Regular health check-ups to monitor your well-being. 👩‍⚕️ ','in_clinic',0,100,11,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:00','2024-09-23 15:21:57','2024-09-23 15:21:57'),(31,31,'Diagnosis and Treatment of Common Illnesses','Expert care for everyday health issues like colds and flu. 💊 ','in_clinic',0,100,11,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:02','2024-09-23 15:21:51','2024-09-23 15:21:51'),(32,32,'Vaccinations and Immunizations','Protect yourself and your loved ones with timely vaccinations. 💉','in_clinic',0,100,11,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:04','2024-09-23 15:21:46','2024-09-23 15:21:46'),(33,33,'Acupuncture','Traditional healing through precise needle therapy.📍','in_clinic',0,100,12,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:07','2024-09-23 15:21:41','2024-09-23 15:21:41'),(34,34,'Nutritional Supplements and Dietary Counseling','Personalized guidance for optimal nutrition. 🥦','in_clinic',0,100,12,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:09','2024-09-23 15:21:36','2024-09-23 15:21:36'),(35,35,'Pediatric Primary Care','Comprehensive medical care tailored to meet your childs needs. 👨‍⚕️👧','in_clinic',0,100,13,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:11','2024-09-23 15:21:32','2024-09-23 15:21:32'),(36,36,'Childhood Illness Management','Expert care for common childhood illnesses and conditions. 🤒💊','in_clinic',0,100,13,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:13','2024-09-23 15:21:28','2024-09-23 15:21:28'),(37,37,'Teeth Cleaning','Professional cleaning to remove plaque and tartar for a healthy smile. 😁✨','in_clinic',0,100,14,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:14','2024-09-23 15:21:24','2024-09-23 15:21:24'),(38,38,'Fillings','Restoring cavities and preserving teeth with durable dental fillings. 🦷💎','in_clinic',0,100,14,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:17','2024-09-23 15:21:19','2024-09-23 15:21:19'),(39,39,'Wisdom Teeth Removal','Surgically extracting problematic wisdom teeth to improve oral health. 💡🦷','in_clinic',0,100,15,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:19','2024-09-23 15:21:15','2024-09-23 15:21:15'),(40,40,'Dental Implant Surgery','Restoring missing teeth with permanent dental implants for a natural-looking smile. 💪🦷','in_clinic',0,100,15,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:21','2024-09-23 15:21:10','2024-09-23 15:21:10'),(41,41,'Tooth Extraction','Removing damaged or decayed teeth to alleviate pain and prevent further complications. 🪓🦷','in_clinic',0,100,15,NULL,1,30,'15',1,0,NULL,NULL,NULL,1,1,'2024-09-03 23:50:23','2024-09-23 15:21:03','2024-09-23 15:21:03'),(42,42,'Dermal Fillers','Enhancing facial volume and reducing wrinkles for a youthful appearance. 💉✨','in_clinic',0,100,16,NULL,3,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:25','2024-09-03 23:50:25',NULL),(43,43,'Chemical Peels','Renew and rejuvenate skin. 🔬','in_clinic',0,100,16,NULL,3,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:26','2024-09-03 23:50:26',NULL),(44,44,'Skin Cancer Removal','Surgical removal of cancerous skin lesions to promote healing and prevent spread. 🩹🌞','in_clinic',0,100,17,NULL,3,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:27','2024-09-03 23:50:27',NULL),(45,45,'Mohs Micrographic Surgery','Highly precise technique for removing skin cancer while preserving healthy tissue. 🎨🔍','in_clinic',0,100,17,NULL,3,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:31','2024-09-03 23:50:31',NULL),(46,46,'Cataract Surgery','Surgical removal of cataracts to restore clear vision and improve quality of life. 👁️‍🗨️🔪','in_clinic',0,100,18,NULL,4,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:34','2024-09-03 23:50:34',NULL),(47,47,'LASIK Eye Surgery','Laser vision correction to improve vision and reduce dependence on glasses or contacts. 👁️‍🗨️💫','in_clinic',0,100,18,NULL,4,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:36','2024-09-03 23:50:36',NULL),(48,48,'Comprehensive Eye Examinations','Thorough evaluations to assess vision and eye health. 👁️‍🗨️🔍','in_clinic',0,100,19,NULL,4,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:38','2024-09-03 23:50:38',NULL),(49,49,'Contact Lens Fitting','Customized fittings for comfortable and clear vision with contact lenses. 👁️‍🗨️👓','in_clinic',0,100,19,NULL,4,30,'15',1,0,NULL,NULL,NULL,NULL,NULL,'2024-09-03 23:50:39','2024-09-03 23:50:39',NULL),(50,NULL,'Test Service',NULL,'in_clinic',0,100,8,NULL,2,60,'5',1,0,0,'fixed',2,2,NULL,'2024-09-24 11:23:08','2024-09-24 11:23:08',NULL),(51,NULL,'Sun Service',NULL,'in_clinic',0,55,8,8,1,30,'15',1,0,0,'fixed',1,18,NULL,'2024-09-26 12:01:20','2024-09-28 10:26:51',NULL),(52,NULL,'Test Service111',NULL,'in_clinic',0,10,20,NULL,1,50,'5',1,0,0,'fixed',1,1,1,'2024-09-28 09:24:40','2024-09-28 09:30:28','2024-09-28 09:30:28'),(53,NULL,'Test Service454',NULL,'in_clinic',0,100,20,NULL,1,50,'60',1,0,0,'fixed',1,1,NULL,'2024-09-28 09:31:12','2024-09-28 09:54:47',NULL);

--
-- Table structure for table `commission_earnings`
--

CREATE TABLE `commission_earnings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint unsigned NOT NULL,
  `commissionable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `commissionable_id` bigint unsigned NOT NULL,
  `commission_amount` double DEFAULT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commissions` text COLLATE utf8mb4_unicode_ci,
  `payment_date` date DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commission_earnings_commissionable_type_commissionable_id_index` (`commissionable_type`,`commissionable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commission_earnings`
--

INSERT INTO `commission_earnings` VALUES (1,18,'Modules\\Appointment\\Models\\Appointment',1,3,'doctor','unpaid','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:23:24','2024-05-27 00:27:18',NULL),(2,1,'Modules\\Appointment\\Models\\Appointment',1,147,'admin','unpaid',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:23:24','2024-05-27 00:27:18',NULL),(3,20,'Modules\\Appointment\\Models\\Appointment',2,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:23:50','2024-05-27 00:23:50',NULL),(4,1,'Modules\\Appointment\\Models\\Appointment',2,147,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:23:50','2024-05-27 00:23:50',NULL),(5,19,'Modules\\Appointment\\Models\\Appointment',3,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:24:19','2024-05-27 00:24:19',NULL),(6,1,'Modules\\Appointment\\Models\\Appointment',3,147,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:24:19','2024-05-27 00:24:19',NULL),(7,18,'Modules\\Appointment\\Models\\Appointment',4,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:24:46','2024-05-27 00:24:46',NULL),(8,1,'Modules\\Appointment\\Models\\Appointment',4,147,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:24:46','2024-05-27 00:24:46',NULL),(9,20,'Modules\\Appointment\\Models\\Appointment',5,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:25:18','2024-05-27 00:25:18',NULL),(10,1,'Modules\\Appointment\\Models\\Appointment',5,147,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:25:18','2024-05-27 00:25:18',NULL),(11,18,'Modules\\Appointment\\Models\\Appointment',6,3,'doctor','unpaid','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 00:26:25','2024-05-27 00:27:38',NULL),(12,1,'Modules\\Appointment\\Models\\Appointment',6,147,'admin','unpaid',NULL,NULL,NULL,NULL,NULL,'2024-05-27 00:26:25','2024-05-27 00:27:38',NULL),(13,21,'Modules\\Appointment\\Models\\Appointment',7,3,'doctor','unpaid','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:05:09','2024-05-27 01:09:17',NULL),(14,1,'Modules\\Appointment\\Models\\Appointment',7,3,'admin','unpaid','[{\"id\":1,\"title\":\"Admin Fees\",\"commission_type\":\"fixed\",\"commission_value\":3,\"type\":\"admin_fees\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:05:09','2024-05-27 01:09:17',NULL),(15,3,'Modules\\Appointment\\Models\\Appointment',7,144,'vendor','unpaid',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:05:09','2024-05-27 01:09:17',NULL),(16,22,'Modules\\Appointment\\Models\\Appointment',8,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:05:47','2024-05-27 01:05:47',NULL),(17,1,'Modules\\Appointment\\Models\\Appointment',8,3,'admin','pending','[{\"id\":1,\"title\":\"Admin Fees\",\"commission_type\":\"fixed\",\"commission_value\":3,\"type\":\"admin_fees\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:05:47','2024-05-27 01:05:47',NULL),(18,4,'Modules\\Appointment\\Models\\Appointment',8,144,'vendor','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:05:47','2024-05-27 01:05:47',NULL),(19,18,'Modules\\Appointment\\Models\\Appointment',9,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:06:19','2024-05-27 01:06:19',NULL),(20,1,'Modules\\Appointment\\Models\\Appointment',9,147,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:06:19','2024-05-27 01:06:19',NULL),(21,22,'Modules\\Appointment\\Models\\Appointment',10,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:06:49','2024-05-27 01:06:49',NULL),(22,1,'Modules\\Appointment\\Models\\Appointment',10,3,'admin','pending','[{\"id\":1,\"title\":\"Admin Fees\",\"commission_type\":\"fixed\",\"commission_value\":3,\"type\":\"admin_fees\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:06:49','2024-05-27 01:06:49',NULL),(23,4,'Modules\\Appointment\\Models\\Appointment',10,144,'vendor','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:06:49','2024-05-27 01:06:49',NULL),(24,21,'Modules\\Appointment\\Models\\Appointment',11,3,'doctor','pending','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:07:31','2024-05-27 01:07:31',NULL),(25,1,'Modules\\Appointment\\Models\\Appointment',11,3,'admin','pending','[{\"id\":1,\"title\":\"Admin Fees\",\"commission_type\":\"fixed\",\"commission_value\":3,\"type\":\"admin_fees\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:07:31','2024-05-27 01:07:31',NULL),(26,3,'Modules\\Appointment\\Models\\Appointment',11,144,'vendor','pending',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:07:31','2024-05-27 01:07:31',NULL),(27,20,'Modules\\Appointment\\Models\\Appointment',12,3,'doctor','unpaid','[{\"id\":3,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":2,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-05-27T05:50:18.000000Z\",\"updated_at\":\"2024-05-27T05:50:18.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-05-27 01:08:20','2024-05-27 01:09:06',NULL),(28,1,'Modules\\Appointment\\Models\\Appointment',12,147,'admin','unpaid',NULL,NULL,NULL,NULL,NULL,'2024-05-27 01:08:20','2024-05-27 01:09:06',NULL),(29,35,'Modules\\Appointment\\Models\\Appointment',13,34.4,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-26 12:12:28','2024-09-26 12:12:28',NULL),(30,1,'Modules\\Appointment\\Models\\Appointment',13,51.6,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-26 12:12:28','2024-09-26 12:12:28',NULL),(31,35,'Modules\\Appointment\\Models\\Appointment',14,34.4,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-26 12:36:35','2024-09-26 12:36:35',NULL),(32,1,'Modules\\Appointment\\Models\\Appointment',14,51.6,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-26 12:36:35','2024-09-26 12:36:35',NULL),(33,35,'Modules\\Appointment\\Models\\Appointment',15,34.4,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-27 05:15:50','2024-09-27 05:15:50',NULL),(34,1,'Modules\\Appointment\\Models\\Appointment',15,51.6,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-27 05:15:50','2024-09-27 05:15:50',NULL),(35,18,'Modules\\Appointment\\Models\\Appointment',16,49.76,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-28 09:59:11','2024-09-28 09:59:11',NULL),(36,1,'Modules\\Appointment\\Models\\Appointment',16,74.64,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-28 09:59:11','2024-09-28 09:59:11',NULL),(37,18,'Modules\\Appointment\\Models\\Appointment',17,49.76,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-28 10:00:55','2024-09-28 10:00:55',NULL),(38,1,'Modules\\Appointment\\Models\\Appointment',17,74.64,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-28 10:00:55','2024-09-28 10:00:55',NULL),(39,18,'Modules\\Appointment\\Models\\Appointment',19,49.76,'doctor','pending','[{\"id\":2,\"title\":\"Doctor Commission\",\"commission_type\":\"percentage\",\"commission_value\":40,\"type\":\"doctor_commission\",\"status\":1,\"created_by\":null,\"updated_by\":null,\"deleted_by\":null,\"created_at\":\"2024-09-03T23:50:42.000000Z\",\"updated_at\":\"2024-09-03T23:50:42.000000Z\",\"deleted_at\":null}]',NULL,NULL,NULL,NULL,'2024-09-30 11:00:27','2024-09-30 11:00:27',NULL),(40,1,'Modules\\Appointment\\Models\\Appointment',19,74.64,'admin','pending',NULL,NULL,NULL,NULL,NULL,'2024-09-30 11:00:27','2024-09-30 11:00:27',NULL);

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_value` int DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commissions`
--

INSERT INTO `commissions` VALUES (1,'Admin Fees','fixed',3,'admin_fees',1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(2,'Doctor Commission','percentage',40,'doctor_commission',1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL);

--
-- Table structure for table `constants`
--

CREATE TABLE `constants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `sequence` int NOT NULL DEFAULT '0',
  `sub_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `constants`
--

INSERT INTO `constants` VALUES (1,'cash','PAYMENT_METHODS','Cash',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(2,'upi','PAYMENT_METHODS','UPI',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(3,'razorpay','PAYMENT_METHODS','Razorpay',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(4,'stripe','PAYMENT_METHODS','Stripe',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(5,'unisex','SERVICE_PROVIDER_SERVICE_GENDER','Unisex',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(6,'female','SERVICE_PROVIDER_SERVICE_GENDER','Female',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(7,'male','SERVICE_PROVIDER_SERVICE_GENDER','Male',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(8,'1','status','Active',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(9,'0','status','Deactive',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(10,'pending','BOOKING_STATUS','Pending',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(11,'confirmed','BOOKING_STATUS','Confirmed',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(12,'check_in','BOOKING_STATUS','Check In',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(13,'checkout','BOOKING_STATUS','Checkout',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(14,'cancelled','BOOKING_STATUS','Cancelled',4,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(15,'#e5a900','BOOKING_STATUS_COLOR','Pending Color',0,'pending',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(16,'#6E6EEF','BOOKING_STATUS_COLOR','Confirm Color',1,'confirmed',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(17,'#D68AF1','BOOKING_STATUS_COLOR','Check In Color',2,'check_in',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(18,'#E58282','BOOKING_STATUS_COLOR','Check Out Color',3,'checkout',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(19,'#D1D1D1','BOOKING_STATUS_COLOR','Cancelled Color',4,'cancelled',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(20,'#3ABA61','BOOKING_STATUS_COLOR','Completed Color',4,'completed',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(21,'Text','field_type','text',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(22,'#e5a900','CLASS_TYPE_COLOR','Do not repeat Color',0,'does_not_repeat',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(23,'#6E6EEF','CLASS_TYPE_COLOR','Daily Color',1,'daily',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(24,'#D68AF1','CLASS_TYPE_COLOR','WEEKLY Color',2,'weekly',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(25,'#E58282','CLASS_TYPE_COLOR','Monthly Color',3,'monthly',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(26,'#D1D1D1','CLASS_TYPE_COLOR','Yearly Color',4,'yearly',1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(27,'Textarea','field_type','textarea',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(28,'Select','field_type','select',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(29,'Radio','field_type','radio',4,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(30,'Checkbox','field_type','checkbox',5,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(31,'English','language','en',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(32,'বাংলা','language','br',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(33,'العربی','language','ar',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(34,'Vietnamese','language','vi',4,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(35,'Category','SLIDER_TYPES','category',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(36,'Service','SLIDER_TYPES','service',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(37,'Cash','EARNING_PAYMENT_TYPE','cash',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(38,'Bank','EARNING_PAYMENT_TYPE','bank',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(39,'gallery','additional_permissions','Gallery',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(40,'password','additional_permissions','Password',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(41,'tableview','additional_permissions','Tableview',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(42,'review','additional_permissions','Review',4,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(43,'Paid','PAYMENT_STATUS','1',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(44,'Pending','PAYMENT_STATUS','0',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(45,'Headache','encounter_problem','headache',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(46,'Difficulty breathing or wheezing','encounter_problem','difficulty_breathing_or_wheezing',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(47,'Body Pain','encounter_problem','body_pain',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(48,'Pulsing or throbbing quality','encounter_observations','pulsing_or_throbbing_quality',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(49,'Heart/Pulse rate','encounter_observations','heart_pulse_rate ',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(50,'Blood Pressure','encounter_observations','blood_pressure',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:48:29','2024-09-03 23:48:29',NULL),(51,'New Appointment','notification_type','new_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(52,'Accept Appointment','notification_type','accept_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(53,'Reject Appointment','notification_type','reject_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(54,'Accept Appointment Request','notification_type','accept_appointment_request',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(55,'Complete On Appointment','notification_type','checkout_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(56,'Cancel On Appointment','notification_type','cancel_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(57,'Reschedule Appointment','notification_type','reschedule_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(58,'Quick Appointment','notification_type','quick_appointment',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(59,'Chnage Password','notification_type','change_password',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(60,'Forget Email/Password','notification_type','forget_email_password',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(61,'ID','notification_param_button','id',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(62,'Customer Name','notification_param_button','user_name',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(63,'Description / Note','notification_param_button','description',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(64,'Appointment ID','notification_param_button','appointment_id',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(65,'Appointment Date','notification_param_button','appointment_date',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(66,'Appointment Time','notification_param_button','appointment_time',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(67,'Appointment Services Names','notification_param_button','appointment_services_names',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(68,'Appointment Duration','notification_param_button','appointment_duration',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(69,'Doctor Name','notification_param_button','doctor_name',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(70,'Venue / Address','notification_param_button','venue_address',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(71,'Your Name','notification_param_button','logged_in_user_fullname',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(72,'Your Position','notification_param_button','logged_in_user_role',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(73,'Company Name','notification_param_button','company_name',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(74,'Company Info','notification_param_button','company_contact_info',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(75,'User\' ID','notification_param_button','user_id',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(76,'User Password','notification_param_button','user_password',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(77,'Link','notification_param_button','link',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(78,'Site URL','notification_param_button','site_url',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(79,'User','notification_to','user',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(80,'Doctor','notification_to','doctor',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(81,'Admin','notification_to','admin',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(82,'New Service Request','notification_type','new_request_service',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(83,'Accept Service Request','notification_type','accept_request_service',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(84,'Reject Service Request','notification_type','reject_request_service',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL),(85,'order_placed','ORDER_STATUS','Order Placed',0,NULL,1,NULL,NULL,NULL,'2024-09-03 23:52:52','2024-09-03 23:52:52',NULL),(86,'pending','ORDER_STATUS','Pending',1,NULL,1,NULL,NULL,NULL,'2024-09-03 23:52:52','2024-09-03 23:52:52',NULL),(87,'processing','ORDER_STATUS','Processing',2,NULL,1,NULL,NULL,NULL,'2024-09-03 23:52:52','2024-09-03 23:52:52',NULL),(88,'delivered','ORDER_STATUS','Delivered',3,NULL,1,NULL,NULL,NULL,'2024-09-03 23:52:52','2024-09-03 23:52:52',NULL),(89,'cancelled','ORDER_STATUS','Cancelled',4,NULL,1,NULL,NULL,NULL,'2024-09-03 23:52:52','2024-09-03 23:52:52',NULL);

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dial_code` int DEFAULT NULL,
  `currency_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,NULL,'England',44,'Pound sterling\n','£','GBP',1,NULL,NULL,NULL,'2024-10-09 00:27:25','2024-10-09 00:27:25',NULL),(2,NULL,'Wales',44,'Pound sterling\n','£','GBP',1,NULL,NULL,NULL,'2024-10-09 00:27:25','2024-10-09 00:27:25',NULL),(3,NULL,'Scotland',44,'Pound sterling\n','£','GBP',1,NULL,NULL,NULL,'2024-10-09 00:27:25','2024-10-09 00:27:25',NULL),(4,NULL,'Northern Ireland',44,'Pound sterling\n','£','GBP',1,NULL,NULL,NULL,'2024-10-09 00:27:26','2024-10-09 00:27:26',NULL),(5,NULL,'Isle of Man',44,'Manx pound\n','£','GBP',1,NULL,NULL,NULL,'2024-10-09 00:27:27','2024-10-09 00:27:27',NULL);

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `currency_position` enum('left','right','left_with_space','right_with_space') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'left',
  `no_of_decimal` int unsigned NOT NULL,
  `thousand_separator` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `decimal_separator` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1,'Doller','$','USD',1,'left',2,',','.',NULL,NULL,NULL,'2024-09-03 23:50:42','2024-09-03 23:50:42',NULL);

--
-- Table structure for table `custom_field_groups`
--

CREATE TABLE `custom_field_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_field_groups`
--


--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_group_id` int DEFAULT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `required` tinyint NOT NULL DEFAULT '0',
  `values` text COLLATE utf8mb4_unicode_ci,
  `is_export` int DEFAULT '0',
  `visible` enum('true','false') COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `is_view` int DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_fields`
--


--
-- Table structure for table `custom_fields_data`
--

CREATE TABLE `custom_fields_data` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` int DEFAULT NULL,
  `model_id` int DEFAULT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_fields_data`
--


--
-- Table structure for table `customformdata`
--

CREATE TABLE `customformdata` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int DEFAULT NULL,
  `module` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_data` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `deleted_by` int unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customformdata`
--

INSERT INTO `customformdata` VALUES (1,1,'encounter','7','[{\"id\":1,\"label\":\"Example field 1\",\"type\":\"text\",\"placeholder\":\"Enter field 1\",\"validation_status\":true,\"option\":[],\"value\":\"test\"},{\"id\":2,\"label\":\"Example field 2\",\"type\":\"text\",\"placeholder\":\"Enter field 2\",\"validation_status\":0,\"option\":[],\"value\":\"test\"},{\"id\":3,\"label\":\"Example field 3\",\"type\":\"file\",\"placeholder\":\"Enter field 3\",\"validation_status\":0,\"option\":[],\"value\":\"data:image/png;base64,[encoded data, 199848 characters]\"}]',1,1,NULL,'2024-09-05 04:13:59','2024-09-04 04:55:02','2024-09-05 04:13:59'),(2,3,'encounter','7','[{\"id\":1,\"label\":\"1. I found it hard to wind down\",\"type\":\"radio\",\"placeholder\":\"Enter field 1\",\"validation_status\":true,\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"3\"},{\"id\":2,\"label\":\"2. I was aware of dryness of my mouth\",\"type\":\"radio\",\"placeholder\":\"Enter field 2\",\"validation_status\":true,\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"1\"},{\"id\":3,\"label\":\"3. I couldn\'t seem to experience any positive feeling at all\",\"type\":\"radio\",\"placeholder\":\"Enter field 3\",\"validation_status\":true,\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":4,\"label\":\"4. I experienced breathing difficulty (eg, excessively rapid breathing, breathlessness in the absence of physical exertion)\",\"type\":\"radio\",\"placeholder\":\"\",\"validation_status\":true,\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":5,\"label\":\"5. I found it difficult to work up the initiative to do things\",\"type\":\"radio\",\"placeholder\":\"Enter field 1\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"1\"},{\"id\":6,\"label\":\"6. I tended to over-react to situations\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"1\"},{\"id\":7,\"label\":\"7. I experienced trembling (eg, in the hands)\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"2\"},{\"id\":8,\"label\":\"8. I felt that I was using a lot of nervous energy\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":9,\"label\":\"9. I was worried about situations in which I might panic and make a fool of myself\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":10,\"label\":\"10. I felt that I had nothing to look forward to\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":11,\"label\":\"11. I found myself getting agitated\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":12,\"label\":\"12. I found it difficult to relax\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":13,\"label\":\"13. I felt down-hearted and blue\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":14,\"label\":\"14. I was intolerant of anything that kept me from getting on with what I was doing\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"2\"},{\"id\":15,\"label\":\"15. I felt I was close to panic\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"1\"},{\"id\":16,\"label\":\"16. I was unable to become enthusiastic about anything\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"3\"},{\"id\":17,\"label\":\"17. I felt I wasn\'t worth much as a person\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"},{\"id\":18,\"label\":\"18. I felt that I was rather touchy\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"3\"},{\"id\":19,\"label\":\"19. I was aware of the action of my heart in the absence of physical exertion (eg, sense of heart rate increase, heart missing a beat)\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"3\"},{\"id\":20,\"label\":\"20. I felt scared without any good reason\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"1\"},{\"id\":21,\"label\":\"21. I felt that life was meaningless\",\"type\":\"radio\",\"placeholder\":\"\",\"option\":[\"0\",\"1\",\"2\",\"3\"],\"value\":\"0\"}]',1,1,NULL,NULL,'2024-09-05 12:34:45','2024-09-05 12:34:45');

--
