-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 01, 2025 at 11:59 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `sacco_db` -- -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loans` -- CREATE TABLE `loans` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `disbursed_amount` decimal(15,2) NOT NULL, `interest_rate` decimal(5,2) NOT NULL, `repayment_schedule` text NOT NULL, `status` enum('running','closed','rescheduled','defaulted') NOT NULL DEFAULT 'running', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loan_applications` -- CREATE TABLE `loan_applications` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `amount_requested` decimal(15,2) NOT NULL, `purpose` text DEFAULT NULL, `status` enum('pending','approved','rejected','disbursed') NOT NULL DEFAULT 'pending', `approved_amount` decimal(15,2) DEFAULT NULL, `approved_by` bigint(20) UNSIGNED DEFAULT NULL, `disbursed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `loan_fines` -- CREATE TABLE `loan_fines` ( `id` bigint(20) UNSIGNED NOT NULL, `loan_id` bigint(20) UNSIGNED NOT NULL, `amount` decimal(15,2) NOT NULL, `reason` varchar(255) NOT NULL, `fine_date` date NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `id_number` varchar(255) NOT NULL, `date_of_birth` date DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `primary_contact` varchar(255) DEFAULT NULL, `secondary_contact` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `occupation` varchar(255) DEFAULT NULL, `employer` varchar(255) DEFAULT NULL, `monthly_income` decimal(15,2) DEFAULT NULL, `password` varchar(255) NOT NULL, `photo` varchar(255) DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `member_subscriptions` -- CREATE TABLE `member_subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `member_type` varchar(255) NOT NULL, `amount` decimal(15,2) NOT NULL, `payment_date` date NOT NULL, `financial_year` varchar(255) NOT NULL, `payment_method` varchar(255) NOT NULL, `reference` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000001_create_cache_table', 1), (2, '0001_01_01_000002_create_jobs_table', 1), (3, '2025_07_06_090358_create_personal_access_tokens_table', 1), (4, '2025_07_06_100000_create_members_table', 1), (5, '2025_07_06_100001_create_users_table', 1), (6, '2025_07_06_110000_create_member_subscriptions_table', 1), (7, '2025_07_06_120000_create_savings_accounts_table', 1), (8, '2025_07_06_120100_create_savings_transactions_table', 1), (9, '2025_07_06_121000_create_savings_fines_table', 1), (10, '2025_07_06_122000_create_share_transactions_table', 1), (11, '2025_07_06_123000_create_loans_table', 1), (12, '2025_07_06_124000_create_loan_applications_table', 1), (13, '2025_07_06_125000_create_loan_fines_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `savings_accounts` -- CREATE TABLE `savings_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `account_type` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `savings_fines` -- CREATE TABLE `savings_fines` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `amount` decimal(15,2) NOT NULL, `reason` varchar(255) NOT NULL, `fine_date` date NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `savings_transactions` -- CREATE TABLE `savings_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `account_id` bigint(20) UNSIGNED NOT NULL, `category` enum('deposit','withdraw') NOT NULL, `amount` decimal(15,2) NOT NULL, `date` date NOT NULL, `deposit_method` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `share_transactions` -- CREATE TABLE `share_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED NOT NULL, `amount` decimal(15,2) NOT NULL, `number_of_shares` int(11) NOT NULL, `description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` bigint(20) UNSIGNED DEFAULT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `loans` -- ALTER TABLE `loans` ADD PRIMARY KEY (`id`), ADD KEY `loans_member_id_foreign` (`member_id`); -- -- Indexes for table `loan_applications` -- ALTER TABLE `loan_applications` ADD PRIMARY KEY (`id`), ADD KEY `loan_applications_member_id_foreign` (`member_id`); -- -- Indexes for table `loan_fines` -- ALTER TABLE `loan_fines` ADD PRIMARY KEY (`id`), ADD KEY `loan_fines_loan_id_foreign` (`loan_id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `members_email_unique` (`email`), ADD UNIQUE KEY `members_id_number_unique` (`id_number`); -- -- Indexes for table `member_subscriptions` -- ALTER TABLE `member_subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `member_subscriptions_member_id_foreign` (`member_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `savings_accounts` -- ALTER TABLE `savings_accounts` ADD PRIMARY KEY (`id`), ADD KEY `savings_accounts_member_id_foreign` (`member_id`); -- -- Indexes for table `savings_fines` -- ALTER TABLE `savings_fines` ADD PRIMARY KEY (`id`), ADD KEY `savings_fines_member_id_foreign` (`member_id`); -- -- Indexes for table `savings_transactions` -- ALTER TABLE `savings_transactions` ADD PRIMARY KEY (`id`), ADD KEY `savings_transactions_account_id_foreign` (`account_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `share_transactions` -- ALTER TABLE `share_transactions` ADD PRIMARY KEY (`id`), ADD KEY `share_transactions_member_id_foreign` (`member_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_member_id_foreign` (`member_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `loans` -- ALTER TABLE `loans` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `loan_applications` -- ALTER TABLE `loan_applications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `loan_fines` -- ALTER TABLE `loan_fines` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `member_subscriptions` -- ALTER TABLE `member_subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `savings_accounts` -- ALTER TABLE `savings_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `savings_fines` -- ALTER TABLE `savings_fines` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `savings_transactions` -- ALTER TABLE `savings_transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `share_transactions` -- ALTER TABLE `share_transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `loans` -- ALTER TABLE `loans` ADD CONSTRAINT `loans_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `loan_applications` -- ALTER TABLE `loan_applications` ADD CONSTRAINT `loan_applications_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `loan_fines` -- ALTER TABLE `loan_fines` ADD CONSTRAINT `loan_fines_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `loans` (`id`) ON DELETE CASCADE; -- -- Constraints for table `member_subscriptions` -- ALTER TABLE `member_subscriptions` ADD CONSTRAINT `member_subscriptions_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `savings_accounts` -- ALTER TABLE `savings_accounts` ADD CONSTRAINT `savings_accounts_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `savings_fines` -- ALTER TABLE `savings_fines` ADD CONSTRAINT `savings_fines_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `savings_transactions` -- ALTER TABLE `savings_transactions` ADD CONSTRAINT `savings_transactions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `savings_accounts` (`id`) ON DELETE CASCADE; -- -- Constraints for table `share_transactions` -- ALTER TABLE `share_transactions` ADD CONSTRAINT `share_transactions_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE SET NULL; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;