-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `safeboxind_safebox`
--

-- --------------------------------------------------------

--
-- Table structure for table `openagreementconsumers`
--

CREATE TABLE `openagreementconsumers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `owner_unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `consumer_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_aadhar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_father_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_pan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_service_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_guardian_aadhar_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_occupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_occupation` enum('s','j','self') COLLATE utf8mb4_unicode_ci DEFAULT 'j',
  `owner_permanent_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `correspondance_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_alternate_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_pin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `correspondance_pin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_image` longblob,
  `owner_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_dob` date DEFAULT NULL,
  `owner_aadhar_card` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_pan_card` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_aadhar_card_front_side` longblob,
  `owner_aadhar_card_back_side` longblob,
  `owner_pan_card_front_side` longblob,
  `owner_service_id_image` longblob,
  `is_active` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'y',
  `is_delete` enum('n','y') COLLATE utf8mb4_unicode_ci NOT NULL,
  `consumer_type` int(11) NOT NULL,
  `job_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Parmanant,Contractual,Daily Basic',
  `owner_service_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_court_check_pass` enum('y','up','r','n','c') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
  `with_copartner` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
  `copartner_relationship_status` enum('um','c','m','f','b','s','sp','o') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'f',
  `host_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `host_invited_by` int(11) DEFAULT NULL,
  `court_check_rec_certificate_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_agreement_rec_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_society_id` int(10) DEFAULT NULL,
  `owner_property_society_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_block_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_apartment_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_flat_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_property_pin` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` enum('f','v','h','rk','d','t') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'f',
  `property_structure` enum('1','2','3','4') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2',
  `size_property` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parking_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `furnishing_status` enum('u','s','f') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'f',
  `rental_amount` int(10) DEFAULT NULL,
  `rental_amount_word` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `security_money` int(10) DEFAULT NULL,
  `security_money_word` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maintenance_charge` decimal(10,2) DEFAULT NULL,
  `rental_amount_increase` int(10) DEFAULT NULL,
  `agreement_start_date` date DEFAULT NULL,
  `period_accomodation` int(10) DEFAULT NULL,
  `expire_agreement` date DEFAULT NULL,
  `lock_in_period_month` int(10) DEFAULT NULL,
  `termination_period_month` int(10) DEFAULT NULL,
  `rental_occupant_full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_pin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_dob` date DEFAULT NULL,
  `rental_occupant_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_aadhar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_pan_card_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_aadhar_back` longblob,
  `rental_occupant_aadhar_front` longblob,
  `rental_occupant_pan` longblob,
  `rental_occupant_profile_image` longblob,
  `rental_occupant_service_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_job_type` enum('s','j','self','o') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'j',
  `rental_occupant_guardian_occupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_aadhar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_pan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_service_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rental_occupant_guardian_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ps_id` int(11) DEFAULT NULL,
  `agreement_clause` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `openagreementconsumers`
