--
-- Host: 10.56.12.14    Database: union_nonprod
-- ------------------------------------------------------

SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;

--
-- GTID state at the beginning of the backup 
--


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_group`
--

INSERT INTO `auth_group` VALUES (1,'admin'),(3,'sample_collector'),(2,'xray_technician');

--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_group_permissions`
--

INSERT INTO `auth_group_permissions` VALUES (1,1,13),(2,1,14),(4,1,16),(5,1,33),(6,1,34),(8,1,36),(9,1,37),(10,1,38),(12,1,40),(13,1,41),(14,1,42),(16,1,44),(17,1,45),(18,1,46),(20,1,48),(21,1,49),(22,1,50),(24,1,52),(25,1,53),(26,1,54),(28,1,56),(29,1,57),(30,1,58),(32,1,60),(33,1,61),(34,1,62),(36,1,64),(37,1,65),(38,1,66),(40,1,68),(41,1,69),(42,1,70),(44,1,72),(45,1,73),(46,1,74),(48,1,76),(57,2,53),(58,2,54),(60,2,56),(49,2,65),(50,2,66),(51,2,67),(52,2,68),(53,2,69),(54,2,70),(55,2,71),(56,2,72),(62,3,53),(63,3,54),(61,3,56);

--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add Token',7,'add_token'),(26,'Can change Token',7,'change_token'),(27,'Can delete Token',7,'delete_token'),(28,'Can view Token',7,'view_token'),(29,'Can add Token',8,'add_tokenproxy'),(30,'Can change Token',8,'change_tokenproxy'),(31,'Can delete Token',8,'delete_tokenproxy'),(32,'Can view Token',8,'view_tokenproxy'),(33,'Can add user attributes',9,'add_userattributes'),(34,'Can change user attributes',9,'change_userattributes'),(35,'Can delete user attributes',9,'delete_userattributes'),(36,'Can view user attributes',9,'view_userattributes'),(37,'Can add district',10,'add_district'),(38,'Can change district',10,'change_district'),(39,'Can delete district',10,'delete_district'),(40,'Can view district',10,'view_district'),(41,'Can add household',11,'add_household'),(42,'Can change household',11,'change_household'),(43,'Can delete household',11,'delete_household'),(44,'Can view household',11,'view_household'),(45,'Can add state',12,'add_state'),(46,'Can change state',12,'change_state'),(47,'Can delete state',12,'delete_state'),(48,'Can view state',12,'view_state'),(49,'Can add recording form',13,'add_recordingform'),(50,'Can change recording form',13,'change_recordingform'),(51,'Can delete recording form',13,'delete_recordingform'),(52,'Can view recording form',13,'view_recordingform'),(53,'Can add record',14,'add_record'),(54,'Can change record',14,'change_record'),(55,'Can delete record',14,'delete_record'),(56,'Can view record',14,'view_record'),(57,'Can add arm',15,'add_arm'),(58,'Can change arm',15,'change_arm'),(59,'Can delete arm',15,'delete_arm'),(60,'Can view arm',15,'view_arm'),(61,'Can add qr code',16,'add_qrcode'),(62,'Can change qr code',16,'change_qrcode'),(63,'Can delete qr code',16,'delete_qrcode'),(64,'Can view qr code',16,'view_qrcode'),(65,'Can add location',17,'add_location'),(66,'Can change location',17,'change_location'),(67,'Can delete location',17,'delete_location'),(68,'Can view location',17,'view_location'),(69,'Can add slot',18,'add_slot'),(70,'Can change slot',18,'change_slot'),(71,'Can delete slot',18,'delete_slot'),(72,'Can view slot',18,'view_slot'),(73,'Can add appointment',19,'add_appointment'),(74,'Can change appointment',19,'change_appointment'),(75,'Can delete appointment',19,'delete_appointment'),(76,'Can view appointment',19,'view_appointment'),(77,'Can add tombstone',20,'add_tombstone'),(78,'Can change tombstone',20,'change_tombstone'),(79,'Can delete tombstone',20,'delete_tombstone'),(80,'Can view tombstone',20,'view_tombstone');

--
-- Table structure for table `auth_user`
--

CREATE TABLE `auth_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_user`
--

INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$390000$MgGnx7NRE5cop6zPke2ge6$DQX+k3SuSvXp7Ssc6O48dSTm9VtKVxcSSE0L9ADRq6c=','2025-10-29 12:25:35.812007',1,'kr','','','v-kousthub@wadhwaniai.org',1,1,'2025-10-09 09:48:03.773617'),(2,'',NULL,0,'8891222456','','','',0,1,'2025-10-09 13:37:30.994312'),(3,'',NULL,0,'8949602794','','','',0,1,'2025-10-10 13:29:15.980309'),(4,'',NULL,0,'7038226720','','','',0,1,'2025-10-10 15:35:22.741052'),(5,'',NULL,0,'9934302919','','','',0,1,'2025-10-13 05:59:17.121260'),(6,'',NULL,0,'8688281829','','','',0,1,'2025-10-13 06:02:12.470257'),(7,'',NULL,0,'9495260267','','','',0,1,'2025-10-13 06:05:06.047546'),(8,'',NULL,0,'7338334609','','','',0,1,'2025-10-13 06:50:03.273386'),(9,'pbkdf2_sha256$390000$V5nlZcCyf6fJkLRDz733vZ$Lq7CHOzZ/EEEqcdJhr6YjRyd2JMCvSNbB/F7KGDfWy0=','2025-11-10 06:33:33.375872',1,'admin-ai','','','',1,1,'2025-10-13 07:09:36.000000'),(10,'pbkdf2_sha256$390000$pmfRih1kKr4eDR3jgClOut$GhrQk1tmNwBZIeNq6RShONPZXQXT4ysF6ScWVBCfTAA=','2025-11-10 08:20:18.930931',0,'xray_technician','','','',1,1,'2025-10-13 07:10:31.000000'),(11,'pbkdf2_sha256$390000$x5Rb46N7hiMEG97RzLalMT$/uFXs7QpqxvLk9Q/PqYkr9OLPQudnZt0Jy/Usq2zkgY=','2025-11-10 09:19:03.582893',0,'sample_collector','','','',1,1,'2025-10-13 07:11:19.000000'),(12,'',NULL,0,'9446617549','','','',0,1,'2025-10-13 12:20:14.066873'),(13,'',NULL,0,'9538564135','','','',0,1,'2025-10-14 10:06:55.194964'),(14,'pbkdf2_sha256$390000$MHxzsB2QVqBaa3VoLKzEpW$BnS3Q1CtaYmGFiDobFBpVcaOfXK74XZK+Ac2tFm5H1I=','2025-11-10 08:22:40.546154',1,'superuser','','','',1,1,'2025-10-29 12:00:56.124610'),(15,'',NULL,0,'9902778065','','','',0,1,'2025-11-03 05:13:46.039153');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_user_groups`
--

INSERT INTO `auth_user_groups` VALUES (1,9,1),(2,10,2),(3,11,3);

--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `auth_user_user_permissions`
--

INSERT INTO `auth_user_user_permissions` VALUES (5,9,4),(6,9,50),(7,9,52),(8,9,54),(9,9,56),(4,10,54),(3,10,56),(2,11,54),(1,11,56);

--
-- Table structure for table `authapp_userattributes`
--

CREATE TABLE `authapp_userattributes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `dob` varchar(20) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `district_id` bigint DEFAULT NULL,
  `state_id` bigint DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `role` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_number` (`phone_number`),
  KEY `authapp_userattribut_district_id_93d3f820_fk_datacolle` (`district_id`),
  KEY `authapp_userattribut_state_id_3f6ec018_fk_datacolle` (`state_id`),
  KEY `authapp_userattributes_user_id_f1125cad_fk_auth_user_id` (`user_id`),
  CONSTRAINT `authapp_userattribut_district_id_93d3f820_fk_datacolle` FOREIGN KEY (`district_id`) REFERENCES `datacollectionapp_district` (`id`),
  CONSTRAINT `authapp_userattribut_state_id_3f6ec018_fk_datacolle` FOREIGN KEY (`state_id`) REFERENCES `datacollectionapp_state` (`id`),
  CONSTRAINT `authapp_userattributes_user_id_f1125cad_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `authapp_userattributes`
--

INSERT INTO `authapp_userattributes` VALUES (1,'Kousthub Raja','8891222456','5-Nov-2000','Male','community_volunteer',1,1,2,'application_user'),(2,'Prashant Soni','8949602794','1-Jan-2005','Male','camp_volunteer',4,2,3,'application_user'),(3,'Test ','7038226720','4-Apr-2003','Male','community_volunteer',4,2,4,'application_user'),(4,'Sashikanta Nayak','9934302919','1-Sep-1970','Male','community_volunteer',2,2,5,'application_user'),(5,'BABURAO BAILIKA','8688281829','5-May-1991','Male','community_volunteer',2,2,6,'application_user'),(6,'Sankar Anand','9495260267','24-May-1986','Male','community_volunteer',2,2,7,'application_user'),(7,'Nikita Srivastava','7338334609','10-Jul-1990','Female','community_volunteer',2,2,8,'application_user'),(8,'Sample Collector','9999999999','NA','Male','camp_volunteer',2,2,11,'sample_collector'),(9,'XRay Technician','9999999991','NA','Male','camp_volunteer',2,1,10,'xray_collector'),(10,'Manu M','9446617549','1-Sep-1946','Male','community_volunteer',2,2,12,'application_user'),(11,'Awele ','9538564135','4-Jun-2000','Female','camp_volunteer',2,2,13,'application_user'),(12,'Test Van','9902778065','3-Feb-1999','Female','camp_volunteer',3,2,15,'application_user');

--
-- Table structure for table `authtoken_token`
--

CREATE TABLE `authtoken_token` (
  `key` varchar(40) NOT NULL,
  `created` datetime(6) NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`key`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `authtoken_token_user_id_35299eff_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `authtoken_token`
--

INSERT INTO `authtoken_token` VALUES ('071ec99733fcd1f76db1ae4a3fcc1f71fe52b92a','2025-10-09 13:37:31.013238',2),('1baf350811b0b32c269a6772dcb050614b748c93','2025-10-13 06:05:06.067674',7),('1fcb97d1285c091c26c15c49961fa484b32912e4','2025-11-03 05:13:46.065434',15),('2931b845b92fa523d5643c65cbef10aa3c607419','2025-10-14 10:06:55.223017',13),('46e60476a5e355b63c271684a8ea7df382243d87','2025-10-13 06:02:12.491456',6),('7db0fbafdef8175a76ba7c14583bca9e5585bf96','2025-10-10 15:35:22.763605',4),('7fb0bbf2f63b787a3aef888c8f170a90f2b0dae9','2025-10-13 06:50:03.291895',8),('b688ca11f3291f47bcd3fbab242f955641d2b53d','2025-10-13 05:59:17.150786',5),('b83272636dad9b38bfdae398602afc9adaf2a01f','2025-10-10 13:29:16.006257',3),('f67c6fac479883a45db344b49a065adcb84434cb','2025-10-13 12:20:14.083236',12);

--
-- Table structure for table `bookingapp_appointment`
--

