INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(239, '#OPNAG-OW-00000221', '$2y$10$RSEsucMCI2foq6Sk8LTpkunzqso7khmMv2gF9eV2wWEjBC4WW195O', '103.59.73.141', 'Amit Kumar Sen', 'Arun Kumar Sen ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Kalachand Para Near Ration Shop Garia South 24 Parganas West Bengal 722164', NULL, '', '722164', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1988-04-27', '233651331628', NULL, 0x[encoded data, 12038 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/298', 'D/298/404', 'D/298/404 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal - 700135', '700135', 'f', '1', '320', 'NA', '4', 'f', 8200, 'Eight Thousand Two Hundred ', 13600, 'Thirteen Thousand Six Hundred ', 0.00, 10, '2023-12-05', 11, '2024-11-04', 7, 1, 'Ruchismita Sen ', 'Aniruddh Sen ', 'Flat No -4,K-53, Kalachand Para Near Ration Shop Garia South 24 Parganas West Bengal 700135', '700135', '1994-02-13', '8777240137', 'sada9873@gmail.com', '573308217803', 'Fylps6874l', 0x[encoded data, 18270 characters], 0x[encoded data, 19518 characters], 0x[encoded data, 14574 characters], 0x[encoded data, 11302 characters], '685061', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-12-05 21:39:07', '2023-12-05 21:45:10');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(240, '#OPNAG-OW-00000222', '$2y$10$dBpuBJhMba4v8C10/2BnyOeOqVEM252PhIXGrGHfifNMjvVt2DEuu', '49.37.33.61', 'Rudraprasad Sinha ', 'Mr.Kausik Sinha', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Tentultala, Raghunathpur, Jhargram, West Bengal - 721507', NULL, 'legacysinharudra@gmail.com', '721507', NULL, NULL, '8967013160', 'legacysinharudra@gmail.com', '2004-02-12', '276237857420', NULL, 0x[encoded data, 18462 characters], 0x[encoded data, 18462 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J Block', 'J-18', '1205', 'J-18/ 1205, SP Sukhobrishti Housing Complex, Kolkata', '700135', 'f', '2', '1500', 'Nil', '12', 'f', 15000, 'Fifteen Thousand ', 28000, 'Twenty Eight Thousand ', 0.00, 0, '2024-01-01', 11, '2024-11-30', 11, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-12-10 18:33:34', '2023-12-10 18:39:49');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(241, '#OPNAG-OW-00000223', '$2y$10$/LuczqTrZSV6T5DmiMnJOe9hWuZEVoVl3A.fiQEH2pAiNUksWWYp.', '103.59.73.104', 'Amit Kumar Sen', 'Parimal Kanti Datta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '30 Jagadish Chandra Bose Road Ghola Panihati Sodpur North 24 Parganas West Bengal 700110', NULL, '', '700091', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1985-12-11', '951130322200', NULL, 0x[encoded data, 11222 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', 'D/298', 'D/298/404', 'D/298/404 Sp Shukhobrishti New Town Action Area 3 Kolkata West Bengal ', '700135', 'f', '2', NULL, NULL, NULL, 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-12-11 20:50:38', '2023-12-11 20:51:13'),
(242, '#OPNAG-OW-00000224', '$2y$10$c.Q9AXGXIfvdrGLfqLiJV.GHohcDI3BvRU3GH6mr83P4DGeAq.Gye', '152.58.182.60', 'Amit Kumar Sen', 'Parimal Kanti Datta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '30 Jagadish Chandra Bose Road Ghola Panihati Sodpur North 24 Parganas West Bengal 700110', NULL, '', '700091', NULL, NULL, '8348817467', 'imranhassi.0022@gmail.com', '1965-12-12', '951130322200', NULL, 0x[encoded data, 11222 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f', '2', NULL, NULL, NULL, 'f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-12-12 19:21:43', '2023-12-12 19:21:43');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(243, '#OPNAG-OW-00000225', '$2y$10$B.Mpk4niTM/wA5Zx.i7d8egO2.x/kCOLUGeY3/n76SAIeUtc2bRui', '152.58.181.20', 'Md. Nayab Nezam Ansari', 'Nezamuddin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Haider Road, Gowal Para, Titagarh, Kolkata 700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1996-10-26', '424242486996', NULL, 0x[encoded data, 13190 characters], 0x[encoded data, 13190 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', '46', '1404', 'gdhsgshfskhfbsh', '700119', 'f', '1', '700', 'k45/6', '9', 'f', 10000, 'Ten Thousand ', 20000, 'Twenty Thousand ', 0.00, 5, '2023-12-19', 11, '2024-11-18', 7, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'hyfvihvhivhvuhv\r\njkjbuhb9ub\r\nkmkoiuhu9', '2023-12-19 23:15:36', '2023-12-19 23:20:17');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(244, '#OPNAG-OW-00000226', '$2y$10$BrGEWjB.NAbWJGX.jpqGq.CXxtvZyln9TLNMpO1GG3c97rLxfLQt2', '103.24.87.124', 'Md Aamir Hassan', 'Mahboob Alam', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'New Area, Raja Baghicha, Rafiganj, Aurangabad, Bihar -824125', NULL, 'amirh.rfj@gmail.com', '824125', NULL, NULL, '9940134178', 'amirh.rfj@gmail.com', '1995-10-16', '383503754707', NULL, 0x[encoded data, 13286 characters], 0x[encoded data, 19262 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'J Block', 'J19', '1306', 'SP Sukhobrishti (Sparsh) , Action Area III, Newtown, Kolkata, WestBengal-700135', '700135', 'f', '2', '480', 'NA', '13', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2024-01-01', 11, '2024-11-30', 6, 1, 'SOUMI PARALI', 'SATYARANJAN PARALI', '13/2, Gitanjali Apartment, Anandpuri CO. OP. Society Ltd, Durgapur (m Corp), Barddhaman, WestBengal', '713213', '1998-10-20', '7384907757', 'amirh.rfj@gmail.com', '474502029193', 'DKIPP1002C', 0x[encoded data, 15366 characters], 0x[encoded data, 12070 characters], 0x[encoded data, 17998 characters], 0x[encoded data, 15142 characters], 'Service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '', '2023-12-29 18:37:51', '2023-12-29 19:00:16');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `openagreementconsumers`
--
ALTER TABLE `openagreementconsumers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `openagreementconsumers`
--
ALTER TABLE `openagreementconsumers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;
COMMIT;

