-- MySQL dump 10.13  Distrib 8.0.38, for Win64 (x86_64)
--
-- Host: 192.168.45.64    Database: db_iemr
-- ------------------------------------------------------
-- Server version	8.0.34

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `form_fields`
--

DROP TABLE IF EXISTS `form_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `form_fields` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `form_id` varchar(100) NOT NULL,
  `section_title` varchar(255) DEFAULT NULL,
  `field_id` varchar(100) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `is_required` tinyint(1) DEFAULT NULL,
  `default_value` varchar(255) DEFAULT NULL,
  `placeholder` varchar(255) DEFAULT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `conditional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `sequence` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_visible` tinyint(1) DEFAULT '0',
  `is_editable` tinyint(1) DEFAULT '1',
  `state_code` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_form` (`form_id`),
  CONSTRAINT `fk_form` FOREIGN KEY (`form_id`) REFERENCES `form_master` (`form_id`) ON DELETE CASCADE,
  CONSTRAINT `form_fields_chk_1` CHECK (json_valid(`options`)),
  CONSTRAINT `form_fields_chk_2` CHECK (json_valid(`validation`)),
  CONSTRAINT `form_fields_chk_3` CHECK (json_valid(`conditional`))
) ENGINE=InnoDB AUTO_INCREMENT=514 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `form_fields`
--

