/*
SQLyog Community
MySQL - 8.0.43-0ubuntu0.24.04.1 : Database - sraservices_production
*********************************************************************
*/



/*Table structure for table `T_HUTOWNERINFODETAILS` */

CREATE TABLE `T_HUTOWNERINFODETAILS` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `login_id` int DEFAULT NULL,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTOWNERNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_general_ci,
  `PropertyType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FLOORNUM` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTLENGTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTWIDTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Area` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Jodpatra` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `submission_status` tinyint DEFAULT '0',
  `application_status` tinyint DEFAULT '0',
  `resubmit_status` tinyint DEFAULT '0',
  `hut_survey_status` tinyint DEFAULT '3',
  `save_status` tinyint DEFAULT '0',
  `added_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `activations` */

CREATE TABLE `activations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activations_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `activity_log` */

CREATE TABLE `activity_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` int DEFAULT NULL,
  `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` int DEFAULT NULL,
  `causer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `properties` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adani_electricity_data` */

CREATE TABLE `adani_electricity_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adani_electricity_data_draft` */

CREATE TABLE `adani_electricity_data_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `adani_electricity_data_history` */

CREATE TABLE `adani_electricity_data_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adhar_api_details` */

CREATE TABLE `adhar_api_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `var_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `var_value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `certificate1` longtext COLLATE utf8mb4_general_ci,
  `certificate2` longtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `adhar_details` */

CREATE TABLE `adhar_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_address` text COLLATE utf8mb4_unicode_ci,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adhar_details_history` */

CREATE TABLE `adhar_details_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_address` text COLLATE utf8mb4_unicode_ci,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adhar_document` */

CREATE TABLE `adhar_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` text COLLATE utf8mb4_unicode_ci,
  `dob_mr` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `address_mr` text COLLATE utf8mb4_unicode_ci,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_adhar_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=393 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adhar_document_draft` */

CREATE TABLE `adhar_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dob_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_adhar_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `adhar_document_history` */

