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

START TRANSACTION;



--
-- Database: `acbptxvs_branch_system`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kra_pin` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `gender` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `county` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employer` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monthly_income` decimal(12,2) DEFAULT NULL,
  `emergency_contact_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emergency_contact_phone` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emergency_contact_relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_phone_verified` tinyint(1) NOT NULL,
  `is_email_verified` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `updated_at` datetime(6) NOT NULL,
  `last_login_at` datetime(6) DEFAULT NULL,
  `id_document` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `selfie` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utility_bill` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crb_report` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_statement` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `physical_address` text COLLATE utf8mb4_unicode_ci,
  `postal_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Kenya',
  `business_address` text COLLATE utf8mb4_unicode_ci,
  `business_registration_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_license` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_certificate` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_documents` json DEFAULT NULL,
  `is_verified` tinyint(1) DEFAULT '0',
  `verification_date` datetime(6) DEFAULT NULL,
  `verified_by` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logbook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_deed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nickname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital_invested` decimal(15,2) DEFAULT NULL,
  `cp_domicile` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `declaration_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domicile` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_turnover` decimal(15,2) DEFAULT NULL,
  `guarantor_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guarantor_mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guarantor_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guarantor_residence` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guarantor_tel` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_business_type` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `personal_pin` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `physical_location` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place_of_birth` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code_business` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recommender_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recommender_mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recommender_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recommender_residence` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recommender_tel` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `source_of_funds` text COLLATE utf8mb4_unicode_ci,
  `start_time` time DEFAULT NULL,
  `profile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `portfolio_manager_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_date` datetime(6) DEFAULT NULL,
  `assigned_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_limit` decimal(12,2) DEFAULT NULL,
  `credit_score` int DEFAULT NULL,
  `risk_rating` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kyc_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `kyc_verified_at` datetime(6) DEFAULT NULL,
  `kyc_verified_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'active',
  `suspension_reason` text COLLATE utf8mb4_unicode_ci,
  `suspended_at` datetime(6) DEFAULT NULL,
  `suspended_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(6) DEFAULT NULL,
  `deleted_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_activity_at` datetime(6) DEFAULT NULL,
  `login_attempts` int DEFAULT '0',
  `locked_until` datetime(6) DEFAULT NULL,
  `password_changed_at` datetime(6) DEFAULT NULL,
  `email_verified_at` datetime(6) DEFAULT NULL,
  `phone_verified_at` datetime(6) DEFAULT NULL,
  `terms_accepted_at` datetime(6) DEFAULT NULL,
  `privacy_accepted_at` datetime(6) DEFAULT NULL,
  `marketing_consent` tinyint(1) DEFAULT '0',
  `notification_preferences` json DEFAULT NULL,
  `language_preference` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'en',
  `timezone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'Africa/Nairobi',
  `two_factor_enabled` tinyint(1) DEFAULT '0',
  `two_factor_secret` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backup_codes` json DEFAULT NULL,
  `api_key` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_key_created_at` datetime(6) DEFAULT NULL,
  `referral_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referred_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_bonus_earned` decimal(10,2) DEFAULT '0.00',
  `total_loans_taken` int DEFAULT '0',
  `total_amount_borrowed` decimal(15,2) DEFAULT '0.00',
  `total_amount_repaid` decimal(15,2) DEFAULT '0.00',
  `current_outstanding` decimal(15,2) DEFAULT '0.00',
  `default_count` int DEFAULT '0',
  `last_loan_date` date DEFAULT NULL,
  `next_eligible_date` date DEFAULT NULL,
  `employment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_start_date` date DEFAULT NULL,
  `salary_account_bank` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_account_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_of_kin_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_of_kin_phone` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_of_kin_relationship` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_of_kin_id_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_branch` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mpesa_number` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preferred_payment_method` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'mpesa',
  `registration_fee_amount` decimal(10,2) DEFAULT NULL,
  `registration_fee_paid` tinyint(1) DEFAULT '0',
  `registration_fee_payment_date` datetime DEFAULT NULL,
  `registration_fee_payment_method` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_fee_receipt_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_fee_notes` longtext COLLATE utf8mb4_unicode_ci,
  `branch_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approval_reason` text COLLATE utf8mb4_unicode_ci,
  `approved_at` datetime DEFAULT NULL,
  `approved_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejected_at` datetime DEFAULT NULL,
  `rejected_by_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rejection_reason` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `is_staff`, `is_active`, `date_joined`, `id`, `email`, `phone_number`, `role`, `status`, `id_number`, `kra_pin`, `date_of_birth`, `gender`, `nationality`, `marital_status`, `address`, `city`, `county`, `postal_code`, `employer`, `business_name`, `business_type`, `monthly_income`, `emergency_contact_name`, `emergency_contact_phone`, `emergency_contact_relationship`, `pin`, `is_phone_verified`, `is_email_verified`, `created_at`, `updated_at`, `last_login_at`, `id_document`, `selfie`, `utility_bill`, `crb_report`, `bank_statement`, `physical_address`, `postal_address`, `country`, `business_address`, `business_registration_number`, `business_license`, `tax_certificate`, `other_documents`, `is_verified`, `verification_date`, `verified_by`, `verified_by_id`, `logbook`, `title_deed`, `signature`, `nickname`, `capital_invested`, `cp_domicile`, `declaration_name`, `domicile`, `expected_turnover`, `guarantor_id`, `guarantor_mobile`, `guarantor_name`, `guarantor_residence`, `guarantor_tel`, `other_business_type`, `personal_pin`, `physical_location`, `place_of_birth`, `postal_code_business`, `recommender_id`, `recommender_mobile`, `recommender_name`, `recommender_residence`, `recommender_tel`, `registration_date`, `source_of_funds`, `start_time`, `profile_image`, `portfolio_manager_id`, `assigned_date`, `assigned_by_id`, `credit_limit`, `credit_score`, `risk_rating`, `kyc_status`, `kyc_verified_at`, `kyc_verified_by_id`, `account_status`, `suspension_reason`, `suspended_at`, `suspended_by_id`, `notes`, `created_by_id`, `updated_by_id`, `deleted_at`, `deleted_by_id`, `last_activity_at`, `login_attempts`, `locked_until`, `password_changed_at`, `email_verified_at`, `phone_verified_at`, `terms_accepted_at`, `privacy_accepted_at`, `marketing_consent`, `notification_preferences`, `language_preference`, `timezone`, `two_factor_enabled`, `two_factor_secret`, `backup_codes`, `api_key`, `api_key_created_at`, `referral_code`, `referred_by_id`, `referral_bonus_earned`, `total_loans_taken`, `total_amount_borrowed`, `total_amount_repaid`, `current_outstanding`, `default_count`, `last_loan_date`, `next_eligible_date`, `employment_status`, `employment_start_date`, `salary_account_bank`, `salary_account_number`, `next_of_kin_name`, `next_of_kin_phone`, `next_of_kin_relationship`, `next_of_kin_id_number`, `bank_name`, `bank_branch`, `account_number`, `account_name`, `mpesa_number`, `preferred_payment_method`, `registration_fee_amount`, `registration_fee_paid`, `registration_fee_payment_date`, `registration_fee_payment_method`, `registration_fee_receipt_number`, `registration_fee_notes`, `branch_id`, `approval_reason`, `approved_at`, `approved_by_id`, `rejected_at`, `rejected_by_id`, `rejection_reason`) VALUES
