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

START TRANSACTION;



--
-- Database: `acbptxvs_branch_system`
--

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

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

CREATE TABLE `users` (
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `id` char(32) NOT NULL,
  `email` varchar(254) DEFAULT NULL,
  `phone_number` varchar(17) DEFAULT NULL,
  `role` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `id_number` varchar(20) DEFAULT NULL,
  `kra_pin` varchar(20) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `gender` varchar(1) DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `marital_status` varchar(20) DEFAULT NULL,
  `address` longtext,
  `city` varchar(100) DEFAULT NULL,
  `county` varchar(100) DEFAULT NULL,
  `postal_code` varchar(10) DEFAULT NULL,
  `employer` varchar(200) DEFAULT NULL,
  `business_name` varchar(200) DEFAULT NULL,
  `business_type` varchar(100) DEFAULT NULL,
  `monthly_income` decimal(12,2) DEFAULT NULL,
  `emergency_contact_name` varchar(200) DEFAULT NULL,
  `emergency_contact_phone` varchar(17) DEFAULT NULL,
  `emergency_contact_relationship` varchar(100) DEFAULT NULL,
  `pin` varchar(6) 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) DEFAULT NULL,
  `selfie` varchar(100) DEFAULT NULL,
  `utility_bill` varchar(100) DEFAULT NULL,
  `crb_report` varchar(100) DEFAULT NULL,
  `bank_statement` varchar(100) DEFAULT NULL,
  `physical_address` text,
  `postal_address` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT 'Kenya',
  `business_address` text,
  `business_registration_number` varchar(50) DEFAULT NULL,
  `business_license` varchar(100) DEFAULT NULL,
  `tax_certificate` varchar(100) DEFAULT NULL,
  `other_documents` json DEFAULT NULL,
  `is_verified` tinyint(1) DEFAULT '0',
  `verification_date` datetime(6) DEFAULT NULL,
  `verified_by` char(1) DEFAULT NULL,
  `verified_by_id` char(32) DEFAULT NULL,
  `logbook` varchar(255) DEFAULT NULL,
  `title_deed` varchar(255) DEFAULT NULL,
  `signature` varchar(255) DEFAULT NULL,
  `nickname` varchar(100) DEFAULT NULL,
  `capital_invested` decimal(15,2) DEFAULT NULL,
  `cp_domicile` varchar(200) DEFAULT NULL,
  `declaration_name` varchar(200) DEFAULT NULL,
  `domicile` varchar(200) DEFAULT NULL,
  `expected_turnover` decimal(15,2) DEFAULT NULL,
  `guarantor_id` varchar(50) DEFAULT NULL,
  `guarantor_mobile` varchar(20) DEFAULT NULL,
  `guarantor_name` varchar(200) DEFAULT NULL,
  `guarantor_residence` varchar(200) DEFAULT NULL,
  `guarantor_tel` varchar(20) DEFAULT NULL,
  `other_business_type` varchar(200) DEFAULT NULL,
  `personal_pin` varchar(50) DEFAULT NULL,
  `physical_location` varchar(200) DEFAULT NULL,
  `place_of_birth` varchar(200) DEFAULT NULL,
  `postal_code_business` varchar(20) DEFAULT NULL,
  `recommender_id` varchar(50) DEFAULT NULL,
  `recommender_mobile` varchar(20) DEFAULT NULL,
  `recommender_name` varchar(200) DEFAULT NULL,
  `recommender_residence` varchar(200) DEFAULT NULL,
  `recommender_tel` varchar(20) DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `source_of_funds` text,
  `start_time` time DEFAULT NULL,
  `profile_image` varchar(255) DEFAULT NULL,
  `portfolio_manager_id` char(32) DEFAULT NULL,
  `assigned_date` datetime(6) DEFAULT NULL,
  `assigned_by_id` char(32) DEFAULT NULL,
  `credit_limit` decimal(12,2) DEFAULT NULL,
  `credit_score` int DEFAULT NULL,
  `risk_rating` varchar(20) DEFAULT NULL,
  `kyc_status` varchar(20) DEFAULT 'pending',
  `kyc_verified_at` datetime(6) DEFAULT NULL,
  `kyc_verified_by_id` char(32) DEFAULT NULL,
  `account_status` varchar(20) DEFAULT 'active',
  `suspension_reason` text,
  `suspended_at` datetime(6) DEFAULT NULL,
  `suspended_by_id` char(32) DEFAULT NULL,
  `notes` text,
  `created_by_id` char(32) DEFAULT NULL,
  `updated_by_id` char(32) DEFAULT NULL,
  `deleted_at` datetime(6) DEFAULT NULL,
  `deleted_by_id` char(32) 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) DEFAULT 'en',
  `timezone` varchar(50) DEFAULT 'Africa/Nairobi',
  `two_factor_enabled` tinyint(1) DEFAULT '0',
  `two_factor_secret` varchar(32) DEFAULT NULL,
  `backup_codes` json DEFAULT NULL,
  `api_key` varchar(64) DEFAULT NULL,
  `api_key_created_at` datetime(6) DEFAULT NULL,
  `referral_code` varchar(20) DEFAULT NULL,
  `referred_by_id` char(32) 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) DEFAULT NULL,
  `employment_start_date` date DEFAULT NULL,
  `salary_account_bank` varchar(100) DEFAULT NULL,
  `salary_account_number` varchar(50) DEFAULT NULL,
  `next_of_kin_name` varchar(200) DEFAULT NULL,
  `next_of_kin_phone` varchar(17) DEFAULT NULL,
  `next_of_kin_relationship` varchar(50) DEFAULT NULL,
  `next_of_kin_id_number` varchar(20) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `bank_branch` varchar(100) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `account_name` varchar(200) DEFAULT NULL,
  `mpesa_number` varchar(17) DEFAULT NULL,
  `preferred_payment_method` varchar(20) DEFAULT 'mpesa'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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`) VALUES
('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-07-28 12:06:14.835228', 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, 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'),
('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-07-28 09:11:25.563175', 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, 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'),
('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-07-22 13:13:39.490119', 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, 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'),
('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-07-28 12:25:59.954073', 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, 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'),
('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-07-28 11:46:25.806923', 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, 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'),
('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-07-26 10:42:05.518605', NULL, 'kyc/id_documents/I.D_FRONT.pdf', 'kyc/selfies/WhatsApp_Image_2024-10-22_at_11.36.50_2.jpeg', '', '', '', 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'),
('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-07-28 09:33:11.435550', 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, 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'),
('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-07-28 10:17:13.942982', 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, 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'),
('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-07-28 10:02:46.881634', 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, 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'),
('!E7wvwdq9p7DY8Xobl9ZInezyxsNbPDjreYRUWXgK', NULL, 0, '+254000000057', 'test', 'user', 0, 1, '2025-08-29 04:33:30.842054', '4dc0572f0f644fceb798b3042beb6b1b', 'venowo6636@gardsiir.com', '+254000000057', 'borrower', 'active', '455345867', NULL, '2025-07-29', 'M', 'Kenyan', 'single', NULL, 'fhfh', NULL, '', NULL, '6778', 'retail', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-08-29 04:33:30.842737', '2025-08-29 04:33:30.844465', NULL, 'kyc/id_documents/error_rCneRiS.png', 'kyc/selfies/error_XrTYPXj.png', '', 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'),
('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-08-29 08:06:07.449325', 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, '', 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'),
('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-08-20 15:18:32.850646', NULL, 'kyc/id_documents/ID_FRONT_pg.jpeg', 'kyc/selfies/PHOTO_GIDEON.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, 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'),
('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-07-28 12:17:06.264554', 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, 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'),
('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-07-28 10:46:54.862316', 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, 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'),
('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-07-24 07:19:57.367000', 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, 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'),
('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-07-24 10:03:10.923986', 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, 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'),
('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-07-28 11:55:31.181194', 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, 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'),
('pbkdf2_sha256$1000000$21YFzK33hef7WCMIhpzLWr$81XWrH1qJ2oPxpK6V4As0saSfupdAxWaelKYZKGJVH8=', NULL, 0, 'phin', 'Phin', 'Client', 0, 1, '2025-07-22 11:58:08.835653', '8b1bce3d286744498fdbeb27fca0819c', 'phin@example.com', '+254700000100', 'borrower', 'active', 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:08.836010', '2025-07-22 11:58:09.042660', 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'),
('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-07-28 11:18:17.464819', 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, 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'),
('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-07-24 05:53:24.632884', NULL, 'kyc/id_documents/BACK-ID.jpeg', 'kyc/selfies/PASSPORT_PHOTO.jpeg', '', '', '', 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'),
('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-07-28 10:27:30.825757', 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, 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'),
('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-08-20 18:23:26.817228', 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, 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'),
('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-07-26 13:13:58.860140', 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, 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'),
('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-07-28 11:31:24.229821', 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, 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'),
('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-07-28 11:00:30.065786', 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, 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');

--
-- 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`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `fk_users_assigned_by` FOREIGN KEY (`assigned_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_deleted_by` FOREIGN KEY (`deleted_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_kyc_verified_by` FOREIGN KEY (`kyc_verified_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_portfolio_manager` FOREIGN KEY (`portfolio_manager_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_referred_by` FOREIGN KEY (`referred_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_suspended_by` FOREIGN KEY (`suspended_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_updated_by` FOREIGN KEY (`updated_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_users_verified_by` FOREIGN KEY (`verified_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