--

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
(1, '#OPNAG-OW-00000001', 'YW5hbmRhLmNoYWtyYWJvcnR5MjAwOEBnbWFpbC5jb200NS4yNTAuMjQ3Ljcy', '45.250.247.72', 'Ananda Chakraborty', 'Ajoy Chakraborty', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Rajabazar Tram Depot, 78B, Acharya Prafulla Chandra Rd, Sealdah, Near, Kolkata, West Bengal 700009', NULL, 'asd@gmail.com', '700131', NULL, NULL, '9831496974', 'ananda.chakraborty2008@gmail.com', '1983-09-26', '987465413210', 'ARNPX9874A', 0x[encoded data, 19446 characters], 0x[encoded data, 19446 characters], 0x[encoded data, 19446 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'Block N', 'apart789', 'Flat787', 'Rajabazar Tram Depot, 78B, Acharya Prafulla Chandra Rd, Sealdah, Near, Kolkata, West Bengal 700009', NULL, 'f', '2', '7845', 'parking12', '4', 'f', 15600, 'fifteen thousand six hundred ', 25000, 'twenty five thousand ', 2500.00, 3, '2023-06-02', 9, '2024-03-02', 10, 8, 'Upal', 'demo', 'Rajabazar Tram Depot, 78B, Acharya Prafulla Chandra Rd, Sealdah, Near, Kolkata, West Bengal 700009', '700131', '2008-02-02', '8965745821', 'anandamca83@gmail.com', '987465413210', 'akolp9632a', 0x[encoded data, 28622 characters], 0x[encoded data, 28622 characters], 0x[encoded data, 28622 characters], 0x[encoded data, 28622 characters], 'asdasda21', 's', 'Business', 'Rajabazar Tram Depot, 78B, Acharya Prafulla Chandra Rd, Sealdah, Near, Kolkata, West Bengal 700009', '987465412010', 'asdad9874a', 'guarserv789', 'upalchatt@gmail.com', '9060305289', NULL, NULL, '2023-05-31 03:39:45', '2023-05-31 03:46:52');
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
(2, '#OPNAG-OW-00000002', 'bmF5YWIxOTk3QGdtYWlsLmNvbTEwMy4xODkuMTMwLjEwOQ==', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'nezamuddin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '333333333333', 'BZBPA0397R', 0x[encoded data, 10926 characters], 0x[encoded data, 10926 characters], 0x[encoded data, 10926 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'B', 'B-161', 'B-161/401', 'nsjcbuocoschasocanscjskc', 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-06-03 22:32:17', '2023-06-03 22:32:32');
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
(3, '#OPNAG-OW-00000003', '$2y$10$5WekwILY1SxIrhK2HbD5auCdxA1ZWXGWx5o7qiliPJGk98prptVgG', '103.189.130.109', 'Venketis kirshna ramchandra surya', 'Ramchandra surya', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'ARENA HOUSING COMPLEX', NULL, 'ordealmaker@gmail.com', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', 0x[encoded data, 11134 characters], 0x[encoded data, 7942 characters], 0x[encoded data, 10126 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'C', '165', '123', 'C - 165 123 SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '1', '580', '', '1', 'f', 18521, 'eighteen thousand five hundred and twenty one only ', 34981, 'thirty four thousand nine hundred and eighty one only ', 1100.00, 52, '2023-07-01', 11, '2024-06-01', 6, 1, 'TAMIM AKHTAR', 'Naim Akhtar', 'ARENA HOUSING COMPLEX\r\nSTREET-110\r\nBACK TO CENTAL MALL,NEWTOWN', '700156', '1997-01-06', '9674946680', 'tamimakhtar56@gmail.com', '375809892334', 'BSFPA8475H', 0x[encoded data, 10590 characters], 0x[encoded data, 9822 characters], 0x[encoded data, 13254 characters], 0x[encoded data, 8582 characters], 'Test123', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-05 22:28:33', '2023-06-05 23:35:08');
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
(4, '#OPNAG-OW-00000004', '$2y$10$s2pAc0xV09iJX1QFPm3qeOi6XgF8.K460pDuOlj6o6sQGvULOHslK', '103.189.130.109', 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', NULL, '', '700119', NULL, NULL, '7003359699', 'nayab1997@gmail.com', '1998-10-26', '355087659876', 'BZBPA0379R', 0x[encoded data, 13150 characters], '', 0x[encoded data, 15206 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'B', 'B-161', 'B-161/401', 'testesteetsdttetetdstdesryeryeyryreyrertyewyrertyeyretyrryery', NULL, 'f', '1', '720', 'N/A', '2', 'f', 18521, 'Eighteen Thousand Five Hundred and Twenty One Only ', 20000, 'Twenty Thousand ', 1100.00, 10, '2023-10-01', 11, '2024-09-01', 3, 1, 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1998-10-26', '7003359699', 'nayab1997@gmail.com', '393656133570', 'BZBPA0379R', '', '', '', '', 'teszt12345', 'self', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-08 19:47:56', '2023-06-08 19:49:55');
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
(5, '#OPNAG-OW-00000005', '$2y$10$b79N269KhMbZ4Gd8rXwnpuv8YlQ3DGnP2uqt5oZBErZl5DodOQxuu', '103.189.130.109', 'TAMIM AKHTAR', 'Naim Akhtar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'ARENA HOUSING COMPLEX, Action Area III , Newtown 700135', NULL, 'nayab1997@gmail.com', '700156', NULL, NULL, '9674946680', 'tamimakhtar56@gmail.com', '1996-01-06', '355087659876', 'BZBPA0379R', 0x[encoded data, 10766 characters], 0x[encoded data, 17934 characters], 0x[encoded data, 15454 characters], NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'Sukhobrishti housing complex', 'B', 'B-161', 'B-161/401', 'B-161/401, SP Sukhobrishti Ln, Action Area III, Newtown, New Town, West Bengal 700135', NULL, 'f', '1', '420', 'No', '4', 'f', 18521, 'Eighteen Thousand Five Hundred and Twenty One Only ', 20000, 'Twenty Thousand ', 1100.00, 3, '2023-05-01', 11, '2024-04-01', 6, 1, 'Md. Nayab Nezam Ansari', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '700119', '1998-10-26', '7003359699', 'nayab1997@gmail.com', '393656133570', 'BZBPA0379R', 0x[encoded data, 12518 characters], 0x[encoded data, 17526 characters], 0x[encoded data, 10454 characters], 0x[encoded data, 17830 characters], 'LOGO', 's', 'Nezamuddin Ansari', '295/3, Ali Harder Road, Gowalpara, Titaghar, Kol-700119', '000000000000', 'BZBPA0397R', 'jiskabhilo', 'nayab1997+test@gmail.com', '7980880043', NULL, NULL, '2023-06-09 14:45:58', '2023-06-09 15:20:19');