('!Q0qJ0YWyfq850V8qQ1bvThxEADyYMtIGAg38xUxk', NULL, 0, '0725673713', 'DAVID', 'KIBE GACHUGU', 0, 1, '2025-10-01 14:02:54.756637', '0031b46eb5fc43afaf471ad51188d7fd', '62none@none.com', '0725673713', 'borrower', 'active', '25325034', NULL, '1987-01-04', 'M', 'KENYAN', 'married', NULL, 'THIKA', 'None', '2788', 'None', 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-01 14:02:54.757984', '2025-10-13 09:11:21.321620', NULL, 'kyc/id_documents/FRONT_I_U00D9o2.D.jpeg', 'kyc/selfies/PHOTO_tG4ZPwx.jpeg', 'kyc/utility_bills/SALE_AGREEMENT.jpeg', NULL, 'kyc/bank_statements/DRIVERS_LICENCE.jpeg', NULL, NULL, 'Kenya', 'BIDCO AREA\r\nJACARANDA TUK TUK SACCO', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!x1BtNlS8mvY4ng3gLHcYu8Gd8h6DzSqb7pBTGzYW', NULL, 0, '0722363382', 'PETER', 'IRUNGU MAINA', 0, 1, '2025-09-05 11:32:20.425969', '07fd334029854de8a7a84c0d9806d913', '56NONE@none', '0722363382', 'borrower', 'active', '23682283', NULL, '1984-03-09', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '00000', NULL, 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-05 11:32:20.426613', '2025-10-13 09:22:33.345079', NULL, 'kyc/id_documents/FRONTID001_FNorQXp.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_10_DkPsqwo.27.29.jpeg', 'kyc/utility_bills/LOGBK001.jpeg', NULL, 'kyc/bank_statements/REGFORM003.jpeg', NULL, NULL, 'Kenya', 'KENOL', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!2QKoGcDOfE5bMxBY2msY5uc76lYM0TdCS4sXrq4B', NULL, 0, '+254729160613', 'PETER', 'WAWERU NJIRAINI', 0, 1, '2025-09-26 09:07:06.387742', '0ac33a5a03af412e92974a4cd5c12633', 'WAWERUAV@gmail.com', '+254729160613', 'borrower', 'active', '25469751', NULL, '1985-02-02', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '', NULL, 'FRUIT VENDOR/ TRANSPORT', 'retail', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-26 09:07:06.388639', '2025-10-13 09:22:51.865997', NULL, 'kyc/id_documents/FRONT_I_ApRu8Pd.D.jpeg', 'kyc/selfies/PHOTO_MYVj16V.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'JUJA JKUAT GATE A', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$NWDmSfkdIuyyguQWSDB5mc$lXA17mtG/CxM5EwEvRzu0M+ztywZ4QnwqUOIVvfZV90=', NULL, 0, '0719140590', 'DANIEL', 'KALEWA WAITHAKA', 0, 1, '2025-07-28 12:06:14.594244', '0d19fac990364dad9d10771270cfb439', '26NONE@none', '0719140590', 'borrower', 'active', '28651872', NULL, '1991-09-14', 'M', 'Kenyan', 'married', 'MWANA WIKIO', 'THIKA', 'MURANGA', '0000', 'SELF', 'NA', 'services', 20000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 12:06:14.834015', '2025-10-13 09:14:40.098484', NULL, 'kyc/id_documents/FRONTID1_ZvzZiy2.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_09_inyZyhk.41.21.jpeg', 'kyc/utility_bills/AFFIDAVIT02.jpeg', '', 'kyc/bank_statements/LGBK1.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$xeDg6c0cbZtzG0vd4N45SH$DuDAlEJUUdqcd0Udxe76xiW7X65gBl9FNSCszMf8ERk=', NULL, 0, '0724931303', 'JOHN', 'IRUNGU NJUGUNA', 0, 1, '2025-07-28 09:11:25.332942', '18c1f9f078c549f3a6c725528e9d52ed', '14NONE@none', '0724931303', 'borrower', 'active', '21989413', NULL, '1978-09-28', 'M', 'Kenyan', 'married', 'KIGANJO', 'THIKA', 'KIAMBU', '0000', 'SELF', 'N/A', 'transport', 4000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 09:11:25.561766', '2025-10-13 09:17:51.996569', NULL, 'kyc/id_documents/ID_F.jpeg', 'kyc/selfies/PASSPORT_0eTkIdg.jpeg', 'kyc/utility_bills/AFF_2.jpeg', '', 'kyc/bank_statements/LOGBOOK_rI8sKbS.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$o6vV8tkxFy2N9ZQYf4PGn0$urFb73tPiLg5sh77FOKMH/E2mg/k4aoJFGM0rUXwG5g=', NULL, 0, '+254769746711', 'WAMBUA', 'NDUNGE', 0, 1, '2025-07-22 13:13:39.254230', '1a5a1dcb8632426b9514a0111fc3301c', 'NONE@none', '+254769746711', 'borrower', 'active', '32299585', NULL, '1994-11-09', 'M', 'Kenyan', 'married', 'KIGANJO B.A.T', 'THIKA', 'KIAMBU', '01000', 'SELF', 'NONE', 'transport', 15000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-22 13:13:39.489359', '2025-10-13 09:25:10.157826', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_15.00.04_1.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_14.59.13.jpeg', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$RiMwdpdHDnFNb3IiVWt3gq$yeiIp8yStASXCgzYSq8ZqW0VHP6lnPFgElX4Up0OydY=', NULL, 0, '0797231439', 'GEORGE', 'OUMA OTIO', 0, 1, '2025-07-28 12:25:59.700042', '25db2b5087ef4a0c9910c743e30bb396', '28NONE@none', '0797231439', 'borrower', 'active', '10842964', NULL, '1970-12-19', 'M', 'Kenyan', 'married', 'KISII', 'THIKA', 'KIAMBU', '0000', 'LABOURER', 'NA', 'services', 35000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 12:25:59.952956', '2025-10-13 09:14:55.577833', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_13.29.10.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_14.11.44.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_13.38.27_4.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_13.30.05.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$zhdkhy2i0K8LeIi6c3Hz33$7Jw3R2tIWeiolLGeBj7NlIPB/bHzWOaQLjprBhu7BO8=', NULL, 0, '0719370013', 'LUICER', 'MUTHEU KIILU', 0, 1, '2025-07-28 11:46:25.482727', '274fb3914c9944f0947a59727198d3f3', '24NONE@none', '0719370013', 'borrower', 'active', '28677644', NULL, '1991-11-28', 'F', 'Kenyan', 'married', 'LANDLESS', 'THIKA', 'KIAMBU', '0000', 'SELF', 'LUICER AUTO SPARE', 'retail', 13000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 11:46:25.805913', '2025-10-13 09:19:44.713558', NULL, 'kyc/id_documents/LUICER_FRONT_ID.jpeg', 'kyc/selfies/LUICER_.jpeg', 'kyc/utility_bills/LUICER_BACK_PAGE_ID.jpeg', '', 'kyc/bank_statements/LUICER_BACK_PAGE_ID.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!PFaSGwhb2guTJvuiEpakQHGjPaS4ay7X2IbOcFXM', NULL, 0, '+254705241687', 'HARON', 'GITAU MBAU', 0, 1, '2025-09-25 09:43:55.079686', '2a75f8e73f4f4b41a4aa50094ecf81b3', 'haronmbau3@gmailcom', '+254705241687', 'borrower', 'active', '31033306', NULL, '1993-03-05', 'M', 'Kenyan', 'married', NULL, 'C', NULL, '', NULL, 'LABORATORY', 'services', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-25 09:43:55.080585', '2025-10-13 09:16:17.394999', NULL, 'kyc/id_documents/I_bi823qS.D_F.jpeg', 'kyc/selfies/PHOTO_7joNsnh.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'GITAMAIYO BUILDING', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!4nqvOHJMzKtgw3v0LTN5Ljd1oQ6g2Bjh2lmxLwWZ', NULL, 0, '+254721627626', 'MARY', 'NDUKU MUIRURI', 0, 1, '2025-09-20 09:19:55.353720', '31673e3f254348a6aa4f4205f71e8f5c', 'mwalimu0@none.com', '+254721627626', 'borrower', 'active', '8043337', NULL, '1963-01-01', 'F', 'Kenyan', 'single', NULL, 'MURANGA', NULL, '', NULL, 'RETIRED TEACHER', 'agriculture', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-20 09:19:55.354529', '2025-10-13 09:22:15.175578', NULL, 'kyc/id_documents/P052080880Z.pdf', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_14.19.12_2.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'NONE', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$1QbuqqZhhtLFcuIpSo0bfd$V9/os+T9rc+5NsLmwpFSkiTsEFEl5avdPj2VcpY/ZMo=', NULL, 0, '+254704283439', 'THOMAS', 'NJOROGE WANYORO', 0, 1, '2025-07-26 10:42:05.267840', '32c3eb16a5464e40b34c817a8dc76a17', '10NONE@none', '+254704283439', 'borrower', 'active', '24236332', NULL, '1986-01-07', 'M', 'Kenyan', 'married', 'MWANA WIKIO', 'THIKA', 'MURANGA', '01000', 'SELF', 'N/A', 'services', 15000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-26 10:42:05.517482', '2025-10-13 09:24:58.426027', NULL, 'kyc/id_documents/THOMAS_NJOROGE_KANYORO_front_I_AbwvMkC.D.jpeg', 'kyc/selfies/THOMAS_NJOROGE_KANYORO_photo.jpeg', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!USTs0FVQdRaWO6E6zF79NGbTgNggw7UL3ShZC10l', NULL, 0, '+254113422515', 'SIMON', 'KURIA MWANGI', 0, 1, '2025-09-11 10:23:56.884093', '346db61857324d05bf43bb69aa145d83', 'simonb067j@gmail.com', '+254113422515', 'borrower', 'active', '21475593', NULL, '1900-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '00100', NULL, 'TUK TUK B067J', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-11 10:23:56.884858', '2025-10-13 09:23:32.721685', NULL, 'kyc/id_documents/I.D_ABSTRACT.jpeg', 'kyc/selfies/PHOTO_xiXfFlR.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'THIKA- KIGANJO', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$XHEjMQtYiyCgalrCq3gcUq$Ht1QPosv+7+NK2B/liL/ytBbjnHeu4w3ofEGIs8ojKU=', NULL, 0, '0795837194', 'VICTOR', 'MURIITHI MWANG', 0, 1, '2025-07-28 09:33:11.220143', '34e2eb40e33446eb9e24db894f99d5f0', '16NONE@none', '0795837194', 'borrower', 'active', '37608105', NULL, '1999-03-26', 'M', 'Kenyan', 'married', 'KIGANJO CORNER 1', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 1500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 09:33:11.434694', '2025-10-13 09:24:48.501938', NULL, 'kyc/id_documents/VICTOR_I.D_F.jpeg', 'kyc/selfies/VICTOR_MURIITHI.jpeg', 'kyc/utility_bills/VICTOR_SALE_AGREEMENT_2.jpeg', '', 'kyc/bank_statements/VICTOR_LOG_BOOK.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$PJDwtaXRW7XdPeSm6JsFvf$4HbWenjeUv2YkpXzNZbzHgETJmC26NdgXPOFFYtaptI=', NULL, 0, '0708789138', 'KELVIN', 'MURIITHI MAINA', 0, 1, '2025-07-28 10:17:13.720093', '388cdab4ecf34fccbae740876c6f1186', '18NONE@none', '0708789138', 'borrower', 'active', '31742345', NULL, '1995-01-19', 'M', 'Kenyan', 'married', 'NGOINGWA', 'THIKA', 'KIAMBU', '200', 'SELF', 'N/A', 'transport', 1500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 10:17:13.942226', '2025-10-13 09:19:35.373696', NULL, 'kyc/id_documents/FRNTID.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_09.07.37.jpeg', 'kyc/utility_bills/AFFIRDAT3.jpeg', '', 'kyc/bank_statements/LOGBOK.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!E1scXkCYGyZizuEso8abjZ6WltQPOSMBGklOUJqX', NULL, 0, '0740091087', 'FAITH', 'MWENDE NZAU', 0, 1, '2025-10-27 13:52:28.758503', '38afce407ee1474ea610b35aa5b5f353', 'fmn36896735@gmailcom', '0740091087', 'borrower', 'active', '36896735', NULL, '1999-12-24', 'F', 'Kenyan', 'married', NULL, 'THIKA', NULL, '01000', NULL, 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-27 13:52:28.759964', '2025-10-27 13:52:28.768412', NULL, 'kyc/id_documents/ID_FRONT.jpeg', 'kyc/selfies/PHOTO_QukRPig.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'KCT( WORKS AT CANNERY DEL-MONTE)', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!3FPx2qWnKcmWMcgpfKcqV2yRaSZg0t8WvqgkyUev', NULL, 0, '+254726016974', 'JOSEPH', 'KARIUKI KAMAU', 0, 1, '2025-10-18 21:21:24.766775', '3a8ef7a88fa840bc85932c499ec2ba0a', 'kario@gmailcom', '+254726016974', 'borrower', 'active', '13511343', NULL, '1975-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '01000', NULL, 'TRANSPORT', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-18 21:21:24.767570', '2025-10-18 21:21:24.772982', NULL, 'kyc/id_documents/id_front.jpeg', 'kyc/selfies/Photo.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'THIKA TOWN', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!7zV2kn9kcvSp7xHTBP8iGHEwDHVactWtTyDRL4X3', NULL, 0, '+254725883450', 'SAMUEL', 'GATHINJI KABUNYI', 0, 1, '2025-09-25 15:07:41.555917', '454116d085c34f8a9dd36ec627203069', 'GATHINJI@gmail.com', '+254725883450', 'borrower', 'active', '23391726', NULL, '1984-06-30', 'M', 'Kenyan', 'divorced', NULL, 'THIKA', NULL, '', NULL, 'DESIGN, PRINTING AN COPY', 'manufacturing', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-25 15:07:41.557421', '2025-10-13 09:23:11.075310', NULL, 'kyc/id_documents/FRONT_ID.jpeg', 'kyc/selfies/PHOTO_M6BE5nd.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'TABBY HOUSE', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!pI1QPqf1tGJMekSn2r3Kgtx1GYHvRH21VzXqiOEC', NULL, 0, '+254726703249', 'STEPHEN', 'KIAI MUGAMBI', 0, 1, '2025-09-26 09:34:35.475075', '45a9dab7cdaf4d77b0091038cdb66f18', 'WAABIE@gmailcom', '+254726703249', 'borrower', 'active', '11565001', NULL, '1972-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '', NULL, 'TRNSPORT', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-26 09:34:35.476431', '2025-10-13 09:23:52.273729', NULL, 'kyc/id_documents/FRONT_I_sMDgHBV.D.jpeg', 'kyc/selfies/PHOTO_okEUwZR.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'ST PATRICKS CATHOLIC CHURCH GATE - UNIVERSAL', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$l6E9i6DHZPIw1Zuc2eMeyW$MKRCZ9NYYk4tqa2FT+0TEVZkW8bJ1PZslm74B14UQv8=', NULL, 0, '0729718742', 'JAMES', 'GATANA GAKURU', 0, 1, '2025-07-28 10:02:46.665304', '467b653e74934290a79ba99957a6ff55', '17NONE@none', '0729718742', 'borrower', 'active', '26081679', NULL, '1985-01-01', 'M', 'Kenyan', 'married', 'SEAGULL', 'JUJA', 'KIAMBU', '0000', 'SELF', 'N/A', 'transport', 3000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 10:02:46.880797', '2025-10-13 09:17:19.405467', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_15.19.26.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_15.17.25.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_15.19.04.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_15.18.26.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$zW7BbUxcIB6m7jPsxYauKx$SHhJhl7Zi55ouxKYp4DeDhtJ6DOzVI9pCB6z/9S+19A=', NULL, 0, '0723084073', 'HELLEN', 'MUTHONI KIRUTHU', 0, 1, '2025-07-28 08:47:42.944653', '6144925f468c460e9a85224bd899dc78', '12NONE@none', '0711578777', 'borrower', 'active', '26097006', NULL, '1986-12-25', 'F', 'Kenyan', 'married', 'SKY', 'THIKA', 'KIAMBU', '630', 'SELF', 'NONE', 'services', 1000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 08:47:43.170421', '2025-10-13 09:15:21.503039', NULL, 'kyc/id_documents/FRONTID.jpeg', 'kyc/selfies/PASSPORT_OVGSprc.jpeg', 'kyc/utility_bills/AFFIRDAVIT.jpeg', '', 'kyc/bank_statements/LOGBK.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!DMNPXdYUDbfl6USIzhb8RhLPqPC9bal3fEcZFKPc', NULL, 0, '0740243962', 'ERICK', 'MUTUKU KIOKO', 0, 1, '2025-10-23 11:22:56.798405', '616cd7d9fc3649469788f9c0bee8e479', '82none@none.com', '0740243962', 'borrower', 'active', '37249335', NULL, '1998-06-18', 'M', 'Kenyan', 'married', NULL, 'THIKA', 'KIAMBU', 'NA', 'SELF', 'NA', 'transport', 30000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-10-23 11:22:56.799024', '2025-10-27 12:49:40.793915', NULL, 'kyc/id_documents/F_ID_lOIytmK.jpeg', 'kyc/selfies/PHOTO_ntwW46s.jpeg', 'kyc/utility_bills/SALE_AGREEMENT_3qIGV2J.jpeg', NULL, 'kyc/bank_statements/VEHICLE_1.jpeg', NULL, NULL, 'Kenya', 'KCT', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$LTOpRGmgfadyJupKHZunG7$KBmd7ae/BrDdh1qyeWMFjInjJhGzZC+wu7mZ4ToGYIk=', NULL, 0, '0721121805', 'GIDEON MAINGI MAUNDU', 'AINGI NMAUNDU', 0, 1, '2025-07-24 10:59:45.389646', '664abc472b0243d0bed2b24f6dc2cf3f', '6NONE@none', '0721121805', 'borrower', 'active', '22125381', NULL, '1980-04-06', 'M', 'Kenyan', 'married', 'THIKA TOWN', 'THIKA', 'KIAMBU', '0000', 'SELF', 'N/A', 'transport', 3000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-24 10:59:45.601093', '2025-10-13 09:16:07.947416', NULL, 'kyc/id_documents/GIEON_I.D.jpeg', 'kyc/selfies/GIDEON_MAINGI_MAUNDU_PHOTO.jpeg', 'kyc/utility_bills/AFFIDAVIT06.jpeg', '', 'kyc/bank_statements/LOG_BOOK2.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$1KPyIIsAh3WEPwcafYm1de$1ZY6VB8r1+CJehZq8Uco1x98Hr/aJMS7bAmAnZ7DOjQ=', NULL, 0, '0704967496', 'WEBSTAR', 'MANYARA OMWERI', 0, 1, '2025-07-28 12:17:06.051303', '69851a6316044ca5a14bca6d6c862473', '27NONE@none', '0704967496', 'borrower', 'active', '3989919', NULL, '2001-12-15', 'M', 'Kenyan', 'single', 'NGOINGWA', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 12000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 12:17:06.263716', '2025-10-13 09:25:19.686084', NULL, 'kyc/id_documents/ID392.jpeg', 'kyc/selfies/WEBSTAR.jpeg', 'kyc/utility_bills/G2.jpeg', '', 'kyc/bank_statements/LOGBKMGN065L.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$vwmHjcQTXRFVbn1L6EUlUO$QmC95MhtBhowaKvYO+hhe1MYVHlyVRBqbNxkEbSms5w=', NULL, 0, '0791423121', 'JAMES', 'NDEGWA WANJIKU', 0, 1, '2025-07-28 10:46:54.652825', '6c91378cb2ff447188cf1291e859440c', '20NONE@none', '0791423121', 'borrower', 'active', '32508511', NULL, '1994-07-05', 'M', 'Kenyan', 'married', 'LANLESS OPPOSITE ECOMATT SUPERMARKET', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 1500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 10:46:54.861517', '2025-10-13 09:17:31.547522', NULL, 'kyc/id_documents/FRONTID008.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_15.04.59.jpeg', 'kyc/utility_bills/AFFIRDAVIT0013.jpeg', '', 'kyc/bank_statements/LOGBK007.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$VFbH85j57JgCIXEcarBZYW$nhhSe00n789pIS+clCLmRzOPkMifbFgotkiCWEWyM5U=', NULL, 0, '07592233546', 'ROGERS', 'OCHIENG OTIATO', 0, 1, '2025-07-24 07:19:57.153940', '7122454159134c9db4831f852843739d', '4NONE@none', '07592233546', 'borrower', 'active', '38557400', NULL, '1990-08-18', 'M', 'Kenyan', 'single', 'THUKA', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NONE', 'transport', 6000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-24 07:19:57.366093', '2025-10-13 09:23:01.635147', NULL, 'kyc/id_documents/FRONTID1.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_09.41.21.jpeg', 'kyc/utility_bills/LGBK1.jpeg', '', 'kyc/bank_statements/AFFIDAVIT02.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$EuPQAMEcU3IxxrZocd5stD$j8yRrFXiuzPzQ2Djibr2FIYx+q11LTsEz1ADfqXWymY=', '2025-10-31 16:05:12.478211', 0, 'MICHAEL', 'JAMES MWAGO', 'THIKA', 1, 1, '2025-09-12 07:28:06.439739', '733e1e7a62274214a66b73afe62b4eff', 'branchbsadvance@gmail.com', '+254757206664', 'loan_officer', 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-12 07:28:06.690734', '2025-10-31 16:05:12.478997', NULL, '', '', '', NULL, '', NULL, NULL, 'Kenya', NULL, NULL, '', '', '[]', 1, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$OcNDbWaYHyZvw0lgu1M9vV$NqUfRiYv6xHvKGkmBuc+c0gubcgmK3XnmbCDRc9hY90=', NULL, 0, '0794198314', 'PAUL', 'MBOTE WARUIRU', 0, 1, '2025-07-24 10:03:10.708665', '76fa9b91aea34852a45e6a93576aa495', 'WARUIRUPAUL79@gmail.com', '0794198314', 'borrower', 'active', '1997985', NULL, '1962-03-23', 'M', 'Kenyan', 'married', '3134', 'THIKA', 'KIAMBU', '01002', 'SELF', 'PENSION', 'services', 22000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-24 10:03:10.922986', '2025-10-13 09:22:24.868330', NULL, 'kyc/id_documents/FRONTID002.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_10.46.07.jpeg', 'kyc/utility_bills/AFFIRDAVIT004.jpeg', '', 'kyc/bank_statements/LOGBK004.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!chS7LFuDJ6aQ58OZA8XfGiZGX7pB1Zm7iZCnSAUT', NULL, 0, '0706611455', 'WILLIAM', 'MUGUNA M\'THARE', 0, 1, '2025-10-27 17:26:27.951413', '7922c46ce0bd44d091835cb6c9523f34', '84none@none.com', '0706611455', 'borrower', 'active', '26370031', NULL, '1988-11-19', 'M', 'Kenyan', 'married', NULL, 'THIKA', 'None', '', 'None', 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-27 17:26:27.952390', '2025-10-28 08:48:01.793112', NULL, 'kyc/id_documents/ID_front.jpeg', 'kyc/selfies/photo_VEzltiK.jpeg', '', NULL, '', NULL, NULL, 'Kenya', '', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$cImXuIYV2BegNAHxL4UdUi$1r8g/gNOeNKRo2HqJ3dx7wXD7EaIZD/uGFf81Fm0Ut8=', NULL, 0, '0708255544', 'JULIUS', 'NJOROGE NDUATI', 0, 1, '2025-07-28 11:55:30.968969', '7b8c5553846b40ac869a0ec4ed493050', '25NONE@none', '0708255544', 'borrower', 'active', '30458560', NULL, '1992-04-18', 'M', 'Kenyan', 'married', 'MAKENJI', 'THIKA', 'MURANGA', '6295', 'SELF', 'NA', 'agriculture', 2000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 11:55:31.180381', '2025-10-13 09:19:24.173840', NULL, 'kyc/id_documents/FRONTID008_pgta1Ed.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_14.56.19.jpeg', 'kyc/utility_bills/AFFIRDAVIT012.jpeg', '', 'kyc/bank_statements/LOGBK006.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$21YFzK33hef7WCMIhpzLWr$81XWrH1qJ2oPxpK6V4As0saSfupdAxWaelKYZKGJVH8=', NULL, 0, 'phin', 'Phin', 'Client', 0, 1, '2025-07-22 11:58:08.835653', '8b1bce3d286744498fdbeb27fca0819c', 'phin@example.com', '+254114565176', 'borrower', 'active', '40178864', NULL, '2025-10-28', 'M', 'Kenyan', 'single', NULL, 'None', 'None', 'None', 'None', 'None', 'technology', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-07-22 11:58:08.836010', '2025-11-01 05:59:17.551444', NULL, 'kyc/id_documents/images_POCx0Wt.png', 'kyc/selfies/images_mSbICk8.png', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$QAceNvH7c5agGr2bc5q5lH$eeq+9B9KL/hPCA3MZSkZFe19dysavHJ+OjNMpLPv0Aw=', NULL, 0, '0791660095', 'FRANCIS', 'KIARIE NJAMBI', 0, 1, '2025-07-28 11:18:17.184461', '91374a8782fd4475acd99a843cc663fa', '22NONE@none', '0791660095', 'borrower', 'active', '42701209', NULL, '2002-05-02', 'M', 'Kenyan', 'married', 'KABATI', 'THIKA', 'MURANGA', '0000', 'SELF', 'NA', 'transport', 3000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 11:18:17.463987', '2025-10-13 09:15:50.377671', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_11.59.35_3.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_11.59.36.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_12.15.03_3.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_12.38.34.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$WGqQtGV3vcmxnLAORizAxK$ZkE6ryb7MxtNhltXSIOlkPIwzGhAnce+O96BLAhP+iw=', NULL, 0, '+254711578777', 'HELLEN', 'UTHONI KIRUTHU', 0, 1, '2025-07-24 05:53:24.391868', '934eba909d66470896a26e6dbc4ca962', '1NONE@none', '+254711578777', 'borrower', 'active', '12465874', NULL, '1973-01-01', 'F', 'Kenyan', 'single', 'GRAY STONE', 'THIKA', 'MURANGA', '', '', 'N/A', 'services', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-07-24 05:53:24.632107', '2025-10-13 09:16:37.801092', NULL, 'kyc/id_documents/BACK-ID.jpeg', 'kyc/selfies/PASSPORT_PHOTO.jpeg', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!R9awd27kOcj7tQIbUnwtszZOD7WoT1S8Wl4bC8MX', NULL, 0, '+254715561198', 'TITUS', 'RIITHO WAIRURA', 0, 1, '2025-09-22 16:28:33.630340', '9971f8e9a0c948608b5df206ee289c22', 'titusriitho@gmail.com', '+254715561198', 'borrower', 'active', '29180310', NULL, '1990-02-20', 'M', 'Kenyan', 'married', NULL, 'THIKA', 'None', '', 'None', 'TRANSPORT', 'retail', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-22 16:28:33.631155', '2025-09-25 10:54:41.370159', NULL, 'kyc/id_documents/I.D_F.jpeg', 'kyc/selfies/TITUS_RIITHO_WAIRURA.jpeg', '', NULL, '', NULL, NULL, 'Kenya', '', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '4909a2220b14420ebd5d2bbeaa42b93f', NULL, NULL, NULL, NULL, NULL, NULL),
('!e99E42Z2RYVlwC7rOKJbCevTrmAph3trYUT68wA4', NULL, 0, '0701258767', 'SAMUEL', 'NJUGUNA GATIMU', 0, 1, '2025-09-03 15:51:39.647860', '9ab3109e0cc547118d5e2ea917e01ddf', '53NONE@none', '0701258767', 'borrower', 'active', '26848233', NULL, '1999-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '00000', NULL, 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-03 15:51:39.648878', '2025-10-13 09:23:22.333822', NULL, 'kyc/id_documents/FRED_MWAURA__MBUGUA_UPLOADS_SALES_AGREEMENT.jpg', 'kyc/selfies/FRED_MWAURA__MBUGUA_UPLOADS_BACK_ID.jpg', 'kyc/utility_bills/FRED_MWAURA__MBUGUA_UPLOADS_SALES_AGREEMENT.jpg', NULL, 'kyc/bank_statements/FRED_MWAURA__MBUGUA_UPLOADS_BACK_ID.jpg', NULL, NULL, 'Kenya', 'MITUMBIRI', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$5dmiakLcZCwJMRXVOPW1aS$sPnDhCNhO8DVpOG9mevrda6i8oxNZnyG5arYM2lgIIY=', NULL, 0, '0708493674', 'JOHN', 'KIOKOMWIKALI', 0, 1, '2025-07-28 10:27:30.617695', '9ad825df08fb420f9df71c8a3b1e6b34', '19NONE@none', '0708493674', 'borrower', 'active', '23908272', NULL, '1984-06-12', 'M', 'Kenyan', 'married', 'MWANA WIKIO', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 12000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 10:27:30.824854', '2025-10-13 09:18:41.510223', NULL, 'kyc/id_documents/ID_F_vwFoeFR.jpeg', 'kyc/selfies/PHOTO.jpeg', 'kyc/utility_bills/AFF_6.jpeg', '', 'kyc/bank_statements/REG_4.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `users` (`password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `is_staff`, `is_active`, `date_joined`, `id`, `email`, `phone_number`, `role`, `status`, `id_number`, `kra_pin`, `date_of_birth`, `gender`, `nationality`, `marital_status`, `address`, `city`, `county`, `postal_code`, `employer`, `business_name`, `business_type`, `monthly_income`, `emergency_contact_name`, `emergency_contact_phone`, `emergency_contact_relationship`, `pin`, `is_phone_verified`, `is_email_verified`, `created_at`, `updated_at`, `last_login_at`, `id_document`, `selfie`, `utility_bill`, `crb_report`, `bank_statement`, `physical_address`, `postal_address`, `country`, `business_address`, `business_registration_number`, `business_license`, `tax_certificate`, `other_documents`, `is_verified`, `verification_date`, `verified_by`, `verified_by_id`, `logbook`, `title_deed`, `signature`, `nickname`, `capital_invested`, `cp_domicile`, `declaration_name`, `domicile`, `expected_turnover`, `guarantor_id`, `guarantor_mobile`, `guarantor_name`, `guarantor_residence`, `guarantor_tel`, `other_business_type`, `personal_pin`, `physical_location`, `place_of_birth`, `postal_code_business`, `recommender_id`, `recommender_mobile`, `recommender_name`, `recommender_residence`, `recommender_tel`, `registration_date`, `source_of_funds`, `start_time`, `profile_image`, `portfolio_manager_id`, `assigned_date`, `assigned_by_id`, `credit_limit`, `credit_score`, `risk_rating`, `kyc_status`, `kyc_verified_at`, `kyc_verified_by_id`, `account_status`, `suspension_reason`, `suspended_at`, `suspended_by_id`, `notes`, `created_by_id`, `updated_by_id`, `deleted_at`, `deleted_by_id`, `last_activity_at`, `login_attempts`, `locked_until`, `password_changed_at`, `email_verified_at`, `phone_verified_at`, `terms_accepted_at`, `privacy_accepted_at`, `marketing_consent`, `notification_preferences`, `language_preference`, `timezone`, `two_factor_enabled`, `two_factor_secret`, `backup_codes`, `api_key`, `api_key_created_at`, `referral_code`, `referred_by_id`, `referral_bonus_earned`, `total_loans_taken`, `total_amount_borrowed`, `total_amount_repaid`, `current_outstanding`, `default_count`, `last_loan_date`, `next_eligible_date`, `employment_status`, `employment_start_date`, `salary_account_bank`, `salary_account_number`, `next_of_kin_name`, `next_of_kin_phone`, `next_of_kin_relationship`, `next_of_kin_id_number`, `bank_name`, `bank_branch`, `account_number`, `account_name`, `mpesa_number`, `preferred_payment_method`, `registration_fee_amount`, `registration_fee_paid`, `registration_fee_payment_date`, `registration_fee_payment_method`, `registration_fee_receipt_number`, `registration_fee_notes`, `branch_id`, `approval_reason`, `approved_at`, `approved_by_id`, `rejected_at`, `rejected_by_id`, `rejection_reason`) VALUES
('pbkdf2_sha256$1000000$Ltg3GEEWtQsHHrMINqIN8u$TJQVcFLvJ6zq/ferLSenJTpLgGKKp63CiPi5T8U4ccA=', NULL, 0, '0791373638', 'STEPHEN', 'KURIA MWANGI', 0, 1, '2025-07-24 07:01:41.301615', '9b4ccb81acb74bf486f58ea4def67677', '3NONE@none', '0791373638', 'borrower', 'active', '13796572', NULL, '1976-01-01', 'M', 'Kenyan', 'married', 'MUKERETI', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NONE', 'transport', 3000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-24 07:01:41.510625', '2025-10-13 09:24:12.943560', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_10.23.27.jpeg', 'kyc/selfies/STEPHEN_K._MWANGI.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_10.30.22_1.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_10.34.45.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$PpfEmFeAkEw2WLegzxfj8C$hbrtn13iDAFqAVDOGFVLjdjiFusvC8AamFLk+bTIVEA=', NULL, 0, '0723682652', 'MARTIN', 'MAINA IRUNGU', 0, 1, '2025-07-26 13:13:58.628653', '9f4f352ec82a4e82a0680c3cd54469e4', 'martinmaino2016@gmail.com', '0723682652', 'borrower', 'active', '24677484', NULL, '1986-06-11', 'M', 'Kenyan', 'married', 'THIKA TOWN', 'THIKA', 'KIAMBU', '1663', 'SELF', 'NA', 'transport', 3500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-26 13:13:58.859035', '2025-10-13 09:22:04.327104', NULL, 'kyc/id_documents/FRONT02.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_09.53.31.jpeg', 'kyc/utility_bills/AFFIRDAVIT06.jpeg', '', 'kyc/bank_statements/BIKEPHOTO02.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$NSadrMrFuOwiDXI99WYAm2$x5g5JdzFzXOlVWoainjlV4Cw6PjopLqbBZgGUr3e/D4=', NULL, 0, '0714213979', 'JAMES', 'NGUNYI OBUTANYWA', 0, 1, '2025-07-28 11:31:23.946350', 'a02db167e13e4decb13c6c41907d9c4a', '23NONE@none', '0714213979', 'borrower', 'active', '28594867', NULL, '1991-03-19', 'M', 'Kenyan', 'married', 'P.K', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 2000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 11:31:24.228879', '2025-10-13 09:17:43.080952', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_14.06.10.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_14.05.14.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_14.19.12_2.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_14.06.56_1.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!DL7FdpJehDsgWb9xSU0ZJKxlWorGKli47ER6brjx', NULL, 0, '+254702220832', 'HASSAN', 'DIKO', 0, 1, '2025-10-17 11:55:01.053224', 'a6fd0afbd8b84b0e990b7a79de62208a', 'dikahassandh@gmail.com', '+254702220832', 'borrower', 'active', '24844648', NULL, '1986-07-23', 'M', 'Kenyan', 'married', NULL, 'THIKA', 'None', '01000', 'None', 'TRANSPORT', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-17 11:55:01.054370', '2025-10-20 17:50:32.429809', NULL, 'kyc/id_documents/front_id.jpeg', 'kyc/selfies/photo_7pGG0Uh.jpeg', 'kyc/utility_bills/Purchases.jpeg', NULL, '', NULL, NULL, 'Kenya', 'THIKA- KIGANJO ROUTE.', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!HYA9M3FIslhbGTQUgfTHSBHykyerN3rbMX4J0BQ0', NULL, 0, '+254711996038', 'WILSON', 'MAINA WAMUGUNDA', 0, 1, '2025-09-25 08:38:39.874853', 'abf9e646f39b46acbc2b606adef31b77', 'WAMUGUNDAAC@gmail.com', '+254711996038', 'borrower', 'active', '28783035', NULL, '1990-01-02', 'M', 'Kenyan', 'married', NULL, 'THAKA', NULL, '', NULL, 'TRANSPORT', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-25 08:38:39.875724', '2025-09-25 08:38:39.877991', NULL, 'kyc/id_documents/FRONT_I.D_AND_DL.jpeg', 'kyc/selfies/PHOTO_IcUxY7y.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'WACHIRA ROUND ABOUT', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '4909a2220b14420ebd5d2bbeaa42b93f', NULL, NULL, NULL, NULL, NULL, NULL),
('!7pPV6eIAWPGiMQ21WRKh6XFtYv3oI1hhNrJEYslS', NULL, 0, '+254720428519', 'THATHI', 'LAVUTA', 0, 1, '2025-09-09 08:00:10.561062', 'ae4d3d0ebb9c4f9c872d232b1ba869e7', 'thathi@none.com', '+254720428519', 'borrower', 'active', '14471192', NULL, '1977-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '01000', NULL, 'EMPLOYED', '', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-09 08:00:10.562065', '2025-10-13 09:24:24.562261', NULL, 'kyc/id_documents/THATHI_ID_F.jpeg', 'kyc/selfies/THATHI_PHOTO.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'WORKS AT SYGENTA KENYA CUTTINGS IN GRAYSTONE SWANI', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!gv73pGRu8Fi05KJOVzPxBmNeIB3B50vW4uqpAR0V', NULL, 0, '+254719485707', 'MARTIN', 'GITONGA NTHIGA', 0, 1, '2025-09-25 08:12:26.322421', 'b4f282b1904945a89f7eec9ae8135aa4', 'NTHIGABF@gmail.com', '+254719485707', 'borrower', 'active', '26425696', NULL, '1989-01-01', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '', NULL, 'TRANSPORT', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-25 08:12:26.323368', '2025-10-13 09:19:54.016197', NULL, 'kyc/id_documents/FRONT_I.D.jpeg', 'kyc/selfies/photo.jpeg', '', NULL, '', NULL, NULL, 'Kenya', '', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$wae4RjGt5qqxmafR3OhQ3r$Si0CjFkDGWyVMrujNUyAl7+Olm4Y8aYDWz6VcVkyu4U=', NULL, 0, '0713275429', 'BRAMWEL', 'INZOFU', 0, 1, '2025-07-28 11:00:29.856363', 'b67936f6fbc04b5995698b72dd0890fc', '21NONE@none', '0713275429', 'borrower', 'active', '31832617', NULL, '1995-02-11', 'M', 'Kenyan', 'married', 'MAKONGENI SMILES', 'THIKA', 'KIAMBU', '0000', 'SELF', 'NA', 'transport', 2000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 11:00:30.064972', '2025-10-13 09:12:01.717202', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_13.40.34.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_13.40.14.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_13.59.01.jpeg', '', 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_13.41.44.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$XYCMVPBwSwMaAaDuTtpHWE$QI5P1uHZyT2b42x6hA/MRlBDRAWK12BcGOZi8bJyHlA=', '2025-11-01 05:56:38.886711', 1, 'admin', 'admin', 'Michael', 1, 1, '2025-07-22 11:53:51.498857', 'be8a21f9af2d4e67a28f82a88ec0b1d2', 'admin@branchbusinessadvance.com', '+254720883521', 'admin', 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2025-07-22 11:53:51.707125', '2025-11-01 05:56:38.887847', NULL, '', '', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, 'profile_images/profile_be8a21f9-af2d-4e67-a28f-82a88ec0b1d2.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$WUvjwpbWVfqEmYpNx9fON7$x2RCAJUro/WysF3X6wz5HSlSrkMcXzITmjQ1FWhqbD8=', NULL, 0, '0717494906', 'GEOFREY', 'MURIUKI NJERU', 0, 1, '2025-07-28 08:59:42.211340', 'c084b3b02f36460f9f1812d15b195abe', '13NONE@none', '0717494906', 'borrower', 'active', '23053989', NULL, '1984-02-20', 'M', 'Kenyan', 'married', 'THIKA', 'THIKA', 'KIAMBU', '60200', 'SELF', 'N/A', 'transport', 1500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 08:59:42.419259', '2025-10-13 09:11:37.042518', NULL, 'kyc/id_documents/FRONTID009.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_15.37.30.jpeg', 'kyc/utility_bills/AFFIRDAVIT014.jpeg', '', 'kyc/bank_statements/LOGBK008.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$cyLp4obYLpoxQqfcCoHMvx$vz5bDSiZfy/eHKOis9algVili7+b0YLYg4Dn6KzSarE=', NULL, 0, '0716968977', 'ALFRED', 'WEME AKHULE', 0, 1, '2025-07-28 08:30:26.421799', 'c890b2cdad1241529830e6e14acd912d', '11NONE@none', '0716968977', 'borrower', 'active', '29235024', NULL, '1990-01-23', 'M', 'Kenyan', 'married', 'PENTA FLOWERS', 'THIKA', 'MURANGA', '0000', 'PENTA FLOWERS', 'NONE', 'agriculture', 3500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 08:30:26.662526', '2025-10-12 19:10:14.466395', NULL, 'kyc/id_documents/FRONT-ID.jpeg', 'kyc/selfies/PASSPORT.jpeg', 'kyc/utility_bills/GUARANTOR_PG_6.jpeg', '', 'kyc/bank_statements/LOGBOOK.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!bakRig0Urkk8XXmYv3MxSEzgB1VcZpkN59oN9rG2', NULL, 0, '07236937946', 'ALICE', 'WANJIKU', 0, 1, '2025-09-03 12:03:02.596468', 'cfa1548eeb91413b911996836140894b', '52NONE@none', '07236937946', 'borrower', 'active', '3580213', NULL, '1958-01-01', 'F', 'Kenyan', 'married', NULL, 'MURANGA', NULL, '00000', NULL, 'NA', 'services', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-03 12:03:02.597417', '2025-10-13 09:11:04.210865', NULL, 'kyc/id_documents/BACK_ID.pdf', 'kyc/selfies/LOGBOOK.jpeg', 'kyc/utility_bills/BACK_ID.pdf', NULL, 'kyc/bank_statements/BACK_ID.pdf', NULL, NULL, 'Kenya', 'MWANA WIKIO', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!ylEJk7LWgKlq8CJYYfg1BcM0xjk72g1F0Mgxw5Ow', NULL, 0, '+254479016', 'MARGARET', 'WAMBUI KAMAU', 0, 1, '2025-10-14 14:18:51.032418', 'd0607974911b499196b15ec738f24f51', 'wacunga@gmail.com', '+254479016', 'borrower', 'active', '23774064', NULL, '2000-01-01', 'F', 'Kenyan', 'married', NULL, 'MURANGA', NULL, '', NULL, 'WACUNGA BOTIQUE', 'retail', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-14 14:18:51.032896', '2025-10-14 14:21:30.366378', NULL, 'kyc/id_documents/JAMES_I.D_BACK.jpeg', 'kyc/selfies/photo_2t9M3iE.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'CLOTHE SELLING AT GRAY STONE.', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!bcBAfWb8IW3Yege1YyyYNrsZAK7ogicoeEUJrG2o', NULL, 0, '0720453082', 'SOLOMON', 'NGUGI RUORO', 0, 1, '2025-09-03 16:01:20.417182', 'd7840244b9da4dbdbe025642d842b0de', '55NONE@none', '0720453082', 'borrower', 'active', '21102002', NULL, '1977-02-14', 'M', 'Kenyan', 'married', NULL, 'THIKA', NULL, '0000', NULL, 'NA', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-03 16:01:20.418429', '2025-10-13 09:23:42.582122', NULL, 'kyc/id_documents/WhatsApp_Image_2024-10-22_at_12.15.03_3.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_11.59.35_4.jpeg', 'kyc/utility_bills/WhatsApp_Image_2024-10-22_at_12.15.03_2.jpeg', NULL, 'kyc/bank_statements/WhatsApp_Image_2024-10-22_at_12.15.03_3.jpeg', NULL, NULL, 'Kenya', 'MWANA WIKIO', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$HeamNTqGXTfpxwP2Y7Ka8W$i6262o2ulYdVGODw6Ek2kxViFXHA0QZWNkm5+SqwISw=', NULL, 0, '0743924997', 'PETER', 'MWICIGI MAINA', 0, 1, '2025-07-26 13:00:41.359409', 'ea62acb36fc4437598090d739853ab45', '9NONE@none', '0743924997', 'borrower', 'active', '25409984', NULL, '1987-01-30', 'M', 'Kenyan', 'married', 'PENTA FLOWERS', 'THIKA', 'MURANGA', 'NA', 'SELF', 'NA', 'transport', 3500.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-26 13:00:41.568708', '2025-10-13 09:22:41.750320', NULL, 'kyc/id_documents/FRONTID001.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_10.27.29.jpeg', 'kyc/utility_bills/AFFIRDAVIT002.jpeg', '', 'kyc/bank_statements/LOGBK001.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!gab4EeRreU8zGrxnqAd6mvbbrPWz0JhhK46Fky7A', NULL, 0, '+254715497264', 'JAMES', 'CHEGE MWANGI', 0, 1, '2025-09-05 08:00:47.428407', 'ed2cbb721b044371b7b9386cc9fafea6', 'mwalimu@none.com', '+254715497264', 'borrower', 'active', '9153918', NULL, '1968-05-30', 'M', 'Kenyan', 'married', NULL, 'MURANGA', NULL, '', NULL, 'TIMBER', 'manufacturing', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-05 08:00:47.429323', '2025-10-13 09:17:07.305445', NULL, 'kyc/id_documents/JAMES_MWANGI_I.D_1.jpeg', 'kyc/selfies/JAMES_MWANGI_PHOTO.jpeg', '', NULL, '', NULL, NULL, 'Kenya', '', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!wF09MsguOBqeRnB4y4r3siC4MkqUkse5vGuu1skh', NULL, 0, '+254795183507', 'JOSEPH', 'MURIGI GATHUA', 0, 1, '2025-10-21 09:31:01.242822', 'ef082fe9858046bd83fe98714e308b9f', 'gathua@gmail.com', '+254795183507', 'borrower', 'active', '31642336', NULL, '1994-12-05', 'M', 'Kenyan', 'single', NULL, 'THIKA', NULL, '01000', NULL, 'MECHANIC', 'services', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-10-21 09:31:01.243606', '2025-10-21 09:31:01.249440', NULL, 'kyc/id_documents/F_ID.jpeg', 'kyc/selfies/PHOTO_HuFiVaY.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'CCF', NULL, '', '', '[]', 0, 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, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$yzOfac0typ37ZYtrjGpZdG$vMBfIntvRRhad4qyzUd1+Rc70u+hZNpG+yE2mo1a4wY=', '2025-10-31 16:46:14.465799', 0, 'Pauline', 'Pauline', 'Kariuki', 1, 1, '2025-09-22 05:44:22.780871', 'ef87276bae7a4a2cbc72305a20e2916e', 'pollymike42@gmail.com', '+254728550616', 'admin', 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-22 05:44:23.007759', '2025-10-31 16:46:14.466695', NULL, '', '', '', NULL, '', NULL, NULL, 'Kenya', NULL, NULL, '', '', '[]', 1, 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, NULL, NULL, 'profile_images/profile_ef87276b-ae7a-4a2c-bc72-305a20e2916e.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$2pKOtRTEorY4UfgAbX0KGZ$SFxoI12lUzWFu5Uia6ldjeuyboi/8t+EJnzekty+eNg=', NULL, 0, 'jane', 'Jane', 'Doe', 0, 1, '2025-07-22 11:58:09.050541', 'f8b704966ff740888e1e28d67981b75f', 'jane@example.com', '+254700000101', 'borrower', 'blacklisted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-07-22 11:58:09.050710', '2025-08-01 02:23:19.192452', NULL, '', '', '', '', '', NULL, NULL, 'Kenya', NULL, NULL, NULL, NULL, NULL, 0, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('pbkdf2_sha256$1000000$a53piEtC4vgH1i8YLKirz6$LpSVuLjO0LJk5PNyrgV/7T3h3sefz1dzDYL3XYjTCrc=', NULL, 0, '0795538351', 'HANNAH', 'NJAMBI GITAU', 0, 1, '2025-07-28 09:21:24.959372', 'fa7898cf0542450fa726ba47aa55a531', '15NONE@none', '0795538351', 'borrower', 'active', '2113815', NULL, '1978-04-05', 'F', 'Kenyan', 'married', 'CENJENTA', 'THIKA', 'KIAMBU', '0000', 'CENJENTA', 'NA', 'services', 6000.00, NULL, NULL, NULL, NULL, 0, 0, '2025-07-28 09:21:25.166453', '2025-10-13 09:15:10.261139', NULL, 'kyc/id_documents/FRONTID007.jpeg', 'kyc/selfies/WhatsApp_Image_2024-10-25_at_14.49.28.jpeg', 'kyc/utility_bills/AFFIRDAVIT010.jpeg', '', 'kyc/bank_statements/OFFERLT005.jpeg', NULL, NULL, 'Kenya', NULL, NULL, '', '', NULL, 0, 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, NULL, NULL, '', '733e1e7a62274214a66b73afe62b4eff', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!ilPoGWPQF357pGgWnQkfp82AVxO1sJ3sAqMzM8e1', NULL, 0, '0799115798', 'JOYCE', 'NJERI KURIA', 0, 1, '2025-09-24 08:55:31.085267', 'fbe15067a32d486f80ca690d97d59a57', 'JOYCEN@gmail.com', '0799115798', 'borrower', 'active', '25606766', NULL, '1985-09-17', 'F', 'Kenyan', 'single', NULL, 'THIKA', NULL, '01000', NULL, 'CARETAKER/ ENTERPRENUER', 'retail', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-24 08:55:31.086230', '2025-10-13 09:18:57.838736', NULL, 'kyc/id_documents/ID_F.pdf', 'kyc/selfies/PHOTO_fD8if8O.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'THIKA, SECTION 9', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL),
('!lFYxHBaJyKGcvncUU89g1VqZ9GNTLlafGYiyaqU2', NULL, 0, '+254769900139', 'JOHN', 'MWANGI KAMAU', 0, 1, '2025-09-11 08:07:55.268890', 'fd6e1904c6a64f2a9cbecbdfd31385a4', '', '+254769900139', 'borrower', 'active', '12663637', NULL, '1974-07-05', 'M', 'Kenyan', 'married', NULL, 'NAIROBI', NULL, '01000', NULL, 'TUK TUK TRANSPORT/ CAMERA MAN', 'transport', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-09-11 08:07:55.269941', '2025-10-13 09:19:11.499722', NULL, 'kyc/id_documents/JOHN_MWANGI_KAMAU_I.D_F.jpeg', 'kyc/selfies/JOHN_BZ_PHOTO.jpeg', '', NULL, '', NULL, NULL, 'Kenya', 'KIGANJO-THIKA TOWN', NULL, '', '', '[]', 0, 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, NULL, NULL, '', 'ef87276bae7a4a2cbc72305a20e2916e', NULL, NULL, NULL, NULL, NULL, 'pending', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'en', 'Africa/Nairobi', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'mpesa', NULL, 0, NULL, NULL, NULL, NULL, '09260dfcba0745199beec7432adfaeb8', NULL, NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `phone_number` (`phone_number`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `id_number` (`id_number`),
  ADD UNIQUE KEY `email_2` (`email`),
  ADD KEY `fk_users_verified_by` (`verified_by_id`),
  ADD KEY `idx_users_role` (`role`),
  ADD KEY `idx_users_status` (`status`),
  ADD KEY `idx_users_phone` (`phone_number`),
  ADD KEY `idx_users_email` (`email`),
  ADD KEY `idx_users_portfolio_manager` (`portfolio_manager_id`),
  ADD KEY `fk_users_assigned_by` (`assigned_by_id`),
  ADD KEY `fk_users_kyc_verified_by` (`kyc_verified_by_id`),
  ADD KEY `fk_users_suspended_by` (`suspended_by_id`),
  ADD KEY `fk_users_created_by` (`created_by_id`),
  ADD KEY `fk_users_updated_by` (`updated_by_id`),
  ADD KEY `fk_users_deleted_by` (`deleted_by_id`),
  ADD KEY `fk_users_referred_by` (`referred_by_id`),
  ADD KEY `idx_users_verified_by` (`verified_by_id`),
  ADD KEY `idx_users_assigned_date` (`assigned_date`),
  ADD KEY `idx_users_credit_score` (`credit_score`),
  ADD KEY `idx_users_kyc_status` (`kyc_status`),
  ADD KEY `idx_users_account_status` (`account_status`),
  ADD KEY `idx_users_last_activity` (`last_activity_at`),
  ADD KEY `idx_users_referral_code` (`referral_code`),
  ADD KEY `idx_users_mpesa_number` (`mpesa_number`),
  ADD KEY `users_branch_id_fk` (`branch_id`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_branch_id_fk` FOREIGN KEY (`branch_id`) REFERENCES `users_branch` (`id`) ON DELETE SET NULL;
COMMIT;