CREATE TABLE `bookingapp_appointment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_by_id` int NOT NULL,
  `created_for_id` char(32) NOT NULL,
  `slot_id` bigint NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bookingapp_appointment_created_by_id_ecb170f8_fk_auth_user_id` (`created_by_id`),
  KEY `bookingapp_appointme_created_for_id_a2f43181_fk_datacolle` (`created_for_id`),
  KEY `bookingapp_appointment_slot_id_73e8f216_fk_bookingapp_slot_id` (`slot_id`),
  CONSTRAINT `bookingapp_appointme_created_for_id_a2f43181_fk_datacolle` FOREIGN KEY (`created_for_id`) REFERENCES `datacollectionapp_record` (`cough_id`),
  CONSTRAINT `bookingapp_appointment_created_by_id_ecb170f8_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `bookingapp_appointment_slot_id_73e8f216_fk_bookingapp_slot_id` FOREIGN KEY (`slot_id`) REFERENCES `bookingapp_slot` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bookingapp_appointment`
--

INSERT INTO `bookingapp_appointment` VALUES (4,8,'9148d96b7524450fbe74daf8dca70e73',9,'2025-10-13 07:25:20.427074','2025-10-13 07:25:20.427127'),(5,8,'10c96c499a06414eacf46074dd884a01',9,'2025-10-13 07:28:09.096582','2025-10-13 07:28:09.096618'),(6,4,'8427a8842b7a40bc9709137894aef648',15,'2025-10-13 08:11:45.806590','2025-10-13 08:11:45.806636'),(7,4,'6be434e2351f41a8833cb3fddc5f48aa',15,'2025-10-13 08:12:49.746490','2025-10-13 08:12:49.746523'),(8,8,'3810c23c31ff40f598fd645e52d4b251',12,'2025-10-13 08:32:06.390264','2025-10-13 08:32:06.390302'),(9,8,'06430385704d4c938c454d5dfad9309e',11,'2025-10-13 08:59:09.724874','2025-10-13 08:59:09.724915'),(10,8,'f87a76fc5017481189a1b0516de961b1',13,'2025-10-13 09:07:53.712968','2025-10-13 09:07:53.713022'),(11,8,'3d5f04f8f080492eb7e924c6e60a93ff',12,'2025-10-13 09:28:37.242213','2025-10-13 09:28:37.242250'),(12,4,'a02a7914a5fd4ec0be363353667ed7dc',15,'2025-10-13 09:34:51.693899','2025-10-13 09:34:51.693961'),(13,4,'506bc4334d0244e2a2c6e79e23c4aa82',15,'2025-10-13 10:38:47.922182','2025-10-13 10:38:47.922217'),(14,4,'dc581fc0212f4810ac257cbe6a7d2df2',15,'2025-10-13 11:06:58.373129','2025-10-13 11:06:58.373167'),(15,3,'bcc01ae1cb0f48cdad5556345771afbc',16,'2025-10-13 13:21:48.063770','2025-10-13 13:21:48.063807'),(16,3,'bcc01ae1cb0f48cdad5556345771afbc',16,'2025-10-13 13:22:52.713777','2025-10-13 13:22:52.713815'),(17,3,'bcc01ae1cb0f48cdad5556345771afbc',16,'2025-10-13 13:23:11.320421','2025-10-13 13:23:11.320462'),(18,4,'3e7f23e316744f0e91e6658217c56b67',15,'2025-10-13 15:50:00.337237','2025-10-13 15:50:00.337272'),(19,15,'ea55c542a1684f76b83e0ef3d7defc53',17,'2025-11-03 05:46:24.449198','2025-11-03 05:46:24.449260'),(20,15,'178aea36092145ff8ab570abd9815267',14,'2025-11-03 10:51:10.741843','2025-11-03 10:51:10.741885'),(21,15,'178aea36092145ff8ab570abd9815267',14,'2025-11-03 10:54:39.804466','2025-11-03 10:54:39.804501'),(24,8,'de51a695859a45cba3c019f89a52aca0',19,'2025-11-10 06:55:15.077053','2025-11-10 06:55:15.077103'),(25,8,'46c12750133d42a093b8a080f3fc91e6',21,'2025-11-10 08:39:10.971012','2025-11-10 08:39:10.971054');

--
-- Table structure for table `bookingapp_location`
--

CREATE TABLE `bookingapp_location` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `h3_index` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bookingapp_location_h3_index_3da71444` (`h3_index`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bookingapp_location`
--

INSERT INTO `bookingapp_location` VALUES (3,'Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India',17.1766905,78.6024034,'8660b534fffffff'),(4,'Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India',28.53635304592516,77.18866328933879,'863da1027ffffff'),(5,'Jasmine Tower, Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India',19.222124249627072,72.96733403189727,'86608b42fffffff'),(6,'dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India',26.8405544,75.7756665,'863da219fffffff'),(7,'Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India',28.536366053905226,77.18868893507468,'863da1027ffffff');

--
-- Table structure for table `bookingapp_slot`
--

CREATE TABLE `bookingapp_slot` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `start_time` time(6) NOT NULL,
  `end_time` time(6) NOT NULL,
  `availability` int NOT NULL,
  `location_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bookingapp_slot_location_id_57e91ae2_fk_bookingapp_location_id` (`location_id`),
  CONSTRAINT `bookingapp_slot_location_id_57e91ae2_fk_bookingapp_location_id` FOREIGN KEY (`location_id`) REFERENCES `bookingapp_location` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `bookingapp_slot`
--

INSERT INTO `bookingapp_slot` VALUES (9,'2025-10-13','12:51:29.000000','13:51:29.000000',148,4),(10,'2025-10-13','13:51:29.000000','14:51:29.000000',150,4),(11,'2025-10-13','14:51:29.000000','15:51:29.000000',149,4),(12,'2025-11-08','12:13:38.000000','18:00:00.000000',147,4),(13,'2025-11-07','16:51:29.000000','17:51:29.000000',148,4),(14,'2025-11-03','16:19:57.000000','17:19:58.000000',148,4),(15,'2025-10-14','13:41:13.000000','13:41:14.000000',144,5),(16,'2026-07-01','06:00:00.000000','07:00:00.000000',147,6),(17,'2025-11-03','11:14:35.000000','12:12:36.000000',149,4),(18,'2025-11-10','12:00:00.000000','13:00:00.000000',150,4),(19,'2025-11-10','13:00:00.000000','14:00:00.000000',149,4),(20,'2025-11-10','14:00:00.000000','15:00:00.000000',150,4),(21,'2025-11-10','15:00:00.000000','16:00:00.000000',149,4),(22,'2025-11-10','16:00:00.000000','17:00:00.000000',150,4),(23,'2025-11-10','17:00:00.000000','18:00:00.000000',150,4);

--
-- Table structure for table `datacollectionapp_arm`
--

CREATE TABLE `datacollectionapp_arm` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ward` varchar(32) NOT NULL,
  `district_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `datacollectionapp_ar_district_id_9b06f4ac_fk_datacolle` (`district_id`),
  CONSTRAINT `datacollectionapp_ar_district_id_9b06f4ac_fk_datacolle` FOREIGN KEY (`district_id`) REFERENCES `datacollectionapp_district` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_arm`
--

INSERT INTO `datacollectionapp_arm` VALUES (2,'arm_3','WARD 1',4),(3,'arm_3','WARD 2',4),(4,'arm_2','WARD 3',4),(5,'arm_2','WARD 4',4),(6,'arm_2','WARD 5',4),(7,'arm_3','WARD 6',4),(8,'arm_1','WARD 7',4),(9,'arm_2','WARD 8',4),(10,'arm_1','WARD 9',4),(11,'arm_2','WARD 10',4),(12,'arm_2','WARD 11',4),(13,'arm_2','WARD 12',4),(14,'arm_3','WARD 13',4),(15,'arm_3','WARD 14',4),(16,'arm_3','WARD 15',4),(17,'arm_2','WARD 16',4),(18,'arm_1','WARD 17',4),(19,'arm_3','WARD 18',4),(20,'arm_1','WARD 19',4),(21,'arm_2','WARD 20',4),(22,'arm_1','WARD 21',4),(23,'arm_2','WARD 22',4),(24,'arm_3','WARD 23',4),(25,'arm_3','WARD 24',4),(26,'arm_2','WARD 25',4),(27,'arm_3','WARD 26',4),(28,'arm_2','WARD 1',3),(29,'arm_2','WARD 2',3),(30,'arm_1','WARD 3',3),(31,'arm_3','WARD 4',3),(32,'arm_2','WARD 5',3),(33,'arm_3','WARD 6',3),(34,'arm_2','WARD 7',3),(35,'arm_2','WARD 8',3),(36,'arm_1','WARD 9',3),(37,'arm_1','WARD 10',3),(38,'arm_3','WARD 11',3),(39,'arm_1','WARD 12',3),(40,'arm_1','WARD 13',3),(41,'arm_1','WARD 14',3),(42,'arm_1','WARD 15',3),(43,'arm_3','WARD 16',3),(44,'arm_1','WARD 17',3),(45,'arm_1','WARD 18',3),(46,'arm_3','WARD 19',3),(47,'arm_1','WARD 20',3),(48,'arm_3','WARD 21',3),(49,'arm_2','WARD 22',3),(50,'arm_1','WARD 23',3),(51,'arm_3','WARD 24',3),(52,'arm_2','WARD 25',3),(53,'arm_1','WARD 26',3),(54,'arm_3','WARD 27',3),(55,'arm_3','WARD 28',3),(56,'arm_2','WARD 1',2),(57,'arm_1','WARD 2',2),(58,'arm_1','WARD 3',2),(59,'arm_3','WARD 4',2),(60,'arm_3','WARD 5',2),(61,'arm_2','WARD 6',2),(62,'arm_1','WARD 7',2),(63,'arm_1','WARD 8',2),(64,'arm_1','WARD 9',2),(65,'arm_2','WARD 10',2),(66,'arm_2','WARD 11',2),(67,'arm_1','WARD 12',2),(68,'arm_1','WARD 13',2),(69,'arm_3','WARD 14',2),(70,'arm_2','WARD 15',2),(71,'arm_3','WARD 16',2),(72,'arm_2','WARD 17',2),(73,'arm_3','WARD 18',2);

--
-- Table structure for table `datacollectionapp_district`
--

CREATE TABLE `datacollectionapp_district` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `refusal_count` int NOT NULL,
  `state_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `datacollectionapp_di_state_id_266b0b77_fk_datacolle` (`state_id`),
  CONSTRAINT `datacollectionapp_di_state_id_266b0b77_fk_datacolle` FOREIGN KEY (`state_id`) REFERENCES `datacollectionapp_state` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_district`
--

INSERT INTO `datacollectionapp_district` VALUES (1,'New Delhi',0,1),(2,'Pocharam',0,2),(3,'Boduppal',0,2),(4,'Peerzadiguda',0,2);

--
-- Table structure for table `datacollectionapp_household`
--

CREATE TABLE `datacollectionapp_household` (
  `created_at` datetime(6) NOT NULL,
  `household_id` char(32) NOT NULL,
  `identifier` varchar(64) DEFAULT NULL,
  `address` varchar(512) DEFAULT NULL,
  `ward_name` varchar(16) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `altitude` double DEFAULT NULL,
  `location_accuracy` double DEFAULT NULL,
  `number_of_people` int NOT NULL,
  `household_status` varchar(32) NOT NULL,
  `classification_of_location` varchar(16) NOT NULL,
  `type_of_house` varchar(16) NOT NULL,
  `district` varchar(64) DEFAULT NULL,
  `complete` tinyint(1) DEFAULT NULL,
  `created_by_id` int DEFAULT NULL,
  `arm_ward_id` bigint DEFAULT NULL,
  PRIMARY KEY (`household_id`),
  KEY `datacollect_househo_9b8bee_idx` (`household_id`),
  KEY `datacollectionapp_ho_created_by_id_85f9adc1_fk_auth_user` (`created_by_id`),
  KEY `datacollectionapp_ho_arm_ward_id_f85270b0_fk_datacolle` (`arm_ward_id`),
  CONSTRAINT `datacollectionapp_ho_arm_ward_id_f85270b0_fk_datacolle` FOREIGN KEY (`arm_ward_id`) REFERENCES `datacollectionapp_arm` (`id`),
  CONSTRAINT `datacollectionapp_ho_created_by_id_85f9adc1_fk_auth_user` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_household`
--

INSERT INTO `datacollectionapp_household` VALUES ('2025-10-13 10:38:23.182330','02dbad9ee7c7418f9c317d1c0ddbf1f6',NULL,'Test','WARD 3',19.2222372,72.9676254,-16.200000762939453,13.87399959564209,25,'incomplete_require_revisit','apartment','pakka','Boduppal',0,4,30),('2025-11-10 09:12:18.805259','06a5674725d849eaa02ac4c6bf1d3548',NULL,'Testunion','WARD 17',28.536485,77.1888451,200.40000915527344,12.401000022888184,2,'incomplete_require_revisit','hostel','semi_pakka','Peerzadiguda',0,8,18),('2025-11-08 06:43:01.655471','0ca265743803489cac8ab1942d5a6a17',NULL,'Ivory court','WARD 7',28.5519039,77.1210889,215.60000610351562,21.839000701904297,4,'incomplete_require_revisit','standalone','semi_pakka','Peerzadiguda',0,8,8),('2025-11-03 05:15:14.949045','131cf285dd64470a860f57ac92134b3a',NULL,'Test','WARD 2',28.6525905,77.3649804,162.40000915527344,20,2,'incomplete_require_revisit','standalone','pakka','Boduppal',0,15,29),('2025-11-07 10:39:49.523675','254e3ff7ba264b6f918c2e2a0752d4b1',NULL,'Test arm2','WARD 2',28.6525929,77.3649779,162.40000915527344,14.29699993133545,2,'incomplete_require_revisit','apartment','semi_pakka','Boduppal',0,15,29),('2025-11-10 09:14:57.220217','2f7465fd7ba24ad2b05be65f387838f5',NULL,'Test','WARD 20',28.5364823,77.1888561,200.40000915527344,13.930000305175781,5,'incomplete_require_revisit','standalone','semi_pakka','Peerzadiguda',0,8,21),('2025-10-10 15:39:11.406752','32d09460966b4902baf4fb809673ef07',NULL,'Test 3','WARD 4',19.2222405,72.96762,-16.200000762939453,17.613000869750977,94,'pending_enumeration','standalone','kaccha','Peerzadiguda',0,4,5),('2025-10-13 06:15:32.577396','33b6976c7de84a8297dd597a1ba444e4',NULL,'202 Pocharam','WARD 2',17.4201209,78.6264808,413.9000244140625,56.099998474121094,4,'incomplete_require_revisit','standalone','pakka','Pocharam',0,7,57),('2025-10-23 09:51:00.510651','33c346b2138449bd9da4f02ad0b4c135',NULL,'H.No 1-234\nPocharam, Sri Sai colony , street -4','WARD 1',17.4102913,78.6046656,414.20001220703125,22.996000289916992,2,'incomplete_require_revisit','standalone','pakka','Pocharam',0,6,56),('2025-10-10 15:39:11.547096','373a525c433449b8bf971d5ad5ce5947',NULL,'Test 3a','WARD 26',19.2222493,72.9676333,-26.5,16.084999084472656,97,'incomplete_require_revisit','standalone','kaccha','Peerzadiguda',0,4,27),('2025-10-24 12:21:02.227913','3a2a4d9ed1854d54824753f29e263423',NULL,'Test b','WARD 16',19.2221804,72.9675963,-15.5,13.350000381469727,94,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,4,17),('2025-10-13 09:50:43.149002','3c94382900a14b53b9bc6cfdada2f80b',NULL,'432 Boduppal','WARD 14',17.4205242,78.6263538,412,68.4000015258789,2,'pending_enumeration','standalone','pakka','Boduppal',0,7,41),('2025-10-10 11:03:23.854925','3f0aa5d04cc74afea1cf04bf72403fd9','Test',NULL,NULL,NULL,NULL,NULL,NULL,0,'pending_enumeration','standalone','pakka',NULL,0,NULL,NULL),('2025-11-03 10:50:15.814945','500cfb1b1a634407bd8e5e969f26282e',NULL,'Test','WARD 9',28.6525934,77.3649864,162.40000915527344,14.177000045776367,66,'incomplete_require_revisit','orphanage','kaccha','Peerzadiguda',0,15,10),('2025-10-13 07:01:23.508405','55c448eedf1b476f980bb22198240da5',NULL,'204,Street No 8,Ramakrishna Puram , Pocharam','WARD 2',17.4199966,78.6262421,415.20001220703125,56.099998474121094,4,'incomplete_require_revisit','standalone','pakka','Pocharam',0,6,57),('2025-10-13 06:18:09.198452','58bdd5556c084d68895eaefd474b5e88',NULL,'Narapally Panchayat Office','WARD 17',17.4204918,78.6264362,412,68.4000015258789,3,'incomplete_require_revisit','standalone','pakka','Pocharam',0,5,72),('2025-10-13 10:52:37.391550','5d793d85752247cabfae323ce8511050',NULL,'Test','WARD 16',19.222253,72.9676468,-26.700000762939453,15.355999946594238,56,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,4,17),('2025-11-10 09:14:57.721919','5f1f6c62740c4ff3859bca493034600d',NULL,'Test','WARD 20',28.5364823,77.1888561,200.40000915527344,13.930000305175781,5,'pending_enumeration','standalone','semi_pakka','Peerzadiguda',0,8,21),('2025-10-10 13:31:31.035998','6346ae719a3c4eefb68fbb26ab08167f',NULL,'Household 1','WARD 3',37.4212162,-122.0828568,NULL,2000,22,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,3,4),('2025-10-10 15:39:11.083984','7608b422b8374f6e8f247ab895c66c35',NULL,'Test','WARD 7',19.2222606,72.9676264,-26.5,15.178000450134277,25,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,4,8),('2025-10-13 08:58:55.618008','79ebf94e33ae4af59f1adfe8fd62bcd5',NULL,'Hjkkk','WARD 3',28.536502,77.1888518,200.40000915527344,12.970999717712402,6,'incomplete_require_revisit','standalone','semi_pakka','Boduppal',0,8,30),('2025-10-13 15:49:51.564680','7fb0e0d2e5da44a5b76f11f49f036ed5',NULL,'Test','WARD 7',19.2222389,72.9676046,-16.200000762939453,16.427000045776367,25,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,4,8),('2025-11-03 10:42:37.305342','8b1d9bb0af5b467f814418ffbd1e0c7e',NULL,'Hdhd','WARD 1',28.6525938,77.3649862,162.40000915527344,15.616000175476074,21,'incomplete_require_revisit','standalone','pakka','Boduppal',0,15,28),('2025-11-08 06:38:14.954564','a55baba20f104675b2202748b48819bd',NULL,'Krishna Park','WARD 5',28.5518717,77.1210825,215.60000610351562,22.315000534057617,4,'pending_enumeration','standalone','semi_pakka','Peerzadiguda',0,8,6),('2025-10-13 06:59:01.064344','accf15191ec44716ae4a7c0da819d95d',NULL,'Test test','WARD 2',28.5364955,77.1888612,200.40000915527344,11.189000129699707,3,'incomplete_require_revisit','apartment','kaccha','Boduppal',0,8,29),('2025-10-10 13:31:31.326518','b2c9b888b1d447debe27e3089b7a10b4',NULL,'Household 2','WARD 3',37.4212162,-122.0828568,NULL,2000,2,'incomplete_require_revisit','standalone','kaccha','Peerzadiguda',0,3,4),('2025-11-06 05:48:42.389250','b4c3179d942c48508b3cac192c91266e',NULL,'Test nov','WARD 4',28.6525945,77.3649858,162.40000915527344,14.12600040435791,66,'incomplete_require_revisit','hostel','pakka','Peerzadiguda',0,15,5),('2025-10-24 12:16:37.431382','b78e88d3de1c4fad98b473bfc7353cf2',NULL,'Test a','WARD 7',19.2222312,72.9676138,-15.5,16.840999603271484,25,'incomplete_require_revisit','standalone','pakka','Peerzadiguda',0,4,8),('2025-10-13 07:35:55.788882','b89b511fa5d447369e4fb770df5772aa',NULL,'Test','WARD 19',19.2222499,72.9676186,-16.200000762939453,16.43899917602539,94,'incomplete_require_revisit','standalone','pakka','Peerzadiguda',0,4,20),('2025-10-10 15:39:11.255728','bd393ffe10274cd49dfabeeef60faadb',NULL,'Test 1','WARD 16',19.2222494,72.9676264,-26.5,15.026000022888184,64,'incomplete_require_revisit','apartment','kaccha','Peerzadiguda',0,4,17),('2025-10-13 08:55:44.649306','cd1a1650aac142dd9305478bf42cd9af',NULL,'Arm 1 xray','WARD 1',28.5365013,77.1888564,200.40000915527344,11.111000061035156,3,'incomplete_require_revisit','apartment','semi_pakka','Boduppal',0,8,28),('2025-10-10 13:33:08.684604','d1aa7801bede4d53bcee78063d391d33',NULL,'Household 3','WARD 1',37.4212162,-122.0828568,NULL,2000,23,'incomplete_require_revisit','standalone','kaccha','Peerzadiguda',0,3,2),('2025-10-13 15:54:43.640070','d926cb5a063d44f686b62967e49edb4e',NULL,'Test','WARD 16',19.2222309,72.9675862,-16.200000762939453,19.81399917602539,56,'incomplete_require_revisit','standalone','kaccha','Peerzadiguda',0,4,17),('2025-10-13 08:31:32.140655','de91527ae2314331857d127d9e383362',NULL,'Test','WARD 1',28.5364894,77.1888475,200.40000915527344,12.902000427246094,4,'incomplete_require_revisit','apartment','semi_pakka','Peerzadiguda',0,8,2),('2025-11-03 10:43:44.594303','edaae346b0a049af9be489a9226aa0bd',NULL,'Yehdh','WARD 1',28.6525936,77.3649868,162.40000915527344,20,25,'incomplete_require_revisit','apartment','semi_pakka','Pocharam',0,15,56),('2025-10-13 08:37:25.977688','fa6d45bcf1974e40b0ed223a379ab98d',NULL,'Arm 1','WARD 1',28.5364865,77.1888442,200.40000915527344,11.583999633789062,3,'incomplete_require_revisit','standalone','semi_pakka','Boduppal',0,8,28),('2025-11-03 10:42:37.588580','fd223924821543bd851d564c0d135a20',NULL,'Hdhd','WARD 1',28.6525938,77.3649862,162.40000915527344,15.616000175476074,21,'pending_enumeration','standalone','pakka','Boduppal',0,15,28);

--
-- Table structure for table `datacollectionapp_qrcode`
--

CREATE TABLE `datacollectionapp_qrcode` (
  `qr_uuid` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  PRIMARY KEY (`qr_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_qrcode`
--

INSERT INTO `datacollectionapp_qrcode` VALUES ('06722371','patient','2025-10-13 06:18:13.950968','2025-10-13 06:18:13.951047'),('06882110','patient','2025-10-13 06:18:10.083363','2025-10-13 06:18:10.083413'),('12AS123','patient','2025-10-13 08:31:32.505818','2025-10-13 08:31:32.505875'),('four four','patient','2025-10-27 05:41:21.385301','2025-10-27 05:41:21.385561'),('gfhghghj','patient','2025-10-13 06:18:11.020924','2025-10-13 06:18:11.021020'),('http://DoQRCodesWork.com','patient','2025-11-10 06:50:23.982305','2025-11-10 06:50:23.982354'),('https://scnv.io/cyO8?qr=1','patient','2025-11-10 06:11:36.438974','2025-11-10 06:11:36.439039'),('https://www.swasthyanagaram.in/node/9','patient','2025-11-03 04:20:41.145770','2025-11-03 04:20:41.145853'),('one one','patient','2025-10-24 12:16:37.678087','2025-10-24 12:16:37.678144'),('patient QR','patient','2025-10-13 15:56:46.364268','2025-10-13 15:56:46.364321'),('sampe','sample','2025-10-24 12:21:02.481729','2025-10-24 12:21:02.481772'),('sample','sample','2025-10-13 15:56:23.755807','2025-10-13 15:56:23.755874'),('test abc','patient','2025-10-13 15:51:06.868408','2025-10-13 15:51:06.868461'),('three three','patient','2025-10-24 12:21:02.466493','2025-10-24 12:21:02.466594'),('two two','patient','2025-10-24 12:17:29.303314','2025-10-24 12:17:29.303368');

--
-- Table structure for table `datacollectionapp_record`
--

CREATE TABLE `datacollectionapp_record` (
  `cough_id` char(32) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `name` varchar(512) DEFAULT NULL,
  `age` int NOT NULL,
  `gender` varchar(32) NOT NULL,
  `pregnant` tinyint(1) DEFAULT NULL,
  `on_tb_treatment` tinyint(1) DEFAULT NULL,
  `enumeration_status` varchar(64) NOT NULL,
  `final_tb_diagnosis_status` varchar(64) DEFAULT NULL,
  `meetings_attempted` int NOT NULL,
  `phone_number` varchar(15) DEFAULT NULL,
  `arm_id` bigint DEFAULT NULL,
  `nikshay_id` varchar(16) DEFAULT NULL,
  `tb_symptomatic` tinyint(1) DEFAULT NULL,
  `vulnerable` tinyint(1) DEFAULT NULL,
  `screening_status` varchar(64) DEFAULT NULL,
  `dicom` varchar(100) DEFAULT NULL,
  `qure_ai_results` varchar(64) DEFAULT NULL,
  `qure_ai_score` double DEFAULT NULL,
  `qure_ai_system_identifier` varchar(255) DEFAULT NULL,
  `qure_ai_remarks` varchar(255) DEFAULT NULL,
  `appointment_date_and_time` datetime(6) DEFAULT NULL,
  `xray_date_and_time` datetime(6) DEFAULT NULL,
  `xray_device` varchar(255) DEFAULT NULL,
  `xray_consent` tinyint(1) NOT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `followup_attempt` int unsigned DEFAULT NULL,
  `household_id` char(32) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `sample_collection_date_and_time` datetime(6) DEFAULT NULL,
  `sample_consent` tinyint(1) NOT NULL,
  `recording_form_id` bigint DEFAULT NULL,
  `date_and_time_of_result` datetime(6) DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  `assessment_status` varchar(64) DEFAULT NULL,
  `quality_of_sample` varchar(32) DEFAULT NULL,
  `sample_id` char(32) NOT NULL,
  `type_of_sample` varchar(32) DEFAULT NULL,
  `refusal_reason` varchar(1024) DEFAULT NULL,
  `sample_collection_attempt` int unsigned DEFAULT NULL,
  `sample_collection_status` varchar(32) DEFAULT NULL,
  `place_of_work_district` varchar(64) DEFAULT NULL,
  `place_of_work_ward` varchar(16) DEFAULT NULL,
  `place_of_work_ward_others` varchar(128) DEFAULT NULL,
  `created_by_id` int DEFAULT NULL,
  `signature` varchar(1024) DEFAULT NULL,
  `qr_code_id` varchar(255) DEFAULT NULL,
  `sample_qr_code_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cough_id`),
  KEY `datacollect_name_b05dbe_idx` (`name`,`enumeration_status`,`final_tb_diagnosis_status`),
  KEY `datacollectionapp_re_household_id_c800d035_fk_datacolle` (`household_id`),
  KEY `datacollectionapp_record_arm_id_155d28b2` (`arm_id`),
  KEY `datacollectionapp_re_recording_form_id_0572e583_fk_datacolle` (`recording_form_id`),
  KEY `datacollectionapp_record_created_by_id_117bdbd2_fk_auth_user_id` (`created_by_id`),
  KEY `datacollectionapp_record_qr_code_id_ef274fa9_fk` (`qr_code_id`),
  KEY `datacollectionapp_record_sample_qr_code_id_62ab0f90_fk` (`sample_qr_code_id`),
  CONSTRAINT `datacollectionapp_re_arm_id_155d28b2_fk_datacolle` FOREIGN KEY (`arm_id`) REFERENCES `datacollectionapp_arm` (`id`),
  CONSTRAINT `datacollectionapp_re_household_id_c800d035_fk_datacolle` FOREIGN KEY (`household_id`) REFERENCES `datacollectionapp_household` (`household_id`),
  CONSTRAINT `datacollectionapp_re_recording_form_id_0572e583_fk_datacolle` FOREIGN KEY (`recording_form_id`) REFERENCES `datacollectionapp_recordingform` (`id`),
  CONSTRAINT `datacollectionapp_record_created_by_id_117bdbd2_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `datacollectionapp_record_qr_code_id_ef274fa9_fk` FOREIGN KEY (`qr_code_id`) REFERENCES `datacollectionapp_qrcode` (`qr_uuid`),
  CONSTRAINT `datacollectionapp_record_sample_qr_code_id_62ab0f90_fk` FOREIGN KEY (`sample_qr_code_id`) REFERENCES `datacollectionapp_qrcode` (`qr_uuid`),
  CONSTRAINT `datacollectionapp_record_chk_1` CHECK ((`followup_attempt` >= 0)),
  CONSTRAINT `datacollectionapp_record_chk_2` CHECK ((`sample_collection_attempt` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_record`
--

INSERT INTO `datacollectionapp_record` VALUES ('06430385704d4c938c454d5dfad9309e','2025-10-13 08:58:55.966487','Manu',35,'male',0,0,'ENUMERATED','',1,'9668589966',30,NULL,0,0,'PENDING_APPOINTMENT','dicom_files/20250627113311_LmYJupm.dcm',NULL,NULL,NULL,'Tuberculosis tag or TBScore or SOPInstanceUID not found in the response.',NULL,NULL,NULL,1,NULL,NULL,1,'79ebf94e33ae4af59f1adfe8fd62bcd5',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'ab9264a77d984cd2a26e732413dbd9b5',NULL,NULL,0,NULL,'Pocharam','WARD 9','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/1b39f4ef-1df7-41a4-bc8b-3a6a35d1d1ad.png',NULL,NULL),('10c96c499a06414eacf46074dd884a01','2025-10-13 07:27:57.218805','Nikita',35,'female',0,0,'ENUMERATED','',3,'6688996339',68,'',0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,2,NULL,NULL,NULL,0,NULL,NULL,NULL,'NOT_AVAILABLE',NULL,'cf24611ce1674a3a8119a58a16c2d2f8',NULL,NULL,0,NULL,'Peerzadiguda','WARD 19','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%25253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/727a935c-a6a8-45f1-8dc7-ad32ca99e287.png',NULL,NULL),('142ef84014e44a46b280de20a669bb92','2025-11-10 09:14:58.353337','Raku',35,'female',0,0,'ENUMERATED','',1,'6556665555',21,NULL,0,1,'PENDING_DIAGNOSIS_TREATMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'2f7465fd7ba24ad2b05be65f387838f5',NULL,'2025-11-10 09:19:54.667487',1,49,'2025-11-10 09:19:54.676523','positive','Y1_ASSESSMENT_COMPLETE','Mucopluruent','6fea62e2f72d40c5b7b3a2093c48dfc4','SPUTUM',NULL,2,'collected','Boduppal','WARD 6','',8,'signature/f06d8525-2ae4-4728-a391-f42f2158583d.png',NULL,NULL),('1465cfbd3f8d4408a080ebe7b2997e5a','2025-10-13 15:54:43.848225','Test two',56,'male',0,0,'ENUMERATED','',1,'9556988666',17,'9797979464',0,1,'PENDING_DIAGNOSIS_TREATMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'d926cb5a063d44f686b62967e49edb4e',NULL,'2025-10-13 15:57:22.264185',1,NULL,'2025-10-13 15:57:22.273804','positive','Y1_ASSESSMENT_COMPLETE','Saliva','2a87b0694eb54108bcb3d3334056719d','SPUTUM',NULL,1,'collected','Peerzadiguda','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%25253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/35bd305b-8b1b-47cc-a1e2-bd1116e66952.png','patient QR','sample'),('14812a4a78864c72a8aaa3b3dbcf4294','2025-10-13 06:18:10.097151','Sreddy',55,'male',0,0,'PENDING_ENUMERATION','',0,'9337581882',72,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'58bdd5556c084d68895eaefd474b5e88',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'cef33381aed64b648c1f8bfea285f27f',NULL,NULL,0,NULL,'Others','WARD 17','Koti',5,'','06882110',NULL),('178aea36092145ff8ab570abd9815267','2025-11-03 10:50:16.089697','Test armss',25,'male',0,0,'ENUMERATED',NULL,1,'9995533556',10,'525252825',0,1,'SCREENED_NEGATIVE_PENDING_TPT','dicom_files/0AJ9IWZ_SeMkRnT.dcm','non-presumptive',0.078,'1.2.826.0.1.3680043.8.498.48414249514689053966881431452238617972','QURE AI results generated.',NULL,'2025-11-03 10:54:59.000000',NULL,1,NULL,NULL,1,'500cfb1b1a634407bd8e5e969f26282e',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'63f9f05a687a4514864d171995a5ab4e',NULL,NULL,0,NULL,'Boduppal','WARD 9',NULL,15,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%25253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/0316262b-36cd-4332-9792-57621cd3c42a.png',NULL,NULL),('187cf7774c984912af7c9979c92465b3','2025-10-10 13:31:31.645543','Prashant Soni',23,'male',0,0,'PENDING_ENUMERATION','',0,'8838388399',4,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'6346ae719a3c4eefb68fbb26ab08167f',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'f254ce02b91c4901931e89ec51b9c923',NULL,NULL,0,NULL,'Peerzadiguda','WARD 4','',3,'',NULL,NULL),('1b31b0ec74fa4a67be75e320436a53f7','2025-10-27 05:41:21.404178','Four four',56,'male',0,0,'PENDING_ENUMERATION','',0,'9494949656',17,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'3a2a4d9ed1854d54824753f29e263423',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'157184b21ffc4cf3b065783a0a9fab25',NULL,NULL,0,NULL,'Peerzadiguda','WARD 7','',4,'','four four',NULL),('1c5bcd5a673d42a2979f410b69f2fce2','2025-11-03 15:50:46.126434','Vibhu',40,'male',0,0,'ENUMERATED','',2,'6454887377',8,'',0,0,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'f18f4d5765df472abf30d59580a08bad',NULL,NULL,0,NULL,'Boduppal','WARD 7','',8,'signature/75c8f270-5210-49a2-acaf-94cbed08647c.png',NULL,NULL),('241782d414da40b18dbd3cf7884a55e2','2025-10-13 07:35:56.243403','Test akash',56,'male',0,0,'ENUMERATED','',1,'6767989565',20,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'46e173bdb4a742b6be0d181cc571518d',NULL,NULL,0,NULL,'Peerzadiguda','WARD 7','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/fc1b4cc7-01a4-40ba-92aa-88b231bb74ab.png',NULL,NULL),('2dd48512f1fb40f4b726b8d6a52147b2','2025-10-13 08:55:45.015013','K',35,'female',0,0,'ENUMERATED','',2,'9966888555',28,'5563368896',0,1,'PENDING_DIAGNOSIS_TREATMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'cd1a1650aac142dd9305478bf42cd9af',NULL,'2025-10-13 11:01:19.782635',1,NULL,'2025-10-13 11:02:31.537007','positive','Y1_ASSESSMENT_COMPLETE','Saliva','56d0cdd980ff419ab3c7cfd3a4c9ec90','SPUTUM',NULL,1,'collected','Boduppal','WARD 4','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/1b56200c-49a7-421a-90ed-349355c2026d.png',NULL,NULL),('30080ee0bf774c0787fa7c0a0a367dd0','2025-10-10 15:39:12.334957','Test c',56,'male',0,0,'ENUMERATED','',1,'7949494944',27,'6767646464',0,1,'AI_RESULT_AVAILABLE','dicom_files/d0c3f320-b8765c6f-87b2f49c-c6699f4f-9a088662.dcm','presumptive',0.685,'1.2.826.0.1.3680043.8.498.33943108913705649606167831054219311703.1','QURE AI results generated.',NULL,'2025-10-10 15:47:04.171205','DEVICE_TWO',1,NULL,NULL,1,'373a525c433449b8bf971d5ad5ce5947',NULL,NULL,0,4,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'664db7e222a94e5984f8c12170aa07ba',NULL,NULL,0,NULL,'Peerzadiguda','WARD 23','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/16f5e695-f4d7-4b7f-ace9-dd4f3a51d64c.png',NULL,NULL),('326c6dccdc1d454fa1862f092296ed36','2025-10-10 15:39:12.133246','Test b',56,'male',0,0,'ENUMERATED','',1,'9764646646',17,'949495956',0,1,'SCREENED_NEGATIVE_PENDING_TPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'bd393ffe10274cd49dfabeeef60faadb',NULL,'2025-10-10 15:43:45.379873',1,3,'2025-10-10 15:43:45.395006','negative','Y1_ASSESSMENT_COMPLETE','Saliva','606a43cf08024af095290613f0223ee4','SPUTUM',NULL,1,'collected','Peerzadiguda','WARD 5','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/c842d5e4-b8b6-4919-b986-ec6e1fe89f45.png',NULL,NULL),('3810c23c31ff40f598fd645e52d4b251','2025-10-13 08:31:32.521082','Niki',65,'female',0,0,'ENUMERATED','',1,'9966655888',2,'',0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,'de91527ae2314331857d127d9e383362',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'89ff28bc0d1e4a63b73d3fbfd17198ff',NULL,NULL,0,NULL,'Boduppal','WARD 5','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/ccc925a2-0473-417a-9abd-af454939c441.png','12AS123',NULL),('3b3faf1e4be44f3a9866d825504f2e6a','2025-10-13 08:37:26.339545','Rakesh',48,'male',0,0,'ENUMERATED','',1,'8866998556',28,'',0,0,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'fa6d45bcf1974e40b0ed223a379ab98d',NULL,'2025-10-13 08:41:14.350413',1,NULL,NULL,NULL,NULL,'Mucopluruent','5c0a90b5089f448ba5702434191bb41e','SPUTUM',NULL,1,'collected','Pocharam','WARD 8','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/32292b1c-103f-4f89-b0df-89537607ff6a.png',NULL,NULL),('3cd3606d30ff412d8cdeb9827679d88c','2025-10-13 06:59:01.348617','Awele',35,'female',0,0,'ENUMERATED','',1,'8666553366',29,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'accf15191ec44716ae4a7c0da819d95d',NULL,'2025-10-13 11:04:47.454200',1,8,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','Blood Stained','96ad3b7aabb643f09ee65dd9861fa7f4','SPUTUM',NULL,2,'collected','Boduppal','WARD 8','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/13ec33ff-867d-4b81-95c4-8be9c9a14332.png',NULL,NULL),('3d5f04f8f080492eb7e924c6e60a93ff','2025-10-13 09:28:08.879582','Nitisha',36,'female',0,0,'ENUMERATED','',1,'6464975737',30,'',0,0,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'79ebf94e33ae4af59f1adfe8fd62bcd5',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'b01497ac2e93404b9978be22b64251d4',NULL,NULL,0,NULL,'Pocharam','WARD 7','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/90b16eef-2212-4352-9ba6-cec5183f6652.png',NULL,NULL),('3e7f23e316744f0e91e6658217c56b67','2025-10-13 15:49:51.810869','Test abc',56,'male',0,0,'ENUMERATED','',1,'9764646464',8,'9764646646',0,1,'SCREENED_NEGATIVE_PENDING_TPT','dicom_files/c3be03b2-9de353b4-079fb233-efeb4707-00e8e97f_qm9UB0z.dcm','non-presumptive',0.008,'1.2.826.0.1.3680043.8.498.42591222890776811004199480634383929168.1','QURE AI results generated.',NULL,'2025-10-13 15:52:10.875038',NULL,1,NULL,NULL,1,'7fb0e0d2e5da44a5b76f11f49f036ed5',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'e91298725e304f92b5574c74719db208',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/7bff3c15-d56b-48ee-a3f2-a888ec1a58cd.png','test abc',NULL),('46c12750133d42a093b8a080f3fc91e6','2025-11-10 08:38:27.354290','Ktest',37,'male',0,0,'ENUMERATED',NULL,1,'6454376737',8,NULL,0,0,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,'0ca265743803489cac8ab1942d5a6a17',NULL,NULL,0,47,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'038f20beed6147328da0421da6dbf9c2',NULL,NULL,0,NULL,'Pocharam','WARD 6',NULL,8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/21d941cc-8f06-400c-8402-90aaff6a1e29.png',NULL,NULL),('47eb339376f74145b9c244669d37a704','2025-10-13 06:18:13.970328','Lreddy',19,'female',0,0,'ENUMERATED','',1,'6666666666',72,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'58bdd5556c084d68895eaefd474b5e88',NULL,'2025-10-13 09:50:45.736759',1,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','Saliva','a480713c07ef48a6b75169acd992ab6b','SPUTUM',NULL,1,'collected','Others','','Uppal',5,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/08b71219-b275-4366-b2b0-7fd5bff694ac.png','06722371','gfhghghj'),('506bc4334d0244e2a2c6e79e23c4aa82','2025-10-13 10:38:24.013755','Test akash one',56,'male',0,0,'ENUMERATED',NULL,1,'9797979868',30,NULL,0,1,'AI_RESULT_AVAILABLE','dicom_files/00ATWKG_Fe3U9EG.dcm','non-presumptive',0.094,'1.2.826.0.1.3680043.8.498.11454460485631545772078497881393492542','QURE AI results generated.',NULL,'2025-10-30 06:13:38.890900','DEVICE_TWO',1,NULL,NULL,1,'02dbad9ee7c7418f9c317d1c0ddbf1f6',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'7e379cb01eaf45918b9d60a37f9e8974',NULL,NULL,0,NULL,'Boduppal','WARD 7',NULL,4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/343f1ec2-457a-48bc-98ba-0c349f036349.png',NULL,NULL),('63d6e02fd9cf4805b465403dbb6735d2','2025-10-27 05:41:22.059140','Five five',56,'female',0,0,'PENDING_ENUMERATION','',0,'9495956656',17,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'3a2a4d9ed1854d54824753f29e263423',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'54f6f28ff8764847910ee703076053d4',NULL,NULL,0,NULL,'Boduppal','WARD 7','',4,'',NULL,NULL),('6b735ebff65d440caae312048dd5f600','2025-10-10 15:39:11.738907','Test A',56,'male',0,0,'ENUMERATED','',1,'9846466464',8,'9494949494',0,1,'AI_RESULT_AVAILABLE','dicom_files/bdfa9ed4-13d44875-61ae510e-6cf46bb2-d4a71892.dcm','presumptive',0.91,'1.2.826.0.1.3680043.8.498.95731071191002715291193798394090725898.2','QURE AI results generated.',NULL,'2025-10-10 15:41:45.055757',NULL,1,NULL,NULL,2,'7608b422b8374f6e8f247ab895c66c35',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'6346773ce90045099996f16247ec9273',NULL,NULL,0,NULL,'Peerzadiguda','WARD 5','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/cf3695a2-b998-483c-9ce0-2d7fdba5ed79.png',NULL,NULL),('6be434e2351f41a8833cb3fddc5f48aa','2025-10-13 08:12:42.932667','Test three',86,'male',0,0,'ENUMERATED','',1,'9597977949',20,'6464644',0,1,'SCREENED_NEGATIVE_PENDING_TPT','dicom_files/cb221a16-0ae23deb-c653808e-a277459f-f66ee69e_2zkRSME.dcm','non-presumptive',0.485,'1.2.826.0.1.3680043.8.498.37791630448144326328080169096887955124.1','QURE AI results generated.',NULL,'2025-10-13 08:13:36.931092','DEVICE_ONE',1,NULL,NULL,1,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'42d1fc4f2e724bd4b82e11be134bda3d',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/5bdb2b65-dded-41a9-8f1a-f89c9a3b055f.png',NULL,NULL),('6c49510f0816418b802ce9e1da7009e9','2025-10-13 06:15:33.254662','Partha Reddy',38,'male',0,0,'ENUMERATED','',1,'6369566696',57,'',0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'33b6976c7de84a8297dd597a1ba444e4',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'202cff7a2109472e9f3dc739a6ca7eb0',NULL,NULL,0,NULL,'Pocharam','WARD 2','',7,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/705484b1-9ea5-4023-95b2-1f08fbb7bf77.png',NULL,NULL),('7ebcfbac94794e30b543cf89e0390122','2025-10-13 08:34:52.363865','Midhunnnn',35,'male',0,0,'ENUMERATED','',1,'6655589666',2,NULL,0,0,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'de91527ae2314331857d127d9e383362',NULL,NULL,0,NULL,NULL,NULL,'NOT_VULNERABLE',NULL,'58c07b61e74b44bfa7f93005c69dd242',NULL,NULL,0,NULL,'Boduppal','WARD 6','',8,'signature/03577fb9-4190-4c73-ad14-ce9282e99b53.png',NULL,NULL),('7fa4cf82503146218357581a03ae7550','2025-10-13 07:14:23.438769','Arvind',35,'male',0,0,'ENUMERATED','',1,'9955566880',68,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,NULL,NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'19e56d140b0a4104933f18d633b3e631',NULL,NULL,0,NULL,'Pocharam','WARD 9','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/e8fd9efc-9058-485b-adad-7a3c7d5a747f.png',NULL,NULL),('80c77abb60fb4f1f83bbaab354724262','2025-10-13 07:01:23.947312','Anand',39,'male',0,0,'PENDING_ENUMERATION','',0,'9464236966',57,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'55c448eedf1b476f980bb22198240da5',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'090f91222aa449569a7843b9ac4853b1',NULL,NULL,0,NULL,'Pocharam','WARD 2','',6,'',NULL,NULL),('83c0731e98d94f9496eba3d060ccfde6','2025-10-13 07:01:24.437642','Baburao',34,'male',0,0,'ENUMERATED','',1,'8688281829',57,'',0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,2,'55c448eedf1b476f980bb22198240da5',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'ff54efa1fdbb49a88a7fe7ce9d6c09d3',NULL,NULL,0,NULL,'Pocharam','WARD 2','',6,'signature/9387fcb7-f123-43c5-a5a5-a24c2d1b7736.png','https://www.swasthyanagaram.in/node/9',NULL),('8427a8842b7a40bc9709137894aef648','2025-10-13 08:07:18.781586','Test two',56,'male',0,0,'ENUMERATED','',2,'9494946446',20,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'e18d99461506422a9c6f49ef432d2c17',NULL,NULL,0,NULL,'Boduppal','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/60dc2c73-0a50-4fd5-b610-4d9e7a635e55.png',NULL,NULL),('84df9cadb83a4f308e23b709e7bcecd5','2025-11-06 05:48:42.670751','Test novv',25,'male',0,0,'ENUMERATED','',3,'9653538686',5,'',0,0,'PENDING_SAMPLE_COLLECTION','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'b4c3179d942c48508b3cac192c91266e',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'fbe5d77d0e1c48d6b865b326615871d9',NULL,NULL,0,NULL,'Boduppal','WARD 9','',15,'signature/f6960fa5-9b04-4723-8472-ca4553212a8e.png',NULL,NULL),('8505830b3bc24efdb506e8af88218683','2025-10-13 10:52:38.437749','Test akash three',56,'male',0,0,'ENUMERATED','',1,'9764646464',17,NULL,0,1,'RESULT_REPORTED','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'5d793d85752247cabfae323ce8511050',NULL,'2025-10-13 10:52:52.668174',1,NULL,'2025-10-13 10:54:03.000000','negative','Y1_ASSESSMENT_COMPLETE','Blood Stained','ed6f6f1672654f93aa4becda0fc3e672','SPUTUM',NULL,1,'collected','Boduppal','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/0bb777d4-7c61-4d13-88b3-20a932ae3230.png',NULL,NULL),('89c53bf8d01145568515f13a3da14fe4','2025-10-24 12:16:37.693569','One one',56,'male',0,0,'PENDING_ENUMERATION','',0,'9494949494',8,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'b78e88d3de1c4fad98b473bfc7353cf2',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'644fbb5e59694a5cb12a47a885806765',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'','one one',NULL),('9148d96b7524450fbe74daf8dca70e73','2025-10-13 07:24:47.982872','Midhun',36,'male',0,0,'ENUMERATED','',1,'9998800066',68,NULL,0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,NULL,NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'128a8b454127451981e1db9373e203c6',NULL,NULL,0,NULL,'Pocharam','WARD 6','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/77b3ab64-0b71-464d-981f-b40919ac7528.png',NULL,NULL),('9fdb1c1b9d3a42fcb4cbdd359c99234c','2025-10-10 13:33:09.169404','Vandana Vasudev',32,'male',0,0,'ENUMERATED','',1,'9399399399',2,NULL,0,1,'AI_RESULT_AVAILABLE','dicom_files/cb221a16-0ae23deb-c653808e-a277459f-f66ee69e.dcm','non-presumptive',0.485,'1.2.826.0.1.3680043.8.498.37791630448144326328080169096887955124.1','QURE AI results generated.',NULL,'2025-10-10 13:41:23.407571',NULL,1,NULL,NULL,2,'d1aa7801bede4d53bcee78063d391d33',NULL,NULL,0,1,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'bc5482a530014e21b91f9ed3c271f6aa',NULL,NULL,0,NULL,'Peerzadiguda','WARD 4','',3,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/2c7486a3-0566-49d9-be13-feef066d5d80.png',NULL,NULL),('a02a7914a5fd4ec0be363353667ed7dc','2025-10-13 08:16:43.188176','Test four',56,'female',0,0,'ENUMERATED','',1,'9797949494',20,NULL,0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,2,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'a581464dc6df42b4878e9c9c5b737254',NULL,NULL,0,NULL,'Boduppal','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/d2ed498e-0397-4b9f-93a4-00d36a3ba5e5.png',NULL,NULL),('a137a001276146eda172994751496580','2025-10-10 13:31:32.087304','Kousthub Raja',32,'male',0,0,'PENDING_ENUMERATION','',0,'9939399299',4,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'6346ae719a3c4eefb68fbb26ab08167f',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'fb1e54797c6b4cb281f2db67a7a11f23',NULL,NULL,0,NULL,'Peerzadiguda','WARD 8','',3,'',NULL,NULL),('a1d5595cc7c84eceabe127c40e7c1704','2025-10-13 07:39:13.931897','Test Prashant',56,'male',0,0,'ENUMERATED','',1,'9494946464',20,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'386ccc8a5ea74e0a94f39de7df432c66',NULL,NULL,0,NULL,'Peerzadiguda','WARD 19','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/a9299efd-1810-4361-80af-1c63e77c43c4.png',NULL,NULL),('a3d54afbbae140068201557d3fa0feff','2025-11-07 10:44:01.896464','Test',25,'female',0,0,'ENUMERATED','',1,'9695656655',29,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'254e3ff7ba264b6f918c2e2a0752d4b1',NULL,'2025-11-07 10:49:08.468583',1,44,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','N/A','c4985d31bba6478b91eceecfb75ef28d','TONGUE_SWAB',NULL,2,'collected','Pocharam','WARD 9','',15,'signature/a8845ae4-a558-48b1-9836-b35abcdec06f.png',NULL,NULL),('b52a51ea05d44852a373a1ea6f9f46e5','2025-10-10 13:31:32.459120','Himanshu Kataria',32,'male',0,0,'ENUMERATED','',1,'8388388383',4,'',0,1,'PENDING_SAMPLE_COLLECTION','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'b2c9b888b1d447debe27e3089b7a10b4',NULL,NULL,0,35,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'fc2d2b47ef624ac7b21f08bf38856ead',NULL,NULL,0,NULL,'Peerzadiguda','WARD 5','',3,'signature/ccd080ef-f66f-419d-b84e-c677564b5a25.png',NULL,NULL),('b62abd57333740ab9c63b84fab2e4a41','2025-10-13 07:51:56.293407','Test abc',56,'male',0,0,'ENUMERATED','',1,'9464646464',20,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'b89b511fa5d447369e4fb770df5772aa',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'7cb0313174dc4af2887e8a91c17ff2e7',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/519b5bfd-e97d-4a4a-aad3-b78fbe1a70d8.png',NULL,NULL),('bc5af3c860824b74a5886cded7bf0a63','2025-10-13 08:52:08.765507','Test abc',86,'male',0,0,'ENUMERATED','',1,'6467676764',17,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,'2025-10-13 09:01:41.214625',1,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','Blood Stained','0ca05553a270487b81f9c6391ac4c59e','SPUTUM',NULL,1,'collected','Boduppal','WARD 6','',4,'signature/5871bd63-c5d6-4a32-989f-56394a5469d0.png',NULL,NULL),('bcc01ae1cb0f48cdad5556345771afbc','2025-10-13 13:21:36.735415','Shalome Shreya',23,'female',0,0,'ENUMERATED',NULL,1,'8848328838',2,NULL,0,1,'AI_RESULT_AVAILABLE','dicom_files/0AFQAAD_GFrw3ZS.dcm','non-presumptive',0.094,'1.2.826.0.1.3680043.8.498.71703627897085449056539313191065653688','QURE AI results generated.',NULL,'2025-10-30 05:13:18.250048','DEVICE_TWO',1,NULL,NULL,2,'d1aa7801bede4d53bcee78063d391d33',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'685dd7fa0e18433490f8f48a0637c120',NULL,NULL,0,NULL,'Boduppal','WARD 5',NULL,3,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/61ba49e5-43ce-4448-b531-9093065f3801.png',NULL,NULL),('c1a266ce15164d27a93088c382681e8e','2025-10-23 09:51:02.159839','Keshavani',31,'female',0,0,'PENDING_ENUMERATION','',1,'9999885555',56,'',0,0,'PENDING_SAMPLE_COLLECTION','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'33c346b2138449bd9da4f02ad0b4c135',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'5166fc65b6e74172aa329938bf90172f',NULL,NULL,0,NULL,'Pocharam','WARD 11','',6,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/d7899347-4f8e-4bc9-a3fc-27c87e6afe69.png',NULL,NULL),('c31432178b7f4a4283cbbcb6f849bc4b','2025-10-13 10:44:00.736889','Test akash two',56,'male',0,0,'ENUMERATED','',1,'9794946565',30,'',0,1,'REFUSED_X_RAY','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,3,'02dbad9ee7c7418f9c317d1c0ddbf1f6',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'a7db73cf7a254e48b6ac872cc700e64f',NULL,NULL,0,NULL,'Peerzadiguda','WARD 7','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/2945fa03-7451-4da0-adb7-c94ca8f6a584.png',NULL,NULL),('c334fdc2b8ad47098201e8ad613af948','2025-11-03 10:46:22.590679','Test',65,'female',0,0,'PENDING_ENUMERATION',NULL,1,'8873245332',56,NULL,0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'edaae346b0a049af9be489a9226aa0bd',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'6873423fe7ec4e3585c48af9965ae405',NULL,NULL,0,NULL,'Boduppal','WARD 9','',15,'signature/69272d41-935b-44db-83a7-49417d56b118.png',NULL,NULL),('d4f7d90369ec4d63b1240365120c2a64','2025-10-23 09:51:01.191834','Rudra Keshav',38,'male',0,0,'ENUMERATED','',1,'9963255888',56,'',0,1,'PENDING_SAMPLE_COLLECTION','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'33c346b2138449bd9da4f02ad0b4c135',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'ae62774923254555a2aeca7886ecd114',NULL,NULL,0,NULL,'Others','','13',6,'signature/095e1a0c-0192-4992-842d-89b77f164427.png',NULL,NULL),('d72347a1b9f04b8d9b47a548094b0382','2025-11-03 15:50:45.824309','Samy',5,'female',0,0,'ENUMERATED','',0,'6467876767',8,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,'NOT_ELIGIBLE',NULL,'adddaef6314c4ea5af6441c6dabdb71a',NULL,NULL,0,NULL,'Boduppal','WARD 6','',8,'',NULL,NULL),('dc581fc0212f4810ac257cbe6a7d2df2','2025-10-13 11:06:27.549699','Test akash seven',56,'male',0,0,'ENUMERATED','',1,'6767674656',30,NULL,0,1,'AI_RESULT_AVAILABLE','dicom_files/20250703113727_3f0qjYd.dcm','non-presumptive',0.078,'1.2.826.0.1.3680043.8.498.48414249514689053966881431452238617972','Conflict: DICOM already uploaded, but unable to fetch existing results. SOPInstanceUID: 1.2.840.114257.3.6.5.1751522661725.2644.0.0',NULL,'2025-10-30 06:23:55.496442',NULL,1,NULL,NULL,1,'02dbad9ee7c7418f9c317d1c0ddbf1f6',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'aa606352698649278a3d791f6d744adc',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/da5e46d4-cf68-4117-b9e4-a0ffd32119a6.png',NULL,NULL),('de51a695859a45cba3c019f89a52aca0','2025-11-10 06:11:36.822707','Nitisha',39,'female',0,0,'ENUMERATED','',1,'6464476763',8,NULL,0,0,'AI_RESULT_AVAILABLE','dicom_files/0004S_REGULA_ORIMALA_68_CHEST_PA_image1762160854895_Q6spyKC.dcm','non-presumptive',0.033,'1.3.6.1.4.1.53829.3.6.5.20251103143509485283505755.1.1.1','QURE AI results generated.',NULL,'2025-11-10 08:21:33.500935',NULL,1,NULL,NULL,1,'0ca265743803489cac8ab1942d5a6a17',NULL,NULL,0,46,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'9d7ccd79b66a4745a827053fc293da5a',NULL,NULL,0,NULL,'Boduppal','WARD 9','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/17f43da5-1b51-4bff-aeab-679798241181.png','http://DoQRCodesWork.com',NULL),('e5ed8334bdb2438b8b264347c25d1497','2025-10-24 12:21:02.500578','Three three',56,'male',0,0,'ENUMERATED','',1,'9494495959',17,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'3a2a4d9ed1854d54824753f29e263423',NULL,'2025-10-24 12:19:53.823000',1,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','Blood Stained','22d05c97c5dd4e9496f9218af23c760b','SPUTUM',NULL,1,'collected','Peerzadiguda','WARD 7','',4,'signature/8c1208fd-752b-4bce-8481-a945fc6ff8cd.png','three three','sampe'),('ea55c542a1684f76b83e0ef3d7defc53','2025-11-03 05:42:44.118919','Test xrayw',25,'male',0,0,'ENUMERATED',NULL,1,'9696999665',30,NULL,0,1,'AI_RESULT_AVAILABLE','dicom_files/d0c3f320-b8765c6f-87b2f49c-c6699f4f-9a088662_h1MSbYx.dcm','presumptive',0.685,'1.2.826.0.1.3680043.8.498.33943108913705649606167831054219311703.1','QURE AI results generated.',NULL,'2025-11-07 09:17:06.915492',NULL,1,NULL,NULL,2,NULL,NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'083441c3c7e54fc592fcdcc5ac19761b',NULL,NULL,0,NULL,'Boduppal','WARD 11',NULL,15,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%3A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/https%253A//storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/d075fbd6-b144-419b-b01f-58c4dea2930e.png',NULL,NULL),('ec21b302f8d4439c86b1634f5c1d5468','2025-10-24 12:17:29.319898','Two two',56,'male',0,0,'PENDING_ENUMERATION','',0,'9595595959',8,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'b78e88d3de1c4fad98b473bfc7353cf2',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'132f10f076d94eba8b38e48427f6d23b',NULL,NULL,0,NULL,'Peerzadiguda','WARD 6','',4,'','two two',NULL),('ecccebd573664d96837a2bef2f3c27af','2025-10-13 06:18:11.041975','A reddy',50,'female',0,0,'ENUMERATED','',1,'8888888888',72,'',0,1,'SAMPLE_NA','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'58bdd5556c084d68895eaefd474b5e88',NULL,NULL,0,7,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'18ec8265ccf847af91f64faacce6d295',NULL,'Doesn\'t want',1,'refused','Others','','Koti',5,'signature/68a014bb-afcd-4901-849e-b7d91834df87.png','gfhghghj',NULL),('f4772254ec1d44b9837ba72939366be9','2025-10-13 11:01:02.517168','Neena',66,'female',0,0,'ENUMERATED','',1,'6464575737',28,'',0,1,'SAMPLE_COLLECTED_PENDING_RECEIPT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'fa6d45bcf1974e40b0ed223a379ab98d',NULL,'2025-10-15 10:32:07.906662',1,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE','TONGUE_SWAB','d2cdf44ef83b489983c787d1676895a4','TONGUE_SWAB',NULL,1,'collected','Boduppal','WARD 5','',8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/7108ad3c-fb3e-4b3a-9d11-00368812a377.png',NULL,NULL),('f87a76fc5017481189a1b0516de961b1','2025-10-13 09:07:36.858810','Shweta',25,'female',0,0,'ENUMERATED',NULL,1,'6999885668',30,NULL,0,0,'AI_RESULT_AVAILABLE','dicom_files/00ATWKG.dcm','non-presumptive',0.094,'1.2.826.0.1.3680043.8.498.11454460485631545772078497881393492542','QURE AI results generated.',NULL,'2025-11-07 09:11:30.140324',NULL,1,NULL,NULL,1,'79ebf94e33ae4af59f1adfe8fd62bcd5',NULL,NULL,0,NULL,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'7001496284c749e49d7262235c5bbc74',NULL,NULL,0,NULL,'Boduppal','WARD 9',NULL,8,'https://storage.googleapis.com/bucket-nonprod-catb-asso1-app-data/union/signature/7af66b87-4657-4672-9704-f138a2799e9c.png','06722371',NULL),('fe4749be8df54c01ae5ae9039f45c3cb','2025-11-03 05:27:52.814221','Dyd',25,'female',1,0,'ENUMERATED','',0,'8700788942',29,'',0,0,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'131cf285dd64470a860f57ac92134b3a',NULL,NULL,0,NULL,NULL,NULL,'NOT_ELIGIBLE',NULL,'eb955ce93e6140b991ce46e7fffa322f',NULL,NULL,0,NULL,'Pocharam','WARD 11','',15,'',NULL,NULL),('ff243472cb944ad3b51e4134cce3132a','2025-11-10 09:12:19.529192','Abhimanyu',63,'male',0,0,'ENUMERATED','',1,'6454573767',18,'',0,1,'PENDING_APPOINTMENT','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,'06a5674725d849eaa02ac4c6bf1d3548',NULL,NULL,0,48,NULL,NULL,'Y1_ASSESSMENT_COMPLETE',NULL,'f514a4eba7f34626afaa3cc77952bfa2',NULL,NULL,0,NULL,'Boduppal','WARD 6','',8,'signature/be4b4935-0c50-4d69-82e1-37493078faeb.png',NULL,NULL);

--
-- Table structure for table `datacollectionapp_recordingform`
--

CREATE TABLE `datacollectionapp_recordingform` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `consent` tinyint(1) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `age` smallint unsigned DEFAULT NULL,
  `height` double DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `bmi` double DEFAULT NULL,
  `fever` varchar(10) NOT NULL,
  `fever_duration` double NOT NULL,
  `cough` varchar(10) NOT NULL,
  `cough_duration` double NOT NULL,
  `loss_of_appetite` varchar(10) NOT NULL,
  `loss_of_appetite_duration` double NOT NULL,
  `weight_loss` varchar(10) NOT NULL,
  `weight_loss_duration` double NOT NULL,
  `shortness_of_breath` varchar(10) NOT NULL,
  `shortness_of_breath_duration` double NOT NULL,
  `chest_pain` varchar(10) NOT NULL,
  `chest_pain_duration` double NOT NULL,
  `hemoptysis` varchar(10) NOT NULL,
  `hemoptysis_duration` double NOT NULL,
  `night_sweat` varchar(10) NOT NULL,
  `night_sweat_duration` double NOT NULL,
  `diabetes` varchar(50) DEFAULT NULL,
  `covid_19` varchar(50) DEFAULT NULL,
  `hiv_status` varchar(50) DEFAULT NULL,
  `alcohol_intake` varchar(50) DEFAULT NULL,
  `alcohol_intake_duration` varchar(256) DEFAULT NULL,
  `alcohol_more` varchar(3) DEFAULT NULL,
  `alcohol_cut` varchar(3) DEFAULT NULL,
  `tobacco_intake` varchar(50) DEFAULT NULL,
  `tobacco_intake_duration` varchar(256) DEFAULT NULL,
  `tb_history_or_treatment` varchar(50) DEFAULT NULL,
  `is_the_participant` varchar(2048) DEFAULT NULL,
  `close_contact` varchar(16) DEFAULT NULL,
  `close_contact_duration` varchar(256) DEFAULT NULL,
  `chronic_diseases` json DEFAULT NULL,
  `risk_inference_score` double DEFAULT NULL,
  `risk_inference_class` varchar(50) DEFAULT NULL,
  `cough_recording_1` varchar(100) DEFAULT NULL,
  `cough_recording_2` varchar(100) DEFAULT NULL,
  `cough_recording_3` varchar(100) DEFAULT NULL,
  `background_sound` varchar(100) DEFAULT NULL,
  `rejected_recording_1` varchar(100) DEFAULT NULL,
  `rejected_recording_2` varchar(100) DEFAULT NULL,
  `rejected_recording_3` varchar(100) DEFAULT NULL,
  `model_threshold` double DEFAULT NULL,
  `cough_model_score` double DEFAULT NULL,
  `tabular_model_score` double DEFAULT NULL,
  `ensemble_model_score` double DEFAULT NULL,
  `ai_model_final_class` varchar(50) DEFAULT NULL,
  `model_version` varchar(50) DEFAULT NULL,
  `app_version` double DEFAULT NULL,
  `uuid` varchar(50) NOT NULL,
  `device_details` varchar(500) DEFAULT NULL,
  `created_at` datetime(6) NOT NULL,
  `modified_at` datetime(6) NOT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `altitude` double DEFAULT NULL,
  `location_accuracy` double DEFAULT NULL,
  `sent_for_testing` varchar(10) NOT NULL,
  `final_screening_result` varchar(20) DEFAULT NULL,
  `nikshay_id` varchar(15) DEFAULT NULL,
  `tb_diagnosis_date` datetime(6) DEFAULT NULL,
  `basis_of_diagnosis` varchar(50) DEFAULT NULL,
  `tb_status` varchar(50) DEFAULT NULL,
  `treatment_outcome` varchar(50) DEFAULT NULL,
  `cough_detector_threshold` double DEFAULT NULL,
  `cough_detector_score1` double DEFAULT NULL,
  `cough_detector_score2` double DEFAULT NULL,
  `cough_detector_score3` double DEFAULT NULL,
  `rule_based_4s` int DEFAULT NULL,
  `rule_based_7s` int DEFAULT NULL,
  `rejected_recording_1_score` double DEFAULT NULL,
  `rejected_recording_2_score` double DEFAULT NULL,
  `rejected_recording_3_score` double DEFAULT NULL,
  `cough1_valid` tinyint(1) DEFAULT NULL,
  `cough2_valid` tinyint(1) DEFAULT NULL,
  `cough3_valid` tinyint(1) DEFAULT NULL,
  `cough_tb_score_1` double DEFAULT NULL,
  `cough_tb_score_2` double DEFAULT NULL,
  `cough_tb_score_3` double DEFAULT NULL,
  `time_of_recording` datetime(6) DEFAULT NULL,
  `ntep_result` varchar(50) DEFAULT NULL,
  `sputum_collection_status` varchar(10) NOT NULL,
  `district_id` bigint DEFAULT NULL,
  `state_id` bigint DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `datacollectionapp_re_district_id_2908b7ae_fk_datacolle` (`district_id`),
  KEY `datacollectionapp_re_state_id_0a1b43c9_fk_datacolle` (`state_id`),
  KEY `datacollectionapp_recordingform_user_id_31100658_fk_auth_user_id` (`user_id`),
  CONSTRAINT `datacollectionapp_re_district_id_2908b7ae_fk_datacolle` FOREIGN KEY (`district_id`) REFERENCES `datacollectionapp_district` (`id`),
  CONSTRAINT `datacollectionapp_re_state_id_0a1b43c9_fk_datacolle` FOREIGN KEY (`state_id`) REFERENCES `datacollectionapp_state` (`id`),
  CONSTRAINT `datacollectionapp_recordingform_user_id_31100658_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `datacollectionapp_recordingform_chk_1` CHECK ((`age` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_recordingform`
--

INSERT INTO `datacollectionapp_recordingform` VALUES (1,1,'Vandana Vasudev','9399399399','male',32,190,90,24.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','never_had','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\"]','no',NULL,'[\"On anti cancerous treatment\", \"Bedridden\"]',7,'high','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'767d8f4c-aa19-44e3-ad87-c09a3d3e4458',NULL,'2025-10-10 13:34:25.029256','2025-10-10 13:41:30.740593',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',4,2,3),(2,1,'Test A','9846466464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Health Care Worker directly involved in the patient care or dealing with the patient samples\",\"Slum Dweller\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'c16a48e0-24b1-4a1e-a136-7441be327efa','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-10 15:39:10.812170','2025-10-13 11:10:19.533541',19.2222493,72.9676333,-26.5,88.83879852294922,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-10 15:39:08.303000',NULL,'pending',4,2,4),(3,1,'Test b','9764646646','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\",\"Slum Dweller\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'2b7d94f9-8232-4deb-901b-f701f5bb031d','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-10 15:42:34.346617','2025-10-13 11:10:19.663407',19.2222559,72.9676328,-26.5,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,NULL,0,0,NULL,NULL,NULL,1,1,0,NULL,NULL,NULL,'2025-10-10 15:42:31.286000',NULL,'pending',4,2,4),(4,1,'Test c','7949494944','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\", \"Bedridden\"]',22,'high','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'2b658f3a-c246-4e1f-adf3-70857e5f0d1a',NULL,'2025-10-10 15:46:21.223954','2025-10-13 11:10:19.778144',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',4,2,4),(5,1,'Partha Reddy','6369566696','male',38,165,65,23.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','negative','yes','3 years to 5 years','no','no','no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'69782b90-79b5-4026-afa9-baf95a869571','{\"brand\":\"google\",\"systemName\":\"Android\",\"systemVersion\":\"13\",\"model\":\"Pixel 4a\"}','2025-10-13 06:15:31.729555','2025-10-13 06:15:31.729614',17.4201209,78.6264808,413.9000244140625,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,0,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-13 06:15:23.144000',NULL,'pending',2,2,7),(6,1,'Lreddy undefined','6666666666','female',19,164,56,20.8,'no',0,'no',0,'yes',15,'no',0,'yes',10,'no',0,'no',0,'no',0,'non_diabetic','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'221660e3-88fa-42b5-92fb-2b6321e1b52c','{\"brand\":\"Redmi\",\"systemName\":\"Android\",\"systemVersion\":\"13\",\"model\":\"2201116SI\"}','2025-10-13 06:18:07.531810','2025-10-13 09:50:57.078593',17.420205,78.6262262,413.70001220703125,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,NULL,NULL,0,1,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,'2025-10-13 06:17:46.482000',NULL,'pending',2,2,5),(7,1,'A reddy','8888888888','female',50,170,72,24.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'diabetic','old_case','unknown','yes','More than 5 years','no','yes','yes','More than 10 years','no','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'185d1103-55ad-4653-8e27-63573825fca2','{\"brand\":\"Redmi\",\"systemName\":\"Android\",\"systemVersion\":\"13\",\"model\":\"2201116SI\"}','2025-10-13 06:27:24.945767','2025-10-13 09:50:57.310576',0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 06:27:04.239000',NULL,'pending',2,2,5),(8,1,'Awele undefined','8666553366','female',35,165,54,19.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'yes','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'fba972d9-6398-40a3-b9bb-80952a2bd97f','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 07:00:01.946428','2025-10-13 11:04:47.437715',28.5364898,77.188855,200.60000610351562,11.168999671936035,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 06:59:56.825000',NULL,'pending',2,2,8),(9,1,'Arvind','9955566880','male',35,165,36,13.2,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'0f805730-37db-4f83-933d-cd9c601c5740','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 07:14:22.686332','2025-10-13 11:04:47.576395',28.5364999,77.1888615,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:14:19.136000',NULL,'pending',2,2,8),(10,1,'Midhun undefined','9998800066','male',36,165,65,23.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'yes','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'d22ab1f8-7126-4c77-add8-5958b1f8be0b','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 07:24:47.089455','2025-10-13 11:04:47.784096',28.5364842,77.1888403,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:24:43.245000',NULL,'pending',2,2,8),(11,1,'Nikita undefined','6688996339','female',35,150,55,24.4,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'9a9ead72-fedd-4255-b750-a28e9e88b77e','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 07:27:56.387167','2025-10-13 11:04:47.926775',28.5364908,77.1888708,200.60000610351562,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:27:53.252000',NULL,'pending',2,2,8),(12,1,'Test akash','6767989565','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\", \"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'2ccdc176-dab3-4b05-813a-7bb75225290a','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 07:35:55.395469','2025-10-13 11:10:19.902056',19.2222499,72.9676186,-16.200000762939453,82.13819885253906,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:35:52.474000',NULL,'pending',4,2,4),(13,1,'Test Prashant','9494946464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\",\"Slum Dweller\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'12799a00-f216-477a-8f61-9a21f54c0abe','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 07:39:13.509030','2025-10-13 11:10:20.030780',19.2222544,72.9676301,-16.200000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:39:09.267000',NULL,'pending',4,2,4),(14,1,'Test abc','9464646464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\",\"Homeless\",\"Slum Dweller\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\", \"Chronic Kidney Disease on dialysis\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'8a0064a2-c9fe-4d81-acd8-ee8bf5861733','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 07:51:55.396399','2025-10-13 11:10:20.143511',19.2222291,72.9676158,-16.200000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 07:51:51.407000',NULL,'pending',4,2,4),(15,1,'Test one','9494494949','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\",\"Slum Dweller\",\"Homeless\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\", \"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'b74cdd3b-9c49-4ccd-b46e-2b4a4ac93fbf','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 08:00:37.731406','2025-10-13 11:10:20.291712',19.2222487,72.9676198,-16.200000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:00:34.565000',NULL,'pending',4,2,4),(16,1,'Test two','9494946446','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'b6a26ef5-f48a-4d88-b1a2-39aa7936710b','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 08:07:18.174019','2025-10-13 11:10:20.415874',19.2222639,72.9676096,-16.200000762939453,97.83820343017578,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:07:13.304000',NULL,'pending',4,2,4),(17,1,'Test three','9597977949','male',86,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'6a291dab-5e62-4888-a3c8-ff749e16be76','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 08:12:42.502077','2025-10-13 11:10:20.529710',19.2222245,72.9675989,-16.200000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:12:39.108000',NULL,'pending',4,2,4),(18,1,'Test four','9797949494','female',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'1913eb6a-a7c7-484e-a5f6-218dd0624d41','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 08:16:42.510244','2025-10-13 11:10:20.645698',0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:16:36.714000',NULL,'pending',4,2,4),(19,1,'Niki undefined','9966655888','female',65,186,85,24.6,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',1,'low','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'a0c5c855-4f8d-4be4-b453-a884c841e7d6',NULL,'2025-10-13 08:31:31.583132','2025-10-13 11:04:48.067005',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',2,2,8),(20,1,'Midhunnnn undefined','6655589666','male',35,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,'low','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'f333ad9e-1fe4-461d-bddc-08ab775f0ff9',NULL,'2025-10-13 08:34:51.869139','2025-10-13 11:04:48.192207',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',2,2,8),(21,1,'Rakesh','8866998556','male',48,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'b6acd43f-1e81-4fd4-8482-a247cd2ae66d','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 08:37:25.442616','2025-10-13 11:04:48.312250',28.5364865,77.1888442,200.40000915527344,96.20700073242188,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:37:14.754000',NULL,'pending',2,2,8),(22,1,'Test abc','6467676764','male',86,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\",\"Homeless\",\"Slum Dweller\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\", \"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'3f3e9779-d3c6-4e42-b97f-be1a7d982041','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 08:52:08.134424','2025-10-13 11:10:20.806564',19.2222381,72.9675773,-16.200000762939453,81.19319915771484,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,NULL,NULL,0,0,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,'2025-10-13 08:52:03.027000',NULL,'pending',4,2,4),(23,1,'K undefined','9966888555','female',35,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'642d279a-f74d-435b-972f-19a0ebd37d20','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 08:55:44.122246','2025-10-13 11:04:48.438417',28.5365024,77.1888526,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:55:36.813000',NULL,'pending',2,2,8),(24,1,'Manu undefined','9668589966','male',35,165,65,23.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'9fd2d355-c6cd-4183-99a2-90847bc06d9d','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 08:58:55.032566','2025-10-13 11:04:48.553376',28.536502,77.1888518,200.40000915527344,99.68000030517578,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 08:58:50.460000',NULL,'pending',2,2,8),(25,1,'Shweta','6999885668','female',25,155,53,22.1,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'1889e655-a2ea-4590-824f-d8e9ba4f379a','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 09:07:36.123224','2025-10-13 09:07:36.123264',28.536488,77.1888465,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,0,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-13 09:07:29.175000',NULL,'pending',2,2,8),(26,1,'Nitisha undefined','6464975737','female',36,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'bd6c86e9-d5dd-4248-934b-b1e3ac482b55','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 09:28:08.269851','2025-10-13 11:04:48.686054',0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 09:28:04.042000',NULL,'pending',2,2,8),(27,1,'Test Raj','9494946464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"Chronic Kidney Disease on dialysis\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'b722f31b-b7e4-4502-82f7-58dc6f31f878','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 10:20:08.559769','2025-10-13 10:20:08.559815',19.2222189,72.9676005,-27.799999237060547,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,0,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-13 10:20:04.533000',NULL,'pending',4,2,4),(28,1,'Test akash','9797979868','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\", \"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'5e8828b1-29b9-45b3-b908-370e0f1a2211','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 10:38:22.725621','2025-10-13 11:10:20.943331',19.2222372,72.9676254,-16.200000762939453,78.56379699707031,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 10:38:19.002000',NULL,'pending',4,2,4),(29,1,'Test akash','9794946565','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'425e9c28-59b2-4e57-a4bc-a04f69ed25f8','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 10:43:59.732996','2025-10-13 11:10:21.053673',19.2222281,72.9676007,-27.600000381469727,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 10:43:55.612000',NULL,'pending',4,2,4),(30,1,'Test akash','9494646565','male',56,166,56,20.3,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'yes','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'08d3a2cb-4223-4de0-b542-f6901d7a9bec','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 10:47:54.931436','2025-10-13 11:10:21.172954',19.222238,72.9675926,-26.700000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 10:47:50.959000',NULL,'pending',4,2,4),(31,1,'Test akash','9764646464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"Chronic Kidney Disease on dialysis\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'6bf1c052-4499-40a6-9945-f0adbb1962f8','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 10:52:36.929507','2025-10-13 11:10:21.291298',19.222253,72.9676468,-26.700000762939453,68.99840545654297,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 10:52:33.073000',NULL,'pending',4,2,4),(32,1,'Vandana undefined','6464646767','female',35,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,NULL,0,'low','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'ca8a3ee2-a526-4b22-8e4b-a6e22f625ea4',NULL,'2025-10-13 10:57:44.397109','2025-10-13 11:04:48.805449',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',2,2,8),(33,1,'Neena undefined','6464575737','female',66,186,63,18.2,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'925b0414-e682-405e-a7cc-da064cabb0c2','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-10-13 11:01:01.714989','2025-10-13 11:04:48.949526',28.5364866,77.1888465,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 11:00:55.980000',NULL,'pending',2,2,8),(34,1,'Test akash','6767674656','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Slum Dweller\",\"Homeless\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'68c75ab0-bdda-4f8d-a253-ab0abc2aa8a7','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 11:06:26.261411','2025-10-13 11:10:21.404327',19.222253,72.9676468,-26.700000762939453,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 11:06:21.957000',NULL,'pending',4,2,4),(35,1,'Himanshu Kataria','8388388383','male',32,190,90,24.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'yes','[\"Homeless\",\"Slum Dweller\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'76c13b56-b5e2-453a-b6e8-632c577473e3','{\"brand\":\"google\",\"systemName\":\"Android\",\"systemVersion\":\"13\",\"model\":\"sdk_gphone64_arm64\"}','2025-10-13 13:17:07.890757','2025-10-13 13:19:33.018466',37.4212162,-122.0828568,0,2000,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 13:17:01.665000',NULL,'pending',4,2,3),(36,1,'Shalome Shreya','8848328838','female',23,190,90,24.9,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','unknown','no',NULL,NULL,NULL,'no',NULL,'yes','[\"Health Care Worker directly involved in the patient care or dealing with the patient samples\",\"Homeless\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\"]',23,'high','','','','','','','',0.1576833417,NULL,NULL,NULL,NULL,'nagaland_v2.0',1,'5efd427c-1e5c-4b28-840d-5050fb36bc2a',NULL,'2025-10-13 13:21:35.881539','2025-10-13 13:23:18.498666',NULL,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,NULL,0.5028611,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,'non_presumptive','pending',4,2,3),(37,1,'Test abc','9764646464','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\",\"Slum Dweller\",\" Migrated to this location temporarily (less than one year) and engaged in casual/unskilled/skilled labour (NOT office/ professional job)\"]','no',NULL,'[\"On anti cancerous treatment\", \"Undergone Organ Transplantation and on medicines\", \"Bedridden\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'86ba5ee1-5255-447a-8c21-988bbc9a73cd','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 15:49:50.986183','2025-10-13 15:57:47.179028',19.2222389,72.9676046,-16.200000762939453,88.6166000366211,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,NULL,NULL,0,0,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,'2025-10-13 15:49:40.986000',NULL,'pending',4,2,4),(38,1,'Test two','9556988666','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'yes','[\"Homeless\",\"Slum Dweller\",\"Health Care Worker directly involved in the patient care or dealing with the patient samples\"]','no',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"Chronic Kidney Disease on dialysis\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'95326c54-2cfb-4327-b8b5-ec1637dc8914','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-13 15:54:43.206962','2025-10-29 12:27:51.391544',19.2222672,72.9676333,-16.200000762939453,16.79199981689453,'no',NULL,'67646464554',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-13 15:54:39.444000',NULL,'pending',4,2,4),(39,1,'Keshavani undefined','9999885555','female',31,165,53,19.5,'no',0,'yes',2,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'non_diabetic','never_had','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'a24debf2-3007-49c0-b882-47ba0628d38a','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"CPH2381\"}','2025-10-23 09:50:59.512834','2025-10-23 09:50:59.512974',17.4102913,78.6046656,414.20001220703125,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,0,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-23 09:50:18.868000',NULL,'pending',2,2,6),(40,1,'Rudra Keshav','9963255888','male',38,173,75,25.1,'no',0,'no',0,'no',0,'no',0,'yes',14,'no',0,'no',0,'no',0,'non_diabetic','never_had','negative','yes','6 months to 1 year','yes','no','no',NULL,'no','[\"Homeless\"]','no',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'5d20773e-3505-4041-b82f-eccb8ef6b113','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"CPH2381\"}','2025-10-23 09:54:39.727731','2025-10-23 09:54:39.727774',17.4100887,78.6045364,418.3000183105469,23.913999557495117,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,1,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-23 09:53:58.228000',NULL,'pending',2,2,6),(41,1,'Baburao undefined','8688281829','male',34,165,55,20.2,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','yes','3 years to 5 years',NULL,NULL,'no',NULL,'no','[\"None of the above\"]','no',NULL,NULL,0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'7f03808d-a266-4858-9f68-f57f2ba610d0','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"CPH2381\"}','2025-10-24 09:08:45.655511','2025-10-24 09:08:45.655706',17.4102712,78.6047351,414.20001220703125,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.998,0.998,0.998,0,0,NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,'2025-10-24 09:06:05.628000',NULL,'pending',2,2,6),(42,1,'Three three','9494495959','male',56,156,56,23,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','currently_infected','negative','no',NULL,NULL,NULL,'no',NULL,'yes','[\"Health Care Worker directly involved in the patient care or dealing with the patient samples\",\"Homeless\",\"Slum Dweller\"]','unknown',NULL,'[\"Undergone Organ Transplantation and on medicines\", \"Chronic Kidney Disease on dialysis\", \"On anti cancerous treatment\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'d67c0732-edcf-4d59-960c-a079d21cd9f6','{\"brand\":\"samsung\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"SM-S911B\"}','2025-10-24 12:21:01.505826','2025-10-27 05:42:37.862157',19.2221804,72.9675963,-15.5,90.66219329833984,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-10-24 12:19:35.768000',NULL,'pending',4,2,4),(43,1,'Yshdgd undefined','9684545564','female',25,163,60,22.6,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','never_had','negative','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,NULL,0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'e66f2d33-d8c3-41e5-854b-f2164e6de92e','{\"brand\":\"Redmi\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"2312DRA50I\"}','2025-11-07 10:40:35.686458','2025-11-07 10:49:08.277548',0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-07 10:40:32.062000',NULL,'pending',3,2,15),(44,1,'Test undefined','9695656655','female',25,160,60,23.4,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'yes','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'aa99bcdb-10fe-48d1-8316-61a4d5930e8f','{\"brand\":\"Redmi\",\"systemName\":\"Android\",\"systemVersion\":\"15\",\"model\":\"2312DRA50I\"}','2025-11-07 10:43:29.194608','2025-11-07 10:49:08.448257',0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-07 10:42:05.519000',NULL,'pending',3,2,15),(45,1,'Ankit undefined','6464573767','male',39,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"Homeless\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'2aaf6d2a-3abb-4bae-8ce9-8b250d8ac71d','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-11-08 06:43:00.209609','2025-11-10 09:20:39.883427',28.5519039,77.1210889,215.60000610351562,97.55380249023438,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-08 06:42:54.296000',NULL,'pending',2,2,8),(46,1,'Nitisha undefined','6464476763','female',39,169,65,22.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,NULL,0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'d4855434-1006-443d-8722-c5cab79ff847','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-11-10 06:54:37.106350','2025-11-10 09:20:40.127647',28.5365006,77.1888586,200.40000915527344,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-10 06:54:34.564000',NULL,'pending',2,2,8),(47,1,'Ktest undefined','6454376737','male',37,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'08f813e4-0f9e-480c-8c95-ee24d8db850d','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-11-10 08:38:26.460255','2025-11-10 09:20:40.288116',28.5365056,77.1888506,200.8000030517578,100,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-10 08:38:23.655000',NULL,'pending',2,2,8),(48,1,'Abhimanyu undefined','6454573767','male',63,186,65,18.8,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'2ab4bc43-785e-4dbe-94cd-d8b140247e15','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-11-10 09:12:17.769757','2025-11-10 09:20:40.446758',28.536485,77.1888451,200.40000915527344,96.2750015258789,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-10 09:12:13.814000',NULL,'pending',2,2,8),(49,1,'Raku undefined','6556665555','female',35,186,62,17.9,'no',0,'no',0,'yes',5,'no',0,'no',0,'no',0,'no',0,'no',0,'unknown','old_case','unknown','no',NULL,NULL,NULL,'no',NULL,'no','[\"None of the above\"]','unknown',NULL,'[\"None of the above\"]',0,NULL,'','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,1,'37429b7d-08cf-4ca6-87a4-7fe9dd4e56b4','{\"brand\":\"OnePlus\",\"systemName\":\"Android\",\"systemVersion\":\"14\",\"model\":\"LE2121\"}','2025-11-10 09:14:55.967617','2025-11-10 09:20:40.599566',28.5364652,77.1888492,200.40000915527344,13.612000465393066,'no',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'2025-11-10 09:14:51.543000',NULL,'pending',2,2,8);

--
-- Table structure for table `datacollectionapp_state`
--

CREATE TABLE `datacollectionapp_state` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_state`
--

INSERT INTO `datacollectionapp_state` VALUES (1,'Delhi'),(2,'Telangana');

--
-- Table structure for table `datacollectionapp_tombstone`
--

CREATE TABLE `datacollectionapp_tombstone` (
  `uuid` char(32) NOT NULL,
  `model_type` varchar(20) NOT NULL,
  `deleted_at` datetime(6) NOT NULL,
  `deleted_by_id` int DEFAULT NULL,
  PRIMARY KEY (`uuid`),
  KEY `datacollectionapp_to_deleted_by_id_de122a67_fk_auth_user` (`deleted_by_id`),
  KEY `datacollect_deleted_5ee40b_idx` (`deleted_at`),
  KEY `datacollect_model_t_86ffd1_idx` (`model_type`,`deleted_at`),
  CONSTRAINT `datacollectionapp_to_deleted_by_id_de122a67_fk_auth_user` FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datacollectionapp_tombstone`
--

INSERT INTO `datacollectionapp_tombstone` VALUES ('3c67a54cef204d0fa9d79509c1ef329e','record','2025-11-10 08:37:50.170043',NULL),('aa2ee14bcedc4090882622a3b6867954','record','2025-11-07 10:49:04.942221',NULL),('b47c1cd9dfe94a7e9b9c203b8c408b8b','household','2025-11-07 10:49:04.938861',NULL);

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (1,'2025-10-09 13:37:10.462335','1','Delhi',1,'[{\"added\": {}}]',12,1),(2,'2025-10-09 13:37:21.062771','1','Delhi',1,'[{\"added\": {}}]',10,1),(3,'2025-10-10 11:03:23.860132','3f0aa5d0-4cc7-4afe-a1cf-04bf72403fd9','Household object (3f0aa5d0-4cc7-4afe-a1cf-04bf72403fd9)',1,'[{\"added\": {}}]',11,1),(4,'2025-10-10 11:04:35.626039','1','Arm object (1)',1,'[{\"added\": {}}]',15,1),(5,'2025-10-10 13:19:58.495107','1','Arm object (1)',3,'',15,1),(6,'2025-10-10 13:26:00.625494','2','Telangana',1,'[{\"added\": {}}]',12,1),(7,'2025-10-10 13:26:22.609167','2','Pocharam',1,'[{\"added\": {}}]',10,1),(8,'2025-10-10 13:26:32.152636','3','Boduppal',1,'[{\"added\": {}}]',10,1),(9,'2025-10-10 13:26:41.494425','4','Peerzadiguda',1,'[{\"added\": {}}]',10,1),(10,'2025-10-10 13:26:52.495738','1','New Delhi',2,'[{\"changed\": {\"fields\": [\"Name\"]}}]',10,1),(11,'2025-10-10 13:40:23.391969','1','dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India',1,'[{\"added\": {}}]',17,1),(12,'2025-10-10 13:40:39.741076','1','dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India (2026-04-30 06:00:00-07:00:00)',1,'[{\"added\": {}}]',18,1),(13,'2025-10-10 13:41:23.412193','9fdb1c1b-9d3a-42fc-b4cb-dd359c99234c','Record object (9fdb1c1b-9d3a-42fc-b4cb-dd359c99234c)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,1),(14,'2025-10-10 15:40:16.193999','2','Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India',1,'[{\"added\": {}}]',17,1),(15,'2025-10-10 15:40:40.018641','2','Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India (2026-04-30 06:00:00-07:00:00)',1,'[{\"added\": {}}]',18,1),(16,'2025-10-10 15:41:45.060614','6b735ebf-f65d-440c-aae3-12048dd5f600','Record object (6b735ebf-f65d-440c-aae3-12048dd5f600)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,1),(17,'2025-10-10 15:43:45.411639','326c6dcc-dc1d-454f-a186-2f092296ed36','Record object (326c6dcc-dc1d-454f-a186-2f092296ed36)',2,'[{\"changed\": {\"fields\": [\"Result\"]}}]',14,1),(18,'2025-10-10 15:47:04.175704','30080ee0-bf77-4c07-87fa-7c0a0a367dd0','Record object (30080ee0-bf77-4c07-87fa-7c0a0a367dd0)',2,'[{\"changed\": {\"fields\": [\"Dicom\", \"Xray device\"]}}]',14,1),(19,'2025-10-10 15:47:15.913585','30080ee0-bf77-4c07-87fa-7c0a0a367dd0','Record object (30080ee0-bf77-4c07-87fa-7c0a0a367dd0)',2,'[]',14,1),(20,'2025-10-13 07:08:09.233588','1','admin',1,'[{\"added\": {}}]',3,1),(21,'2025-10-13 07:08:43.638073','2','xray_technician',1,'[{\"added\": {}}]',3,1),(22,'2025-10-13 07:09:12.013310','3','sample_collector',1,'[{\"added\": {}}]',3,1),(23,'2025-10-13 07:09:36.536564','9','admin-ai',1,'[{\"added\": {}}]',4,1),(24,'2025-10-13 07:09:41.399104','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"Groups\"]}}]',4,1),(25,'2025-10-13 07:10:10.878367','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"Staff status\"]}}]',4,1),(26,'2025-10-13 07:10:31.291287','10','xray_technician',1,'[{\"added\": {}}]',4,1),(27,'2025-10-13 07:10:37.869738','10','xray_technician',2,'[{\"changed\": {\"fields\": [\"Staff status\", \"Groups\"]}}]',4,1),(28,'2025-10-13 07:11:20.111729','11','sample_collector',1,'[{\"added\": {}}]',4,1),(29,'2025-10-13 07:11:25.261214','11','sample_collector',2,'[{\"changed\": {\"fields\": [\"Staff status\", \"Groups\"]}}]',4,1),(30,'2025-10-13 07:12:28.878066','1','dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India',3,'',17,10),(31,'2025-10-13 07:12:28.886549','2','Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India',3,'',17,10),(32,'2025-10-13 07:12:47.592868','3','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India',1,'[{\"added\": {}}]',17,10),(33,'2025-10-13 07:13:14.683382','None','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 12:00:00-18:00:00)',1,'[{\"added\": {}}]',18,10),(34,'2025-10-13 07:20:07.023576','8','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 17:00:00-18:00:00)',3,'',18,10),(35,'2025-10-13 07:20:07.031758','7','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 16:00:00-17:00:00)',3,'',18,10),(36,'2025-10-13 07:20:07.039708','6','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 15:00:00-16:00:00)',3,'',18,10),(37,'2025-10-13 07:20:07.047252','5','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 14:00:00-15:00:00)',3,'',18,10),(38,'2025-10-13 07:20:07.054692','4','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 13:00:00-14:00:00)',3,'',18,10),(39,'2025-10-13 07:20:07.061780','3','Pocharam, Ibrahimpatnam mandal, Ranga Reddy, Telangana, India (2025-10-13 12:00:00-13:00:00)',3,'',18,10),(40,'2025-10-13 07:20:36.747332','4','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India',1,'[{\"added\": {}}]',17,10),(41,'2025-10-13 07:21:05.489595','None','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-10-13 12:51:29-18:00:00)',1,'[{\"added\": {}}]',18,10),(42,'2025-10-13 08:10:53.607645','5','Jasmine Tower, Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India',1,'[{\"added\": {}}]',17,1),(43,'2025-10-13 08:11:15.457798','15','Jasmine Tower, Vasant Vihar, Thane, Thane Taluka, Thane, Maharashtra, 401302, India (2025-10-14 13:41:13-13:41:14)',1,'[{\"added\": {}}]',18,1),(44,'2025-10-13 08:13:35.804627','6be434e2-351f-41a8-833c-b3fddc5f48aa','Record object (6be434e2-351f-41a8-833c-b3fddc5f48aa)',2,'[{\"changed\": {\"fields\": [\"Dicom\", \"Xray device\"]}}]',14,1),(45,'2025-10-13 08:13:36.935172','6be434e2-351f-41a8-833c-b3fddc5f48aa','Record object (6be434e2-351f-41a8-833c-b3fddc5f48aa)',2,'[{\"changed\": {\"fields\": [\"Dicom\", \"Xray device\"]}}]',14,1),(46,'2025-10-13 09:17:15.300571','d948609e-2291-4865-807d-8edfe410e08d','Household object (d948609e-2291-4865-807d-8edfe410e08d)',3,'',11,9),(47,'2025-10-13 09:17:53.161289','97565e42-025b-492d-8fb6-920f19f91024','Household object (97565e42-025b-492d-8fb6-920f19f91024)',3,'',11,9),(48,'2025-10-13 09:20:26.179193','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"Superuser status\"]}}]',4,9),(49,'2025-10-13 09:21:48.847691','9148d96b-7524-450f-be74-daf8dca70e73','Record object (9148d96b-7524-450f-be74-daf8dca70e73)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(50,'2025-10-13 09:23:07.630737','11','sample_collector',2,'[{\"changed\": {\"fields\": [\"Superuser status\"]}}]',4,9),(51,'2025-10-13 09:23:42.360627','11','sample_collector',2,'[{\"changed\": {\"fields\": [\"Superuser status\", \"Last login\"]}}]',4,9),(52,'2025-10-13 09:24:12.733647','11','sample_collector',2,'[{\"changed\": {\"fields\": [\"User permissions\"]}}]',4,9),(53,'2025-10-13 09:35:37.253561','3','sample_collector',2,'[{\"changed\": {\"fields\": [\"Permissions\"]}}]',3,9),(54,'2025-10-13 09:37:02.528474','11','sample_collector',2,'[]',4,9),(55,'2025-10-13 09:40:14.907661','11','sample_collector',2,'[]',4,9),(56,'2025-10-13 09:41:27.888348','2','xray_technician',2,'[]',3,9),(57,'2025-10-13 09:41:35.119106','1','admin',2,'[]',3,9),(58,'2025-10-13 09:47:21.609000','8','8 Sample Collector 9999999999',1,'[{\"added\": {}}]',9,9),(59,'2025-10-13 09:47:53.926776','9','9 XRay Technician 9999999991',1,'[{\"added\": {}}]',9,9),(60,'2025-10-13 09:49:53.605501','10','xray_technician',2,'[{\"changed\": {\"fields\": [\"User permissions\"]}}]',4,9),(61,'2025-10-13 09:50:27.698530','e88cecca-8c00-499a-bc1b-32da43bada62','Record object (e88cecca-8c00-499a-bc1b-32da43bada62)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,1),(62,'2025-10-13 09:50:36.060922','2','xray_technician',2,'[{\"changed\": {\"fields\": [\"Permissions\"]}}]',3,9),(63,'2025-10-13 09:57:47.047653','a02a7914-a5fd-4ec0-be36-3353667ed7dc','Record object (a02a7914-a5fd-4ec0-be36-3353667ed7dc)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,1),(64,'2025-10-13 10:11:41.406494','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(65,'2025-10-13 10:14:17.927018','9148d96b-7524-450f-be74-daf8dca70e73','Record object (9148d96b-7524-450f-be74-daf8dca70e73)',2,'[]',14,9),(66,'2025-10-13 10:15:10.784643','7ebcfbac-9479-4e30-b543-cf89e0390122','Record object (7ebcfbac-9479-4e30-b543-cf89e0390122)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(67,'2025-10-13 10:20:32.379332','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(68,'2025-10-13 10:21:36.004610','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[]',14,9),(69,'2025-10-13 10:21:39.315826','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[]',14,9),(70,'2025-10-13 10:21:57.039122','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[]',14,9),(71,'2025-10-13 10:53:46.279527','8505830b-3bc2-4efd-b506-e8af88218683','Record object (8505830b-3bc2-4efd-b506-e8af88218683)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,11),(72,'2025-10-13 10:54:03.917746','8505830b-3bc2-4efd-b506-e8af88218683','Record object (8505830b-3bc2-4efd-b506-e8af88218683)',2,'[{\"changed\": {\"fields\": [\"Screening status\", \"Result\"]}}]',14,11),(73,'2025-10-13 10:54:33.021276','8505830b-3bc2-4efd-b506-e8af88218683','Record object (8505830b-3bc2-4efd-b506-e8af88218683)',2,'[]',14,11),(74,'2025-10-13 10:59:22.086840','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(75,'2025-10-13 11:02:31.546176','2dd48512-f1fb-40f4-b726-b8d6a52147b2','Record object (2dd48512-f1fb-40f4-b726-b8d6a52147b2)',2,'[{\"changed\": {\"fields\": [\"Screening status\", \"Result\"]}}]',14,11),(76,'2025-10-13 11:07:55.238130','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,10),(77,'2025-10-13 11:08:11.720769','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,10),(78,'2025-10-13 11:09:00.385638','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(79,'2025-10-13 11:16:11.403005','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[]',14,10),(80,'2025-10-13 11:16:15.377223','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(81,'2025-10-13 11:17:01.254290','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(82,'2025-10-13 11:17:56.784428','06430385-704d-4c93-8c45-4d5dfad9309e','Record object (06430385-704d-4c93-8c45-4d5dfad9309e)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(83,'2025-10-13 11:20:52.818577','06430385-704d-4c93-8c45-4d5dfad9309e','Record object (06430385-704d-4c93-8c45-4d5dfad9309e)',2,'[]',14,10),(84,'2025-10-13 12:06:04.110015','1','admin',2,'[{\"changed\": {\"fields\": [\"Permissions\"]}}]',3,9),(85,'2025-10-13 12:07:23.736553','1','admin',2,'[{\"changed\": {\"fields\": [\"Permissions\"]}}]',3,9),(86,'2025-10-13 12:07:43.230059','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"Superuser status\"]}}]',4,9),(87,'2025-10-13 12:08:21.527207','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"User permissions\"]}}]',4,9),(88,'2025-10-13 12:08:48.794418','9','admin-ai',2,'[{\"changed\": {\"fields\": [\"Superuser status\"]}}]',4,9),(89,'2025-10-13 12:08:57.075749','3','sample_collector',2,'[]',3,9),(90,'2025-10-13 12:09:18.948201','1','admin',2,'[]',3,9),(91,'2025-10-13 12:09:35.605568','eacffd9f-fcb5-4aa2-b897-5791962c93f5','Record object (eacffd9f-fcb5-4aa2-b897-5791962c93f5)',3,'',14,9),(92,'2025-10-13 13:18:48.052521','6','dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India',1,'[{\"added\": {}}]',17,1),(93,'2025-10-13 13:19:00.282975','16','dwarkadas park, Jaipur Municipal Corporation, Sanganer Tehsil, Jaipur, Rajasthan, India (2026-07-01 06:00:00-07:00:00)',1,'[{\"added\": {}}]',18,1),(94,'2025-10-13 15:52:10.882956','3e7f23e3-1674-4f0e-91e6-658217c56b67','Record object (3e7f23e3-1674-4f0e-91e6-658217c56b67)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(95,'2025-10-13 15:52:22.717803','3e7f23e3-1674-4f0e-91e6-658217c56b67','Record object (3e7f23e3-1674-4f0e-91e6-658217c56b67)',2,'[{\"changed\": {\"fields\": [\"Xray device\"]}}]',14,10),(96,'2025-10-13 15:57:22.283720','1465cfbd-3f8d-4408-a080-ebe7b2997e5a','Record object (1465cfbd-3f8d-4408-a080-ebe7b2997e5a)',2,'[{\"changed\": {\"fields\": [\"Result\"]}}]',14,11),(97,'2025-10-29 12:18:29.088512','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(98,'2025-10-29 12:21:24.349373','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(99,'2025-10-29 12:22:02.351079','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(100,'2025-10-29 12:27:51.396264','38','38 - Test two - 9556988666',2,'[{\"changed\": {\"fields\": [\"Nikshay id\"]}}]',13,14),(101,'2025-10-29 12:28:20.581008','e88cecca-8c00-499a-bc1b-32da43bada62','Record object (e88cecca-8c00-499a-bc1b-32da43bada62)',3,'',14,14),(102,'2025-10-29 12:35:00.328840','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Qr code\"]}}]',14,14),(103,'2025-10-29 12:41:49.535896','bcc01ae1-cb0f-48cd-ad55-56345771afbc','Record object (bcc01ae1-cb0f-48cd-ad55-56345771afbc)',2,'[{\"changed\": {\"fields\": [\"Dicom\", \"Xray device\"]}}]',14,10),(104,'2025-10-29 12:42:46.485409','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\", \"Xray device\"]}}]',14,10),(105,'2025-10-29 12:49:01.125284','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(106,'2025-10-29 12:50:49.012958','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(107,'2025-10-29 12:51:22.131682','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(108,'2025-10-30 05:13:18.257310','bcc01ae1-cb0f-48cd-ad55-56345771afbc','Record object (bcc01ae1-cb0f-48cd-ad55-56345771afbc)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(109,'2025-10-30 06:12:14.145347','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(110,'2025-10-30 06:13:10.833836','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(111,'2025-10-30 06:13:38.897351','506bc433-4d02-44e2-a2c6-e79e23c4aa82','Record object (506bc433-4d02-44e2-a2c6-e79e23c4aa82)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(112,'2025-10-30 06:20:54.564074','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(113,'2025-10-30 06:22:36.699308','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(114,'2025-10-30 06:22:53.776086','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(115,'2025-10-30 06:23:12.503900','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(116,'2025-10-30 06:23:33.282633','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(117,'2025-10-30 06:23:45.105681','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(118,'2025-10-30 06:23:55.502090','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(119,'2025-10-30 06:24:06.890696','dc581fc0-212f-4810-ac25-7cbe6a7d2df2','Record object (dc581fc0-212f-4810-ac25-7cbe6a7d2df2)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(120,'2025-11-03 05:27:44.721621','fd39037f-6c02-4642-9103-c5f3d13418eb','Record object (fd39037f-6c02-4642-9103-c5f3d13418eb)',3,'',14,9),(121,'2025-11-03 05:44:46.072824','17','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-11-03 11:14:35-12:12:36)',1,'[{\"added\": {}}]',18,9),(122,'2025-11-03 05:54:57.339865','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(123,'2025-11-03 05:55:09.237080','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Xray device\"]}}]',14,9),(124,'2025-11-03 05:57:21.010853','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Xray consent\"]}}]',14,9),(125,'2025-11-03 05:57:48.074855','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(126,'2025-11-03 05:59:09.063598','fdccac28-caf8-4b6d-877e-4ea3df34aeeb','Household object (fdccac28-caf8-4b6d-877e-4ea3df34aeeb)',3,'',11,9),(127,'2025-11-03 10:46:13.609459','6d0b9884-c464-4f42-8d69-f92945bf8788','Record object (6d0b9884-c464-4f42-8d69-f92945bf8788)',3,'',14,9),(128,'2025-11-03 10:47:02.463950','c334fdc2-b8ad-4709-8201-e8ad613af948','Record object (c334fdc2-b8ad-4709-8201-e8ad613af948)',2,'[{\"changed\": {\"fields\": [\"Enumeration status\", \"Assessment status\", \"Meetings attempted\"]}}]',14,9),(129,'2025-11-03 10:50:09.342444','14','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-10-13 16:19:57-17:19:58)',2,'[{\"changed\": {\"fields\": [\"Start time\", \"End time\"]}}]',18,9),(130,'2025-11-03 10:50:58.708290','14','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-11-03 16:19:57-17:19:58)',2,'[{\"changed\": {\"fields\": [\"Date\"]}}]',18,9),(131,'2025-11-03 10:52:44.673032','178aea36-0921-45ff-8ab5-70abd9815267','Record object (178aea36-0921-45ff-8ab5-70abd9815267)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(132,'2025-11-03 10:54:59.813053','178aea36-0921-45ff-8ab5-70abd9815267','Record object (178aea36-0921-45ff-8ab5-70abd9815267)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(133,'2025-11-03 10:55:31.869789','178aea36-0921-45ff-8ab5-70abd9815267','Record object (178aea36-0921-45ff-8ab5-70abd9815267)',2,'[{\"changed\": {\"fields\": [\"Screening status\", \"Followup attempt\", \"Qure ai results\", \"Qure ai score\", \"Qure ai system identifier\", \"Qure ai remarks\", \"Xray date and time\"]}}]',14,9),(134,'2025-11-03 16:02:06.426143','1551cf1a-0179-4c65-b2e4-8d2c03f5c800','Record object (1551cf1a-0179-4c65-b2e4-8d2c03f5c800)',3,'',14,9),(135,'2025-11-03 16:06:34.772380','40a397a5-1fe1-4155-a7cc-864d170486cc','Household object (40a397a5-1fe1-4155-a7cc-864d170486cc)',3,'',11,9),(136,'2025-11-07 08:55:19.581692','f87a76fc-5017-4811-89a1-b0516de961b1','Record object (f87a76fc-5017-4811-89a1-b0516de961b1)',2,'[{\"changed\": {\"fields\": [\"Qure ai results\", \"Qure ai score\", \"Qure ai system identifier\"]}}]',14,14),(137,'2025-11-07 09:15:19.346562','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Qure ai results\", \"Qure ai score\", \"Qure ai system identifier\"]}}]',14,14),(138,'2025-11-07 09:15:45.424747','ea55c542-a168-4f76-b83e-0ef3d7defc53','Record object (ea55c542-a168-4f76-b83e-0ef3d7defc53)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,14),(139,'2025-11-07 10:43:57.818345','13','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-11-07 16:51:29-17:51:29)',2,'[{\"changed\": {\"fields\": [\"Date\"]}}]',18,9),(140,'2025-11-07 10:44:45.685596','aa2ee14b-cedc-4090-8826-22a3b6867954','Record object (aa2ee14b-cedc-4090-8826-22a3b6867954)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(141,'2025-11-07 10:45:01.666209','aa2ee14b-cedc-4090-8826-22a3b6867954','Record object (aa2ee14b-cedc-4090-8826-22a3b6867954)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,9),(142,'2025-11-07 10:45:07.229415','aa2ee14b-cedc-4090-8826-22a3b6867954','Record object (aa2ee14b-cedc-4090-8826-22a3b6867954)',2,'[]',14,9),(143,'2025-11-07 10:47:43.272706','b47c1cd9-dfe9-4a7e-9b9c-203b8c408b8b','Household object (b47c1cd9-dfe9-4a7e-9b9c-203b8c408b8b)',3,'',11,9),(144,'2025-11-07 10:49:04.916175','b47c1cd9-dfe9-4a7e-9b9c-203b8c408b8b','Household object (b47c1cd9-dfe9-4a7e-9b9c-203b8c408b8b)',3,'',11,9),(145,'2025-11-08 06:43:43.656953','12','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-11-08 12:13:38-18:00:00)',2,'[{\"changed\": {\"fields\": [\"Date\", \"Start time\", \"End time\"]}}]',18,10),(146,'2025-11-10 06:10:31.504188','7','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India',1,'[{\"added\": {}}]',17,10),(147,'2025-11-10 06:11:26.467980','None','Qutub Institutional Area, Hauz Khas Tehsil, South Delhi, Delhi, 110016, India (2025-11-10 12:00:00-18:00:00)',1,'[{\"added\": {}}]',18,10),(148,'2025-11-10 06:50:43.020188','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(149,'2025-11-10 06:51:32.504101','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Screening status\"]}}]',14,9),(150,'2025-11-10 07:11:08.427505','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(151,'2025-11-10 07:15:38.059911','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(152,'2025-11-10 07:23:49.449251','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(153,'2025-11-10 07:28:48.306599','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(154,'2025-11-10 07:31:00.305356','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(155,'2025-11-10 08:16:34.420795','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Meetings attempted\"]}}]',14,14),(156,'2025-11-10 08:17:29.914497','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[]',14,14),(157,'2025-11-10 08:20:30.939226','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[]',14,10),(158,'2025-11-10 08:20:43.621416','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(159,'2025-11-10 08:21:03.233014','de51a695-859a-45cb-a3c0-19f89a52aca0','Record object (de51a695-859a-45cb-a3c0-19f89a52aca0)',2,'[{\"changed\": {\"fields\": [\"Dicom\"]}}]',14,10),(160,'2025-11-10 08:23:05.902777','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Meetings attempted\", \"Followup attempt\"]}}]',14,14),(161,'2025-11-10 08:26:33.456631','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[]',14,14),(162,'2025-11-10 08:28:16.427021','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Xray consent\"]}}]',14,14),(163,'2025-11-10 08:30:02.028108','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[]',14,14),(164,'2025-11-10 08:32:13.883216','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Meetings attempted\"]}}]',14,14),(165,'2025-11-10 08:33:33.340175','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',2,'[{\"changed\": {\"fields\": [\"Meetings attempted\"]}}]',14,14),(166,'2025-11-10 08:37:50.165136','3c67a54c-ef20-4d0f-a9d7-9509c1ef329e','Record object (3c67a54c-ef20-4d0f-a9d7-9509c1ef329e)',3,'',14,14),(167,'2025-11-10 08:40:13.200341','46c12750-133d-42a0-93b8-a080f3fc91e6','Record object (46c12750-133d-42a0-93b8-a080f3fc91e6)',2,'[{\"changed\": {\"fields\": [\"Screening status\", \"Followup attempt\", \"Xray consent\"]}}]',14,14),(168,'2025-11-10 09:19:54.686102','142ef840-14e4-4a46-b280-de20a669bb92','Record object (142ef840-14e4-4a46-b280-de20a669bb92)',2,'[{\"changed\": {\"fields\": [\"Result\"]}}]',14,11);

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(9,'authapp','userattributes'),(7,'authtoken','token'),(8,'authtoken','tokenproxy'),(19,'bookingapp','appointment'),(17,'bookingapp','location'),(18,'bookingapp','slot'),(5,'contenttypes','contenttype'),(15,'datacollectionapp','arm'),(10,'datacollectionapp','district'),(11,'datacollectionapp','household'),(16,'datacollectionapp','qrcode'),(14,'datacollectionapp','record'),(13,'datacollectionapp','recordingform'),(12,'datacollectionapp','state'),(20,'datacollectionapp','tombstone'),(6,'sessions','session');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2025-10-09 09:32:49.061594'),(2,'auth','0001_initial','2025-10-09 09:32:50.501403'),(3,'admin','0001_initial','2025-10-09 09:32:50.855680'),(4,'admin','0002_logentry_remove_auto_add','2025-10-09 09:32:50.874491'),(5,'admin','0003_logentry_add_action_flag_choices','2025-10-09 09:32:50.894767'),(6,'contenttypes','0002_remove_content_type_name','2025-10-09 09:32:51.107412'),(7,'auth','0002_alter_permission_name_max_length','2025-10-09 09:32:51.299299'),(8,'auth','0003_alter_user_email_max_length','2025-10-09 09:32:51.360827'),(9,'auth','0004_alter_user_username_opts','2025-10-09 09:32:51.378487'),(10,'auth','0005_alter_user_last_login_null','2025-10-09 09:32:51.545678'),(11,'auth','0006_require_contenttypes_0002','2025-10-09 09:32:51.556681'),(12,'auth','0007_alter_validators_add_error_messages','2025-10-09 09:32:51.579522'),(13,'auth','0008_alter_user_username_max_length','2025-10-09 09:32:51.732785'),(14,'auth','0009_alter_user_last_name_max_length','2025-10-09 09:32:51.887457'),(15,'auth','0010_alter_group_name_max_length','2025-10-09 09:32:51.926306'),(16,'auth','0011_update_proxy_permissions','2025-10-09 09:32:51.951296'),(17,'auth','0012_alter_user_first_name_max_length','2025-10-09 09:32:52.093520'),(18,'datacollectionapp','0001_initial','2025-10-09 09:32:54.211677'),(19,'authapp','0001_initial','2025-10-09 09:32:54.989366'),(20,'authapp','0002_userattributes_role','2025-10-09 09:32:55.261593'),(21,'authapp','0003_alter_userattributes_role','2025-10-09 09:32:55.302974'),(22,'authapp','0004_alter_userattributes_role','2025-10-09 09:32:55.329347'),(23,'authapp','0005_alter_userattributes_role','2025-10-09 09:32:55.358176'),(24,'authapp','0006_alter_userattributes_designation_and_more','2025-10-09 09:32:55.402775'),(25,'authapp','0007_alter_userattributes_role','2025-10-09 09:32:55.428321'),(26,'authtoken','0001_initial','2025-10-09 09:32:55.746508'),(27,'authtoken','0002_auto_20160226_1747','2025-10-09 09:32:55.823635'),(28,'authtoken','0003_tokenproxy','2025-10-09 09:32:55.836988'),(29,'authtoken','0004_alter_tokenproxy_options','2025-10-09 09:32:55.854710'),(30,'datacollectionapp','0002_alter_record_cough_id','2025-10-09 09:32:55.879651'),(31,'datacollectionapp','0003_alter_record_cough_id','2025-10-09 09:32:56.131577'),(32,'datacollectionapp','0004_alter_record_xray_device','2025-10-09 09:32:56.230889'),(33,'datacollectionapp','0005_record_remarks','2025-10-09 09:32:56.435191'),(34,'datacollectionapp','0006_record_sample_collection_date_and_time_and_more','2025-10-09 09:32:56.900128'),(35,'datacollectionapp','0007_alter_household_district','2025-10-09 09:32:57.464345'),(36,'datacollectionapp','0008_arm','2025-10-09 09:32:57.788827'),(37,'datacollectionapp','0009_alter_record_arm','2025-10-09 09:32:58.513314'),(38,'datacollectionapp','0010_alter_record_arm','2025-10-09 09:32:59.098835'),(39,'datacollectionapp','0011_alter_record_arm','2025-10-09 09:32:59.887289'),(40,'datacollectionapp','0012_household_complete_alter_household_district','2025-10-09 09:33:00.182098'),(41,'datacollectionapp','0013_remove_recordingform_household_record_recording_form_and_more','2025-10-09 09:33:01.073279'),(42,'datacollectionapp','0014_alter_record_followup_attempt','2025-10-09 09:33:01.331319'),(43,'datacollectionapp','0015_record_date_and_time_of_result_record_result','2025-10-09 09:33:01.977174'),(44,'datacollectionapp','0016_alter_record_result','2025-10-09 09:33:02.009103'),(45,'datacollectionapp','0017_record_assessment_status_record_quality_of_sample_and_more','2025-10-09 09:33:03.402022'),(46,'datacollectionapp','0018_alter_record_followup_attempt_and_more','2025-10-09 09:33:03.664881'),(47,'datacollectionapp','0019_record_refusal_reason_and_more','2025-10-09 09:33:04.432846'),(48,'datacollectionapp','0020_alter_household_household_status','2025-10-09 09:33:04.452060'),(49,'bookingapp','0001_initial','2025-10-09 09:33:05.591288'),(50,'bookingapp','0002_alter_slot_availability','2025-10-09 09:33:05.608845'),(51,'bookingapp','0003_add_appointment_timestamps','2025-10-09 09:33:06.108996'),(52,'datacollectionapp','0021_record_place_of_work','2025-10-09 09:33:06.388925'),(53,'datacollectionapp','0022_remove_record_place_of_work_and_more','2025-10-09 09:33:07.362293'),(54,'datacollectionapp','0023_household_created_by_record_created_by','2025-10-09 09:33:07.924097'),(55,'datacollectionapp','0024_record_signature','2025-10-09 09:33:08.197638'),(56,'datacollectionapp','0025_alter_record_signature','2025-10-09 09:33:08.243127'),(57,'datacollectionapp','0026_alter_record_signature','2025-10-09 09:33:08.419074'),(58,'datacollectionapp','0027_alter_record_signature','2025-10-09 09:33:08.485864'),(59,'datacollectionapp','0028_alter_record_signature','2025-10-09 09:33:08.517671'),(60,'datacollectionapp','0029_record_address','2025-10-09 09:33:08.742807'),(61,'datacollectionapp','0030_alter_household_identifier','2025-10-09 09:33:08.910334'),(62,'datacollectionapp','0031_remove_record_address','2025-10-09 09:33:09.182154'),(63,'datacollectionapp','0029_alter_recordingform_is_the_participant','2025-10-09 09:33:09.276065'),(64,'datacollectionapp','0032_merge_20250807_1547','2025-10-09 09:33:09.287900'),(65,'datacollectionapp','0033_alter_record_place_of_work_district','2025-10-09 09:33:09.331492'),(66,'datacollectionapp','0034_qrcode_record_qr_code','2025-10-09 09:33:09.818101'),(67,'datacollectionapp','0035_record_sample_qr_code_alter_record_qr_code','2025-10-09 09:33:10.260261'),(68,'sessions','0001_initial','2025-10-09 09:33:10.431849'),(69,'datacollectionapp','0036_alter_qrcode_qr_uuid','2025-10-29 12:01:12.883797'),(70,'datacollectionapp','0037_alter_record_followup_attempt_and_more','2025-10-29 12:01:13.536226'),(71,'datacollectionapp','0038_tombstone','2025-11-07 10:48:01.674120'),(72,'datacollectionapp','0039_alter_record_cough_id_alter_record_household','2025-11-07 10:48:01.824150'),(73,'datacollectionapp','0040_household_arm_ward','2025-11-10 12:20:12.474682');

--
-- Table structure for table `django_session`
--

CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `django_session`
--

INSERT INTO `django_session` VALUES ('0aaabod7v7zuxmtt36sph0y9w04d60cj','.eJxVjMsOwiAQRf-FtSF0eAgu3fcbCMMMUjU0Ke3K-O_apAvd3nPOfYmYtrXGrfMSJxIXMYjT74YpP7jtgO6p3WaZ57YuE8pdkQftcpyJn9fD_TuoqddvDVSCNUBMhN6y8VSs9xoHlxNy0WxzYANnrZQj4ACuMEN2XqHRKoN4fwAFnjhr:1v8GLS:2Y1nLQk3LWhGN7cPnpcrNB3g8d35Lg6dfJb5Qh8PnHQ','2025-10-27 11:04:02.183115'),('34up42x3u6m6qyrcmlt2uv1n8cvgaxhn','.eJxVjMEOwiAQRP-FsyFFdyl49N5vIAu7SNXQpLQn47_bJj3obTLvzbxVoHUpYW0yh5HVVRlQp98yUnpK3Qk_qN4nnaa6zGPUu6IP2vQwsbxuh_t3UKiVbd2jTYjCwOJNb6Gz4p1DpnxGawmAELyhnJPr2FwQnQGKOW85GU-gPl_60Tfl:1vIM94:7bOAaLkZElmDDXsDz_VhxfDrUgaGo6aS2Zjv2McINNM','2025-11-24 07:16:58.397657'),('4bz0kj8a53p7pz4qsszat6jxq8duiylz','.eJxVjMEOwiAQRP-FsyFFdyl49N5vIAu7SNXQpLQn47_bJj3obTLvzbxVoHUpYW0yh5HVVRlQp98yUnpK3Qk_qN4nnaa6zGPUu6IP2vQwsbxuh_t3UKiVbd2jTYjCwOJNb6Gz4p1DpnxGawmAELyhnJPr2FwQnQGKOW85GU-gPl_60Tfl:1vE57E:J0R1JvyMZbI4GwD381Oi0tJ6M27n7J0kXNR0wfIn550','2025-11-12 12:17:24.766619'),('4s5yt2ndbut3zdjnlswi5yz0jeqv7g6o','.eJxVjE0OwiAYBe_C2hAKLRSX7j0D-f6QqqFJaVfGu2uTLnT7Zua9VIJtLWlrsqSJ1VlFdfrdEOghdQd8h3qbNc11XSbUu6IP2vR1ZnleDvfvoEAr33p0LmYwIugHG3NE6QkwAzjrHRAatH2IPjhDIwBbJvbcmW5AtC5EUu8PCk04tA:1v8F87:0BO3LkYqhm8oTTMvrkCZXXCm_u5mQWTrbSNR2F5yZZQ','2025-10-27 09:46:11.062302'),('9mu5zqniibnmpqfdlo72p88e2vwin70b','.eJxVjEEOwiAQRe_C2hAIlQGX7j0DGZgZqRqalHbVeHdt0oVu_3vvbyrhutS0dp7TSOqirFWn3zFjeXLbCT2w3SddprbMY9a7og_a9W0ifl0P9--gYq_f2oENBQYxYIJncNGilbOHnIOR4kTYDEAkgNEHiQxeyNsIDKYgOVHvD_mOOF0:1v8Cic:2xvdqNOaKdpoZhLYAATPGNRLTXDR_uCCy5QNuTsn0EE','2025-10-27 07:11:42.608585'),('g3tmfif5qbqoq813zrinshbjtdpk8z6u','.eJxVjMsOwiAQRf-FtSF0eAgu3fcbCMMMUjU0Ke3K-O_apAvd3nPOfYmYtrXGrfMSJxIXMYjT74YpP7jtgO6p3WaZ57YuE8pdkQftcpyJn9fD_TuoqddvDVSCNUBMhN6y8VSs9xoHlxNy0WxzYANnrZQj4ACuMEN2XqHRKoN4fwAFnjhr:1v8Ccb:QSr1gyrhUpS6OT_I1I4_b45ZToD60q_uQF-WzPadIAM','2025-10-27 07:05:29.142739'),('ijidj5ezz45hdzm96jrqaadifi0rrp8u','.eJxVjDsOwjAQRO_iGlnsJv5R0ucMltdecADZUpxUiLvjSCmgmObNm3kLH7Y1-63x4uckLgLO4vQLKcQnl71Jj1DuVcZa1mUmuSvyaJucauLX9XD_DnJoua_RjdFoAMaBwNJAY2LmMUJEdNFYpB6j002RhU6QAzo2WlkHTIrE5wv6rTff:1vE5Tz:zNndc9ZbTKDs7yWLo2Rv3s7wm2GrDypkO0XEmU0m7PA','2025-11-12 12:40:55.971790'),('jd4jces2xvhec7cdodqq6vo7x2eymh6q','.eJxVjMEOwiAQRP-FsyFFdyl49N5vIAu7SNXQpLQn47_bJj3obTLvzbxVoHUpYW0yh5HVVRlQp98yUnpK3Qk_qN4nnaa6zGPUu6IP2vQwsbxuh_t3UKiVbd2jTYjCwOJNb6Gz4p1DpnxGawmAELyhnJPr2FwQnQGKOW85GU-gPl_60Tfl:1vFn6Z:juNwKOzf6l4Znzv2fgmDB3ad6Muzrjf4Myevs7VcY2Y','2025-11-17 05:27:47.918951'),('liymd81rqt09kktsbk51ieqebc6f5a46','.eJxVjDsOwjAQRO_iGlnsJv5R0ucMltdecADZUpxUiLvjSCmgmObNm3kLH7Y1-63x4uckLgLO4vQLKcQnl71Jj1DuVcZa1mUmuSvyaJucauLX9XD_DnJoua_RjdFoAMaBwNJAY2LmMUJEdNFYpB6j002RhU6QAzo2WlkHTIrE5wv6rTff:1v8GVC:TfYKMrW8eq8iqZ9dfO36GLrwX5Q1ipI6lssd0r6VfpA','2025-10-27 11:14:06.532225'),('mr3699oux0ps3q5rsuy7fhwne6quzkfb','.eJxVjMEOwiAQRP-FsyFFdyl49N5vIAu7SNXQpLQn47_bJj3obTLvzbxVoHUpYW0yh5HVVRlQp98yUnpK3Qk_qN4nnaa6zGPUu6IP2vQwsbxuh_t3UKiVbd2jTYjCwOJNb6Gz4p1DpnxGawmAELyhnJPr2FwQnQGKOW85GU-gPl_60Tfl:1vIN3o:DDXi-HQfqzfNtSlADhrDDBFm_c76IRZtD_P9D5XcJZI','2025-11-24 08:15:36.402029'),('qe4z50pohhzvgnm3ryice4vktzt20y2b','.eJxVjEEOwiAQRe_C2hAIlQGX7j0DGZgZqRqalHbVeHdt0oVu_3vvbyrhutS0dp7TSOqirFWn3zFjeXLbCT2w3SddprbMY9a7og_a9W0ifl0P9--gYq_f2oENBQYxYIJncNGilbOHnIOR4kTYDEAkgNEHiQxeyNsIDKYgOVHvD_mOOF0:1vIO3D:5WvV5zzkfkfXn9AhSoZZp0PTkYC_mHEkWaufZdwJdUs','2025-11-24 09:19:03.591733'),('tp9sq6ibl7tj4vnqul9ubkbvkmvgux71','.eJxVjMsOwiAQRf-FtSF0eAgu3fcbCMMMUjU0Ke3K-O_apAvd3nPOfYmYtrXGrfMSJxIXMYjT74YpP7jtgO6p3WaZ57YuE8pdkQftcpyJn9fD_TuoqddvDVSCNUBMhN6y8VSs9xoHlxNy0WxzYANnrZQj4ACuMEN2XqHRKoN4fwAFnjhr:1v8EwN:gtqgp6HxFxN3GFqnHsLGgvDVNShEddVXyzo7uvykBxc','2025-10-27 09:34:03.522776'),('ykh53utd48226gi652og6m5hfez2ncwy','.eJxVjEEOwiAQRe_C2hAIlQGX7j0DGZgZqRqalHbVeHdt0oVu_3vvbyrhutS0dp7TSOqirFWn3zFjeXLbCT2w3SddprbMY9a7og_a9W0ifl0P9--gYq_f2oENBQYxYIJncNGilbOHnIOR4kTYDEAkgNEHiQxeyNsIDKYgOVHvD_mOOF0:1v8KtL:KYPrFBv3jFnyF9_tz9jdTfwOSMj6UaBKzusz64GG8TE','2025-10-27 15:55:19.953745'),('zm3hwhcbf7p5dd3hmcc0elk9fttnr9ji','.eJxVjE0OwiAYBe_C2hAKLRSX7j0D-f6QqqFJaVfGu2uTLnT7Zua9VIJtLWlrsqSJ1VlFdfrdEOghdQd8h3qbNc11XSbUu6IP2vR1ZnleDvfvoEAr33p0LmYwIugHG3NE6QkwAzjrHRAatH2IPjhDIwBbJvbcmW5AtC5EUu8PCk04tA:1vHK1P:bmhhgE2rXlR1uE2ZEY-SiiGUdtTu63SIP0orwO3ckuM','2025-11-21 10:48:47.707816');