LOCK TABLES `form_fields` WRITE;
/*!40000 ALTER TABLE `form_fields` DISABLE KEYS */;
INSERT INTO `form_fields` VALUES (1,'hbnc_form_001','HBNC Visit Details','visit_day','HBNC Visit Day','dropdown',1,'1st Day',NULL,'[\"1st Day\",\"3rd Day\",\"7th Day\",\"14th Day\",\"21st Day\",\"28th Day\",\"42nd Day\"]','{\"incremental\":true}',NULL,1,'2025-07-10 15:38:18',NULL,1,0),(2,'hbnc_form_001','HBNC Visit Details','due_date','HBNC Due Date','date',0,NULL,'HBNC Due Date',NULL,NULL,NULL,2,'2025-07-10 15:38:18',NULL,1,0),(3,'hbnc_form_001','HBNC Visit Details','visit_date','Visit Date','date',1,NULL,'Select visit date',NULL,'{\"minDate\":\"dob\",\"maxDate\":\"today\",\"afterField\":\"due_date\"}',NULL,3,'2025-07-10 15:38:19',NULL,1,0),(4,'hbnc_form_001','HBNC Visit Details','is_baby_alive','Is the Baby alive?','radio',1,'Yes',NULL,'[\"Yes\",\"No\"]',NULL,NULL,4,'2025-07-10 15:38:19',NULL,1,0),(5,'hbnc_form_001','HBNC Visit Details','date_of_death','Date of Death','date',1,NULL,'Select date of death',NULL,'{\"minDate\":\"dob\",\"maxDate\":\"today\"}','{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"No\"}',5,'2025-07-10 15:38:19',NULL,1,0),(6,'hbnc_form_001','HBNC Visit Details','reason_for_death','Reason for Death','dropdown',1,NULL,NULL,'[\n  \"Fever\",\n  \"Measles\",\n  \"Diarrhoea\",\n  \"Pneumonia\",\n  \"Sepsis\",\n  \"Asphyxia\",\n  \"Complications of Prematurity\",\n  \"Accident\",\n  \"Infectious Disease\",\n  \"Animal Bite Death\"\n]','{\"maxLength\":200,\"regex\":\"^[a-zA-Z0-9 ,.-]{5,200}$\",\"errorMessage\":\"Only letters, numbers, spaces, and ,.- are allowed\"}','{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"No\"}',6,'2025-07-10 15:38:19',NULL,1,0),(7,'hbnc_form_001','HBNC Visit Details','place_of_death','Place of Death','dropdown',1,NULL,NULL,'[\"Home\",\"Subcenter\",\"PHC\",\"CHC\",\"District Hospital\",\"Any other place\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"No\"}',7,'2025-07-10 15:38:19',NULL,1,0),(8,'hbnc_form_001','HBNC Visit Details','other_place_of_death','Other Place of Death','text',1,NULL,'Specify other place of death',NULL,'{\"maxLength\":100,\"regex\":\"^[a-zA-Z0-9 ,.-]{3,100}$\",\"errorMessage\":\"Only letters, numbers, spaces, and ,.- are allowed\"}','{\"dependsOn\":\"place_of_death\",\"expectedValue\":\"Any other place\"}',8,'2025-07-10 15:38:19',NULL,1,0),(9,'hbnc_form_001','HBNC Visit Details','baby_weight','Baby Weight (Gram)','number',1,NULL,'Enter weight in gram (e.g. 1000)',NULL,'{\"min\":100,\"max\":5000}','{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',9,'2025-07-10 15:38:19',NULL,1,0),(10,'hbnc_form_001','HBNC Visit Details','urine_passed','Urine Passed','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',10,'2025-07-10 15:38:19',NULL,1,0),(11,'hbnc_form_001','HBNC Visit Details','stool_passed','Stool Passed','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',11,'2025-07-10 15:38:19',NULL,1,0),(12,'hbnc_form_001','HBNC Visit Details','diarrhoea','Diarrhoea','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',12,'2025-07-10 15:38:19',NULL,1,0),(13,'hbnc_form_001','HBNC Visit Details','vomiting','Vomiting','radio',0,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',13,'2025-07-10 15:38:19',NULL,1,0),(14,'hbnc_form_001','HBNC Visit Details','convulsions','Convulsions','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',14,'2025-07-10 15:38:19',NULL,1,0),(15,'hbnc_form_001','HBNC Visit Details','activity','Activity','radio',0,'Good',NULL,'[\"Good\",\"Lethargic\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',15,'2025-07-10 15:38:19',NULL,1,0),(16,'hbnc_form_001','HBNC Visit Details','sucking','Sucking','radio',0,'Good',NULL,'[\"Good\",\"Poor\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',16,'2025-07-10 15:38:19',NULL,1,0),(17,'hbnc_form_001','HBNC Visit Details','breathing','Breathing','radio',0,'Fast',NULL,'[\"Fast\",\"Difficult\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',17,'2025-07-10 15:38:20',NULL,1,0),(18,'hbnc_form_001','HBNC Visit Details','chest_indrawing','Chest Indrawing','radio',0,'Absent',NULL,'[\"Present\",\"Absent\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',18,'2025-07-10 15:38:20',NULL,1,0),(19,'hbnc_form_001','HBNC Visit Details','temperature','Temperature (Fahrenheit)','number',1,NULL,'e.g. 98.6',NULL,'{\"min\":97.7,\"max\":99.5,\"errorMessage\":\"Enter valid temperature like 98.6\",\"decimalPlaces\": 1}','{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',19,'2025-07-10 15:38:20',NULL,1,0),(20,'hbnc_form_001','HBNC Visit Details','jaundice','Jaundice','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',20,'2025-07-10 15:38:20',NULL,1,0),(21,'hbnc_form_001','HBNC Visit Details','umbilical_stump','Condition of Umbilical Stump','dropdown',0,'Drying and Color Change',NULL,'[\"Drying and Color Change\",\"Falling Off\",\"Appears Infected with redness\",\"Swelling\",\"Foul-smelling discharge\",\"Tenderness\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',21,'2025-07-10 15:38:20',NULL,1,0),(22,'hbnc_form_001','HBNC Visit Details','discharged_from_sncu','Is Baby discharge from SNCU?','radio',1,NULL,NULL,'[\"Yes\",\"No\"]',NULL,'{\"dependsOn\":\"is_baby_alive\",\"expectedValue\":\"Yes\"}',22,'2025-07-10 15:38:20',NULL,1,0),(23,'hbnc_form_001','HBNC Visit Details','discharge_summary_upload','Discharge Summary','image',0,NULL,'Upload image (Max 5MB)',NULL,'{\"maxSizeMB\":5}','{\"dependsOn\":\"discharged_from_sncu\",\"expectedValue\":\"Yes\"}',23,'2025-07-10 15:38:20',NULL,1,5),(24,'hbnc_form_001','HBNC Visit Details','discharge_summary_view','Discharge Summary (View)','image',0,NULL,'View uploaded image',NULL,'{\"maxSizeMB\":5}','{\"dependsOn\":\"discharged_from_sncu\",\"expectedValue\":\"Yes\"}',24,'2025-07-10 15:38:20',NULL,1,5),(194,'hbyc_form_001','HBYC Visit Details','visit_day','HBYC Visit','dropdown',1,'1st Day','','[\"1st Day\",\"3rd Day\",\"7th Day\",\"14th Day\",\"21st Day\",\"28th Day\",\"42nd Day\"]','{}','{}',1,'2025-10-08 04:42:45',1,1,0),(195,'hbyc_form_001','HBYC Visit Details','due_date','HBYC Due Date','date',0,'','HBYC Due Date','[]','{}','{}',2,'2025-10-08 04:42:45',1,1,0),(196,'hbyc_form_001','HBYC Visit Details','visit_date','Visit Date','date',1,'','Select visit date','[]','{\"maxDate\": \"today\", \"minDate\": \"dob\", \"afterField\": \"due_date\"}','{}',3,'2025-10-08 04:42:45',1,1,0),(197,'hbyc_form_001','HBYC Visit Details','is_baby_alive','Is the Baby alive?','radio',1,'Yes','','[\"Yes\",\"No\"]','{}','{}',4,'2025-10-08 04:42:45',1,1,0),(198,'hbyc_form_001','HBYC Visit Details','date_of_death','Date of Death','date',1,'','Select date of death','[]','{\"maxDate\": \"today\", \"minDate\": \"dob\"}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"No\"}',5,'2025-10-08 04:42:45',1,1,0),(199,'hbyc_form_001','HBYC Visit Details','reason_for_death','Reason for Death','dropdown',1,'',NULL,'[\n  \"Fever\",\n  \"Measles\",\n  \"Diarrhoea\",\n  \"Pneumonia\",\n  \"Sepsis\",\n  \"Asphyxia\",\n  \"Complications of Prematurity\",\n  \"Accident\",\n  \"Infectious Disease\",\n  \"Animal Bite Death\"\n]','{\"regex\": \"^[a-zA-Z0-9 ,.-]{5,200}$\", \"maxLength\": 200, \"errorMessage\": \"Only letters, numbers, spaces, and ,.- are allowed\"}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"No\"}',6,'2025-10-08 04:42:45',1,1,0),(200,'hbyc_form_001','HBYC Visit Details','place_of_death','Place of Death','dropdown',1,'','','[\"Home\",\"Subcenter\",\"PHC\",\"CHC\",\"District Hospital\",\"Any other place\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"No\"}',7,'2025-10-08 04:42:45',1,1,0),(201,'hbyc_form_001','HBYC Visit Details','other_place_of_death','Other Place of Death','text',1,'','Specify other place of death','[]','{\"regex\": \"^[a-zA-Z0-9 ,.-]{3,100}$\", \"maxLength\": 100, \"errorMessage\": \"Only letters, numbers, spaces, and ,.- are allowed\"}','{\"dependsOn\": \"place_of_death\", \"expectedValue\": \"Any other place\"}',8,'2025-10-08 04:42:45',1,1,0),(202,'hbyc_form_001','HBYC Visit Details','baby_weight','Baby Weight (Gram)','number',1,'','Enter weight in gram (e.g. 1000)','[]','{\"min\":100,\"max\":5000}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',9,'2025-10-08 04:42:45',1,1,0),(346,'hbyc_form_001','HBYC Visit Details','is_child_sick','Is the child sick?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',10,'2025-10-08 09:23:01',1,1,0),(347,'hbyc_form_001','HBYC Visit Details','exclusive_breastfeeding','Is the child exclusively breast feeding?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',11,'2025-10-08 09:23:01',1,1,0),(348,'hbyc_form_001','HBYC Visit Details','mother_counseled_ebf','Is the mother counseled for exclusive breast feeding?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',12,'2025-10-08 09:23:01',1,1,0),(349,'hbyc_form_001','HBYC Visit Details','complementary_feeding','Has the child started complementary feeding?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',13,'2025-10-08 09:23:01',1,1,0),(350,'hbyc_form_001','HBYC Visit Details','mother_counseled_cf','Is the mother counseled for complementary feeding?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',14,'2025-10-08 09:23:01',1,1,0),(351,'hbyc_form_001','HBYC Visit Details','weight_recorded','Is the Weight of the child recorded by AWW?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',15,'2025-10-08 09:23:01',1,1,0),(352,'hbyc_form_001','HBYC Visit Details','developmental_delay','Is there any developmental delay?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',16,'2025-10-08 09:23:01',1,1,0),(353,'hbyc_form_001','HBYC Visit Details','measles_vaccine','Is Measles Vaccine given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',17,'2025-10-08 09:23:01',1,1,0),(354,'hbyc_form_001','HBYC Visit Details','vitamin_a','Is Vitamin A given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',18,'2025-10-08 09:23:01',1,1,0),(355,'hbyc_form_001','HBYC Visit Details','ors_available','Is ORS available at home?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',19,'2025-10-08 09:23:01',1,1,0),(356,'hbyc_form_001','HBYC Visit Details','ifa_available','Is IFA syrup available at home?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',20,'2025-10-08 09:23:01',1,1,0),(357,'hbyc_form_001','HBYC Visit Details','ors_given','Is ORS given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',21,'2025-10-08 09:23:01',1,1,0),(358,'hbyc_form_001','HBYC Visit Details','ifa_given','Is IFA syrup given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',22,'2025-10-08 09:23:01',1,1,0),(359,'hbyc_form_001','HBYC Visit Details','handwash_counseling','Is counseling for handwashing given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',23,'2025-10-08 09:23:01',1,1,0),(360,'hbyc_form_001','HBYC Visit Details','parenting_counseling','Is counseling for parenting given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',24,'2025-10-08 09:23:01',1,1,0),(361,'hbyc_form_001','HBYC Visit Details','family_planning_counseling','Is counseling for family planning given?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',25,'2025-10-08 09:23:01',1,1,0),(362,'hbyc_form_001','HBYC Visit Details','diarrhoea_episode','Diarrhoea episode in the last two weeks','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',26,'2025-10-08 09:23:01',1,1,0),(363,'hbyc_form_001','HBYC Visit Details','breathing_difficulty','Any episode of cough, breathlessness or difficulty in breathing?','radio',1,'','','[\"Yes\", \"No\"]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',27,'2025-10-08 09:23:01',1,1,0),(364,'hbyc_form_001','HBYC Visit Details','temperature_check','Temperature (deg F)','number',1,'','Enter temperature (e.g. 98.6)','[]','{\"min\":97.7,\"max\":99.5,\"errorMessage\":\"Enter valid temperature like 98.6\",\"decimalPlaces\": 1}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',28,'2025-10-08 09:23:01',1,1,0),(365,'hbyc_form_001','HBYC Visit Details','mcp_upload','MCP Card: Child care page/section','image',0,'','Upload up to 2 images','[]','{\"maxImages\": 2, \"maxSizeMB\": 5}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',29,'2025-10-08 09:23:01',1,1,5),(366,'hbyc_form_001','HBYC Visit Details','mcp_view','MCP Card (View)','image',0,'','View uploaded image','[]','{}','{\"dependsOn\": \"is_baby_alive\", \"expectedValue\": \"Yes\"}',30,'2025-10-08 09:23:01',1,1,5),(413,'sam_visit_001','SAM Visit Details','visit_date','Visit Date','date',1,NULL,'Choose visit date',NULL,'{\"required\":true,\"format\":\"dd-MM-yyyy\",\"maxDate\":\"today\",\"errorMessage\":\"Visit Date cannot be future date\"}','{\"dependsOn\":null}',1,'2025-10-13 06:42:07',1,1,0),(414,'sam_visit_001','SAM Visit Details','visit_label','Visit','readonly',0,'Visit-1',NULL,NULL,'{}','{\"autoIncrement\":true}',2,'2025-10-13 06:42:07',1,1,0),(415,'sam_visit_001','SAM Visit Details','muac','MUAC (Mid-upper Arm Circumference)','number',1,NULL,'Enter MUAC in cm',NULL,'{\"regex\":\"^[0-9]{1,2}(\\\\.[0-9])?$\",\"min\":0.0,\"max\":30.0,\"errorMessage\":\"Enter valid MUAC between 0.0 - 30.0\"}','{\"alertIfLessOrEqual\":11.5,\"alertMessage\":\"Please refer the Child to NRC as SAM case\"}',3,'2025-10-13 06:42:07',1,1,0),(416,'sam_visit_001','SAM Visit Details','weight_for_height_status','Weight-for-Height Status','dropdown',1,NULL,'Select status','{\"options\":[\"Normal\",\"Moderate\",\"SAM\"]}','{\"required\":true}','{\"alertIf\":\"SAM\",\"alertMessage\":\"Please refer the Child to NRC as SAM case\"}',4,'2025-10-13 06:42:07',1,1,0),(417,'sam_visit_001','SAM Visit Details','is_child_referred_nrc','Is Child referred to NRC?','radio',1,'No',NULL,'{\"options\":[\"Yes\",\"No\"]}','{\"required\":true}','{\"dependsOnAny\":[{\"field\":\"muac\",\"operator\":\"<=\",\"value\":11.5},{\"field\":\"weight_for_height_status\",\"value\":\"SAM\"}]}',5,'2025-10-13 06:42:07',1,1,0),(418,'sam_visit_001','SAM Visit Details','is_child_admitted_nrc','Is Child Admitted in NRC?','radio',0,NULL,NULL,'{\"options\":[\"Yes\",\"No\"]}','{}','{\"dependsOn\":\"is_child_referred_nrc\",\"expectedValue\":\"Yes\"}',6,'2025-10-13 06:42:07',1,1,0),(419,'sam_visit_001','SAM Visit Details','nrc_admission_date','NRC Admission Date','date',0,NULL,'Select NRC Admission Date',NULL,'{\"format\":\"dd-MM-yyyy\",\"maxDate\":\"today\"}','{\"dependsOn\":\"is_child_admitted_nrc\",\"expectedValue\":\"Yes\"}',7,'2025-10-13 06:42:07',1,1,0),(420,'sam_visit_001','SAM Visit Details','is_child_discharged_nrc','Is Child discharged from NRC?','radio',0,NULL,NULL,'{\"options\":[\"Yes\",\"No\"]}','{}','{\"dependsOn\":\"is_child_admitted_nrc\",\"expectedValue\":\"Yes\"}',8,'2025-10-13 06:42:07',1,1,0),(421,'sam_visit_001','SAM Visit Details','nrc_discharge_date','NRC Discharge Date','date',0,NULL,'Select discharge date',NULL,'{\"format\":\"dd-MM-yyyy\",\"maxDate\":\"today\"}','{\"dependsOn\":\"is_child_discharged_nrc\",\"expectedValue\":\"Yes\"}',9,'2025-10-13 06:42:07',1,1,0),(422,'sam_visit_001','SAM Visit Details','follow_up_visit_date','Follow-up Visit Date','date',0,NULL,'Select follow-up visit date',NULL,'{\"format\":\"dd-MM-yyyy\",\"maxDate\":\"today\"}','{\"dependsOn\":\"is_child_discharged_nrc\",\"expectedValue\":\"Yes\"}',10,'2025-10-13 06:42:07',1,1,0),(423,'sam_visit_001','SAM Visit Details','sam_status','Follow-up Visit Outcome (SAM Status)','dropdown',0,NULL,'Select outcome','{\"options\":[\"Improved\",\"No Change\",\"Relapse\"]}','{}','{\"dependsOn\":\"is_child_discharged_nrc\",\"expectedValue\":\"Yes\"}',11,'2025-10-13 06:42:07',1,1,0),(424,'sam_visit_001','SAM Visit Details','discharge_summary','Discharge Summary or MCP Card','image',0,NULL,NULL,'{\"maxFiles\":4,\"fileTypes\":[\"image/jpeg\",\"image/png\",\"pdf\"]}','{}','{\"dependsOn\":\"is_child_discharged_nrc\",\"expectedValue\":\"Yes\"}',12,'2025-10-13 06:42:07',1,1,5),(425,'sam_visit_001','SAM Visit Details','view_discharge_docs','Discharge Summary or MCP Card (View)','view_image',0,NULL,NULL,NULL,'{}','{\"dependsOn\":\"discharge_summary\",\"expectedValue\":\"uploaded\"}',13,'2025-10-13 06:42:07',1,1,0),(429,'ors_distribution_form','ORS Distribution','visit_date','Visit Date','date',1,NULL,NULL,'{}','{\"format\":\"dd-mm-yyyy\",\"future_date_not_allowed\":true}',NULL,1,'2025-10-14 11:29:51',1,1,0),(430,'ors_distribution_form','ORS Distribution','num_under5_children','Number of Under-5 Children','number',1,NULL,'Enter number of under-5 children','{}','{\"min\":0,\"max\":10,\"warning_if_zero\":\"ORS distribution requires at least 1 child under age 5.\"}',NULL,3,'2025-10-14 11:29:51',1,1,0),(431,'ors_distribution_form','ORS Distribution','num_ors_packets','Number of ORS Packets Distributed','number',1,NULL,'Enter number of ORS packets','{}','{\"min\":0,\"max_formula\":\"num_under5_children*2\",\"error_if_exceed\":\"ORS packets cannot exceed twice the number of U-5 children.\"}',NULL,4,'2025-10-14 11:29:51',1,1,0),(432,'ors_form_001','ORS Distribution','visit_date','Visit Date','date',1,NULL,NULL,'{}','{\"format\":\"dd-mm-yyyy\",\"future_date_not_allowed\":true}',NULL,1,'2025-10-14 11:31:47',1,1,0),(433,'ors_form_001','ORS Distribution','num_under5_children','Number of Under-5 Children','number',1,NULL,'Enter number of under-5 children','{}','{\"min\":0,\"max\":10,\"warning_if_zero\":\"ORS distribution requires at least 1 child under age 5.\"}',NULL,3,'2025-10-14 11:31:47',1,1,0),(434,'ors_form_001','ORS Distribution','num_ors_packets','Number of ORS Packets Distributed','number',1,NULL,'Enter number of ORS packets','{}','{\"min\":0,\"max_formula\":\"num_under5_children*2\",\"error_if_exceed\":\"ORS packets cannot exceed twice the number of U-5 children.\"}',NULL,4,'2025-10-14 11:31:47',1,1,0),(435,'ifa_form_001','IFA Bottle Distribution Recording','ifa_provision_date','Date of provision of IFA Bottle','date',1,NULL,'Select date (dd-mm-yyyy)',NULL,'{\"format\":\"dd-MM-yyyy\",\"notFutureDate\":true,\"oneMonthApart\":true,\"noSameMonth\":true,\"errorMessage\":\"Date cannot be in future or within same month of previous entry\"}',NULL,1,'2025-10-23 06:48:10',1,1,0),(436,'ifa_form_001','IFA Bottle Distribution Recording','mcp_card_upload','MCP Card Upload','image',0,NULL,'Upload MCP Card (IFA Section)',NULL,'{\"maxFiles\":1,\"maxSizeMB\":5,\"allowUpdate\":true,\"errorMessage\":\"Only 1 image upto 5MB is allowed\"}',NULL,2,'2025-10-23 06:48:10',1,1,5),(439,'eye_checkup_form_001','Eye Screening Details','visit_date','Visit Date','date',0,NULL,'Select visit date',NULL,'{\"maxDate\":\"today\"}',NULL,1,'2025-10-28 09:30:52',1,1,0),(440,'eye_checkup_form_001','Eye Screening Details','symptoms_observed','Symptoms Observed','dropdown',0,NULL,NULL,'[\"Blurred Vision\",\"Difficulty Seeing at Night\",\"Sensitivity to Light\",\"White/Gray Spot in Eye\",\"Other\"]','{\"maxSelection\":5}',NULL,2,'2025-10-28 09:30:52',1,1,0),(441,'eye_checkup_form_001','Eye Screening Details','eye_affected','Eye Affected','radio',1,NULL,NULL,'[\"Left\",\"Right\",\"Both\"]',NULL,NULL,3,'2025-10-28 09:30:52',1,1,0),(442,'eye_checkup_form_001','Eye Screening Details','referred_to','Referred To','dropdown',0,NULL,'Select refer to','[\"Public Facility\",\"Private Facility\"]','{\"maxLength\":150,\"regex\":\"^[a-zA-Z0-9 ,.()-]{3,150}$\"}',NULL,4,'2025-10-28 09:30:52',1,1,0),(443,'eye_checkup_form_001','Eye Screening Details','follow_up_status','Follow-up Status','dropdown',1,NULL,'Select status','[\"Surgery Done\",\"Awaiting Surgery\",\"Declined Surgery\"]',NULL,NULL,5,'2025-10-28 09:30:52',1,1,0),(444,'eye_checkup_form_001','Eye Screening Details','date_of_surgery','Date of Surgery','date',0,NULL,'Select surgery date',NULL,'{\"maxDate\":\"today\"}',NULL,6,'2025-10-28 09:30:53',1,1,0),(445,'eye_checkup_form_001','Eye Screening Details','discharge_summary_upload','File Upload (Discharge Summary)','image',0,NULL,'Upload discharge summary',NULL,'{\"allowedTypes\":[\"pdf\",\"jpg\",\"png\"],\"errorMessage\":\"Only PDF, JPG, PNG allowed\"}','{\"dependsOn\":\"follow_up_status\",\"expectedValue\":\"Surgery Done\"}',7,'2025-10-28 09:30:53',1,1,5),(446,'ifa_form_001','IFA Bottle Distribution Recording','ifa_bottle_count','IFA Bottle Count','number',1,NULL,'',NULL,'{\"maxValue\":100, \"minValue\":1, \"errorMessage\":\"Enter valid bottle count (1–100)\"}',NULL,1,'2025-10-28 11:04:43',1,1,0),(447,'ifa_distribution_form','IFA Supplement Distribution','visit_date','Visit Date','date',1,NULL,'',NULL,'{\"maxDate\":\"today\"}',NULL,1,'2025-11-03 11:52:24',1,1,0),(448,'ifa_distribution_form','IFA Supplement Distribution','ifa_provided','Has the woman been provided with iron supplements?','radio',1,NULL,'','{\"options\":[\"Yes\",\"No\"]}',NULL,NULL,2,'2025-11-03 11:52:24',1,1,0),(449,'ifa_distribution_form','IFA Supplement Distribution','ifa_quantity','Issued Quantity of IFA Supplement','number',0,NULL,'',NULL,'{\"min\":10,\"max\":180}','{\"dependsOn\":\"ifa_provided\",\"expectedValue\":\"YES\"}',3,'2025-11-03 11:52:24',1,1,0),(451,'mda_distribution_form','MDA Distribution Details','mda_distribution_date','MDA Distribution Date','date',1,NULL,'Select distribution date',NULL,'{\"maxDate\":\"today\",\"frequency\":\"monthly\"}',NULL,1,'2025-11-05 12:05:56',1,1,0),(452,'mda_distribution_form','MDA Distribution Details','is_medicine_distributed','Is Medicine Distributed','dropdown',1,NULL,'Select option','[\"Yes\",\"No\"]',NULL,NULL,2,'2025-11-05 12:06:22',1,1,0),(454,'mosquito_net_distribution_form','Mosquito Net Distribution','visit_date','Visit Date','date',1,NULL,'Select visit date',NULL,'{\"maxDate\":\"today\"}',NULL,2,'2025-11-07 14:25:01',0,1,0),(455,'mosquito_net_distribution_form','Mosquito Net Distribution','is_net_distributed','Is Mosquito Net Distributed?','radio',1,NULL,NULL,'[\"Yes\",\"No\"]',NULL,NULL,3,'2025-11-07 14:25:01',0,1,0),(468,'anc_form_001','Antenatal Counselling and Care','home_visit_date','Date of Home Visit','date',1,NULL,'Select visit date',NULL,'{\n \"format\":\"dd-mm-yyyy\",\n \"minWeeksFromLMP\":5,\n \"minWeeksFromLastVisit\":4,\n \"afterField\":\"last_visit_date\",\n \"maxDate\":\"today\",\n \"maxWeeksFromLMP\":42\n}',NULL,1,'2025-12-18 15:32:53',1,1,0),(469,'anc_form_001','Antenatal Counselling and Care','visit_number','Visit','readonly',0,'Visit-1',NULL,NULL,'{\"autoIncrement\":true,\"min\":1,\"max\":9}','{\"autoIncrement\":true}',2,'2025-12-18 15:32:53',1,1,0),(471,'anc_form_001','Antenatal Counselling and Care','swelling','Swelling on face or hands/feet','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,4,'2025-12-18 15:32:53',1,1,0),(472,'anc_form_001','Antenatal Counselling and Care','high_bp','High blood pressure','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,5,'2025-12-18 15:32:53',1,1,0),(473,'anc_form_001','Antenatal Counselling and Care','convulsions','Convulsions (fits)','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,6,'2025-12-18 15:32:53',1,1,0),(474,'anc_form_001','Antenatal Counselling and Care','anemia','Anemia (lack of blood)','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,7,'2025-12-18 15:32:53',1,1,0),(475,'anc_form_001','Antenatal Counselling and Care','reduced_fetal_movement','Reduced or no fetal movements felt','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,8,'2025-12-18 15:32:53',1,1,0),(476,'anc_form_001','Antenatal Counselling and Care','age_risk','Mother age <18 or >35','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"autoFrom\":\"mother_age\",\"oneTime\":true}',NULL,9,'2025-12-18 15:32:53',1,1,0),(477,'anc_form_001','Antenatal Counselling and Care','child_gap','Less than 3 years gap between children','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,10,'2025-12-18 15:32:53',1,1,0),(478,'anc_form_001','Antenatal Counselling and Care','short_height','Height less than 4 feet 10 inches','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,11,'2025-12-18 15:32:53',1,1,0),(479,'anc_form_001','Antenatal Counselling and Care','pre_preg_weight','Pre-pregnancy weight <40kg or >60kg','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,12,'2025-12-18 15:32:53',1,1,0),(480,'anc_form_001','Antenatal Counselling and Care','bleeding','Bleeding (Hemorrhage)','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,13,'2025-12-18 15:32:53',1,1,0),(481,'anc_form_001','Antenatal Counselling and Care','miscarriage_history','Previous history of miscarriage or stillbirth','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,14,'2025-12-18 15:32:53',1,1,0),(482,'anc_form_001','Antenatal Counselling and Care','four_plus_delivery','Woman with four or more previous deliveries','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,15,'2025-12-18 15:32:53',1,1,0),(483,'anc_form_001','Antenatal Counselling and Care','first_delivery','Woman having first delivery','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,16,'2025-12-18 15:32:53',1,1,0),(484,'anc_form_001','Antenatal Counselling and Care','twin_pregnancy','Twin pregnancy','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"persist\":true,\"editable\":true}',NULL,17,'2025-12-18 15:32:53',1,1,0),(485,'anc_form_001','Antenatal Counselling and Care','c_section_history','Previous delivery by operation (C-section)','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,18,'2025-12-18 15:32:53',1,1,0),(486,'anc_form_001','Antenatal Counselling and Care','pre_existing_disease','Pre-existing diseases (Diabetes / TB)','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,19,'2025-12-18 15:32:53',1,1,0),(487,'anc_form_001','Antenatal Counselling and Care','fever_malaria','Fever or Malaria','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,20,'2025-12-18 15:32:53',1,1,0),(488,'anc_form_001','Antenatal Counselling and Care','jaundice','Jaundice','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,21,'2025-12-18 15:32:53',1,1,0),(489,'anc_form_001','Antenatal Counselling and Care','sickle_cell','Sickle Cell Anemia','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"persist\":true,\"editable\":true}',NULL,22,'2025-12-18 15:32:53',1,1,0),(490,'anc_form_001','Antenatal Counselling and Care','prolonged_labor','Prolonged labor (>12 hours)','radio',1,'No',NULL,'[\"Yes\",\"No\"]','{\"oneTime\":true}',NULL,23,'2025-12-18 15:32:53',1,1,0),(491,'anc_form_001','Antenatal Counselling and Care','malpresentation','Malpresentation of baby','radio',1,'No',NULL,'[\"Yes\",\"No\"]',NULL,NULL,24,'2025-12-18 15:32:53',1,1,0),(493,'CDTF_001','Visit Details','visit_label','Visit','readonly',0,'Visit-1',NULL,NULL,NULL,NULL,1,'2026-01-05 06:50:26',1,1,0),(494,'CDTF_001','Diagnosis','diagnosis','Diagnosis','multicheckbox',1,NULL,'Select Diagnosis','[\"Hypertension (BP)\",\"Diabetes (DM)\",\"Cancer\"]',NULL,NULL,2,'2026-01-05 06:50:26',1,1,0),(495,'CDTF_001','Treatment Details','treatment_start_date','Treatment Start Date','date',1,NULL,'Select Date',NULL,'{\"maxDate\":\"today\"}',NULL,3,'2026-01-05 06:50:26',1,1,0),(496,'CDTF_001','Follow-up Details','follow_up_date','Follow-up Date','date',1,NULL,'Select Date',NULL,'{\"maxDate\":\"today\"}',NULL,4,'2026-01-05 06:50:26',1,1,0),(497,'CDTF_001','MCP Card','mcp_card','MCP Card (Child Care Page)','image',0,NULL,'Upload Image',NULL,'{\"maxSizeMB\":5}',NULL,5,'2026-01-05 06:50:26',1,1,5),(498,'pulse_polio_campaign_form','Campaign Details','start_date','Start Date','date',1,NULL,NULL,NULL,'{\r       \"frequency\": \"6_months\",\r       \"allowYearly\": 2,\r       \"futureMonthLimit\": 2,\r\"pastMonthLimit\": 1\r     }',NULL,1,'2026-01-13 17:02:49',1,1,0),(499,'ors_campaign_form','Campaign Details','start_date','Start Date','date',1,NULL,NULL,NULL,'{\n      \"frequency\": \"monthly_once\",\n      \"futureMonthLimit\": 2,\n      \"pastMonthLimit\": 1\n    }',NULL,1,'2026-01-13 17:09:21',1,1,0),(500,'ors_campaign_form','Campaign Details','end_date','End Date','date',1,NULL,NULL,NULL,'{\n      \"greaterThan\": \"start_date\",\n      \"futureMonthFromStart\": 1,\n      \"autoCalculate\": true,\n      \"editable\": true\n    }',NULL,2,'2026-01-13 17:09:21',1,1,0),(501,'ors_campaign_form','Campaign Data','number_of_families','Number of Families','number',1,NULL,'Enter number of families',NULL,'{\n      \"min\": 0,\n      \"max\": 999,\n      \"numericOnly\": true\n    }',NULL,3,'2026-01-13 17:09:21',1,1,0),(502,'ors_campaign_form','Campaign Data','campaign_photos','Campaign Photos','image',0,NULL,NULL,NULL,'{\n      \"maxFiles\": 2,\n      \"fileType\": \"image\",\n      \"replaceOld\": true\n    }',NULL,4,'2026-01-13 17:09:21',1,1,0),(504,'pulse_polio_campaign_form','Campaign Details','end_date','End Date','date',1,NULL,NULL,NULL,'{\n      \"greaterThan\": \"start_date\",\n      \"futureMonthFromStart\": 1\n    }',NULL,2,'2026-01-13 17:11:36',1,1,0),(505,'pulse_polio_campaign_form','Vaccination Details','children_vaccinated','Number of Children Vaccinated','number',1,NULL,NULL,NULL,'{\n      \"min\": 0,\n      \"max\": 999,\n      \"numericOnly\": true\n    }',NULL,3,'2026-01-13 17:11:36',1,1,0),(506,'pulse_polio_campaign_form','Vaccination Details','campaign_photos','Pulse Polio Campaign Photos','image',0,NULL,NULL,NULL,'{\n      \"maxFiles\": 2,\n      \"fileType\": \"image\",\n      \"replaceOld\": true\n    }',NULL,4,'2026-01-13 17:11:36',1,1,0),(509,'LF_MDA_CAMPAIGN','Campaign Details','start_date','Start Date','date',1,NULL,NULL,NULL,'{\"future_months\":2,\"past_months\":1,\"frequency\":\"YEARLY\"}',NULL,1,'2026-01-14 15:38:57',0,1,0),(510,'LF_MDA_CAMPAIGN','Campaign Details','end_date','End Date','date',1,NULL,NULL,NULL,'{\"greater_than\":\"start_date\",\"future_months_from_start\":1}',NULL,2,'2026-01-14 15:38:57',0,1,0),(511,'LF_MDA_CAMPAIGN','Coverage','no_of_families','Number of Families','number',0,NULL,NULL,NULL,'{\"min\":0,\"max\":999,\"numeric_only\":true}',NULL,3,'2026-01-14 15:38:57',0,1,0),(512,'LF_MDA_CAMPAIGN','Coverage','no_of_individuals','Number of Individuals','number',0,NULL,NULL,NULL,'{\"min\":0,\"max\":999,\"numeric_only\":true}',NULL,4,'2026-01-14 15:38:57',0,1,0),(513,'LF_MDA_CAMPAIGN','Photos','mda_photos','MDA Campaign Photos','image',0,NULL,NULL,'{\"max_files\":2}','{\"allowed_types\":[\"jpg\",\"png\"],\"update_latest\":true}',NULL,5,'2026-01-14 15:38:57',0,1,5);
/*!40000 ALTER TABLE `form_fields` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-23 17:34:40