CREATE TABLE `adhar_document_history` (
  `id` int NOT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` text COLLATE utf8mb4_unicode_ci,
  `dob_mr` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `address_mr` text COLLATE utf8mb4_unicode_ci,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_adhar_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `adhar_document_reject` */

CREATE TABLE `adhar_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` text COLLATE utf8mb4_unicode_ci,
  `dob_mr` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `address_mr` text COLLATE utf8mb4_unicode_ci,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_adhar_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `agreement_details` */

CREATE TABLE `agreement_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seller_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=835 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `agreement_details_draft` */

CREATE TABLE `agreement_details_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seller_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `agreement_details_history` */

CREATE TABLE `agreement_details_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seller_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=821 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `agreement_document` */

CREATE TABLE `agreement_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date` text COLLATE utf8mb4_unicode_ci,
  `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci,
  `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_agreement_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `agreement_document_draft` */

CREATE TABLE `agreement_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `seller_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `seller_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_agreement_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `agreement_document_history` */

CREATE TABLE `agreement_document_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date` text COLLATE utf8mb4_unicode_ci,
  `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci,
  `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_agreement_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `agreement_document_reject` */

CREATE TABLE `agreement_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date` text COLLATE utf8mb4_unicode_ci,
  `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci,
  `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_agreement_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `assign_application_photopass` */

CREATE TABLE `assign_application_photopass` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `assign_application` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `bar_chart_draft_count` */

CREATE TABLE `bar_chart_draft_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_clusters_count` int DEFAULT NULL,
  `pending_clusters_count` int DEFAULT NULL,
  `completed_clusters_count` int DEFAULT NULL,
  `inprogress_clusters_count` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `bar_chart_final_count` */

CREATE TABLE `bar_chart_final_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_clusters_final_count` int DEFAULT NULL,
  `pending_clusters_final_count` int DEFAULT NULL,
  `completed_clusters_final_count` int DEFAULT NULL,
  `inprogress_clusters_final_count` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `bar_doughnut_chart_draft_count` */

CREATE TABLE `bar_doughnut_chart_draft_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_clusters` int DEFAULT NULL,
  `completed_clusters` int DEFAULT NULL,
  `pending_clusters` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `bar_doughnut_chart_draft_count_all` */

CREATE TABLE `bar_doughnut_chart_draft_count_all` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_clusters` int DEFAULT NULL,
  `completed_clusters` int DEFAULT NULL,
  `pending_clusters` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `bar_doughnut_chart_final_count` */

CREATE TABLE `bar_doughnut_chart_final_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_clusters` int DEFAULT NULL,
  `completed_clusters` int DEFAULT NULL,
  `pending_clusters` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `bar_doughnut_chart_final_count_all` */

CREATE TABLE `bar_doughnut_chart_final_count_all` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_clusters` int DEFAULT NULL,
  `completed_clusters` int DEFAULT NULL,
  `pending_clusters` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `bar_pie_chart_draft_count` */

CREATE TABLE `bar_pie_chart_draft_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_count_draft` int DEFAULT NULL,
  `eligible_count` int DEFAULT NULL,
  `eligible_percentage` decimal(10,2) DEFAULT NULL,
  `not_eligible_count` int DEFAULT NULL,
  `not_eligible_percentage` decimal(10,2) DEFAULT NULL,
  `undeciede_count` int DEFAULT NULL,
  `undeciede_percentage` decimal(10,2) DEFAULT NULL,
  `eligible_charge_count` int DEFAULT NULL,
  `eligible_charge_percentage` decimal(10,2) DEFAULT NULL,
  `reject_count` int DEFAULT NULL,
  `reject_percentage` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `bar_pie_chart_final_count` */

CREATE TABLE `bar_pie_chart_final_count` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_count_final` int DEFAULT NULL,
  `eligible_hut_id_count` int DEFAULT NULL,
  `eligible_hut_id_count_percentage` decimal(11,2) DEFAULT NULL,
  `not_eligible_hut_id_count` int DEFAULT NULL,
  `not_eligible_hut_id_count_percentage` decimal(10,2) DEFAULT NULL,
  `undeciede_count` int DEFAULT NULL,
  `undeciede_percentage` decimal(10,2) DEFAULT NULL,
  `eligible_charge_count` int DEFAULT NULL,
  `eligible_charge_percentage` decimal(10,2) DEFAULT NULL,
  `reject_hut_id_count` int DEFAULT NULL,
  `reject_hut_id_count_percentage` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `downloaded_draft_reports` */

CREATE TABLE `downloaded_draft_reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `downloaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `downloaded_final_annexure_reports` */

CREATE TABLE `downloaded_final_annexure_reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `downloaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `downloaded_supplementary_report` */

CREATE TABLE `downloaded_supplementary_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `downloaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `election_details` */

CREATE TABLE `election_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` int DEFAULT NULL,
  `elector_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `housing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `file_upload` text COLLATE utf8mb4_unicode_ci,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `election_details_history` */

CREATE TABLE `election_details_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` int DEFAULT NULL,
  `elector_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `housing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `file_upload` text COLLATE utf8mb4_unicode_ci,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `election_document` */

CREATE TABLE `election_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_image` longblob,
  `upload_date` datetime DEFAULT NULL,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_mr` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_election_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

insert  into `electricity_document`(`id`,`elector_name`,`elector_name_mr`,`ca_number`,`ca_number_mr`,`bill_date`,`bill_date_mr`,`hut_id`,`elector_address`,`elector_address_mr`,`category`,`category_mr`,`doc_type`,`doc_type_mr`,`bill_image`,`year`,`upload_date`,`service_provider`,`service_provider_mr`,`updated_at`,`status`,`user_id`,`status_manual`,`created_at`,`updated_by`,`final_status`) values 
(1,'REENA SWAPNIL GAMRE',NULL,'151985032',NULL,'2022-08-27',NULL,'PN_26900001','KARANDE CHAWL SHIVAJI CHOWK JAKERUA ROAD, NR BHARAT GAS, MALAD WEST, MUMBAI 400064',NULL,'RESIDENTIAL',NULL,NULL,NULL,'/9j/4AAQSkZJRgABAgEAlgCWAAD//gAtSW50ZWwoUikgSlBFRyBMafjXEB/wAgiT/v4Kd2Ihb45JG6FtIkbP8A00FLc/HiO2GW0SRvpOP8KE9bDsQTfH6EpldFlH/bYVlap8d5opNh0okH/prVcvvco0rnN+I/ihqOv6NInkJbwrLjaDnpXJf8JLeetY63ZjWbi1bsf//Z','2023','2023-06-07 06:05:06',NULL,NULL,NULL,1,1,1,'2024-07-31 11:37:57',NULL,0);

/*Table structure for table `election_document_draft` */

CREATE TABLE `election_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `voter_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_image` longblob,
  `upload_date` datetime DEFAULT NULL,
  `year` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_mr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sr_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_election_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `election_document_history` */

CREATE TABLE `election_document_history` (
  `id` int NOT NULL,
  `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_image` longblob,
  `upload_date` datetime DEFAULT NULL,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_mr` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_election_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `election_document_reject` */

CREATE TABLE `election_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_image` longblob,
  `upload_date` datetime DEFAULT NULL,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_mr` longtext COLLATE utf8mb4_unicode_ci,
  `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_election_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `election_integration` */

CREATE TABLE `election_integration` (
  `integration_id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_mr` int DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`integration_id`),
  KEY `IX_election_integration_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `election_integration_draft` */

CREATE TABLE `election_integration_draft` (
  `integration_id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year` int DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_mr` int DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`integration_id`),
  KEY `IX_election_integration_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `election_integration_history` */

CREATE TABLE `election_integration_history` (
  `integration_id` int NOT NULL DEFAULT '0',
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_mr` int DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`integration_id`),
  KEY `IX_election_integration_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `electricity_document` */

CREATE TABLE `electricity_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_address` text COLLATE utf8mb4_unicode_ci,
  `elector_address_mr` text COLLATE utf8mb4_unicode_ci,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_image` longblob,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_date` datetime DEFAULT NULL,
  `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_electricity_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=460 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `electricity_document_draft` */

CREATE TABLE `electricity_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `elector_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `elector_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_image` longblob,
  `year` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_date` datetime DEFAULT NULL,
  `service_provider` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_provider_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_electricity_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=263 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `electricity_document_history` */

CREATE TABLE `electricity_document_history` (
  `id` int NOT NULL,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_address` text COLLATE utf8mb4_unicode_ci,
  `elector_address_mr` text COLLATE utf8mb4_unicode_ci,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_image` longblob,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_date` datetime DEFAULT NULL,
  `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_electricity_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `electricity_document_reject` */

CREATE TABLE `electricity_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `elector_address` text COLLATE utf8mb4_unicode_ci,
  `elector_address_mr` text COLLATE utf8mb4_unicode_ci,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_image` longblob,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_date` datetime DEFAULT NULL,
  `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_electricity_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `entity_media` */

CREATE TABLE `entity_media` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `media_id` int unsigned NOT NULL,
  `entity_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_id` bigint unsigned NOT NULL,
  `zone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entity_media_entity_type_entity_id_index` (`entity_type`,`entity_id`),
  KEY `entity_media_media_id_index` (`media_id`),
  KEY `entity_media_zone_index` (`zone`),
  CONSTRAINT `entity_media_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `file_extensions` */

CREATE TABLE `file_extensions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assign_toall` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `files` */

CREATE TABLE `files` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `folder_id` int unsigned NOT NULL DEFAULT '0',
  `filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `download` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `files_user_id_index` (`user_id`),
  KEY `files_filename_index` (`filename`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `final_annexure_details` */

CREATE TABLE `final_annexure_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_no_of_huts` int DEFAULT NULL,
  `completed_status` int DEFAULT '0',
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `folders` */

CREATE TABLE `folders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int unsigned DEFAULT NULL,
  `assign_toall` tinyint(1) NOT NULL DEFAULT '0',
  `public_download` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `folders_slug_unique` (`slug`),
  KEY `folders_parent_id_foreign` (`parent_id`),
  CONSTRAINT `folders_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `front_page` */

CREATE TABLE `front_page` (
  `id` int NOT NULL AUTO_INCREMENT,
  `welcome_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `welcome_content` longtext COLLATE utf8mb4_unicode_ci,
  `sub_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyright` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `genrate_report` */

CREATE TABLE `genrate_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `genration_date` timestamp NULL DEFAULT NULL,
  `scheme_name` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `gumasta_details` */

CREATE TABLE `gumasta_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_exp_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_file` longblob,
  `nature_of_business` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `gumasta_details_draft` */

CREATE TABLE `gumasta_details_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_issue_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_exp_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organisation_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_file` longblob,
  `nature_of_business` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `gumasta_details_history` */

CREATE TABLE `gumasta_details_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License_exp_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_file` longblob,
  `nature_of_business` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `gumasta_document` */

CREATE TABLE `gumasta_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name` text COLLATE utf8mb4_unicode_ci,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_gumasta_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `gumasta_document_draft` */

CREATE TABLE `gumasta_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_upto` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_gumasta_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `gumasta_document_history` */

CREATE TABLE `gumasta_document_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name` text COLLATE utf8mb4_unicode_ci,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_gumasta_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `gumasta_document_reject` */

CREATE TABLE `gumasta_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name` text COLLATE utf8mb4_unicode_ci,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` longblob,
  `upload_date` datetime DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_gumasta_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `head_office_members` */

CREATE TABLE `head_office_members` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `officer_image` longblob,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `hutlist_inprogress_status` */

CREATE TABLE `hutlist_inprogress_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci NOT NULL,
  `in_progress_status` tinyint DEFAULT '0',
  `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_hut_user` (`hut_id`,`user_id`),
  KEY `IX_sims_master_hut_ids` (`hut_id`),
  KEY `IX_sims_master_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1819 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `jodpatra` */

CREATE TABLE `jodpatra` (
  `id` int NOT NULL AUTO_INCREMENT,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `self_image` longblob,
  `declaration_image` longblob,
  `jodpatra_image` longblob,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `jodpatra_reject` */

CREATE TABLE `jodpatra_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `self_image` longblob,
  `declaration_image` longblob,
  `jodpatra_image` longblob,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `jurisdictions_details` */

CREATE TABLE `jurisdictions_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ca_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ca_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jurisdictions` longtext COLLATE utf8mb4_unicode_ci,
  `cluster_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `media` */

CREATE TABLE `media` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_user_id_index` (`user_id`),
  KEY `media_filename_index` (`filename`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `message` */

CREATE TABLE `message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `login_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `read_status` tinyint DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `migrations` */

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `missing_document` */

CREATE TABLE `missing_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=728 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `missing_election_details` */

CREATE TABLE `missing_election_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `property_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `missing_electricity_details` */

CREATE TABLE `missing_electricity_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `mseb_electricity_data` */

CREATE TABLE `mseb_electricity_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `mseb_electricity_data_draft` */

CREATE TABLE `mseb_electricity_data_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `mseb_electricity_data_history` */

CREATE TABLE `mseb_electricity_data_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `new_owner_name` */

CREATE TABLE `new_owner_name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `voter_name_marathi` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hutment_dweller_to_scheme` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `thumb_impression` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `other_document` */

CREATE TABLE `other_document` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` longblob,
  `upload_date` date DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  KEY `id` (`id`),
  KEY `IX_other_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `other_document_draft` */

CREATE TABLE `other_document_draft` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` longblob,
  `upload_date` date DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  KEY `id` (`id`),
  KEY `IX_other_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `other_document_history` */

CREATE TABLE `other_document_history` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` longblob,
  `upload_date` date DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  KEY `id` (`id`),
  KEY `IX_other_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `other_document_reject` */

CREATE TABLE `other_document_reject` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` longblob,
  `upload_date` date DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  KEY `id` (`id`),
  KEY `IX_other_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `persistences` */

CREATE TABLE `persistences` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `persistences_code_unique` (`code`),
  KEY `persistences_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `photopass_document` */

CREATE TABLE `photopass_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_org_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `validity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photopass_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `upload_date` datetime NOT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`,`upload_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_abhay_yojana` */

CREATE TABLE `recommendation_abhay_yojana` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `overall_remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `overall_remark_mr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `final_annexure_recommendation_status` int DEFAULT NULL,
  `user` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_adhar` */

CREATE TABLE `recommendation_adhar` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_uid` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_dob` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_uid_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_uid` text COLLATE utf8mb4_unicode_ci,
  `final_uid_mr` text COLLATE utf8mb4_unicode_ci,
  `final_aadharname` text COLLATE utf8mb4_unicode_ci,
  `final_aadharname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_aadhardate` text COLLATE utf8mb4_unicode_ci,
  `final_aadhardate_mr` text COLLATE utf8mb4_unicode_ci,
  `final_address` text COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=472 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_adhar_draft` */

CREATE TABLE `recommendation_adhar_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_uid` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_dob` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `remark_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_uid_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_uid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_uid_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_aadharname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_aadharname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_aadhardate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_aadhardate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_adhar_history` */

CREATE TABLE `recommendation_adhar_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_uid` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_dob` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `remark_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_uid_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_dob_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_uid` text COLLATE utf8mb4_unicode_ci,
  `final_uid_mr` text COLLATE utf8mb4_unicode_ci,
  `final_aadharname` text COLLATE utf8mb4_unicode_ci,
  `final_aadharname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_aadhardate` text COLLATE utf8mb4_unicode_ci,
  `final_aadhardate_mr` text COLLATE utf8mb4_unicode_ci,
  `final_address` text COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_agreement` */

CREATE TABLE `recommendation_agreement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_srno` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_aggrement_date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_seller_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_purchaser_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_relationship` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_srno` text COLLATE utf8mb4_unicode_ci,
  `remark_srno_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_type` text COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date` text COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_seller_name` text COLLATE utf8mb4_unicode_ci,
  `remark_seller_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name` text COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_relationship` text COLLATE utf8mb4_unicode_ci,
  `remark_relationship_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_srno` text COLLATE utf8mb4_unicode_ci,
  `final_srno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_type` text COLLATE utf8mb4_unicode_ci,
  `final_type_mr` text COLLATE utf8mb4_unicode_ci,
  `final_date` text COLLATE utf8mb4_unicode_ci,
  `final_date_mr` text COLLATE utf8mb4_unicode_ci,
  `final_sname` text COLLATE utf8mb4_unicode_ci,
  `final_sname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_pname` text COLLATE utf8mb4_unicode_ci,
  `final_pname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_rname` text COLLATE utf8mb4_unicode_ci,
  `final_rname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1050 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_agreement_draft` */

CREATE TABLE `recommendation_agreement_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_srno` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_aggrement_date` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_seller_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_purchaser_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_relationship` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_srno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_srno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_seller_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_seller_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_relationship` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_relationship_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_srno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_srno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_sname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_sname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_pname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_pname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_rname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_rname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_agreement_history` */

CREATE TABLE `recommendation_agreement_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `eligibility_srno` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_aggrement_date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_seller_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_purchaser_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_relationship` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_srno` text COLLATE utf8mb4_unicode_ci,
  `remark_srno_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_type` text COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date` text COLLATE utf8mb4_unicode_ci,
  `remark_aggrement_date_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_seller_name` text COLLATE utf8mb4_unicode_ci,
  `remark_seller_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name` text COLLATE utf8mb4_unicode_ci,
  `remark_purchaser_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_relationship` text COLLATE utf8mb4_unicode_ci,
  `remark_relationship_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_srno` text COLLATE utf8mb4_unicode_ci,
  `final_srno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_type` text COLLATE utf8mb4_unicode_ci,
  `final_type_mr` text COLLATE utf8mb4_unicode_ci,
  `final_date` text COLLATE utf8mb4_unicode_ci,
  `final_date_mr` text COLLATE utf8mb4_unicode_ci,
  `final_sname` text COLLATE utf8mb4_unicode_ci,
  `final_sname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_pname` text COLLATE utf8mb4_unicode_ci,
  `final_pname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_rname` text COLLATE utf8mb4_unicode_ci,
  `final_rname_mr` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_election` */

CREATE TABLE `recommendation_election` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_number` tinyint DEFAULT '0',
  `eligibility_type` tinyint DEFAULT '0',
  `eligibility_const_no` tinyint DEFAULT '0',
  `eligibility_sr_no` tinyint DEFAULT '0',
  `eligibility_part_no` tinyint DEFAULT '0',
  `remark_name` text COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_number` text COLLATE utf8mb4_unicode_ci,
  `remark_number_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_type` text COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_const_no` text COLLATE utf8mb4_unicode_ci,
  `remark_const_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_sr_no` text COLLATE utf8mb4_unicode_ci,
  `remark_sr_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_part_no` text COLLATE utf8mb4_unicode_ci,
  `remark_part_no_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_electorname` text COLLATE utf8mb4_unicode_ci,
  `final_electorname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electoraddress` text COLLATE utf8mb4_unicode_ci,
  `final_electoraddress_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electornumber` text COLLATE utf8mb4_unicode_ci,
  `final_electornumber_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electortype` text COLLATE utf8mb4_unicode_ci,
  `final_electortype_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute` text COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no` text COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no` text COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_election_draft` */

CREATE TABLE `recommendation_election_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_number` tinyint DEFAULT '0',
  `eligibility_type` tinyint DEFAULT '0',
  `eligibility_const_no` tinyint DEFAULT '0',
  `eligibility_sr_no` tinyint DEFAULT '0',
  `eligibility_part_no` tinyint DEFAULT '0',
  `remark_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_number_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_const_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_const_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_sr_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_sr_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_part_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_part_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT NULL,
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_electorname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electoraddress` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electoraddress_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electornumber` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electornumber_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electortype` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electortype_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_election_history` */

CREATE TABLE `recommendation_election_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_number` tinyint DEFAULT '0',
  `eligibility_type` tinyint DEFAULT '0',
  `eligibility_const_no` tinyint DEFAULT '0',
  `eligibility_sr_no` tinyint DEFAULT '0',
  `eligibility_part_no` tinyint DEFAULT '0',
  `remark_name` text COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_number` text COLLATE utf8mb4_unicode_ci,
  `remark_number_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_type` text COLLATE utf8mb4_unicode_ci,
  `remark_type_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_const_no` text COLLATE utf8mb4_unicode_ci,
  `remark_const_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_sr_no` text COLLATE utf8mb4_unicode_ci,
  `remark_sr_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_part_no` text COLLATE utf8mb4_unicode_ci,
  `remark_part_no_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_electorname` text COLLATE utf8mb4_unicode_ci,
  `final_electorname_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electoraddress` text COLLATE utf8mb4_unicode_ci,
  `final_electoraddress_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electornumber` text COLLATE utf8mb4_unicode_ci,
  `final_electornumber_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electortype` text COLLATE utf8mb4_unicode_ci,
  `final_electortype_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute` text COLLATE utf8mb4_unicode_ci,
  `final_electorconstitute_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no` text COLLATE utf8mb4_unicode_ci,
  `final_electorsr_no_mr` text COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no` text COLLATE utf8mb4_unicode_ci,
  `final_electorpart_no_mr` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_electricity` */

CREATE TABLE `recommendation_electricity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` text COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_category` text COLLATE utf8mb4_unicode_ci,
  `remark_category_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider` text COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_ca` text COLLATE utf8mb4_unicode_ci,
  `remark_ca_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_billdate` text COLLATE utf8mb4_unicode_ci,
  `remark_billdate_mr` text COLLATE utf8mb4_unicode_ci,
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_category` tinyint DEFAULT '0',
  `eligibility_serviceprovider` tinyint DEFAULT '0',
  `eligibility_ca` tinyint DEFAULT '0',
  `eligibility_billdate` tinyint DEFAULT '0',
  `overall_remark` longtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` longtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_electricity_draft` */

CREATE TABLE `recommendation_electricity_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_category_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_ca` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_ca_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_billdate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_billdate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_category` tinyint DEFAULT '0',
  `eligibility_serviceprovider` tinyint DEFAULT '0',
  `eligibility_ca` tinyint DEFAULT '0',
  `eligibility_billdate` tinyint DEFAULT '0',
  `overall_remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `final_highest_percentage_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_electricity_history` */

CREATE TABLE `recommendation_electricity_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name` text COLLATE utf8mb4_unicode_ci,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_category` text COLLATE utf8mb4_unicode_ci,
  `remark_category_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider` text COLLATE utf8mb4_unicode_ci,
  `remark_serviceprovider_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_ca` text COLLATE utf8mb4_unicode_ci,
  `remark_ca_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_billdate` text COLLATE utf8mb4_unicode_ci,
  `remark_billdate_mr` text COLLATE utf8mb4_unicode_ci,
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_category` tinyint DEFAULT '0',
  `eligibility_serviceprovider` tinyint DEFAULT '0',
  `eligibility_ca` tinyint DEFAULT '0',
  `eligibility_billdate` tinyint DEFAULT '0',
  `overall_remark` longtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` longtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_category_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_service_provider_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_ca_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_bill_date_mr` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_gumasta` */

CREATE TABLE `recommendation_gumasta` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT '0',
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_licanse_name` tinyint DEFAULT '0',
  `eligibility_licanse_issue_date` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_owner_org_name` tinyint DEFAULT '0',
  `eligibility_validity` tinyint DEFAULT '0',
  `remark_licanse_name` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_name` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_validity` text COLLATE utf8mb4_unicode_ci,
  `remark_validity_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_highest_percentage_licno` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_licno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_gumasta_draft` */

CREATE TABLE `recommendation_gumasta_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT '0',
  `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_licanse_name` tinyint DEFAULT '0',
  `eligibility_licanse_issue_date` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_owner_org_name` tinyint DEFAULT '0',
  `eligibility_validity` tinyint DEFAULT '0',
  `remark_licanse_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_licanse_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_owner_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_validity` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_validity_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_highest_percentage_licno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_licno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_gumasta_history` */

CREATE TABLE `recommendation_gumasta_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT '0',
  `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_licanse_name` tinyint DEFAULT '0',
  `eligibility_licanse_issue_date` tinyint DEFAULT '0',
  `eligibility_name` tinyint DEFAULT '0',
  `eligibility_address` tinyint DEFAULT '0',
  `eligibility_owner_org_name` tinyint DEFAULT '0',
  `eligibility_validity` tinyint DEFAULT '0',
  `remark_licanse_name` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date` text COLLATE utf8mb4_unicode_ci,
  `remark_licanse_issue_date_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_org_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_name` text COLLATE utf8mb4_unicode_ci,
  `remark_owner_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` text COLLATE utf8mb4_unicode_ci,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_validity` text COLLATE utf8mb4_unicode_ci,
  `remark_validity_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` tinyint DEFAULT '0',
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `final_highest_percentage_licno` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_licno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_issuedate_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_org_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid` text COLLATE utf8mb4_unicode_ci,
  `final_highest_percentage_valid_mr` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_photopass` */

CREATE TABLE `recommendation_photopass` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_application_no` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_name` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_landarea_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_ownership_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_use_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_applicationno` text COLLATE utf8mb4_unicode_ci,
  `final_applicationno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_name` text COLLATE utf8mb4_unicode_ci,
  `final_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_address` text COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_use` text COLLATE utf8mb4_unicode_ci,
  `final_use_mr` text COLLATE utf8mb4_unicode_ci,
  `final_annexure_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `recommendation_photopass_draft` */

CREATE TABLE `recommendation_photopass_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_application_no` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_name` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_landarea` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_landarea` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_landarea_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_ownership_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remark_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_use_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_applicationno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_applicationno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_use` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `final_use_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `recommendation_photopass_history` */

CREATE TABLE `recommendation_photopass_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_application_no` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_name` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibility_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_application_no_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_name_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_address_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_landarea_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_ownership_mr` text COLLATE utf8mb4_unicode_ci,
  `remark_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark_use_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_applicationno` text COLLATE utf8mb4_unicode_ci,
  `final_applicationno_mr` text COLLATE utf8mb4_unicode_ci,
  `final_name` text COLLATE utf8mb4_unicode_ci,
  `final_name_mr` text COLLATE utf8mb4_unicode_ci,
  `final_address` text COLLATE utf8mb4_unicode_ci,
  `final_address_mr` text COLLATE utf8mb4_unicode_ci,
  `final_use` text COLLATE utf8mb4_unicode_ci,
  `final_use_mr` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `reminders` */

CREATE TABLE `reminders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reminders_user_id_foreign` (`user_id`),
  CONSTRAINT `reminders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `reopen_appeal` */

CREATE TABLE `reopen_appeal` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appeal` tinyint DEFAULT '1',
  `appeal_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appeal_date` timestamp NULL DEFAULT NULL,
  `assign_date` timestamp NULL DEFAULT NULL,
  `completion_date` timestamp NULL DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `report_title` */

CREATE TABLE `report_title` (
  `title_id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residing_at` text COLLATE utf8mb4_general_ci,
  `situated_at` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`title_id`),
  KEY `title_id` (`title_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `roles` */

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sort_order_no` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `setting_translations` */

CREATE TABLE `setting_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `setting_id` int unsigned NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`),
  CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `settings` */

CREATE TABLE `settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plainValue` text COLLATE utf8mb4_unicode_ci,
  `isTranslatable` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `sims_master` */

CREATE TABLE `sims_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `overall_status` tinyint NOT NULL DEFAULT '0',
  `remark` text COLLATE utf8mb4_unicode_ci,
  `remark_mr` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `final_status` int DEFAULT '0',
  `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_date` timestamp NULL DEFAULT NULL,
  `rejected_status` tinyint DEFAULT '0',
  `history_type` tinyint DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IX_sims_master_hut_user_id` (`hut_id`,`user_id`),
  KEY `IX_sims_master_overall_status` (`overall_status`),
  KEY `IX_sims_master_user_id` (`user_id`),
  KEY `IX_sims_master_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `sims_master_detail` */

CREATE TABLE `sims_master_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_status` tinyint DEFAULT '0',
  `electricity_remark` text COLLATE utf8mb4_unicode_ci,
  `electricity_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `election_status` tinyint DEFAULT '0',
  `election_remark` text COLLATE utf8mb4_unicode_ci,
  `election_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `gumasta_status` tinyint DEFAULT '0',
  `gumasta_remark` text COLLATE utf8mb4_unicode_ci,
  `gumasta_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `photopass_status` tinyint DEFAULT '0',
  `photopass_remark` text COLLATE utf8mb4_unicode_ci,
  `photopass_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `agreement_status` tinyint DEFAULT '0',
  `agreement_remark` text COLLATE utf8mb4_unicode_ci,
  `agreement_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `adhar_status` tinyint DEFAULT '0',
  `adhar_remark` text COLLATE utf8mb4_unicode_ci,
  `adhar_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_status` tinyint DEFAULT '0',
  `overall_remark` text COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `voter_name_marathi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `user_id` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `final_annexure` int DEFAULT '0',
  `in_progress_status` int DEFAULT '0',
  `rejected_status` tinyint DEFAULT '0',
  `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_date` timestamp NULL DEFAULT NULL,
  `resubmission_status` tinyint DEFAULT '0',
  `data_type` tinyint DEFAULT '1',
  `reopen_status` tinyint DEFAULT '0',
  `final_adhar_recommendation_status` int DEFAULT '0',
  `abhay_yojana_status` tinyint DEFAULT '0',
  `abhay_yojana_remark` text COLLATE utf8mb4_unicode_ci,
  `abhay_yojana_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `final_abhay_yojana_recommendation_status` int DEFAULT '0',
  `final_agreement_recommendation_status` int DEFAULT '0',
  `final_gumasta_recommendation_status` int DEFAULT '0',
  `final_photopass_recommendation_status` int DEFAULT '0',
  `final_electricity_recommendation_status` int DEFAULT '0',
  `final_election_recommendation_status` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_sims_master_detail_hut_user_id` (`hut_id`,`user_id`),
  KEY `IX_sims_master_detail_updated_at` (`updated_at`),
  KEY `IX_sims_master_user_id` (`user_id`),
  KEY `IX_sims_master_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=1146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `sims_master_detail_history` */

CREATE TABLE `sims_master_detail_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_status` tinyint DEFAULT '0',
  `electricity_remark` text COLLATE utf8mb4_unicode_ci,
  `electricity_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `election_status` tinyint DEFAULT '0',
  `election_remark` text COLLATE utf8mb4_unicode_ci,
  `election_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `gumasta_status` tinyint DEFAULT '0',
  `gumasta_remark` text COLLATE utf8mb4_unicode_ci,
  `gumasta_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `photopass_status` tinyint DEFAULT '0',
  `photopass_remark` text COLLATE utf8mb4_unicode_ci,
  `photopass_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `agreement_status` tinyint DEFAULT '0',
  `agreement_remark` text COLLATE utf8mb4_unicode_ci,
  `agreement_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `adhar_status` tinyint DEFAULT '0',
  `adhar_remark` text COLLATE utf8mb4_unicode_ci,
  `adhar_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `overall_status` tinyint DEFAULT '0',
  `overall_remark` text COLLATE utf8mb4_unicode_ci,
  `overall_remark_mr` text COLLATE utf8mb4_unicode_ci,
  `voter_name_marathi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `user_id` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `final_annexure` int DEFAULT '0',
  `in_progress_status` int DEFAULT '0',
  `rejected_status` tinyint DEFAULT '0',
  `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_date` timestamp NULL DEFAULT NULL,
  `resubmission_status` tinyint DEFAULT '0',
  `data_type` tinyint DEFAULT '1',
  `reopen_status` tinyint DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_key` (`hut_id`,`user_id`,`data_type`),
  KEY `IX_sims_master_detail_hut_user_id` (`hut_id`,`user_id`),
  KEY `IX_sims_master_detail_updated_at` (`updated_at`),
  KEY `IX_sims_master_user_id` (`user_id`),
  KEY `IX_sims_master_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=6964 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `sims_master_history` */

CREATE TABLE `sims_master_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `overall_status` tinyint NOT NULL DEFAULT '0',
  `remark` text COLLATE utf8mb4_unicode_ci,
  `remark_mr` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `final_status` int DEFAULT '0',
  `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_date` timestamp NULL DEFAULT NULL,
  `rejected_status` tinyint DEFAULT '0',
  `history_type` tinyint DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_key` (`user_id`,`history_type`,`hut_id`),
  KEY `IX_sims_master_hut_user_id` (`hut_id`,`user_id`),
  KEY `IX_sims_master_overall_status` (`overall_status`),
  KEY `IX_sims_master_user_id` (`user_id`),
  KEY `IX_sims_master_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=879 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `simsdoc` */

CREATE TABLE `simsdoc` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `simsDocument` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DocumentTypeId` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `skip_repeted_close_hut` */

CREATE TABLE `skip_repeted_close_hut` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `sra` */

CREATE TABLE `sra` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` int DEFAULT NULL,
  `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` int DEFAULT NULL,
  `causer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `properties` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `survey_receipt_document` */

CREATE TABLE `survey_receipt_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci,
  `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_image` longblob,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `year` int DEFAULT NULL,
  `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `status_manual` tinyint(1) DEFAULT '0',
  `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_survey_receipt_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `survey_receipt_document_draft` */

CREATE TABLE `survey_receipt_document_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `survey_receipt_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_as_per_survey_receipt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `usage_type_of_hut` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area_of_hut` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_image` longblob,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `year` int DEFAULT NULL,
  `land_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `status_manual` tinyint(1) DEFAULT '0',
  `name_as_per_survey_receipt_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_no_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usage_type_of_hut_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_survey_receipt_document_hut_id` (`hut_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `survey_receipt_document_history` */

CREATE TABLE `survey_receipt_document_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci,
  `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_image` longblob,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `year` int DEFAULT NULL,
  `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `status_manual` tinyint(1) DEFAULT '0',
  `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_survey_receipt_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `survey_receipt_document_reject` */

CREATE TABLE `survey_receipt_document_reject` (
  `id` int NOT NULL AUTO_INCREMENT,
  `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci,
  `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_image` longblob,
  `upload_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `year` int DEFAULT NULL,
  `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `status_manual` tinyint(1) DEFAULT '0',
  `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_survey_receipt_document_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `t_abhay_yojana_info` */

CREATE TABLE `t_abhay_yojana_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sulm_evivtion_report` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `upload_document` longblob,
  `added_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `status_manual` tinyint(1) DEFAULT '0',
  `final_status` tinyint(1) DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `t_hutownerfamilyinfodetails` */

CREATE TABLE `t_hutownerfamilyinfodetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FFNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FMNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FLNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UIDNO` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FamilyInfoId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `RelName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `t_hutownerinfodetails` */

CREATE TABLE `t_hutownerinfodetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTOWNERNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` text COLLATE utf8mb4_general_ci,
  `PropertyType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FLOORNUM` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTLENGTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `HUTWIDTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Area` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Jodpatra` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `submission_status` tinyint DEFAULT '0',
  `application_status` tinyint DEFAULT '0',
  `resubmit_status` tinyint DEFAULT '0',
  `hut_survey_status` tinyint DEFAULT '3',
  `save_status` tinyint DEFAULT '0',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `jodpatra3` longblob,
  `jodpatra4` longblob,
  `form_A` longblob,
  `form_B` longblob,
  `self_assesmen` longblob,
  `self_declarion` longblob,
  `Jodpatra1` longblob,
  `Jodpatra2` longblob,
  `upload_document` longblob,
  `original_annexure_copy` longblob,
  `selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sulm_evivtion_report` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1220 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tata_electricity_data` */

CREATE TABLE `tata_electricity_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `tata_electricity_data_draft` */

CREATE TABLE `tata_electricity_data_draft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tata_electricity_data_history` */

CREATE TABLE `tata_electricity_data_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `category` text COLLATE utf8mb4_unicode_ci,
  `service_provider` text COLLATE utf8mb4_unicode_ci,
  `legacy_ca_no` text COLLATE utf8mb4_unicode_ci,
  `ca_no` text COLLATE utf8mb4_unicode_ci,
  `first_consumer_name` text COLLATE utf8mb4_unicode_ci,
  `first_bill` text COLLATE utf8mb4_unicode_ci,
  `change_name_date` text COLLATE utf8mb4_unicode_ci,
  `change_date` text COLLATE utf8mb4_unicode_ci,
  `move_in_date` text COLLATE utf8mb4_unicode_ci,
  `move_out_date` text COLLATE utf8mb4_unicode_ci,
  `legacy_customer` text COLLATE utf8mb4_unicode_ci,
  `house_no` text COLLATE utf8mb4_unicode_ci,
  `tariff` text COLLATE utf8mb4_unicode_ci,
  `flag_migr` text COLLATE utf8mb4_unicode_ci,
  `year` tinyint DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `throttle` */

CREATE TABLE `throttle` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `throttle_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `translation_translations` */

CREATE TABLE `translation_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `translation_id` int unsigned NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `translation_translations_translation_id_locale_unique` (`translation_id`,`locale`),
  CONSTRAINT `translation_translations_translation_id_foreign` FOREIGN KEY (`translation_id`) REFERENCES `translations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `user_file_extensions` */

CREATE TABLE `user_file_extensions` (
  `user_id` int unsigned NOT NULL,
  `file_extension_id` int unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`file_extension_id`),
  KEY `user_file_extensions_file_extension_id_foreign` (`file_extension_id`),
  CONSTRAINT `user_file_extensions_file_extension_id_foreign` FOREIGN KEY (`file_extension_id`) REFERENCES `file_extensions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_file_extensions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `user_folders` */

CREATE TABLE `user_folders` (
  `user_id` int unsigned NOT NULL,
  `folder_id` int unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`folder_id`),
  KEY `user_folders_folder_id_foreign` (`folder_id`),
  CONSTRAINT `user_folders_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_folders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `user_roles` */

CREATE TABLE `user_roles` (
  `user_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `user_roles_role_id_foreign` (`role_id`),
  CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `voter_name_marathi` */

CREATE TABLE `voter_name_marathi` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `voter_name_marathi` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hutment_dweller_to_scheme` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `thumb_impression` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_voter_name_marathi_hut_id` (`hut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/* Trigger structure for table `adani_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `adani_electricity_data_insert` AFTER INSERT ON `adani_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO adani_electricity_data_history
    (
        hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
        first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
        flag_migr, YEAR, created_at, updated_at, user_id, history_value
    )
    VALUES
    (
        NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
        NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
        NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert'
    );
END */$$


DELIMITER ;

/* Trigger structure for table `adani_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `adani_electricity_data_update` AFTER UPDATE ON `adani_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO adani_electricity_data_history
    (
        hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
        first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
        flag_migr, YEAR, created_at, updated_at, user_id, history_value
    )
    VALUES
    (
        NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
        NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
        NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update'
    );
END */$$


DELIMITER ;

/* Trigger structure for table `adhar_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `adhar_details_insert` AFTER INSERT ON `adhar_details` FOR EACH ROW BEGIN
    INSERT INTO `adhar_details_history`
    (hut_id, uid_no, owner_name, birth_date, owner_address, `year`, created_at, updated_at, user_id, updated_by, history_value)
    VALUES
    (NEW.hut_id, NEW.uid_no, NEW.owner_name, NEW.birth_date, NEW.owner_address, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `adhar_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `adhar_details_update` AFTER UPDATE ON `adhar_details` FOR EACH ROW BEGIN
    INSERT INTO `adhar_details_history`
    (hut_id, uid_no, owner_name, birth_date, owner_address, `year`, created_at, updated_at, user_id, updated_by, history_value)
    VALUES
    (NEW.hut_id, NEW.uid_no, NEW.owner_name, NEW.birth_date, NEW.owner_address, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `agreement_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `agreement_details_insert` AFTER INSERT ON `agreement_details` FOR EACH ROW BEGIN
    INSERT INTO `agreement_details_history`
        (hut_id, sr_no, document, seller_name, purchaser_name, relationship, agreement_date, `year`, created_at, 
        updated_at, updated_by, user_id, history_value)
    VALUES
        (NEW.hut_id, NEW.sr_no, NEW.document, NEW.seller_name, NEW.purchaser_name, NEW.relationship, NEW.agreement_date, NEW.year, 
        NEW.created_at, NEW.updated_at, NEW.updated_by, NEW.user_id, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `agreement_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `agreement_details_update` AFTER UPDATE ON `agreement_details` FOR EACH ROW BEGIN
    INSERT INTO `agreement_details_history`
        (hut_id, sr_no, document, seller_name, purchaser_name, relationship, agreement_date, `year`, created_at, 
        updated_at, updated_by, user_id, history_value)
    VALUES
        (NEW.hut_id, NEW.sr_no, NEW.document, NEW.seller_name, NEW.purchaser_name, NEW.relationship, NEW.agreement_date, NEW.year, 
        NEW.created_at, NEW.updated_at, NEW.updated_by, NEW.user_id, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `election_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_details_update` AFTER INSERT ON `election_details` FOR EACH ROW BEGIN
    INSERT INTO `election_details_history`
          (hut_id, voter_id, sr_no, cont_no, part_no, elector_name, elector_sec_name, age, gender, housing, pincode,
          address, file_upload, `year`, created_at, updated_at, user_id, updated_by, history_value)
    VALUES
       (NEW.hut_id, NEW.voter_id, NEW.sr_no, NEW.cont_no, NEW.part_no, NEW.elector_name, NEW.elector_sec_name, NEW.age,
       NEW.gender, NEW.housing, NEW.pincode, NEW.address, NEW.file_upload, NEW.year, NEW.created_at, NEW.updated_at,NEW.user_id, NEW.updated_by, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `election_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_details_insert` AFTER INSERT ON `election_details` FOR EACH ROW BEGIN
    INSERT INTO `election_details_history`
          (hut_id, voter_id, sr_no, cont_no, part_no, elector_name, elector_sec_name, age, gender, housing, pincode,
          address, file_upload, `year`, created_at, updated_at, user_id, updated_by, history_value)
    VALUES
       (NEW.hut_id, NEW.voter_id, NEW.sr_no, NEW.cont_no, NEW.part_no, NEW.elector_name, NEW.elector_sec_name, NEW.age,
       NEW.gender, NEW.housing, NEW.pincode, NEW.address, NEW.file_upload, NEW.year, NEW.created_at, NEW.updated_at,NEW.user_id, NEW.updated_by, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `election_integration` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_integration_insert` AFTER INSERT ON `election_integration` FOR EACH ROW BEGIN
    INSERT INTO `election_integration_history`
          (integration_id, hut_id, hutment_no, integration_part_no, integration_sr_no, integration_year, integration_cont_no, 
     integration_voter_name, `year`, updated_at, hutment_no_mr, integration_part_no_mr, integration_sr_no_mr, 
     integration_year_mr, integration_cont_no_mr, integration_voter_name_mr, year_mr, user_id, created_at, updated_by, history_value)
    VALUES
         (NEW.integration_id, NEW.hut_id, NEW.hutment_no, NEW.integration_part_no, NEW.integration_sr_no, NEW.integration_year, 
     NEW.integration_cont_no, NEW.integration_voter_name, NEW.year, NEW.updated_at, NEW.hutment_no_mr, NEW.integration_part_no_mr, 
     NEW.integration_sr_no_mr, NEW.integration_year_mr, NEW.integration_cont_no_mr, NEW.integration_voter_name_mr, NEW.year_mr, 
     NEW.user_id, NEW.created_at, NEW.updated_by, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `election_integration` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_integration_update` AFTER INSERT ON `election_integration` FOR EACH ROW BEGIN
    INSERT INTO `election_integration_history`
          (integration_id, hut_id, hutment_no, integration_part_no, integration_sr_no, integration_year, integration_cont_no, 
     integration_voter_name, `year`, updated_at, hutment_no_mr, integration_part_no_mr, integration_sr_no_mr, 
     integration_year_mr, integration_cont_no_mr, integration_voter_name_mr, year_mr, user_id, created_at, updated_by, history_value)
    VALUES
         (NEW.integration_id, NEW.hut_id, NEW.hutment_no, NEW.integration_part_no, NEW.integration_sr_no, NEW.integration_year, 
     NEW.integration_cont_no, NEW.integration_voter_name, NEW.year, NEW.updated_at, NEW.hutment_no_mr, NEW.integration_part_no_mr, 
     NEW.integration_sr_no_mr, NEW.integration_year_mr, NEW.integration_cont_no_mr, NEW.integration_voter_name_mr, NEW.year_mr, 
     NEW.user_id, NEW.created_at, NEW.updated_by, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `gumasta_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `gumasta_details_insert` AFTER INSERT ON `gumasta_details` FOR EACH ROW BEGIN
    INSERT INTO `gumasta_details_history`
	(hut_id, License_no, License_issue_date, License_exp_date, organisation_name, name, address, 
     relationship, agreement_date, year, upload_file, nature_of_business, created_at, updated_at, 
     user_id, updated_by, history_value)
    VALUES
           (NEW.hut_id, NEW.License_no, NEW.License_issue_date, NEW.License_exp_date, NEW.organisation_name, 
     NEW.name, NEW.address, NEW.relationship, NEW.agreement_date, NEW.year, NEW.upload_file, 
     NEW.nature_of_business, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `gumasta_details` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `gumasta_details_update` AFTER INSERT ON `gumasta_details` FOR EACH ROW BEGIN
    INSERT INTO `gumasta_details_history`
	(hut_id, License_no, License_issue_date, License_exp_date, organisation_name, name, address, 
     relationship, agreement_date, year, upload_file, nature_of_business, created_at, updated_at, 
     user_id, updated_by, history_value)
    VALUES
           (NEW.hut_id, NEW.License_no, NEW.License_issue_date, NEW.License_exp_date, NEW.organisation_name, 
     NEW.name, NEW.address, NEW.relationship, NEW.agreement_date, NEW.year, NEW.upload_file, 
     NEW.nature_of_business, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `mseb_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `mseb_electricity_data_insert` AFTER INSERT ON `mseb_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO `mseb_electricity_data_history`
     (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
     first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
     flag_migr, year, created_at, updated_at, user_id, history_value)
    VALUES
    (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
     NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
     NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `mseb_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `mseb_electricity_data_update` AFTER UPDATE ON `mseb_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO `mseb_electricity_data_history`
     (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
     first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
     flag_migr, year, created_at, updated_at, user_id, history_value)
    VALUES
    (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
     NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
     NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_adhar` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_adhar_insert` AFTER INSERT ON `recommendation_adhar` FOR EACH ROW BEGIN
    INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`, `user_id`) 
    VALUES (NEW.hut_id, 1, NEW.user_id) 
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_adhar` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_adhar_delete` AFTER DELETE ON `recommendation_adhar` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_adhar_history` (
        `hut_id`,
        `year`,
        `user_id`,
        `eligibility_uid`,
        `eligibility_name`,
        `eligibility_dob`,
        `eligibility_address`,
        `remark_uid`,
        `remark_uid_mr`,
        `remark_name`,
        `remark_name_mr`,
        `remark_dob`,
        `remark_dob_mr`,
        `remark_address`,
        `remark_address_mr`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_uid`,
        `final_uid_mr`,
        `final_aadharname`,
        `final_aadharname_mr`,
        `final_aadhardate`,
        `final_aadhardate_mr`,
        `final_address`,
        `final_address_mr`
    ) 
    VALUES (
        OLD.hut_id,
        OLD.year,
        OLD.user_id,
        OLD.eligibility_uid,
        OLD.eligibility_name,
        OLD.eligibility_dob,
        OLD.eligibility_address,
        OLD.remark_uid,
        OLD.remark_uid_mr,
        OLD.remark_name,
        OLD.remark_name_mr,
        OLD.remark_dob,
        OLD.remark_dob_mr,
        OLD.remark_address,
        OLD.remark_address_mr,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_uid,
        OLD.final_uid_mr,
        OLD.final_aadharname,
        OLD.final_aadharname_mr,
        OLD.final_aadhardate,
        OLD.final_aadhardate_mr,
        OLD.final_address,
        OLD.final_address_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_agreement` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_agreement_insert` AFTER INSERT ON `recommendation_agreement` FOR EACH ROW BEGIN
    INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) 
    VALUES (NEW.hut_id, 1,NEW.user_id)
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_agreement` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_agreement_delete` AFTER DELETE ON `recommendation_agreement` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_agreement_history` (
        `hut_id`,
        `year`,
        `user_id`,
        `eligibility_srno`,
        `eligibility_type`,
        `eligibility_aggrement_date`,
        `eligibility_seller_name`,
        `eligibility_purchaser_name`,
        `eligibility_relationship`,
        `remark_srno`,
        `remark_srno_mr`,
        `remark_type`,
        `remark_type_mr`,
        `remark_aggrement_date`,
        `remark_aggrement_date_mr`,
        `remark_seller_name`,
        `remark_seller_name_mr`,
        `remark_purchaser_name`,
        `remark_purchaser_name_mr`,
        `remark_relationship`,
        `remark_relationship_mr`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_srno`,
        `final_srno_mr`,
        `final_type`,
        `final_type_mr`,
        `final_date`,
        `final_date_mr`,
        `final_sname`,
        `final_sname_mr`,
        `final_pname`,
        `final_pname_mr`,
        `final_rname`,
        `final_rname_mr`
    ) 
    VALUES (
        OLD.hut_id,
        OLD.year,
        OLD.user_id,
        OLD.eligibility_srno,
        OLD.eligibility_type,
        OLD.eligibility_aggrement_date,
        OLD.eligibility_seller_name,
        OLD.eligibility_purchaser_name,
        OLD.eligibility_relationship,
        OLD.remark_srno,
        OLD.remark_srno_mr,
        OLD.remark_type,
        OLD.remark_type_mr,
        OLD.remark_aggrement_date,
        OLD.remark_aggrement_date_mr,
        OLD.remark_seller_name,
        OLD.remark_seller_name_mr,
        OLD.remark_purchaser_name,
        OLD.remark_purchaser_name_mr,
        OLD.remark_relationship,
        OLD.remark_relationship_mr,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_srno,
        OLD.final_srno_mr,
        OLD.final_type,
        OLD.final_type_mr,
        OLD.final_date,
        OLD.final_date_mr,
        OLD.final_sname,
        OLD.final_sname_mr,
        OLD.final_pname,
        OLD.final_pname_mr,
        OLD.final_rname,
        OLD.final_rname_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_election` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_election_insert` AFTER INSERT ON `recommendation_election` FOR EACH ROW BEGIN
     INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) 
    VALUES (NEW.hut_id, 1,NEW.user_id)
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_election` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_election_delete` AFTER DELETE ON `recommendation_election` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_election_history` (
        `hut_id`,
        `year`,
        `user_id`,
        `eligibility_name`,
        `eligibility_address`,
        `eligibility_number`,
        `eligibility_type`,
        `eligibility_const_no`,
        `eligibility_sr_no`,
        `eligibility_part_no`,
        `remark_name`,
        `remark_name_mr`,
        `remark_address`,
        `remark_address_mr`,
        `remark_number`,
        `remark_number_mr`,
        `remark_type`,
        `remark_type_mr`,
        `remark_const_no`,
        `remark_const_no_mr`,
        `remark_sr_no`,
        `remark_sr_no_mr`,
        `remark_part_no`,
        `remark_part_no_mr`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_electorname`,
        `final_electorname_mr`,
        `final_electoraddress`,
        `final_electoraddress_mr`,
        `final_electornumber`,
        `final_electornumber_mr`,
        `final_electortype`,
        `final_electortype_mr`,
        `final_electorconstitute`,
        `final_electorconstitute_mr`,
        `final_electorsr_no`,
        `final_electorsr_no_mr`,
        `final_electorpart_no`,
        `final_electorpart_no_mr`
    ) 
    VALUES (
        OLD.hut_id,
        OLD.year,
        OLD.user_id,
        OLD.eligibility_name,
        OLD.eligibility_address,
        OLD.eligibility_number,
        OLD.eligibility_type,
        OLD.eligibility_const_no,
        OLD.eligibility_sr_no,
        OLD.eligibility_part_no,
        OLD.remark_name,
        OLD.remark_name_mr,
        OLD.remark_address,
        OLD.remark_address_mr,
        OLD.remark_number,
        OLD.remark_number_mr,
        OLD.remark_type,
        OLD.remark_type_mr,
        OLD.remark_const_no,
        OLD.remark_const_no_mr,
        OLD.remark_sr_no,
        OLD.remark_sr_no_mr,
        OLD.remark_part_no,
        OLD.remark_part_no_mr,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_electorname,
        OLD.final_electorname_mr,
        OLD.final_electoraddress,
        OLD.final_electoraddress_mr,
        OLD.final_electornumber,
        OLD.final_electornumber_mr,
        OLD.final_electortype,
        OLD.final_electortype_mr,
        OLD.final_electorconstitute,
        OLD.final_electorconstitute_mr,
        OLD.final_electorsr_no,
        OLD.final_electorsr_no_mr,
        OLD.final_electorpart_no,
        OLD.final_electorpart_no_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_electricity` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_electricity_insert` AFTER INSERT ON `recommendation_electricity` FOR EACH ROW BEGIN
     INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) 
    VALUES (NEW.hut_id, 1,NEW.user_id)
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_electricity` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_electricity_delete` AFTER DELETE ON `recommendation_electricity` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_electricity_history` (
        `id`,
        `hut_id`,
        `user_id`,
        `year`,
        `remark_name`,
        `remark_name_mr`,
        `remark_address`,
        `remark_address_mr`,
        `remark_category`,
        `remark_category_mr`,
        `remark_serviceprovider`,
        `remark_serviceprovider_mr`,
        `remark_ca`,
        `remark_ca_mr`,
        `remark_billdate`,
        `remark_billdate_mr`,
        `eligibility_name`,
        `eligibility_address`,
        `eligibility_category`,
        `eligibility_serviceprovider`,
        `eligibility_ca`,
        `eligibility_billdate`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_highest_percentage_name`,
        `final_highest_percentage_name_mr`,
        `final_highest_percentage_address`,
        `final_highest_percentage_address_mr`,
        `final_highest_percentage_category`,
        `final_highest_percentage_category_mr`,
        `final_highest_percentage_service_provider`,
        `final_highest_percentage_service_provider_mr`,
        `final_highest_percentage_ca`,
        `final_highest_percentage_ca_mr`,
        `final_highest_percentage_bill_date`,
        `final_highest_percentage_bill_date_mr`
    ) 
    VALUES (
        OLD.id,
        OLD.hut_id,
        OLD.user_id,
        OLD.year,
        OLD.remark_name,
        OLD.remark_name_mr,
        OLD.remark_address,
        OLD.remark_address_mr,
        OLD.remark_category,
        OLD.remark_category_mr,
        OLD.remark_serviceprovider,
        OLD.remark_serviceprovider_mr,
        OLD.remark_ca,
        OLD.remark_ca_mr,
        OLD.remark_billdate,
        OLD.remark_billdate_mr,
        OLD.eligibility_name,
        OLD.eligibility_address,
        OLD.eligibility_category,
        OLD.eligibility_serviceprovider,
        OLD.eligibility_ca,
        OLD.eligibility_billdate,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_highest_percentage_name,
        OLD.final_highest_percentage_name_mr,
        OLD.final_highest_percentage_address,
        OLD.final_highest_percentage_address_mr,
        OLD.final_highest_percentage_category,
        OLD.final_highest_percentage_category_mr,
        OLD.final_highest_percentage_service_provider,
        OLD.final_highest_percentage_service_provider_mr,
        OLD.final_highest_percentage_ca,
        OLD.final_highest_percentage_ca_mr,
        OLD.final_highest_percentage_bill_date,
        OLD.final_highest_percentage_bill_date_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_gumasta` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_gumasta_insert` AFTER INSERT ON `recommendation_gumasta` FOR EACH ROW BEGIN
     INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) 
    VALUES (NEW.hut_id, 1,NEW.user_id)
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_gumasta` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_gumasta_delete` AFTER DELETE ON `recommendation_gumasta` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_gumasta_history` (
        `hut_id`,
        `user_id`,
        `year`,
        `eligibility_licanse_name`,
        `eligibility_licanse_issue_date`,
        `eligibility_name`,
        `eligibility_address`,
        `eligibility_owner_org_name`,
        `eligibility_validity`,
        `remark_licanse_name`,
        `remark_licanse_name_mr`,
        `remark_licanse_issue_date`,
        `remark_licanse_issue_date_mr`,
        `remark_owner_org_name`,
        `remark_owner_org_name_mr`,
        `remark_owner_name`,
        `remark_owner_name_mr`,
        `remark_address`,
        `remark_address_mr`,
        `remark_validity`,
        `remark_validity_mr`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_highest_percentage_licno`,
        `final_highest_percentage_licno_mr`,
        `final_highest_percentage_issuedate`,
        `final_highest_percentage_issuedate_mr`,
        `final_highest_percentage_org`,
        `final_highest_percentage_org_mr`,
        `final_highest_percentage_name`,
        `final_highest_percentage_name_mr`,
        `final_highest_percentage_address`,
        `final_highest_percentage_address_mr`,
        `final_highest_percentage_valid`,
        `final_highest_percentage_valid_mr`
    ) 
    VALUES (
        OLD.hut_id,
        OLD.user_id,
        OLD.year,
        OLD.eligibility_licanse_name,
        OLD.eligibility_licanse_issue_date,
        OLD.eligibility_name,
        OLD.eligibility_address,
        OLD.eligibility_owner_org_name,
        OLD.eligibility_validity,
        OLD.remark_licanse_name,
        OLD.remark_licanse_name_mr,
        OLD.remark_licanse_issue_date,
        OLD.remark_licanse_issue_date_mr,
        OLD.remark_owner_org_name,
        OLD.remark_owner_org_name_mr,
        OLD.remark_owner_name,
        OLD.remark_owner_name_mr,
        OLD.remark_address,
        OLD.remark_address_mr,
        OLD.remark_validity,
        OLD.remark_validity_mr,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_highest_percentage_licno,
        OLD.final_highest_percentage_licno_mr,
        OLD.final_highest_percentage_issuedate,
        OLD.final_highest_percentage_issuedate_mr,
        OLD.final_highest_percentage_org,
        OLD.final_highest_percentage_org_mr,
        OLD.final_highest_percentage_name,
        OLD.final_highest_percentage_name_mr,
        OLD.final_highest_percentage_address,
        OLD.final_highest_percentage_address_mr,
        OLD.final_highest_percentage_valid,
        OLD.final_highest_percentage_valid_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_photopass` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_photopass_insert` AFTER INSERT ON `recommendation_photopass` FOR EACH ROW BEGIN
    INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) 
    VALUES (NEW.hut_id, 1, NEW.user_id) 
    ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `recommendation_photopass` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_photopass_delete` AFTER DELETE ON `recommendation_photopass` FOR EACH ROW BEGIN
    INSERT INTO `recommendation_photopass_history` (
        `hut_id`,
        `year`,
        `user_id`,
        `eligibility_application_no`,
        `eligibility_name`,
        `eligibility_address`,
        `eligibility_landarea`,
        `eligibility_ownership`,
        `eligibility_use`,
        `remark_application_no`,
        `remark_application_no_mr`,
        `remark_name`,
        `remark_name_mr`,
        `remark_address`,
        `remark_address_mr`,
        `remark_landarea`,
        `remark_landarea_mr`,
        `remark_ownership`,
        `remark_ownership_mr`,
        `remark_use`,
        `remark_use_mr`,
        `overall_remark`,
        `overall_remark_mr`,
        `overall_eligibility`,
        `user`,
        `created_at`,
        `final_applicationno`,
        `final_applicationno_mr`,
        `final_name`,
        `final_name_mr`,
        `final_address`,
        `final_address_mr`,
        `final_use`,
        `final_use_mr`
    ) 
    VALUES (
        OLD.hut_id,
        OLD.year,
        OLD.user_id,
        OLD.eligibility_application_no,
        OLD.eligibility_name,
        OLD.eligibility_address,
        OLD.eligibility_landarea,
        OLD.eligibility_ownership,
        OLD.eligibility_use,
        OLD.remark_application_no,
        OLD.remark_application_no_mr,
        OLD.remark_name,
        OLD.remark_name_mr,
        OLD.remark_address,
        OLD.remark_address_mr,
        OLD.remark_landarea,
        OLD.remark_landarea_mr,
        OLD.remark_ownership,
        OLD.remark_ownership_mr,
        OLD.remark_use,
        OLD.remark_use_mr,
        OLD.overall_remark,
        OLD.overall_remark_mr,
        OLD.overall_eligibility,
        OLD.user,
        OLD.created_at,
        OLD.final_applicationno,
        OLD.final_applicationno_mr,
        OLD.final_name,
        OLD.final_name_mr,
        OLD.final_address,
        OLD.final_address_mr,
        OLD.final_use,
        OLD.final_use_mr
    );
END */$$


DELIMITER ;

/* Trigger structure for table `sims_master` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_history_insert` AFTER INSERT ON `sims_master` FOR EACH ROW BEGIN
    INSERT INTO `sims_master_history` (
        `user_id`, `hut_id`, `status`, `overall_status`, `remark`, 
        `remark_mr`, `created_at`, `updated_at`, `final_status`, 
        `rejected_by`, `rejected_date`, `rejected_status`,`history_type`
    ) 
    VALUES (
        NEW.user_id, NEW.hut_id, NEW.status, NEW.overall_status, NEW.remark, 
        NEW.remark_mr, NEW.created_at, NEW.updated_at, NEW.final_status, 
        NEW.rejected_by, NEW.rejected_date, NEW.rejected_status, NEW.history_type
    ) 
    ON DUPLICATE KEY UPDATE 
        `status` = VALUES(`status`),
        `overall_status` = VALUES(`overall_status`),
        `remark` = VALUES(`remark`),
        `remark_mr` = VALUES(`remark_mr`),
        `created_at` = VALUES(`created_at`),
        `updated_at` = VALUES(`updated_at`),
        `final_status` = VALUES(`final_status`),
        `rejected_by` = VALUES(`rejected_by`),
        `rejected_date` = VALUES(`rejected_date`),
        `rejected_status` = VALUES(`rejected_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `sims_master` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_history_update` AFTER UPDATE ON `sims_master` FOR EACH ROW BEGIN
    INSERT INTO `sims_master_history` (
        `user_id`, `hut_id`, `status`, `overall_status`, `remark`, 
        `remark_mr`, `created_at`, `updated_at`, `final_status`, 
        `rejected_by`, `rejected_date`, `rejected_status`,`history_type`
    ) 
    VALUES (
        NEW.user_id, NEW.hut_id, NEW.status, NEW.overall_status, NEW.remark, 
        NEW.remark_mr, NEW.created_at, NEW.updated_at, NEW.final_status, 
        NEW.rejected_by, NEW.rejected_date, NEW.rejected_status, NEW.history_type
    ) 
    ON DUPLICATE KEY UPDATE 
        `status` = VALUES(`status`),
        `overall_status` = VALUES(`overall_status`),
        `remark` = VALUES(`remark`),
        `remark_mr` = VALUES(`remark_mr`),
        `created_at` = VALUES(`created_at`),
        `updated_at` = VALUES(`updated_at`),
        `final_status` = VALUES(`final_status`),
        `rejected_by` = VALUES(`rejected_by`),
        `rejected_date` = VALUES(`rejected_date`),
        `rejected_status` = VALUES(`rejected_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `sims_master_detail` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_detail_history_insert` AFTER INSERT ON `sims_master_detail` FOR EACH ROW BEGIN
    INSERT INTO `sims_master_detail_history` (
        `hut_id`, `electricity_status`, `electricity_remark`, `electricity_remark_mr`, `election_status`,`election_remark`,`election_remark_mr`,`gumasta_status`,`gumasta_remark`,`gumasta_remark_mr`,`photopass_status`,`photopass_remark`,`photopass_remark_mr`,`agreement_status`,`agreement_remark`,`agreement_remark_mr`,`adhar_status`,`adhar_remark`,`adhar_remark_mr`,`overall_status`,`overall_remark`,`overall_remark_mr`,`voter_name_marathi`,`status`,`user_id`,`created_at`,`updated_at`,`final_annexure`,`in_progress_status`,`rejected_status`,`rejected_by`,`rejected_date`,`resubmission_status`,`data_type`
    ) 
    VALUES (
        NEW.hut_id, NEW.electricity_status, NEW.electricity_remark, NEW.electricity_remark_mr, NEW.election_status, NEW.election_remark, NEW.election_remark_mr, NEW.gumasta_status, NEW.gumasta_remark, NEW.gumasta_remark_mr, NEW.photopass_status, NEW.photopass_remark, NEW.photopass_remark_mr, NEW.agreement_status, NEW.agreement_remark, NEW.agreement_remark_mr, NEW.adhar_status, NEW.adhar_remark, NEW.adhar_remark_mr, NEW.overall_status, NEW.overall_remark, NEW.overall_remark_mr, NEW.voter_name_marathi, NEW.status, NEW.user_id, NEW.created_at, NEW.updated_at, NEW.final_annexure, NEW.in_progress_status, NEW.rejected_status, NEW.rejected_by, NEW.rejected_date, NEW.resubmission_status, NEW.data_type
    ) 
    ON DUPLICATE KEY UPDATE 
        `electricity_status` = VALUES(`electricity_status`),
        `electricity_remark` = VALUES(`electricity_remark`),
        `electricity_remark_mr` = VALUES(`electricity_remark_mr`),
        `election_status` = VALUES(`election_status`),
        `election_remark` = VALUES(`election_remark`),
        `election_remark_mr` = VALUES(`election_remark_mr`),
        `gumasta_status` = VALUES(`gumasta_status`),
        `gumasta_remark` = VALUES(`gumasta_remark`),
        `gumasta_remark_mr` = VALUES(`gumasta_remark_mr`),
        `photopass_status` = VALUES(`photopass_status`),
        `photopass_remark` = VALUES(`photopass_remark`),
        `photopass_remark_mr` = VALUES(`photopass_remark_mr`),
        `agreement_status` = VALUES(`agreement_status`),
        `agreement_remark` = VALUES(`agreement_remark`),
        `agreement_remark_mr` = VALUES(`agreement_remark_mr`),
        `adhar_status` = VALUES(`adhar_status`),
        `adhar_remark` = VALUES(`adhar_remark`),
        `adhar_remark_mr` = VALUES(`adhar_remark_mr`),
        `overall_status` = VALUES(`overall_status`),
        `overall_remark` = VALUES(`overall_remark`),
        `overall_remark_mr` = VALUES(`overall_remark_mr`),
        `voter_name_marathi` = VALUES(`voter_name_marathi`),
        `status` = VALUES(`status`),
        `created_at` = VALUES(`created_at`),
        `updated_at` = VALUES(`updated_at`),
        `final_annexure` = VALUES(`final_annexure`),
        `in_progress_status` = VALUES(`in_progress_status`),
        `rejected_status` = VALUES(`rejected_status`),
        `rejected_by` = VALUES(`rejected_by`),
        `rejected_date` = VALUES(`rejected_date`),
        `resubmission_status` = VALUES(`resubmission_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `sims_master_detail` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_detail_history_updates` AFTER UPDATE ON `sims_master_detail` FOR EACH ROW BEGIN
    INSERT INTO `sims_master_detail_history` (
        `hut_id`, `electricity_status`, `electricity_remark`, `electricity_remark_mr`, `election_status`,`election_remark`,`election_remark_mr`,`gumasta_status`,`gumasta_remark`,`gumasta_remark_mr`,`photopass_status`,`photopass_remark`,`photopass_remark_mr`,`agreement_status`,`agreement_remark`,`agreement_remark_mr`,`adhar_status`,`adhar_remark`,`adhar_remark_mr`,`overall_status`,`overall_remark`,`overall_remark_mr`,`voter_name_marathi`,`status`,`user_id`,`created_at`,`updated_at`,`final_annexure`,`in_progress_status`,`rejected_status`,`rejected_by`,`rejected_date`,`resubmission_status`,`data_type`
    ) 
    VALUES (
        NEW.hut_id, NEW.electricity_status, NEW.electricity_remark, NEW.electricity_remark_mr, NEW.election_status, NEW.election_remark, NEW.election_remark_mr, NEW.gumasta_status, NEW.gumasta_remark, NEW.gumasta_remark_mr, NEW.photopass_status, NEW.photopass_remark, NEW.photopass_remark_mr, NEW.agreement_status, NEW.agreement_remark, NEW.agreement_remark_mr, NEW.adhar_status, NEW.adhar_remark, NEW.adhar_remark_mr, NEW.overall_status, NEW.overall_remark, NEW.overall_remark_mr, NEW.voter_name_marathi, NEW.status, NEW.user_id, NEW.created_at, NEW.updated_at, NEW.final_annexure, NEW.in_progress_status, NEW.rejected_status, NEW.rejected_by, NEW.rejected_date, NEW.resubmission_status, NEW.data_type
    ) 
    ON DUPLICATE KEY UPDATE 
        `electricity_status` = VALUES(`electricity_status`),
        `electricity_remark` = VALUES(`electricity_remark`),
        `electricity_remark_mr` = VALUES(`electricity_remark_mr`),
        `election_status` = VALUES(`election_status`),
        `election_remark` = VALUES(`election_remark`),
        `election_remark_mr` = VALUES(`election_remark_mr`),
        `gumasta_status` = VALUES(`gumasta_status`),
        `gumasta_remark` = VALUES(`gumasta_remark`),
        `gumasta_remark_mr` = VALUES(`gumasta_remark_mr`),
        `photopass_status` = VALUES(`photopass_status`),
        `photopass_remark` = VALUES(`photopass_remark`),
        `photopass_remark_mr` = VALUES(`photopass_remark_mr`),
        `agreement_status` = VALUES(`agreement_status`),
        `agreement_remark` = VALUES(`agreement_remark`),
        `agreement_remark_mr` = VALUES(`agreement_remark_mr`),
        `adhar_status` = VALUES(`adhar_status`),
        `adhar_remark` = VALUES(`adhar_remark`),
        `adhar_remark_mr` = VALUES(`adhar_remark_mr`),
        `overall_status` = VALUES(`overall_status`),
        `overall_remark` = VALUES(`overall_remark`),
        `overall_remark_mr` = VALUES(`overall_remark_mr`),
        `voter_name_marathi` = VALUES(`voter_name_marathi`),
        `status` = VALUES(`status`),
        `created_at` = VALUES(`created_at`),
        `updated_at` = VALUES(`updated_at`),
        `final_annexure` = VALUES(`final_annexure`),
        `in_progress_status` = VALUES(`in_progress_status`),
        `rejected_status` = VALUES(`rejected_status`),
        `rejected_by` = VALUES(`rejected_by`),
        `rejected_date` = VALUES(`rejected_date`),
        `resubmission_status` = VALUES(`resubmission_status`);
END */$$


DELIMITER ;

/* Trigger structure for table `tata_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `tata_electricity_data_update` AFTER UPDATE ON `tata_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO `tata_electricity_data_history`
    (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
     first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
     flag_migr, YEAR, created_at, updated_at, user_id, history_value)
    VALUES
    (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
     NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
     NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update');
END */$$


DELIMITER ;

/* Trigger structure for table `tata_electricity_data` */

DELIMITER $$

/*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `tata_electricity_data_insert` AFTER UPDATE ON `tata_electricity_data` FOR EACH ROW BEGIN
    INSERT INTO `tata_electricity_data_history`
    (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name,
     first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, 
     flag_migr, YEAR, created_at, updated_at, user_id, history_value)
    VALUES
    (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no,
     NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date,
     NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert');
END */$$


DELIMITER ;

/* Trigger structure for table `users` */

DELIMITER $$


DELIMITER ;

