--
-- Host: localhost    Database: shirecu
-- ------------------------------------------------------


--
-- Table structure for table `account_balance_snapshots`
--

CREATE TABLE `account_balance_snapshots` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `chart_of_account_id` bigint unsigned NOT NULL,
  `fiscal_year_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `snapshot_date` date NOT NULL,
  `balances` json NOT NULL COMMENT 'JSON of {account_id: balance} pairs',
  `organisation_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_balance_snapshots_chart_of_account_id_foreign` (`chart_of_account_id`),
  KEY `account_balance_snapshots_fiscal_year_id_foreign` (`fiscal_year_id`),
  KEY `account_balance_snapshots_organisation_id_snapshot_date_index` (`organisation_id`,`snapshot_date`),
  CONSTRAINT `account_balance_snapshots_chart_of_account_id_foreign` FOREIGN KEY (`chart_of_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `account_balance_snapshots_fiscal_year_id_foreign` FOREIGN KEY (`fiscal_year_id`) REFERENCES `fiscal_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_balance_snapshots`
--


--
-- Table structure for table `account_categories`
--

CREATE TABLE `account_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` int NOT NULL,
  `normal_balance_side` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_categories_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_categories`
--

INSERT INTO `account_categories` VALUES (1,'Assets',100200,1,NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22'),(2,'Liabilities',20000,2,NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22'),(3,'Capital and Reserves',30000,2,NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22'),(4,'Income',100000,2,NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22'),(5,'Expenses',100800,1,NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22');

--
-- Table structure for table `account_sub_categories`
--

CREATE TABLE `account_sub_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_category_id` bigint unsigned DEFAULT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` int NOT NULL,
  `is_system_created` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'This is to avoid deleting account which are prepacked in the system',
  `is_working_capital` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'For accounts that affect working capital (AR, AP, Inventory)',
  `is_non_cash` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'For non-cash items like depreciation',
  `is_financing_related` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'For accounts directly related to financing activities',
  `cash_flow_type` enum('Operating','Investing','Financing') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_sub_categories_code_unique` (`code`),
  KEY `account_sub_categories_account_category_id_foreign` (`account_category_id`),
  KEY `account_sub_categories_parent_id_foreign` (`parent_id`),
  KEY `account_sub_categories_id_index` (`id`),
  KEY `account_sub_categories_id_organisation_id_index` (`id`,`organisation_id`),
  CONSTRAINT `account_sub_categories_account_category_id_foreign` FOREIGN KEY (`account_category_id`) REFERENCES `account_categories` (`id`),
  CONSTRAINT `account_sub_categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `account_sub_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_sub_categories`
--

INSERT INTO `account_sub_categories` VALUES (1,1,NULL,NULL,'None Current Assets','Are long-term assets used in the business, typically for more than one year',100201,1,0,0,0,'Investing',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(2,1,NULL,NULL,'Current Assets','Current assets are short-term assets that are expected to be converted into cash within a year',101701,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(3,1,NULL,2,'Inventory','Raw Materials, Work-in-Progress, Finished Goods',101702,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(4,1,NULL,2,'Accounts Receivable','Trade Receivables',101727,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(5,1,NULL,2,'Assets Held For Sale','Assets Held For Sale',101752,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(6,1,NULL,2,'Cash and Cash Equivalents','Cash in Hand, Bank Accounts, Short-term Investments',101777,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(7,1,NULL,1,'Property, Plant, and Equipment (PP&E)','Ledger: Buildings, Machinery, Office Equipment, Furniture',100202,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(8,1,NULL,1,'Work In Progress','Work In Progress (Kazi Ya Ujenzi)',100282,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(9,1,NULL,1,'Work In Progress- Intangible Assets','Work In Progress for example software',100362,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(10,1,NULL,1,'Tax Owed','Tax prepaid to authority(Kodi Inayodaiwa)',100442,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(11,1,NULL,1,'Long-term Investments','These are investments held for more than one year',100522,1,0,0,0,'Investing',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(12,1,NULL,1,'Investment In Shares','Shares investment in other companies',100602,1,0,0,0,'Investing',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(13,3,NULL,NULL,'Capital Accounts','Owners equity, share capital',30001,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(14,3,NULL,NULL,'Reserves','Reserves',30101,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(15,3,NULL,NULL,'Retained Earnings','Retained earnings',30201,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(16,2,NULL,NULL,'Long-Term Liabilities','These are obligations due after one year, often associated with long-term financing and large capital expenses.',20001,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(17,2,NULL,NULL,'Current Liabilities','These are obligations that are due within a year, typically relating to day-to-day operations.',22001,1,1,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(18,2,NULL,14,'HISA ZA WANACHAMA (Members Shares)','HISA.',30102,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(19,2,NULL,17,'WADAI WA KIBIASHARA(Accounts Payable)','Amounts owed to suppliers for goods or services received but not yet paid for.',30112,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(20,2,NULL,17,'WADAI WA KIBIASHARA','WADAI WA KIBIASHARA (Othe accounts payable)',30122,1,1,0,1,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(21,2,NULL,14,'Hesabu Ya Wakulima (Farmers Account)','Farmers Account',30132,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(22,2,NULL,14,'Wadai Vya Wanachama','Farmers Account',30142,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(23,2,NULL,14,'KODI ILIYOAHILISHWA (DEFFERED TAX)','KODI ILIYOAHILISHWA (DEFFERED TAX)',30152,1,1,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(24,2,NULL,14,'Unearned Revenue (Deferred Revenue)','Payments received before goods or services have been delivered, representing a liability until the obligation is fulfilled.',30162,1,1,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(25,4,NULL,NULL,'Sales Revenue/Income','Primary business income from products and services',100001,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(26,4,NULL,26,'Other Income','Miscellaneous or irregular sources of income.',100501,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(27,4,NULL,27,'Other Comprehensive Income','Miscellaneous or irregular sources of income.',101001,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(28,4,NULL,25,'Mapato Mengineyo','Primary business income from products and services',100005,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(29,4,NULL,25,'Ushuru Wa Mazao','Ushuru Wa Mazao.',100105,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(30,4,NULL,25,'Mapato Yatokanayo na Milki','Mapato Yatokanayo na Milki',100205,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(31,4,NULL,NULL,'Gain on Asset Sale','Gain on Disposal of Assets / Gain on Sale of Fixed Assetsor.',1,1,1,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(32,5,NULL,NULL,'Cost of Goods Sold (COGS)','Costs directly related to the production of goods or services.',100801,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(33,5,NULL,NULL,'Operating Expenses','Costs related to running the business, not directly tied to production',101301,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(34,5,NULL,NULL,'Interest Expenses','Interest Expenses',101801,1,0,0,0,NULL,NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(35,5,NULL,33,'Administrative Expenses(Gharama za Utawala)','Administrative Expenses',100006,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(36,5,NULL,33,'Gharama za Utumishi (Service Costs)','Service Costs',100016,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(37,5,NULL,33,'Gharama za Bodi (Board Expenses)','Technology & IT Expenses',100026,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(38,5,NULL,33,'Gharama za kibiashara (Financial Expenses)','Office Supplies and Equipment',100036,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(39,5,NULL,33,'Depreciation Expense','Depreciation Expenses',100046,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38'),(40,5,NULL,33,'Provision Expense','Provision Expense ',100056,1,0,0,0,'Operating',NULL,'2026-01-30 10:31:38','2026-01-30 10:31:38');

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `objectives` text COLLATE utf8mb4_unicode_ci,
  `activity_methodology` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `cost` decimal(20,2) DEFAULT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prioty` enum('High','Medium','Low') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Low',
  `status` enum('Not Started','In Progress','Completed','On Hold','Cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Not Started',
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activities_project_id_foreign` (`project_id`),
  CONSTRAINT `activities_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--


--
-- Table structure for table `activity_approvals`
--

CREATE TABLE `activity_approvals` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approval_date` date NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_approvals`
--


--
-- Table structure for table `activity_budgets`
--

CREATE TABLE `activity_budgets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_budgets`
--


--
-- Table structure for table `activity_files`
--

CREATE TABLE `activity_files` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_files`
--


--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` VALUES ('0016ccfb-8ad6-43f3-9138-ce587c5cc049','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-20 17:07:30','2026-01-20 17:07:30'),('004c821d-5196-4b0a-b672-86d9cf548ea0','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:16:19','2026-01-21 17:16:19'),('03bd259c-135e-47b7-9767-aed282f3dc68','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 19:00:55','2026-01-28 19:00:55'),('05ac094c-36c4-474d-a816-b7d7b24d16e2','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MICHANGO YA TPAWU','2026-01-20 12:17:29','2026-01-20 12:17:29'),('098e2f71-c211-49f5-bb7e-2d9abbe7c703','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (FOOD ITEMS)','2026-01-20 13:31:46','2026-01-20 13:31:46'),('09b3ae9e-bfb7-4171-88d7-ffa25b511816','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 15:00:08','2026-01-31 15:00:08'),('09ba0780-622e-4b35-9388-ac95d73a21ca','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:51:36','2026-01-31 11:51:36'),('09fb3296-bdd6-46a1-bf75-464d538fbb4c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75 - 4','2026-01-20 11:21:04','2026-01-20 11:21:04'),('0dc504d9-d485-4b6e-97d4-6f7abc1fc70d','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:12:05','2026-01-28 14:12:05'),('0e54523d-cd8a-40d1-bf5c-c8503d54a90f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:14:45','2026-01-28 13:14:45'),('0f26f66d-0609-4a9f-b6b1-8003a8516b93','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock reorder report','Retrieved stock reorder report','2026-01-30 07:52:52','2026-01-30 07:52:52'),('10226820-23c7-4dfd-9f7f-6f1b3acaccae','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:19:58','2026-01-21 17:19:58'),('1024f41e-4cf4-485d-84b3-7462967c7730','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account Upangishaji Maghala','2026-01-28 13:36:12','2026-01-28 13:36:12'),('10a0ef86-6f8a-426e-a887-b5c012cb3c6b','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:38:19','2026-01-28 15:38:19'),('10bf163a-6d84-4fbc-b821-7900bd792d0c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TENKI LA GARI(1600 DAF) -2','2026-01-20 11:26:14','2026-01-20 11:26:14'),('10fadcf6-0caa-4dd4-b057-aaaf395808d4','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:46:53','2026-01-28 12:46:53'),('13c1abe4-18df-44c2-a836-34b244de37cb','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TENGO LA WADAIWA WALIOMASHAKANI','2026-01-20 10:46:13','2026-01-20 10:46:13'),('140d1cf5-ba9c-4358-90ca-1eb68c559f0f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:37:00','2026-01-28 13:37:00'),('140f3f9d-deca-41e0-b547-4222e74483c5','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-22 13:37:44','2026-01-22 13:37:44'),('148d70af-8c6d-48d4-bdf7-09fd5090a47a','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 20','2026-01-28 18:35:51','2026-01-28 18:35:51'),('18f1af29-ea45-4f19-a5c0-496584afb872','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA IDARA USAMBAZAJI','2026-01-20 09:58:16','2026-01-20 09:58:16'),('1d0ece49-4a68-40a4-91f0-e00a6f24e7f8','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 20','2026-01-28 18:27:59','2026-01-28 18:27:59'),('1e5c35f6-cdc0-426a-97d2-bdfd96f4cd4b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:26:27','2026-02-03 09:26:27'),('1f1f38ea-e2fe-4c0b-8bcb-07be377e55bd','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:19:40','2026-01-21 17:19:40'),('202fc182-217f-4494-a51c-bbeb1be43102','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:51:07','2026-01-21 15:51:07'),('2161510f-112e-4eac-9052-8bdc3e364e59','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:42:26','2026-01-28 12:42:26'),('22536470-7bb1-4a43-afc8-17f5c5ae2065','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating new supplier','Successfully created new supplier (NGALYA STORE)','2026-01-21 10:34:41','2026-01-21 10:34:41'),('2517c133-597b-4cf2-bd94-fbbe2aa0eba6','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MAGARI MAKUBWA','2026-01-20 09:05:54','2026-01-20 09:05:54'),('26acc7d6-1954-4c95-a7c0-7634a0ed06da','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN','2026-01-20 11:26:48','2026-01-20 11:26:48'),('283a5c82-c203-45d3-8408-9c4062a3e9e0','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIPURI VYA VIWANDA','2026-01-20 09:47:51','2026-01-20 09:47:51'),('2864e298-7a2a-4164-ada1-41a14c06f711','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account Upangishaji Minara','2026-01-28 13:52:42','2026-01-28 13:52:42'),('292f39d8-6374-480f-9ad3-86a77a56ca94','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:57:50','2026-01-31 11:57:50'),('296e6597-d1b2-47aa-aaaa-f8f973dcbea1','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:44:44','2026-01-28 14:44:44'),('2a1a5a18-ec6a-4380-a497-85b0a73cf5a9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA KARAKANA','2026-01-20 09:48:42','2026-01-20 09:48:42'),('2a4af0e7-59dc-40fe-90a6-2ce633f6344c','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:54:46','2026-01-21 17:54:46'),('2b29d5df-b9b3-4ed3-a8e2-7a3a796f9198','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA MAGARI IDARA YA USAFIRISHAJI','2026-01-20 09:57:12','2026-01-20 09:57:12'),('2b7db9b8-c3da-40ff-a421-6d283f86235c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75 - 2','2026-01-20 11:19:30','2026-01-20 11:19:30'),('2bb14e99-e7f2-44e7-a716-6a4c5566b6e4','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MIKOPO TOKA BENKI','2026-01-20 11:54:08','2026-01-20 11:54:08'),('2bcd2be7-a02d-4074-aa34-a2fd5ac03ac1','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:31:29','2026-01-21 17:31:29'),('2c06906e-6cef-4d33-adef-cbe26dae2157','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-24 15:31:06','2026-01-24 15:31:06'),('2c0bfff5-a8a7-4583-a8b4-203495ba7afb','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:35:57','2026-01-28 14:35:57'),('2cd6f2c9-5303-435b-b075-0b76f9359988','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:37:11','2026-01-21 17:37:11'),('2d81cda4-e613-478b-a528-6ce62df85105','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account USHURU WA PAMBA','2026-01-28 13:23:13','2026-01-28 13:23:13'),('2f6c4c9e-6cbf-402b-9dba-405621f949b0','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-29 17:08:56','2026-01-29 17:08:56'),('2fa32d30-d954-4e76-9cc8-0e197410504a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account ADA YA UKAGUZI','2026-01-20 11:59:39','2026-01-20 11:59:39'),('30936534-392b-4d16-a826-f2663d10f51b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:54:03','2026-01-31 11:54:03'),('312e51a3-7b6d-48c6-a05b-746001ae70df','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 13:41:44','2026-01-31 13:41:44'),('3293c178-a129-43c1-ad8c-45e63e55e932','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 13:40:40','2026-01-31 13:40:40'),('3470b699-4108-47d5-bf99-876376ffc5b2','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -4','2026-01-20 11:28:53','2026-01-20 11:28:53'),('34c11ae0-e2ed-47c7-a717-b19c78109412','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -8','2026-01-20 11:31:38','2026-01-20 11:31:38'),('34e1e14d-eb89-44a1-bc6a-a83aae8d324c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Deleting coa','Successfully deleted details of AIRTEL TANZANIA LTD','2026-01-20 22:52:03','2026-01-20 22:52:03'),('3601867b-9e38-4eca-9bbe-b18bf7d153c9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-20 16:22:46','2026-01-20 16:22:46'),('362cd93b-9bcd-4265-bd05-2ad9fd3a360e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:54:38','2026-01-31 11:54:38'),('36379c78-c386-43fa-857f-f943b88e29df','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Journal Transaction posted','Journal transaction 3','2026-01-20 23:00:32','2026-01-20 23:00:32'),('36465d8a-957d-4f57-a535-8fa1db866c24','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:40:26','2026-01-28 14:40:26'),('368942fd-d982-4842-a12f-aebc653c284b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock reorder report','Retrieved stock reorder report','2026-01-30 16:35:51','2026-01-30 16:35:51'),('3730b8cd-c70d-4460-964a-62f48bc1691f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:58:14','2026-01-31 11:58:14'),('37898e04-b8e1-4e55-a1f7-b0658ff85bc9','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 16:03:54','2026-01-21 16:03:54'),('385dac6e-67e9-438d-8c5b-7ce8fa15224e','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:51:08','2026-01-21 14:51:08'),('39243a8f-7854-4015-8362-f9b61d6132e9','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 16:59:34','2026-01-21 16:59:34'),('39aa02ae-756f-4b89-9a14-011d87a08d8c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-20 17:03:59','2026-01-20 17:03:59'),('3b8c3726-89e9-45db-8d5a-ce9cb0fc32f8','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:23:38','2026-01-21 12:23:38'),('3deafb58-013d-4f89-b9e0-45952fd1a972','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-29 14:28:34','2026-01-29 14:28:34'),('40042c5f-d098-4f10-8376-de658156f38b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -5','2026-01-20 11:29:30','2026-01-20 11:29:30'),('404ef239-36b4-4763-94c0-86058d0be4fa','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 17:40:00','2026-01-28 17:40:00'),('4208df17-2d0d-4177-8277-b91cc64f9981','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:51:19','2026-01-21 14:51:19'),('43e2c51e-1797-4d0d-b194-b52df55c9e42','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:06:42','2026-01-21 15:06:42'),('448de187-25b1-454d-8929-65693414b4f2','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA KUFUNGIA BIDHAA','2026-01-20 10:00:31','2026-01-20 10:00:31'),('4596cf3d-4e51-4ec8-87aa-b8b1e0ceebea','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:48:44','2026-01-28 12:48:44'),('4670e66e-d0c0-4bbe-ac3f-d3e43f905a36','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account FEDHA ZA KIGENI BENKI YA CRDB (02J1058431300)','2026-01-20 10:56:30','2026-01-20 10:56:30'),('46fa4f83-3d74-4b82-8ef2-f5f4eaaa3bab','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:36:01','2026-01-28 14:36:01'),('4757c7f0-7fc7-4f1e-b938-21aeaa678f36','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75 - 3','2026-01-20 11:20:05','2026-01-20 11:20:05'),('4b64528b-7bfd-48ad-a305-b6c0eefa274f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:22:35','2026-01-28 15:22:35'),('4bc353dd-a679-4253-8eea-f7775eadf860','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA','2026-01-20 09:11:41','2026-01-20 09:11:41'),('512144f8-2de7-450a-9ae2-038a267754d6','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:46:32','2026-01-28 12:46:32'),('527986da-6598-4e0d-b19b-6a137f376d66','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:47:31','2026-01-28 12:47:31'),('552672af-b1fa-4d88-86df-b8ddd4138e51','db76612e-7eae-40e5-83c9-78f38ed17581',NULL,'Creating new supplier','Successfully created new supplier (TRIANGE  GENERAL ENTERPRISES)','2026-01-21 12:02:37','2026-01-21 12:02:37'),('5684a248-64bc-4402-9992-3de578129562','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account ISUZU HTR 113-31','2026-01-20 11:15:12','2026-01-20 11:15:12'),('56e7d4eb-3707-4c70-a3ca-edeb01ab02ab','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Deleting coa','Successfully deleted details of USHURU WA PAMBA','2026-01-21 14:52:58','2026-01-21 14:52:58'),('572f91c2-9ade-4974-9fae-890bdb5de7ae','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-26 08:37:43','2026-01-26 08:37:43'),('582dbb6d-9d82-4daa-bd06-dc4042ff5d2d','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:51:01','2026-01-24 12:51:01'),('5872efc5-361d-4bcb-8b72-e89560e8ad1d','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account FEDHA ZA MAUZO YA VYUMA CHAKAVU BENKI YA POSTA (29020700134)','2026-01-20 11:03:34','2026-01-20 11:03:34'),('58a21533-3372-4cc5-9dce-eb065b31ddfb','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PEMBEJEO ZILIZOHARIBIKA','2026-01-20 10:01:26','2026-01-20 10:01:26'),('58ef46c2-6829-4874-81e2-77e8711b5ddc','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:50:50','2026-01-21 14:50:50'),('5d8ae9fe-b4cc-4c3b-9be8-6f2894cf5ce1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-30 16:36:03','2026-01-30 16:36:03'),('5dd34fc9-aa69-4a1b-b097-2666e9718da9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account ISUZU HTR','2026-01-20 11:14:24','2026-01-20 11:14:24'),('5e78ef6a-07d1-495e-b124-fbb602f03cf6','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account DAF AVM','2026-01-20 11:13:10','2026-01-20 11:13:10'),('5eafb25f-b205-4b29-bd62-9beba2c593bc','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account USHURU WA PAMBA','2026-01-21 12:27:18','2026-01-21 12:27:18'),('605e7fc0-89e6-4dee-92b8-1b45070e441a','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:22:28','2026-01-21 12:22:28'),('6104b31d-4bf9-4409-bb97-88499dec7ff1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:58:50','2026-01-31 11:58:50'),('62b97844-8526-40ad-8ece-078f7e1bfb5c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 14:58:10','2026-01-31 14:58:10'),('63b8dfdb-f4d8-4f50-a6ac-328641873a1c','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating new supplier','Successfully created new supplier (RAJABU M BUGERAH)','2026-01-20 13:38:37','2026-01-20 13:38:37'),('63f7699e-1bf0-465c-86df-edf450ba4e8c','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:30:59','2026-01-21 15:30:59'),('6476aa99-3d38-4880-8ffa-e3523b525f5d','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:44:29','2026-01-28 12:44:29'),('64cdd9b2-e48e-4167-a6b8-cde001cf2091','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:50:45','2026-01-21 14:50:45'),('65b78129-f925-4bcb-afb3-2c4aa12759cc','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account KODI YA PAYE','2026-01-20 12:18:35','2026-01-20 12:18:35'),('65dd8003-fd17-4c9b-84fc-9fe12c3ef35e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFUNGIA-MAGUNIA NA KAMBA','2026-01-20 09:59:11','2026-01-20 09:59:11'),('65efed7a-a5c5-4ef3-9d02-938622ac01d1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-22 13:42:16','2026-01-22 13:42:16'),('660042a8-e9ee-40a1-8f4d-e65da7ee306b','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:24:06','2026-01-24 12:24:06'),('67219657-6b5a-4112-8c15-322b36e812c9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA MBALI MBALI NA MIKANDA','2026-01-20 09:55:33','2026-01-20 09:55:33'),('6973a10f-4ad0-4a6b-b4fa-39ba807f422f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:14:39','2026-01-28 13:14:39'),('6a846b40-72e1-4fee-a98f-8a7ea0468acd','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 12:00:13','2026-01-31 12:00:13'),('6b1c0e2d-c7f0-420b-930a-9c9cf0cf4822','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:27:10','2026-01-21 17:27:10'),('6cc3c686-c7b4-487e-bf92-4ab5bbb091f9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account Ardhi','2026-01-20 08:59:54','2026-01-20 08:59:54'),('6d27b5fa-ccf5-47c9-ab86-06b571ecbc2c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-22 13:44:17','2026-01-22 13:44:17'),('6dfc3aa1-0ba2-4ae2-98bf-4fccece26c41','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-30 07:53:31','2026-01-30 07:53:31'),('6e5aafc5-3eb5-45f9-a825-e7fec659833e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Deleting coa','Successfully deleted details of ADA YA UKAGUZI','2026-01-20 12:01:40','2026-01-20 12:01:40'),('7048e04e-1799-44f0-b540-d5cac21a16c8','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VITEGA UCHUMI','2026-01-20 09:28:49','2026-01-20 09:28:49'),('706273b4-84e3-4407-bddb-1d7c2ff80949','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:53:30','2026-01-31 11:53:30'),('7086ece0-d749-4d3b-b09d-4b1f6c3f0c60','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MITAMBO','2026-01-20 09:03:33','2026-01-20 09:03:33'),('71aac921-2e78-4caf-85f8-a4617d37f5e0','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PAMBA NYUZI','2026-01-20 10:02:15','2026-01-20 10:02:15'),('735eee81-6cf7-46a1-b7b5-c90329c1fd1b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:54:26','2026-01-31 11:54:26'),('746d0d72-ed89-4ecd-95eb-93949338932e','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Updating account','Successfully updated account Posho safari za wajumbe wa Bodi.','2026-01-28 14:34:38','2026-01-28 14:34:38'),('74be6275-9c1c-42e5-bd0e-94fe962ea99f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75 - 5','2026-01-20 11:22:02','2026-01-20 11:22:02'),('750a903c-10a8-4da3-82a2-4170b9a6e02c','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:51:11','2026-01-21 15:51:11'),('75157db1-665b-474c-bc9d-53e3b3f631ae','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TENKI LA GARI(SCANIA) -1','2026-01-20 11:25:17','2026-01-20 11:25:17'),('76988d82-8d70-46d7-a940-2c9083c53216','db76612e-7eae-40e5-83c9-78f38ed17581',NULL,'Creating new supplier','Successfully created new supplier (MARY  JAMES  GAMBAMALA)','2026-01-21 11:56:22','2026-01-21 11:56:22'),('7743a137-ade5-4f1b-aacf-ede5bef3d649','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:36:51','2026-01-21 17:36:51'),('777a8d1e-d686-4162-b3d5-ce1aeaf4431f','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (HARDWARE)','2026-01-20 13:31:24','2026-01-20 13:31:24'),('77c8e00d-5cef-46f5-969e-d73add835e8f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MAJENGO','2026-01-20 09:02:02','2026-01-20 09:02:02'),('7828d3f1-67c8-46e0-bc6f-b448500f459a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MIKOPO KWA YAFANYAKAZI (Imprest & Loans)','2026-01-20 10:43:56','2026-01-20 10:43:56'),('78d36bd5-f468-404e-ba29-44ccd06bdc67','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 14:59:09','2026-01-31 14:59:09'),('79280489-3870-4ea0-8f00-f8c1ac26f7f5','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:38:47','2026-01-21 15:38:47'),('7930ea4a-c6e2-4a16-994e-51d73e55f99b','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:11:18','2026-01-28 18:11:18'),('793fc254-b43e-4505-89f4-55692219c149','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account WADAIWA WA KIBIASHARA','2026-01-20 10:41:14','2026-01-20 10:41:14'),('7adf53b3-b5bf-4593-b308-72863d5f497c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock reorder report','Retrieved stock reorder report','2026-01-29 17:07:48','2026-01-29 17:07:48'),('7b02ec00-a860-4514-8dc1-fee422ecb00f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:36:24','2026-01-28 12:36:24'),('7b92af77-fe83-42fb-a43e-79b0516ee1de','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Updating account','Successfully updated account NMB WAKALA  30710105008','2026-01-28 18:35:01','2026-01-28 18:35:01'),('7c5b50da-95c1-4b0d-a9e8-4b4a2952d019','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account Hisa za wanachama','2026-01-20 11:57:50','2026-01-20 11:57:50'),('7d2d2e8b-eda6-41e9-9749-bcc8760b5ef2','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account LAYLAND COMET  1','2026-01-20 11:16:11','2026-01-20 11:16:11'),('7e5871e1-2edc-4203-af7e-8f7ae3f7f237','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-22 15:40:45','2026-01-22 15:40:45'),('7eb4d165-c002-4e3e-ad3e-c2d7149b442f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 3','2026-01-24 11:47:17','2026-01-24 11:47:17'),('7ee9fb9c-190c-4139-b3bf-8cf11fd6a194','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:30:20','2026-01-28 13:30:20'),('7f2a94e9-4c59-4110-8fde-9cb50dded571','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:15:38','2026-01-28 18:15:38'),('806f9070-eb70-4904-8e1a-cdf428d4c1bc','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account LIMBIKIZO LA FAIDA/(HASARA)','2026-01-20 11:52:12','2026-01-20 11:52:12'),('81de10d5-3cb8-4dd2-97ce-57733c9e4a97','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-23 12:40:52','2026-01-23 12:40:52'),('81f9038a-2f98-4681-abef-6a4ffce18410','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:28','2026-01-24 12:23:28'),('8306b272-ee09-421d-9636-873b3185405d','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:19:38','2026-02-03 09:19:38'),('8328fed8-2d92-46c2-aed2-b0b2227faf3b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:40:13','2026-01-28 12:40:13'),('83a80292-340b-49f9-b8d6-7b968fe824bf','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 11:43:03','2026-01-21 11:43:03'),('84629abc-7849-4edc-a139-96fe55e1e624','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating new inventory','Successfully created a new inventory','2026-01-24 15:26:22','2026-01-24 15:26:22'),('86d3419f-d9d2-4b9b-91c3-e84245927a43','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MAGARI MADOGO','2026-01-20 09:06:49','2026-01-20 09:06:49'),('8721a56e-e5db-4d1f-b73e-b0f518b4e6d1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock reorder report','Retrieved stock reorder report','2026-01-28 19:01:28','2026-01-28 19:01:28'),('8856d6dd-8dbc-49fa-8b6c-4d2adf721ca9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-21 07:19:35','2026-01-21 07:19:35'),('8945d447-0193-40ab-a0e0-ac4f20b961db','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:31:45','2026-01-28 14:31:45'),('8a021e0a-4272-47b8-856d-2cc1cad177d6','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:30:14','2026-01-28 13:30:14'),('8ac2ac4d-d80d-4ffc-9880-3f95d21a57d5','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating new inventory','Successfully created a new inventory','2026-01-24 15:35:36','2026-01-24 15:35:36'),('8b8f9edc-b94a-48f4-91f2-d699eb077942','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account AIRTEL TANZANIA','2026-01-20 12:34:28','2026-01-20 12:34:28'),('8c056402-7f66-457f-a7a1-6ff2aa3c925e','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:10:25','2026-01-21 12:10:25'),('8c655e7f-b991-4635-990a-0bdb2d07004c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account SAMANI','2026-01-20 09:10:49','2026-01-20 09:10:49'),('8dac420f-b172-4550-ab3d-b33a62f3777b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-30 17:20:37','2026-01-30 17:20:37'),('8dbaaf02-5fad-449c-8bc1-9343ac67aa4f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:48:43','2026-01-28 12:48:43'),('8e363665-adc6-4ec1-b610-1650e8bc9757','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:42:55','2026-01-28 12:42:55'),('8e7b2719-7934-46c1-97b5-5eeb4ca26261','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:21:02','2026-02-03 09:21:02'),('8f4f8f34-6def-43e8-8a16-89e5df44ac3a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:50:48','2026-01-24 12:50:48'),('8f80d40f-3ac7-4d64-9ef3-2c62c535beaf','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:37:34','2026-01-28 15:37:34'),('8f92487d-641f-4a5b-aed0-3be20589f577','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:58:29','2026-01-31 11:58:29'),('90712f4d-b59b-4815-af04-18c653bc7a32','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:51:27','2026-01-21 14:51:27'),('92a244db-4227-434e-8da7-7ad26648ea60','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 11:51:29','2026-01-31 11:51:29'),('92a69a39-a89a-47ed-8894-07e7150a6e08','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:53:19','2026-01-28 13:53:19'),('937ea089-68f4-4002-b046-b82122a6e61a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 14:58:49','2026-01-31 14:58:49'),('9479f73a-124b-45a3-9669-1099d41bc9e9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account AKIBA YA UTHAMANISHAJI','2026-01-20 11:49:05','2026-01-20 11:49:05'),('94e4fb2b-1005-4cc7-8bc7-aeecaaae1c0a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MADAI YA MISHAHARA YA WAFANYAKAZI','2026-01-20 12:22:22','2026-01-20 12:22:22'),('95864aad-0c11-4184-bf9a-e182c3c0e7e6','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:40:12','2026-01-28 12:40:12'),('970942cd-ec7a-4d45-bdfb-be9f9e4cd42e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 14:58:18','2026-01-31 14:58:18'),('97ff1a3c-6b2c-4b97-b44c-756342977946','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:49:52','2026-01-24 12:49:52'),('982ca751-6f46-427c-8cf5-2d839db962e6','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:05:39','2026-01-28 18:05:39'),('98e71855-8990-4dc9-b431-f6dceabdad7b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account LAYLAND COMET  2','2026-01-20 11:16:46','2026-01-20 11:16:46'),('9987b997-6c83-4bb4-a172-328771769c2c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MALIPO YA KATI KWA WAFANYAKAZI','2026-01-20 10:42:39','2026-01-20 10:42:39'),('9a9c3957-d067-4b1e-9584-02059c75685e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account Shajala','2026-01-20 09:54:37','2026-01-20 09:54:37'),('9baa479f-fb92-49ba-a607-c1e18e5a0e57','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-22 15:40:45','2026-01-22 15:40:45'),('9c739f94-57b1-4698-b791-960c41877bc8','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:12:09','2026-01-28 14:12:09'),('a01dc898-67da-476d-9b34-c37efd99354c','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating new supplier','Successfully created new supplier (AMBITION GRAPHICS)','2026-01-21 10:33:33','2026-01-21 10:33:33'),('a1a199b4-5e90-4adf-9667-fd49d23fbc93','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account USHURU WA CHOROKO','2026-01-28 13:24:33','2026-01-28 13:24:33'),('a20578b5-ced4-461d-b01b-cc12c91ff522','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (MBEGU NA VIATILIFU)','2026-01-21 07:34:27','2026-01-21 07:34:27'),('a2d1c335-4a21-4f3c-bd00-6bdaceb9130c','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:59:23','2026-01-28 18:59:23'),('a445b365-b0f7-4151-b7ed-7056c04e54c9','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 16:03:59','2026-01-21 16:03:59'),('a486d00e-f1d0-48e7-8ff2-7834e49568a1','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:22:29','2026-01-21 12:22:29'),('a4c48b88-8058-467c-8ffc-e364a34152e8','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:19:32','2026-01-21 17:19:32'),('a5927aa3-9be4-4e81-bb7d-04ee98b70307','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account KODI INAYODAIWA (TRA)','2026-01-20 09:32:35','2026-01-20 09:32:35'),('a5d4fa1e-9694-4fba-afee-4f5711b6dead','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 20','2026-01-24 13:47:35','2026-01-24 13:47:35'),('a6dd1efd-160c-422c-868e-37101a69dcee','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-30 17:20:15','2026-01-30 17:20:15'),('a72cb2d3-7640-4988-9fe3-f89813741996','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIPURI VYA OIL MILL','2026-01-20 09:45:51','2026-01-20 09:45:51'),('a7cfbe39-b015-44e7-89e8-9f56c421b69d','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (SPARE PARTS AND LUBRICANTS)','2026-01-20 16:22:11','2026-01-20 16:22:11'),('a840253f-2e09-4f72-ba4f-81cd29a84608','db76612e-7eae-40e5-83c9-78f38ed17581',NULL,'Creating new supplier','Successfully created new supplier (HAHOSA STATIONARY & GENERAL SUPPLIES)','2026-01-21 11:53:41','2026-01-21 11:53:41'),('a852b788-7af7-4dc3-b5df-6f53d3cdafb0','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 11:39:34','2026-01-21 11:39:34'),('aa95f608-e065-4510-80ac-2cea23d35f48','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:47:41','2026-01-28 12:47:41'),('aad983d4-81b8-49a8-8bea-cdec1d8e36d1','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 17:44:08','2026-01-28 17:44:08'),('ab19733a-645f-42c3-8a78-26bced089835','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MICHANGO YA MWAJIRI NSSF','2026-01-20 12:16:03','2026-01-20 12:16:03'),('ab7777da-9755-4974-b38f-8d40370d95a9','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-29 17:26:29','2026-01-29 17:26:29'),('ac0c7bd7-6f15-4539-a611-b0034495f336','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-23 14:37:20','2026-01-23 14:37:20'),('ac0d9599-e299-403b-96c6-19af7c143aec','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:13:44','2026-01-28 18:13:44'),('ac33dc3d-672a-47b5-a174-cb8747115484','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:32:59','2026-01-21 17:32:59'),('ac83033e-ea57-4e9a-8fb7-b5623239df44','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account MITAMBO','2026-01-20 09:08:58','2026-01-20 09:08:58'),('ac9e4637-b4e3-4078-8760-355f21ea71bd','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account Ununuzi wa Vifungashio ( Mifuko 50,000 X 700/=)','2026-01-21 17:24:24','2026-01-21 17:24:24'),('aca3e039-4a2c-4e9b-87bb-6542cbdaa347','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:24:35','2026-01-21 12:24:35'),('aca4b644-639f-4848-8069-bae5d275bc86','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -7','2026-01-20 11:30:49','2026-01-20 11:30:49'),('aea650ca-de09-41af-bc52-80670edf1ace','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:47:40','2026-01-28 12:47:40'),('af7dc583-1ffe-464c-b5f0-b6223be89a48','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75','2026-01-20 11:18:29','2026-01-20 11:18:29'),('b0f209db-e73d-47cc-ba3b-2172ee060831','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:33:44','2026-02-03 09:33:44'),('b139ab6a-2bd2-49d4-aa47-95c3f84b884a','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:23:42','2026-01-21 12:23:42'),('b19f6285-12ca-4be3-9db8-603690aca36d','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA UJENZI','2026-01-20 09:56:11','2026-01-20 09:56:11'),('b2fbc626-d247-44fd-b987-e02ea8de3df8','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:53:30','2026-01-21 14:53:30'),('b417cadc-58b6-43c0-9115-3da1d83adaf7','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (SANITARY ITEMS)','2026-01-20 13:32:18','2026-01-20 13:32:18'),('b6bebe60-b713-465c-8bc1-df1b53fb3325','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Updating account','Successfully updated account USHURU WA DENGU','2026-01-28 13:23:51','2026-01-28 13:23:51'),('b6c669ee-fd53-4a71-9c49-7d5f152e8265','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:36:24','2026-01-28 12:36:24'),('b7324937-7edc-4aea-9df7-d95bf8ff4e86','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-30 16:55:01','2026-01-30 16:55:01'),('b80eece7-b147-4070-bebd-ff561dac21dd','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-24 13:08:42','2026-01-24 13:08:42'),('b84e27fe-5db0-42c4-82c4-7eaf20d316ff','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:16','2026-01-24 12:23:16'),('b96c55bd-509f-4a64-8910-785641a57d0f','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-23 12:34:09','2026-01-23 12:34:09'),('ba6a470e-df6d-4a04-baff-246afbf85161','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:30','2026-01-24 12:23:30'),('bb09a8c1-764b-428f-ac53-36456754f3d8','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -3','2026-01-20 11:28:26','2026-01-20 11:28:26'),('bb4869d8-10ed-4172-bb97-ac6eb0a463f0','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account BENKI YA NMB YA MAKUSANYO (3071004689)','2026-01-20 10:59:45','2026-01-20 10:59:45'),('bc2f66b5-642d-426b-939f-037239b202ac','c4eaf525-c9e9-465b-a06b-a40f9979dee0',NULL,'Creating new account','Successfully created a new account Mapato yatokanayo na pango la Maghala','2026-01-26 17:36:29','2026-01-26 17:36:29'),('bc662b6b-4d32-4bec-bd15-2a052924a1f2','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 14:53:34','2026-01-21 14:53:34'),('bc749324-7dff-4d75-ac54-84c1e179a7f7','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Deleting coa','Successfully deleted details of Upangishaji Maghala','2026-01-28 13:36:45','2026-01-28 13:36:45'),('bce78643-19a8-401a-8396-83ad42b7c055','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 14:59:50','2026-01-31 14:59:50'),('bd3d5c78-b05f-4eea-b019-c408a54f4b89','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 17:45:22','2026-01-28 17:45:22'),('bd640372-78f2-47d8-8320-62a4973dd303','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:29','2026-01-24 12:23:29'),('bdd2ed60-6e43-463d-b1ad-d93b3c5b1c5c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account FEDHA ZA MAKUSANYO BENKI YA CRDB (01J1058431301)','2026-01-20 10:58:26','2026-01-20 10:58:26'),('bde02f6b-db52-4287-9acf-f925672261c2','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TENGO LA BIDHAA CHAKAVU','2026-01-20 10:07:17','2026-01-20 10:07:17'),('bdeb86d7-e3da-464d-a069-1caf565544eb','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TENKI LA GARI(SCANIA)','2026-01-20 11:24:32','2026-01-20 11:24:32'),('be7c553a-81c8-4183-a05b-bc1bb5de6e48','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MADAWA (CHEMICAL)','2026-01-20 09:46:57','2026-01-20 09:46:57'),('beaece7d-3c92-4b9c-90c2-ce2b3da67d13','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-24 15:29:08','2026-01-24 15:29:08'),('bf8c349e-4b74-4956-a328-bb37e43ac808','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:50:59','2026-01-24 12:50:59'),('bfbd1d70-fe70-4a18-9a81-76ba4d4186ee','b22d4a77-aa25-46c8-9468-51ef5afcabea',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:42:26','2026-01-28 12:42:26'),('bfc21e77-19c4-4c11-bfb8-5640d404b8e3','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:35:48','2026-01-21 17:35:48'),('bfe3acdc-f362-4a37-95d1-3cd346525e7f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:50:47','2026-01-24 12:50:47'),('bfe8786f-6401-42e1-8f69-d549cf197104','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:24:31','2026-01-21 12:24:31'),('c05b974b-64fe-4e53-8b6d-0a9821b5418d','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 16:59:29','2026-01-21 16:59:29'),('c0b6f060-23e7-426c-94b0-e73135bfdb55','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account MAJENGO','2026-01-20 09:08:37','2026-01-20 09:08:37'),('c0edfa96-bada-47f5-b59b-60051f6c4dca','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-25 16:07:53','2026-01-25 16:07:53'),('c1db800a-a124-4dab-8589-cb3e3db66082','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:46:57','2026-01-28 12:46:57'),('c1e19ab7-a886-44d1-a7ad-58f6047b0b30','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:32:04','2026-02-03 09:32:04'),('c2a7c946-4c5c-47b4-b9bd-05b5b8969934','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 4','2026-01-28 18:39:23','2026-01-28 18:39:23'),('c3b9ab76-ebf9-415b-a6a5-3da59786cb66','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account AKIBA MTAJI','2026-01-20 11:38:40','2026-01-20 11:38:40'),('c40ba198-b97e-4a8b-b97c-78652faf4c7d','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:18:21','2026-01-28 13:18:21'),('c41d9612-265f-42e2-8888-4670d59e6bea','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:58:37','2026-01-28 18:58:37'),('c4eea46f-7c24-4d0e-94f6-27313b913342','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account LAYLAND COMET 3','2026-01-20 11:17:27','2026-01-20 11:17:27'),('c6760026-2190-42be-8dc2-ca917c1eb362','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 13:40:50','2026-01-31 13:40:50'),('c6aee70f-7449-4f54-be5e-b88c33d19ea4','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account ADA YA UKAGUZI','2026-01-20 12:03:11','2026-01-20 12:03:11'),('c837775b-e5b1-4517-91cc-7d59f7ee6c7d','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 12:10:31','2026-01-21 12:10:31'),('ca8886f9-b699-4342-b504-856643c42487','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 18:12:39','2026-01-28 18:12:39'),('cbcff84a-6da4-472a-a574-9c2e9218926e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MFUMO YA ERP','2026-01-20 09:21:49','2026-01-20 09:21:49'),('cbed2a63-bc5c-4702-bff3-ffa27596c454','db76612e-7eae-40e5-83c9-78f38ed17581',NULL,'Creating new supplier','Successfully created new supplier (OGB  INTERNATIONAL LTD)','2026-01-21 12:04:36','2026-01-21 12:04:36'),('cca604b7-1fa2-41ed-82a1-97e3950280d5','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:08:05','2026-01-28 14:08:05'),('ccefcf1c-8383-4c3e-b16a-f1f5bec92a5c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account USHURU WA MISHAHARA NA MAENDELEO YA ELIMU','2026-01-20 12:20:58','2026-01-20 12:20:58'),('ce4c3322-cb74-40d8-87c0-1ea3fb28c817','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:29:16','2026-02-03 09:29:16'),('ce836ad8-0b00-4365-8ff6-6f644bc2f624','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-23 12:35:06','2026-01-23 12:35:06'),('cfc712a4-0ae1-48ce-91a8-0ec34e6d1b93','db76612e-7eae-40e5-83c9-78f38ed17581',NULL,'Creating new supplier','Successfully created new supplier (CLICK TECH SOLUTION)','2026-01-21 12:08:10','2026-01-21 12:08:10'),('cfce71cf-c470-4055-a2dd-fbfa9f64d389','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:22:34','2026-01-28 15:22:34'),('d002717a-a41b-4f4d-be66-a5c4c01d8f45','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-22 13:37:57','2026-01-22 13:37:57'),('d04f9b2f-3ba4-4b7b-ad32-d4aa0ccc19d8','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-31 13:42:12','2026-01-31 13:42:12'),('d052da71-3a91-43b3-b9a4-020a9e9d2006','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:29:10','2026-01-28 13:29:10'),('d1613f20-8784-40d6-b76a-6c70250262ac','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account Ardhi','2026-01-20 09:08:30','2026-01-20 09:08:30'),('d22861dc-4f0a-467d-a83c-890c727e33ef','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -9','2026-01-20 11:32:11','2026-01-20 11:32:11'),('d3026eab-adc7-4167-8b3e-d7bf96c3c36f','c4eaf525-c9e9-465b-a06b-a40f9979dee0',NULL,'Creating new account','Successfully created a new account Mapato yatokanayo na pango la Nyumba','2026-01-26 17:38:01','2026-01-26 17:38:01'),('d30289cc-9795-4847-a4ae-4c76498a23a1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:48:43','2026-01-28 12:48:43'),('d3119d83-cd24-4f7d-a5d2-3214c67121f0','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account MITAMBO','2026-01-20 09:08:42','2026-01-20 09:08:42'),('d5fc5b70-5b68-4194-8a46-9570acc15a1e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-20 15:11:19','2026-01-20 15:11:19'),('d617714e-e34c-4cee-9d29-95d47c033f4f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:57:38','2026-02-03 09:57:38'),('d7bce573-178a-4457-be7a-79a06c810f8b','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 11:42:58','2026-01-21 11:42:58'),('db415d60-0d9c-4055-a956-193cd56fa025','0ce29044-b626-407b-8000-d0ec38b721d4',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-21 19:19:29','2026-01-21 19:19:29'),('dce77504-b238-4632-879b-88f1af4d9717','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account FEDHA HAMISHWA/SAFIRISHWA','2026-01-20 10:44:58','2026-01-20 10:44:58'),('ddae77d5-6c53-403a-ac6c-7b53b508b29e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account UWEKEZAJI KATIKA MAJENGO NA MAGHALA','2026-01-20 09:25:37','2026-01-20 09:25:37'),('ddc2d9ad-5cb1-4eb2-9016-8ec5a8cb4a96','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 11:26:10','2026-01-28 11:26:10'),('de3be48a-142d-4119-a913-693d37068f1c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:31','2026-01-24 12:23:31'),('de888319-fb2a-4fdb-9341-de837642e008','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:18:26','2026-01-28 13:18:26'),('dea11a69-3bef-4d84-8226-222a71e3ac32','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:19:48','2026-01-28 15:19:48'),('dfa3dad2-e8be-4a31-b735-a422a3ce8ee3','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 11:39:53','2026-01-21 11:39:53'),('e075950a-9d52-4ed8-beb8-eb2db3591249','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Updating item category details','Successfully updated item category details (FOOD AND BEVERAGE)','2026-01-20 16:41:31','2026-01-20 16:41:31'),('e18d0efa-487a-4067-bc76-3136432cc23c','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-21 07:19:27','2026-01-21 07:19:27'),('e1f20db8-d0b4-43da-aef6-bbe77a470839','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Updating account','Successfully updated account Posho za vikao vya bodi na kamati zake','2026-01-28 14:34:14','2026-01-28 14:34:14'),('e288c1d2-c6eb-40be-b0ae-b0afb607be5e','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 19:04:54','2026-01-28 19:04:54'),('e2ab560d-834e-47f1-9b01-572fcd8fd7f5','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 15:38:32','2026-01-28 15:38:32'),('e346a5c5-2088-4d39-ad2c-7ed2ac3e7a4d','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -6','2026-01-20 11:30:04','2026-01-20 11:30:04'),('e36afcb0-1352-4056-a313-f6da3b0f37e1','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA UMEME','2026-01-20 09:44:59','2026-01-20 09:44:59'),('e3868325-6215-4eb4-9bef-8efac6411943','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:02:36','2026-01-21 17:02:36'),('e3a03709-fbe7-466f-ac20-7b94e8769f28','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 11:26:24','2026-01-28 11:26:24'),('e3ba6b55-a5c2-44fb-a2a9-b2ad0c5d7bb8','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI','2026-01-20 09:10:03','2026-01-20 09:10:03'),('e4acb1a0-0a98-4fe9-9a1c-90b9a0ed8b91','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account VIFAA VYA ZIMAMOTO','2026-01-20 09:53:30','2026-01-20 09:53:30'),('e4d3d8b0-b9ae-4382-87e4-4d42256d70e7','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 15:49:33','2026-01-21 15:49:33'),('e5c818de-9bf3-4d14-b517-b4985896b25a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-28 12:45:39','2026-01-28 12:45:39'),('e619bdea-75a8-4dd2-bb10-c95a209383d5','768bae0b-3b3f-476e-b7a9-4529fa1f9158',NULL,'Creating a new item category','Successfully created a new item category (FUEL)','2026-01-21 07:38:06','2026-01-21 07:38:06'),('e786f8a1-ce8d-4085-a68f-d87c8b2fe9d2','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Journal Transaction posted','Journal transaction 4','2026-01-28 19:21:20','2026-01-28 19:21:20'),('e7ff5553-5c34-4194-9c97-fe53e9c26b93','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-24 12:23:17','2026-01-24 12:23:17'),('e865e63d-c6e4-47a1-b32c-394bdd78367f','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account TOYOTA L/CRUISER HZJ75 - 6','2026-01-20 11:22:56','2026-01-20 11:22:56'),('e90be765-9e43-45e4-853c-2d686aaa9b44','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Creating new account','Successfully created a new account NMB WAKALA','2026-01-28 18:34:00','2026-01-28 18:34:00'),('e9630728-6802-4af3-a0d6-b0c27b2f9737','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:55:15','2026-01-28 13:55:15'),('ea0afc9f-39b3-43e8-8891-034b4dedd417','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:19:53','2026-01-21 17:19:53'),('ea472253-2681-4ea5-9141-fd3a8532934b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account MAGARI MAKUBWA','2026-01-20 09:08:47','2026-01-20 09:08:47'),('eb8d368f-7e6b-45e7-b7d1-2723c53c630b','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account PIKIPIKI LIFAN -2','2026-01-20 11:27:24','2026-01-20 11:27:24'),('eca561af-0d07-4177-90a4-0f8bfa8ac588','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Updating account','Successfully updated account MAGARI MADOGO','2026-01-20 09:08:51','2026-01-20 09:08:51'),('ecabf8eb-d187-4769-aa29-6fc5fdde18ce','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:04:33','2026-01-28 14:04:33'),('ed412764-ea9e-48aa-97f9-8ac48a26b459','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:24:55','2026-01-21 17:24:55'),('edb2548e-9d1e-4cb4-baad-f7e5058fe784','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:47:24','2026-01-28 12:47:24'),('efa88b6e-97e9-4724-b95b-0ceae5ed3070','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account MICHANGO YA WAFANYAKAZI NSSF','2026-01-20 12:15:03','2026-01-20 12:15:03'),('efe878d8-cfd5-40d1-9318-8a64d5766958','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account FEDHA ZA MATUMIZI BENKI CRDB (01J1058431307)','2026-01-20 10:55:01','2026-01-20 10:55:01'),('f0db00ea-3fb2-43f1-80fa-14c446b8bf50','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:24:51','2026-01-21 17:24:51'),('f0e011f9-269a-433e-9207-bd6e5c02ddd5','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 14:08:03','2026-01-28 14:08:03'),('f1466bb6-b977-4f31-b656-0eb84a06c3e5','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-21 17:17:37','2026-01-21 17:17:37'),('f27a0fd2-cd5c-4cd0-8b96-bbf1cc3335bf','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:36:56','2026-01-28 13:36:56'),('f606eaf6-71d1-47fd-a60a-959fa589b502','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Stock taking report','Successfully retrieved stock taking report','2026-01-21 07:31:42','2026-01-21 07:31:42'),('f7c0c88d-06c0-4694-9cd2-45e3f951c81c','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Deleting coa','Successfully deleted details of WADAIWA WA KIBIASHARA','2026-01-28 15:49:02','2026-01-28 15:49:02'),('f913acf2-e77b-425f-9cbf-971f26d7ffc1','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 13:29:15','2026-01-28 13:29:15'),('fa14a110-9c81-4842-adee-6abb4eacfca8','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account KODI ILIYOAHIRISHWA(DIFFERED TAX LIABILITY)','2026-01-20 12:49:43','2026-01-20 12:49:43'),('fad87b60-4985-4f67-8a29-d60995815d5f','3de7c572-94cb-4a65-b30e-ba55d6c94893',NULL,'Updating account','Successfully updated account TENGO LA WADAIWA WALIOMASHAKANI','2026-01-21 11:25:49','2026-01-21 11:25:49'),('fb3bc5fb-d7e5-455d-88b0-758ac77b4414','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-02-03 09:26:31','2026-02-03 09:26:31'),('fe7e4f34-83be-4273-af7d-9fca5e78748a','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Creating new account','Successfully created a new account KAZI YA UJENZI UNAOENDELEA SHOIL','2026-01-20 09:20:14','2026-01-20 09:20:14'),('ff815dee-d7ec-44e0-aba8-ffecc9fa84ef','f3683bee-094b-4aa6-8163-8d418a27eb6a',NULL,'Retrieving chart of accounts by category id','Successfully retrieved by ','2026-01-28 12:46:54','2026-01-28 12:46:54');

--
-- Table structure for table `activity_parameter_results`
--

CREATE TABLE `activity_parameter_results` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_parameter_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_parameter_results_activity_id_foreign` (`activity_id`),
  KEY `activity_parameter_results_activity_parameter_id_foreign` (`activity_parameter_id`),
  CONSTRAINT `activity_parameter_results_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_parameter_results_activity_parameter_id_foreign` FOREIGN KEY (`activity_parameter_id`) REFERENCES `activity_parameters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_parameter_results`
--


--
-- Table structure for table `activity_parameters`
--

CREATE TABLE `activity_parameters` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_parameters_activity_id_foreign` (`activity_id`),
  CONSTRAINT `activity_parameters_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_parameters`
--


--
-- Table structure for table `activity_plans`
--

CREATE TABLE `activity_plans` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_details` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assigned_to` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `due_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_plans_activity_id_foreign` (`activity_id`),
  KEY `activity_plans_assigned_to_foreign` (`assigned_to`),
  CONSTRAINT `activity_plans_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_plans_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_plans`
--


--
-- Table structure for table `activity_programs`
--

CREATE TABLE `activity_programs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_programs_activity_id_foreign` (`activity_id`),
  CONSTRAINT `activity_programs_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_programs`
--


--
-- Table structure for table `activity_services`
--

CREATE TABLE `activity_services` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `age_group_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_services`
--


--
-- Table structure for table `activity_teams`
--

CREATE TABLE `activity_teams` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_team_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_role_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_teams_activity_id_foreign` (`activity_id`),
  KEY `activity_teams_project_team_id_foreign` (`project_team_id`),
  KEY `activity_teams_project_role_id_foreign` (`project_role_id`),
  CONSTRAINT `activity_teams_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_teams_project_role_id_foreign` FOREIGN KEY (`project_role_id`) REFERENCES `project_roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_teams_project_team_id_foreign` FOREIGN KEY (`project_team_id`) REFERENCES `project_teams` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_teams`
--


--
-- Table structure for table `activitylog`
--

CREATE TABLE `activitylog` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `computer_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `activitylog_log_name_index` (`log_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activitylog`
--


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('billing','shipping') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'billing',
  `line1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `postal_code` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `addresses_customer_id_foreign` (`customer_id`),
  CONSTRAINT `addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--


--
-- Table structure for table `age_groups`
--

CREATE TABLE `age_groups` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age_group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age_range` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `age_groups`
--


--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locality_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` json DEFAULT NULL,
  `commission_fee_type` enum('percentage','fixed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percentage',
  `commission` decimal(5,2) NOT NULL DEFAULT '0.00',
  `balance` decimal(12,2) NOT NULL DEFAULT '0.00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `agents_user_id_foreign` (`user_id`),
  CONSTRAINT `agents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agents`
--


--
-- Table structure for table `allowance_types`
--

CREATE TABLE `allowance_types` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `auto_apply` tinyint(1) NOT NULL DEFAULT '0',
  `calculation_type` enum('fixed','percentage_basic','percentage_gross') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `frequency` enum('One-Time','Monthly','Yearly') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Monthly',
  `account_id` bigint unsigned DEFAULT NULL,
  `default_value` decimal(20,2) NOT NULL DEFAULT '0.00',
  `is_taxable` tinyint(1) NOT NULL DEFAULT '1',
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `allowance_types_account_id_foreign` (`account_id`),
  CONSTRAINT `allowance_types_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `chart_of_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `allowance_types`
--

INSERT INTO `allowance_types` VALUES ('45f563ed-c8b9-417f-84f4-f59e6ca06a3f','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho Ya Nyumba/House Allowance',0,'fixed','Monthly',7,0.00,0,NULL,'2026-01-20 16:10:44','2026-01-20 16:18:42',NULL),('47e45e8f-0c1a-4ecb-b091-04e901f60852','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho Ya Chakula/ Meal Allowance',0,'fixed','One-Time',7,0.00,0,NULL,'2026-01-20 16:21:24','2026-01-20 16:21:24',NULL),('620728c0-c512-4c04-ba47-6282518a0fa6','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho Ya Madaraka/Responsibility Allowance',1,'fixed','Monthly',7,0.00,0,NULL,'2026-01-20 16:17:18','2026-01-20 16:17:18',NULL),('81e2c578-3d4e-4e23-bf3b-f7afeddc419f','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho ya majukumu/Responsibility Allowance',1,'fixed','Monthly',7,0.00,0,NULL,'2026-01-20 16:15:55','2026-01-20 16:17:49',NULL),('a0b8bb2a-3e43-4c1b-a207-ea2ac4ba0837','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho Ya Kukaimu/Acting Allowance',1,'fixed','Monthly',7,0.00,0,NULL,'2026-01-20 16:22:39','2026-01-20 16:22:39',NULL),('c8189025-5578-48fa-b7a5-c670b13dbda9','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho ya Mawasiliano/Communication Allowance',1,'fixed','Monthly',7,0.00,0,NULL,'2026-01-20 16:11:30','2026-01-20 16:19:38',NULL),('de72d392-4527-485c-a84c-13098d87215a','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Posho Ya Matibabu/Medical Allowance',0,'fixed','One-Time',7,0.00,0,NULL,'2026-01-20 16:20:16','2026-01-20 16:20:16',NULL);

--
-- Table structure for table `amcos`
--

CREATE TABLE `amcos` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amcossUid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `memberType` enum('MEMBER','NON-MEMBER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MEMBER',
  `membershipNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accountName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referenceNumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phoneNo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amcos`
--


--
-- Table structure for table `amcos_financial_years`
--

CREATE TABLE `amcos_financial_years` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startYear` int NOT NULL,
  `endYear` int NOT NULL,
  `state` enum('PREVIOUS','CURRENT','NEXT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `muvu_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amcos_financial_years`
--


--
-- Table structure for table `amcos_warehouses`
--

CREATE TABLE `amcos_warehouses` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capacity` decimal(10,2) NOT NULL,
  `muvu_uid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amcos_warehouses`
--


--
-- Table structure for table `application_assets`
--

CREATE TABLE `application_assets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `application_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_value` decimal(12,2) NOT NULL,
  `financed_amount` decimal(12,2) NOT NULL,
  `asset_tenure_months` int NOT NULL,
  `asset_interest_rate` decimal(5,2) NOT NULL,
  `deposit_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `insurance_premium` decimal(12,2) DEFAULT NULL,
  `loan_to_value_ratio` decimal(5,2) GENERATED ALWAYS AS (((`financed_amount` / `asset_value`) * 100)) VIRTUAL,
  `is_primary_asset` tinyint(1) NOT NULL DEFAULT '1',
  `condition` enum('New','Used','Refurbished') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'New',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `application_assets_application_id_foreign` (`application_id`),
  KEY `application_assets_asset_id_foreign` (`asset_id`),
  CONSTRAINT `application_assets_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `financing_applications` (`id`) ON DELETE CASCADE,
  CONSTRAINT `application_assets_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_assets`
--


--
-- Table structure for table `application_documents`
--

CREATE TABLE `application_documents` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `application_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verification_status` enum('Pending','Verified','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `rejection_reason` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `application_documents_application_id_foreign` (`application_id`),
  CONSTRAINT `application_documents_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `financing_applications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_documents`
--


--
-- Table structure for table `application_status_history`
--

CREATE TABLE `application_status_history` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `application_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `changed_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_status` enum('applied','shortlisted','interview','offered','hired','rejected','archived') COLLATE utf8mb4_unicode_ci NOT NULL,
  `to_status` enum('applied','shortlisted','interview','offered','hired','rejected','archived') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `application_status_history_application_id_foreign` (`application_id`),
  KEY `application_status_history_changed_by_foreign` (`changed_by`),
  CONSTRAINT `application_status_history_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE CASCADE,
  CONSTRAINT `application_status_history_changed_by_foreign` FOREIGN KEY (`changed_by`) REFERENCES `employees` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_status_history`
--


--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `candidate_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` enum('Website','Walk-ins','LinkedIn','Google','Referrals','Internal Candidates','Socials','Others') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Website',
  `status` enum('applied','shortlisted','interview','offered','hired','rejected','archived') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'applied',
  `rating` int DEFAULT NULL,
  `cover_letter` text COLLATE utf8mb4_unicode_ci,
  `application_answers` json DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `applications_job_order_id_foreign` (`job_order_id`),
  KEY `applications_candidate_id_foreign` (`candidate_id`),
  KEY `applications_organisation_id_job_order_id_status_index` (`organisation_id`,`job_order_id`,`status`),
  KEY `applications_organisation_id_candidate_id_index` (`organisation_id`,`candidate_id`),
  CONSTRAINT `applications_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `applications_job_order_id_foreign` FOREIGN KEY (`job_order_id`) REFERENCES `job_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `applications_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `applications`
--


--
-- Table structure for table `appreciation_records`
--

CREATE TABLE `appreciation_records` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `calculation_date` date NOT NULL,
  `current_value` decimal(18,2) NOT NULL,
  `appreciation_amount` decimal(18,2) NOT NULL,
  `accumulated_appreciation` decimal(18,2) NOT NULL,
  `net_book_value` decimal(18,2) NOT NULL,
  `method` enum('Standard','Market Adjusted','Custom') COLLATE utf8mb4_unicode_ci NOT NULL,
  `appreciation_rate` decimal(5,2) NOT NULL,
  `status` enum('Calculated','Posted','Reversed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Calculated',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `fiscal_year_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `month` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appreciation_records_asset_id_foreign` (`asset_id`),
  KEY `appreciation_records_fiscal_year_id_foreign` (`fiscal_year_id`),
  CONSTRAINT `appreciation_records_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appreciation_records_fiscal_year_id_foreign` FOREIGN KEY (`fiscal_year_id`) REFERENCES `fiscal_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `appreciation_records`
--


--
-- Table structure for table `approval_levels`
--

CREATE TABLE `approval_levels` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approval_type` enum('Cash','Fuel','Repair','PurchaseRequest','PurchaseOrder','SalesOrder','Store','PayRoll','AssetDisposal','AssetFinancing','GoodsReceipt','Disposals','PurchaseQuoteEvaluation','Offers','QualityAssurance','SupplierLoan','LeaveApplication','Budget') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Cash',
  `level` int NOT NULL DEFAULT '1',
  `isactive` tinyint(1) NOT NULL DEFAULT '1',
  `mandate` int NOT NULL DEFAULT '1',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `approval_level_org_type_unique` (`level`,`organisation_id`,`approval_type`,`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `approval_levels`
--

INSERT INTO `approval_levels` VALUES ('11fd6571-0ecd-4f28-95f3-139a8d75d67e','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Fuel',3,1,1,NULL,'2026-01-21 11:50:10','2026-01-22 13:31:28','2026-01-22 13:31:28'),('16399bbf-609a-4643-bcb7-bb8fe1ebe586','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU MKUU','Fuel',1,1,1,NULL,'2026-01-21 11:48:22','2026-01-21 11:48:22',NULL),('38ad9cc6-5094-49d2-840b-51cae95c649e','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','PurchaseRequest',3,1,1,NULL,'2026-01-21 11:46:59','2026-01-22 13:29:16','2026-01-22 13:29:16'),('3a29b85f-f3f3-4bfd-b554-02f88e5d2ce9','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Repair',3,1,1,NULL,'2026-01-21 12:01:04','2026-01-21 12:01:04',NULL),('4a1163fe-ab6f-4e04-a8a3-5c747c72d210','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','Store',2,1,1,NULL,'2026-01-21 18:11:40','2026-01-22 16:35:09','2026-01-22 16:35:09'),('6357692d-0f71-4933-a6ab-cba1de9ff1e6','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','PayRoll',2,1,1,NULL,'2026-01-22 15:26:40','2026-01-22 15:26:40',NULL),('64aebbba-df4c-4e3c-9f97-eadfd1bcedf3','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Fuel',3,1,1,NULL,'2026-01-22 13:32:02','2026-01-22 13:32:02',NULL),('6ffb7f12-b3c7-41e0-b9fe-cd06d92af62c','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','PurchaseOrder',2,1,1,NULL,'2026-01-22 15:16:03','2026-01-22 16:23:07','2026-01-22 16:23:07'),('759aa60c-f86e-4a81-ac78-ee4e2e6d9548','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Budget',1,1,1,NULL,'2026-01-21 15:53:42','2026-01-21 15:53:42',NULL),('78c3fcb1-d4d9-4bf5-8784-fbd185375f75','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','PurchaseRequest',3,1,1,NULL,'2026-01-22 14:03:16','2026-01-22 14:03:16',NULL),('79216fe4-a0ef-4f77-ba34-9c09b201c251','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','AFISA MANUNUZI NA UGAVI','PurchaseRequest',1,1,1,NULL,'2026-01-21 11:43:48','2026-01-21 11:43:48',NULL),('79caaf8f-9621-4de3-988f-5059bc72e5bb','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU MKUU','PayRoll',1,1,1,NULL,'2026-01-22 15:26:14','2026-01-22 15:26:14',NULL),('7c6cc38b-2b48-4cc4-a7d1-d660bea09cb6','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Store',3,1,1,NULL,'2026-01-21 18:12:58','2026-01-22 16:34:42','2026-01-22 16:34:42'),('7d93fcbe-0718-4b05-ab7c-3d72eabf0488','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','Fuel',2,1,1,NULL,'2026-01-21 11:49:14','2026-01-21 11:49:14',NULL),('8219a503-37de-49ed-9321-c37837667c3c','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU MKUU','PurchaseRequest',2,1,1,NULL,'2026-01-21 11:45:12','2026-01-22 15:12:19',NULL),('83ff4650-056c-493a-8804-84794c710e09','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU MKUU','Cash',1,1,1,NULL,'2026-01-21 10:11:54','2026-01-21 10:11:54',NULL),('97c7fb33-25c4-43ac-8f60-69fbdb782958','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU  MKUU','Repair',1,1,1,NULL,'2026-01-21 11:51:53','2026-01-21 11:51:53',NULL),('a5c719b0-cb49-4a0f-b301-b18346e7c8f6','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','PayRoll',3,1,1,NULL,'2026-01-22 15:27:00','2026-01-22 15:27:00',NULL),('a7db6f7f-bad4-4a28-b5aa-fd305fdb24f1','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','AFISA MANUNUZI NA UGAVI','Store',1,1,1,NULL,'2026-01-21 18:07:00','2026-01-22 16:35:32',NULL),('a8651257-e336-40d0-af0f-79f90c4623f7','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU  MKUU','PurchaseOrder',1,1,1,NULL,'2026-01-22 15:15:24','2026-01-22 16:23:23','2026-01-22 16:23:23'),('b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','Cash',3,1,1,NULL,'2026-01-21 10:17:50','2026-01-21 10:17:50',NULL),('b64c028d-fa2a-4d7a-9469-07ba917dae82','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','SalesOrder',3,1,1,NULL,'2026-01-22 15:24:24','2026-01-22 15:24:24',NULL),('bde7e1b7-70f7-4695-ae09-8a0737cfe5ae','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','SalesOrder',2,1,1,NULL,'2026-01-22 15:23:06','2026-01-22 15:23:06',NULL),('c7afa57c-e5e6-4580-bf14-8953704de0b0','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','Repair',2,1,1,NULL,'2026-01-21 11:59:58','2026-01-21 11:59:58',NULL),('d239cda1-37e7-4a8e-8f1e-2048e3dec47a','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MENEJA MKUU','PurchaseOrder',1,1,1,NULL,'2026-01-22 15:16:40','2026-01-22 16:24:23',NULL),('d621b364-1b77-4975-ae1c-57302083b26e','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MHASIBU MKUU','SalesOrder',1,1,1,NULL,'2026-01-22 15:21:20','2026-01-22 15:21:20',NULL),('f6f5e135-6735-4aa9-8741-524aa0a92458','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','MKAGUZI MKUU WA NDANI','Cash',2,1,1,NULL,'2026-01-21 10:14:34','2026-01-21 10:14:34',NULL);

--
-- Table structure for table `approvers`
--

CREATE TABLE `approvers` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approval_level_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approver_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approver_names` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approver_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rank` int NOT NULL,
  `approver_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `approvers_approval_level_id_foreign` (`approval_level_id`),
  KEY `approvers_approver_id_foreign` (`approver_id`),
  CONSTRAINT `approvers_approval_level_id_foreign` FOREIGN KEY (`approval_level_id`) REFERENCES `approval_levels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `approvers_approver_id_foreign` FOREIGN KEY (`approver_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `approvers`
--

INSERT INTO `approvers` VALUES ('0182b0ca-9b98-4a4c-9d01-99efd07eef06','38ad9cc6-5094-49d2-840b-51cae95c649e','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 11:47:19','2026-01-21 18:55:52','2026-01-21 18:55:52'),('042852a6-fa3d-4e88-83ee-49c1a079aac6','759aa60c-f86e-4a81-ac78-ee4e2e6d9548','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 15:59:17','2026-01-21 15:59:26','2026-01-21 15:59:26'),('04e225c4-2956-4a41-87ea-4f78d3ebf47e','4a1163fe-ab6f-4e04-a8a3-5c747c72d210','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',2,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 18:12:28','2026-01-21 18:12:28',NULL),('0bddf0b6-b526-475c-904a-3dc8cc4aafa1','8219a503-37de-49ed-9321-c37837667c3c','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 18:59:03','2026-01-21 18:59:03',NULL),('10c82411-7e8a-46c5-a32c-517df3b0a5d3','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 10:13:26','2026-01-21 10:13:26',NULL),('1f3577f8-17eb-4f1d-9515-d18fda6a5c0d','bde7e1b7-70f7-4695-ae09-8a0737cfe5ae','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',2,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-22 15:23:44','2026-01-22 15:23:44',NULL),('2fffb094-552d-4f3c-abd2-1166af6322f5','79caaf8f-9621-4de3-988f-5059bc72e5bb','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-22 15:27:53','2026-01-22 15:27:53',NULL),('3f01f366-8427-44ea-b549-493cf06713f5','7c6cc38b-2b48-4cc4-a7d1-d660bea09cb6','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 18:13:14','2026-01-21 18:13:14',NULL),('4024f583-13c6-4d10-a560-b211ec9894a0','8219a503-37de-49ed-9321-c37837667c3c','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 11:46:30','2026-01-21 18:54:47','2026-01-21 18:54:47'),('466cd1fb-2b9b-416c-aa3a-bd7be152c2dc','38ad9cc6-5094-49d2-840b-51cae95c649e','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',3,'MENEJA MKUU',NULL,'2026-01-21 18:56:18','2026-01-21 18:57:39','2026-01-21 18:57:39'),('47a79332-3dbe-4beb-a14a-3d4e277c3658','759aa60c-f86e-4a81-ac78-ee4e2e6d9548','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 15:56:05','2026-01-21 15:57:20','2026-01-21 15:57:20'),('4ed3bd95-13e9-4d98-8b56-6d1e21f124af','78c3fcb1-d4d9-4bf5-8784-fbd185375f75','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-22 14:04:06','2026-01-22 14:04:06',NULL),('4f4f3bd3-c4cd-46c4-a2d5-c861a34c90e2','16399bbf-609a-4643-bcb7-bb8fe1ebe586','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 11:48:46','2026-01-21 11:48:46',NULL),('574cb33f-6dea-49e2-9da1-b904ba12fbd2','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 10:17:10','2026-01-21 10:17:10',NULL),('62c104a8-0fac-4783-a648-06399d632814','38ad9cc6-5094-49d2-840b-51cae95c649e','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 18:58:07','2026-01-21 18:58:07',NULL),('69a121fb-9064-4d80-badc-45eb72a487bc','3a29b85f-f3f3-4bfd-b554-02f88e5d2ce9','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 12:01:52','2026-01-21 12:01:52',NULL),('7255a28b-5cc1-4ed0-9014-3c9adfce09b4','d239cda1-37e7-4a8e-8f1e-2048e3dec47a','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-22 15:17:18','2026-01-22 15:17:18',NULL),('75268aab-f1af-421c-9ddf-f3eed2e9790e','11fd6571-0ecd-4f28-95f3-139a8d75d67e','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 11:50:42','2026-01-22 13:30:25','2026-01-22 13:30:25'),('81cda055-2b3e-4f83-9e03-ab3c8437d959','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 10:18:22','2026-01-21 10:18:22',NULL),('8d0bce3d-1415-49e3-a9f4-23ab865bebb4','c7afa57c-e5e6-4580-bf14-8953704de0b0','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 12:00:33','2026-01-21 12:00:33',NULL),('90b589c4-b32a-4ca4-8da1-1f988cd079f0','79caaf8f-9621-4de3-988f-5059bc72e5bb','f3683bee-094b-4aa6-8163-8d418a27eb6a','Alfred Platin','mplat84@gmail.com',1,'test','test','2026-01-30 00:39:06','2026-01-30 00:39:06',NULL),('96770b72-e5da-4d91-88c5-f64ddbe6168c','64aebbba-df4c-4e3c-9f97-eadfd1bcedf3','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-22 13:33:38','2026-01-22 13:33:38',NULL),('9a28a8f6-db10-4497-adf7-eaaf5a1633e4','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'Chief Internal Auditor',NULL,'2026-01-21 10:15:54','2026-01-21 10:16:28','2026-01-21 10:16:28'),('ae5d6333-41ea-4675-81c9-4242e7212638','79216fe4-a0ef-4f77-ba34-9c09b201c251','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 11:44:28','2026-01-21 18:53:46','2026-01-21 18:53:46'),('c97de039-b95a-4675-a892-7ad24f1214d8','8219a503-37de-49ed-9321-c37837667c3c','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',2,'MHASIBU MKUU',NULL,'2026-01-21 18:55:18','2026-01-21 18:58:31','2026-01-21 18:58:31'),('c9c786ea-6554-446f-b02d-5b217edcbc83','a5c719b0-cb49-4a0f-b301-b18346e7c8f6','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',3,'MENEJA MKUU',NULL,'2026-01-22 15:28:23','2026-01-22 15:28:23',NULL),('d1741396-1639-4b59-91c7-f1a9e0290912','a7db6f7f-bad4-4a28-b5aa-fd305fdb24f1','0ce29044-b626-407b-8000-d0ec38b721d4','Kelvin Mrope','procurementofficer@shireculimited.co.tz',1,'AFISA MANUNUZI NA UGAVI',NULL,'2026-01-22 16:36:10','2026-01-22 16:36:10',NULL),('d1bba45b-d683-43f9-a532-9f82c084949e','6ffb7f12-b3c7-41e0-b9fe-cd06d92af62c','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-22 15:18:34','2026-01-22 15:18:34',NULL),('d786f4ab-513c-4674-be6f-3d5d80aced15','7d93fcbe-0718-4b05-ab7c-3d72eabf0488','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',1,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-21 11:49:40','2026-01-21 11:49:40',NULL),('dc39481c-811f-4353-be02-8673ede19f44','759aa60c-f86e-4a81-ac78-ee4e2e6d9548','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MENEJA MKUU',NULL,'2026-01-21 16:00:33','2026-01-21 16:00:33',NULL),('e046405f-adde-433b-a0f0-ccbb43eb74d0','d621b364-1b77-4975-ae1c-57302083b26e','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-22 15:21:47','2026-01-22 15:21:47',NULL),('e92cce02-da40-4e18-8292-b1811b2089a1','b64c028d-fa2a-4d7a-9469-07ba917dae82','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',3,'MENEJA MKUU',NULL,'2026-01-22 15:24:55','2026-01-22 15:24:55',NULL),('eb2ad142-a218-4cbc-8e59-7565efb575a2','79216fe4-a0ef-4f77-ba34-9c09b201c251','0ce29044-b626-407b-8000-d0ec38b721d4','Kelvin Mrope','procurementofficer@shireculimited.co.tz',1,'AFISA MANUNUZI NA UGAVI',NULL,'2026-01-21 18:54:35','2026-01-21 18:54:35',NULL),('ed793650-43b6-4cbd-95c0-f4d6d67b709e','97c7fb33-25c4-43ac-8f60-69fbdb782958','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 11:52:29','2026-01-21 11:52:29',NULL),('f4441900-8bb5-46fa-ab69-22548a982480','a7db6f7f-bad4-4a28-b5aa-fd305fdb24f1','3de7c572-94cb-4a65-b30e-ba55d6c94893','Thomas Merengo','finance@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-21 18:11:04','2026-01-22 16:36:19','2026-01-22 16:36:19'),('f4e75975-bd10-4738-8ac7-ba026d64473a','6357692d-0f71-4933-a6ab-cba1de9ff1e6','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Joseph Bukombe','internalauditor@shireculimited.co.tz',2,'MKAGUZI MKUU WA NDANI',NULL,'2026-01-22 15:27:32','2026-01-22 15:27:32',NULL),('fd5bea42-bb99-4c2b-b71a-b99c332088fc','a8651257-e336-40d0-af0f-79f90c4623f7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Alpha Makasi','gm@shireculimited.co.tz',1,'MHASIBU MKUU',NULL,'2026-01-22 15:17:49','2026-01-22 15:17:49',NULL);

--
-- Table structure for table `asset_assignments`
--

CREATE TABLE `asset_assignments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assigned_to` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assigned_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reason_for_assignment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Returned','Damaged','Lost') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_assignments_assigned_by_foreign` (`assigned_by`),
  KEY `asset_assignments_asset_id_index` (`asset_id`),
  KEY `asset_assignments_assigned_to_index` (`assigned_to`),
  KEY `asset_assignments_status_index` (`status`),
  CONSTRAINT `asset_assignments_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_assignments_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_assignments_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_assignments`
--


--
-- Table structure for table `asset_attachments`
--

CREATE TABLE `asset_attachments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_attachments_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_attachments_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_attachments`
--


--
-- Table structure for table `asset_categories`
--

CREATE TABLE `asset_categories` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value_change_type` enum('Appreciation','Depreciation','N/A') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `depreciation_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cat_order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_categories`
--

INSERT INTO `asset_categories` VALUES ('26ce09a4-6f54-4fa3-a544-ba565afc33fe','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','INTANGIBLE ASSETS',10.00,'Software licenses, trademarks, patents, goodwill.',7,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('88747e3b-c027-4d64-9e3e-ee1ef95a6090','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','EQUIPMENT & MACHINERY',10.00,'Industrial, manufacturing, lab, and office equipment.',1,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('9b1ea24c-c242-45e3-b72c-0eba7130b449','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Appreciation','LAND',10.00,'Raw or developed land (non-depreciable)',5,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('9bfb2dde-8c33-4694-9e7e-e89dbd4e50bc','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','COMPUTER EQUIPMENT',10.00,'Laptops, desktops, servers, and peripherals.',2,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('a2648a0e-0d6d-4a0e-8841-35e7a3aed6d6','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','FURNITURE & FIXTURES',10.00,'Office desks, chairs, cabinets, fittings.',3,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('a83a7d2b-d40c-40e4-ab05-e2afc8f72902','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','N/A','OTHERS',10.00,'Other assets',8,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('acfb7f5f-6411-4448-ba10-b02a22ed6b25','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','VEHICLES MAGARI',10.00,'Company cars, trucks, motorcycles.',6,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),('e2aa6864-0c95-4396-be47-b6a1015a4f8b','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','Depreciation','BUILDINGS & IMPROVEMENTS',10.00,'Offices, warehouses, renovations.',4,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL);

--
-- Table structure for table `asset_checkins`
--

CREATE TABLE `asset_checkins` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rental_agreement_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_in_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checkin_time` timestamp NOT NULL,
  `ending_mileage` decimal(10,2) DEFAULT NULL,
  `ending_hours` decimal(10,2) DEFAULT NULL,
  `condition_notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `fuel_charge` decimal(10,2) DEFAULT NULL,
  `late_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
  `damage_charges` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cleaning_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
  `charges_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_checkins_asset_id_foreign` (`asset_id`),
  KEY `asset_checkins_rental_agreement_id_foreign` (`rental_agreement_id`),
  KEY `asset_checkins_checked_in_by_foreign` (`checked_in_by`),
  CONSTRAINT `asset_checkins_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_checkins_checked_in_by_foreign` FOREIGN KEY (`checked_in_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_checkins_rental_agreement_id_foreign` FOREIGN KEY (`rental_agreement_id`) REFERENCES `asset_rental_agreements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_checkins`
--


--
-- Table structure for table `asset_checkouts`
--

CREATE TABLE `asset_checkouts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rental_agreement_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checkout_time` timestamp NOT NULL,
  `starting_mileage` decimal(10,2) DEFAULT NULL,
  `starting_hours` decimal(10,2) DEFAULT NULL,
  `condition_notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `fuel_level` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_checkouts_asset_id_foreign` (`asset_id`),
  KEY `asset_checkouts_rental_agreement_id_foreign` (`rental_agreement_id`),
  KEY `asset_checkouts_checked_out_by_foreign` (`checked_out_by`),
  CONSTRAINT `asset_checkouts_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_checkouts_checked_out_by_foreign` FOREIGN KEY (`checked_out_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_checkouts_rental_agreement_id_foreign` FOREIGN KEY (`rental_agreement_id`) REFERENCES `asset_rental_agreements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_checkouts`
--


--
-- Table structure for table `asset_disposals`
--

CREATE TABLE `asset_disposals` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disposal_date` date NOT NULL,
  `disposal_type` enum('Sale','Scrap','Donation','Lost','Theft','Trade-In','Out-of-use') COLLATE utf8mb4_unicode_ci NOT NULL,
  `disposal_value` decimal(18,2) NOT NULL,
  `net_book_value` decimal(18,2) NOT NULL,
  `gain_loss` decimal(18,2) NOT NULL,
  `disposal_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disposed_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_disposals_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_disposals_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_disposals`
--


--
-- Table structure for table `asset_expenses`
--

CREATE TABLE `asset_expenses` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date` datetime NOT NULL,
  `narrative` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Reversed','Deleted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `reversed_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reverse_msg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reversed_date` date DEFAULT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_expenses_asset_id_foreign` (`asset_id`),
  KEY `asset_expenses_reversed_by_foreign` (`reversed_by`),
  KEY `asset_expenses_payment_method_id_foreign` (`payment_method_id`),
  KEY `asset_expenses_currency_id_foreign` (`currency_id`),
  CONSTRAINT `asset_expenses_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_expenses_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_expenses_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_expenses_reversed_by_foreign` FOREIGN KEY (`reversed_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_expenses`
--


--
-- Table structure for table `asset_financing_payments`
--

CREATE TABLE `asset_financing_payments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_schedule_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` date NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_financing_payments_contract_id_foreign` (`contract_id`),
  KEY `asset_financing_payments_payment_method_id_foreign` (`payment_method_id`),
  KEY `asset_financing_payments_payment_schedule_id_foreign` (`payment_schedule_id`),
  CONSTRAINT `asset_financing_payments_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `financing_contracts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_financing_payments_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_financing_payments_payment_schedule_id_foreign` FOREIGN KEY (`payment_schedule_id`) REFERENCES `payment_schedules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_financing_payments`
--


--
-- Table structure for table `asset_incomes`
--

CREATE TABLE `asset_incomes` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date` date NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `narrative` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Reversed','Deleted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `reversed_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reversed_date` date DEFAULT NULL,
  `reverse_msg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_incomes_asset_id_foreign` (`asset_id`),
  KEY `asset_incomes_payment_method_id_foreign` (`payment_method_id`),
  KEY `asset_incomes_currency_id_foreign` (`currency_id`),
  KEY `asset_incomes_reversed_by_foreign` (`reversed_by`),
  CONSTRAINT `asset_incomes_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_incomes_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_incomes_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_incomes_reversed_by_foreign` FOREIGN KEY (`reversed_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_incomes`
--


--
-- Table structure for table `asset_insurances`
--

CREATE TABLE `asset_insurances` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `policy_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `insurer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `insurance_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `insured_value` decimal(15,4) NOT NULL,
  `premium_frequency` enum('Monthly','Quarterly','Annual') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Monthly',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `coverage_details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_insurances_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_insurances_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_insurances`
--


--
-- Table structure for table `asset_locations`
--

CREATE TABLE `asset_locations` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_locations`
--


--
-- Table structure for table `asset_maintenance_attachments`
--

CREATE TABLE `asset_maintenance_attachments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_maintenance_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_maintenance_attachments_asset_maintenance_id_foreign` (`asset_maintenance_id`),
  CONSTRAINT `asset_maintenance_attachments_asset_maintenance_id_foreign` FOREIGN KEY (`asset_maintenance_id`) REFERENCES `asset_maintenances` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_maintenance_attachments`
--


--
-- Table structure for table `asset_maintenances`
--

CREATE TABLE `asset_maintenances` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `maintenance_type` enum('Preventive','Corrective','Scheduled') COLLATE utf8mb4_unicode_ci NOT NULL,
  `downtime_days` int NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost` decimal(18,2) DEFAULT NULL,
  `service_provider_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checklist` json DEFAULT NULL,
  `status` enum('Pending','In Progress','Completed','Cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `priority` enum('Low','Medium','High','Critical') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Medium',
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `approval_message` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registered_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completion_notes` text COLLATE utf8mb4_unicode_ci,
  `is_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `recurrence_pattern` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_maintenances_asset_id_foreign` (`asset_id`),
  KEY `asset_maintenances_service_provider_id_foreign` (`service_provider_id`),
  KEY `asset_maintenances_approved_by_foreign` (`approved_by`),
  KEY `asset_maintenances_registered_by_foreign` (`registered_by`),
  CONSTRAINT `asset_maintenances_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_maintenances_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_maintenances_registered_by_foreign` FOREIGN KEY (`registered_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_maintenances_service_provider_id_foreign` FOREIGN KEY (`service_provider_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_maintenances`
--


--
-- Table structure for table `asset_movements`
--

CREATE TABLE `asset_movements` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_location_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_location_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_assignment_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_assignment_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `movement_date` datetime NOT NULL,
  `actual_move_date` datetime DEFAULT NULL,
  `movement_type` enum('Transfer','Assignment','Return','Maintenance','Repair','Inventory','Disposal','Other') COLLATE utf8mb4_unicode_ci NOT NULL,
  `requested_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Approved','Completed','Rejected','Cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `reference_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `from_condition` text COLLATE utf8mb4_unicode_ci,
  `to_condition` text COLLATE utf8mb4_unicode_ci,
  `created_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_movements_asset_id_foreign` (`asset_id`),
  KEY `asset_movements_from_location_id_foreign` (`from_location_id`),
  KEY `asset_movements_to_location_id_foreign` (`to_location_id`),
  KEY `asset_movements_from_assignment_id_foreign` (`from_assignment_id`),
  KEY `asset_movements_to_assignment_id_foreign` (`to_assignment_id`),
  KEY `asset_movements_requested_by_foreign` (`requested_by`),
  KEY `asset_movements_approved_by_foreign` (`approved_by`),
  KEY `asset_movements_created_by_foreign` (`created_by`),
  CONSTRAINT `asset_movements_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asset_movements_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_movements_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asset_movements_from_assignment_id_foreign` FOREIGN KEY (`from_assignment_id`) REFERENCES `asset_assignments` (`id`),
  CONSTRAINT `asset_movements_from_location_id_foreign` FOREIGN KEY (`from_location_id`) REFERENCES `asset_locations` (`id`),
  CONSTRAINT `asset_movements_requested_by_foreign` FOREIGN KEY (`requested_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asset_movements_to_assignment_id_foreign` FOREIGN KEY (`to_assignment_id`) REFERENCES `asset_assignments` (`id`),
  CONSTRAINT `asset_movements_to_location_id_foreign` FOREIGN KEY (`to_location_id`) REFERENCES `asset_locations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_movements`
--


--
-- Table structure for table `asset_payments`
--

CREATE TABLE `asset_payments` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(18,2) NOT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date` date NOT NULL,
  `payment_method_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `narrative` text COLLATE utf8mb4_unicode_ci,
  `unique_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','reversed','canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `asset_payments_unique_id_unique` (`unique_id`),
  KEY `asset_payments_asset_id_foreign` (`asset_id`),
  KEY `asset_payments_organisation_id_foreign` (`organisation_id`),
  KEY `asset_payments_currency_id_foreign` (`currency_id`),
  KEY `asset_payments_payment_method_id_foreign` (`payment_method_id`),
  CONSTRAINT `asset_payments_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_payments_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`),
  CONSTRAINT `asset_payments_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_payments_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_payments`
--


--
-- Table structure for table `asset_rental_agreements`
--

CREATE TABLE `asset_rental_agreements` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `actual_return_date` date DEFAULT NULL,
  `status` enum('Reserved','Active','Completed','Cancelled','Overdue') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Reserved',
  `total_amount` decimal(12,2) NOT NULL,
  `security_deposit` decimal(10,2) NOT NULL,
  `damage_waiver_fee` decimal(10,2) DEFAULT NULL,
  `terms_conditions` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `special_instructions` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `asset_rental_agreements_contract_number_unique` (`contract_number`),
  KEY `asset_rental_agreements_customer_id_foreign` (`customer_id`),
  CONSTRAINT `asset_rental_agreements_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `rental_customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_rental_agreements`
--


--
-- Table structure for table `asset_transfers`
--

CREATE TABLE `asset_transfers` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_contract_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_contract_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_date` date NOT NULL,
  `transfer_type` enum('New','Repossession','Upgrade','Disposal') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_transfers_from_contract_id_foreign` (`from_contract_id`),
  KEY `asset_transfers_to_contract_id_foreign` (`to_contract_id`),
  KEY `asset_transfers_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_transfers_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_transfers_from_contract_id_foreign` FOREIGN KEY (`from_contract_id`) REFERENCES `financing_contracts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `asset_transfers_to_contract_id_foreign` FOREIGN KEY (`to_contract_id`) REFERENCES `financing_contracts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_transfers`
--


--
-- Table structure for table `asset_utilization`
--

CREATE TABLE `asset_utilization` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tracking_date` date NOT NULL,
  `days_rented` int NOT NULL,
  `days_maintenance` int NOT NULL,
  `days_available` int NOT NULL,
  `utilization_rate` decimal(5,2) NOT NULL,
  `revenue_generated` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_utilization_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_utilization_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_utilization`
--


--
-- Table structure for table `asset_valuations`
--

CREATE TABLE `asset_valuations` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valuation_date` date NOT NULL,
  `value` decimal(12,2) NOT NULL,
  `valued_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valuation_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_valuations_asset_id_foreign` (`asset_id`),
  CONSTRAINT `asset_valuations_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_valuations`
--


--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `asset_category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purchase_date` date NOT NULL,
  `purchase_cost` decimal(18,2) NOT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_value` decimal(18,2) NOT NULL DEFAULT '0.00',
  `accumulated_depreciation` decimal(18,2) NOT NULL DEFAULT '0.00',
  `supplier` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_put_to_use` date NOT NULL,
  `last_depreciation_date` date DEFAULT NULL,
  `last_appreciation_date` date DEFAULT NULL,
  `depreciation_method` enum('straight_line','declining_balance') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'straight_line',
  `depreciation_rate` decimal(5,2) NOT NULL DEFAULT '0.00',
  `appreciation_rate` int DEFAULT NULL,
  `depreciation_calculation_frequency` int DEFAULT NULL,
  `asset_account_id` bigint unsigned NOT NULL,
  `depreciation_account_id` bigint unsigned DEFAULT NULL,
  `depreciation_loss_account_id` bigint unsigned DEFAULT NULL,
  `depreciation_gain_account_id` bigint unsigned DEFAULT NULL,
  `appreciation_account_id` bigint unsigned DEFAULT NULL,
  `appreciation_loss_account_id` bigint unsigned DEFAULT NULL,
  `salvage_value` int DEFAULT NULL,
  `useful_life` int DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `warranty_expiry_date` date DEFAULT NULL,
  `status` enum('Available','Financed','Disposed','Under Maintenance') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Available',
  `codification_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building_cost` decimal(20,2) DEFAULT NULL,
  `condition` enum('Good','Fair','Poor','N/A') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N/A',
  `remarks` enum('Good','Service','Un-Serviceable','N/A') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N/A',
  `usage` enum('Warehouse','Office','Residential','Rent','Industry','N/A') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N/A',
  `plot_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_allocation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `district_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acquistion_cost` decimal(20,2) DEFAULT NULL,
  `surveyed_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `squire_meter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titled_deed_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `make` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `engine_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chasis_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_of_manufacture` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assets_asset_account_id_foreign` (`asset_account_id`),
  KEY `assets_depreciation_account_id_foreign` (`depreciation_account_id`),
  KEY `assets_depreciation_loss_account_id_foreign` (`depreciation_loss_account_id`),
  KEY `assets_depreciation_gain_account_id_foreign` (`depreciation_gain_account_id`),
  KEY `assets_appreciation_account_id_foreign` (`appreciation_account_id`),
  KEY `assets_appreciation_loss_account_id_foreign` (`appreciation_loss_account_id`),
  KEY `assets_currency_id_foreign` (`currency_id`),
  KEY `assets_asset_category_id_foreign` (`asset_category_id`),
  KEY `assets_supplier_foreign` (`supplier`),
  KEY `assets_modified_by_foreign` (`modified_by`),
  KEY `assets_branch_id_foreign` (`branch_id`),
  KEY `assets_created_by_foreign` (`created_by`),
  CONSTRAINT `assets_appreciation_account_id_foreign` FOREIGN KEY (`appreciation_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_appreciation_loss_account_id_foreign` FOREIGN KEY (`appreciation_loss_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_asset_account_id_foreign` FOREIGN KEY (`asset_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_asset_category_id_foreign` FOREIGN KEY (`asset_category_id`) REFERENCES `asset_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assets_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assets_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assets_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assets_depreciation_account_id_foreign` FOREIGN KEY (`depreciation_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_depreciation_gain_account_id_foreign` FOREIGN KEY (`depreciation_gain_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_depreciation_loss_account_id_foreign` FOREIGN KEY (`depreciation_loss_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `assets_modified_by_foreign` FOREIGN KEY (`modified_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assets_supplier_foreign` FOREIGN KEY (`supplier`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` VALUES ('7f213490-707e-4ee5-a3d9-9a1a877665b9','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','CAR','79367349634','88747e3b-c027-4d64-9e3e-ee1ef95a6090','2026-01-27',500000.00,'26b3126e-62de-40bc-bfcc-794fcd220251',0.00,0.00,'0e9dc6f0-cac5-453f-9653-81a7c3e18c0e','2026-01-28',NULL,NULL,'straight_line',4.00,NULL,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hsdividb',NULL,NULL,'07ed4bf3-eea2-489d-8b80-c379e67636e9',NULL,'Available','563497349',NULL,NULL,'Good','Good','N/A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-01-30 11:13:24','2026-01-30 11:13:24',NULL);

--
-- Table structure for table `attendance_devices`
--

CREATE TABLE `attendance_devices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `device_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendance_devices`
--


--
-- Table structure for table `attendance_records`
--

CREATE TABLE `attendance_records` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `employee_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `status` enum('Present','Absent','Late','On Leave') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Present',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_records_employee_id_foreign` (`employee_id`),
  CONSTRAINT `attendance_records_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendance_records`
--


--
-- Table structure for table `attendances`
--

CREATE TABLE `attendances` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `employee_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `biometric_user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attendance_date` date NOT NULL,
  `type` enum('check-in','check-out') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` enum('biometric','web','app') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL,
  `hours_worked` decimal(5,2) DEFAULT NULL,
  `overtime_hours` decimal(8,2) NOT NULL DEFAULT '0.00',
  `overtime_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendances_employee_id_foreign` (`employee_id`),
  CONSTRAINT `attendances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendances`
--


--
-- Table structure for table `attribute_values`
--

CREATE TABLE `attribute_values` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_values`
--


--
-- Table structure for table `attributes`
--

CREATE TABLE `attributes` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attributes`
--


--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_values` json DEFAULT NULL,
  `new_values` json DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--


--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_branch_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chart_of_account_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `swift_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exchange_rate` decimal(15,6) NOT NULL DEFAULT '1.000000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bank_accounts_account_no_unique` (`account_no`),
  KEY `bank_accounts_chart_of_account_id_foreign` (`chart_of_account_id`),
  KEY `bank_accounts_currency_id_foreign` (`currency_id`),
  KEY `bank_accounts_bank_branch_id_foreign` (`bank_branch_id`),
  KEY `bank_accounts_bank_id_foreign` (`bank_id`),
  KEY `bank_accounts_organisation_id_account_no_index` (`organisation_id`,`account_no`),
  CONSTRAINT `bank_accounts_bank_branch_id_foreign` FOREIGN KEY (`bank_branch_id`) REFERENCES `bank_branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_accounts_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_accounts_chart_of_account_id_foreign` FOREIGN KEY (`chart_of_account_id`) REFERENCES `chart_of_accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_accounts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_accounts_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_accounts`
--

INSERT INTO `bank_accounts` VALUES ('d4c42470-00e2-4f3f-b2c5-f47bf941969c','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','e177a182-ef03-44de-826a-d520dfea8cba','ec3cfb1a-a58c-4525-8b65-9794c2edb95d',183,'NMB ACCOUNT','30710046889',NULL,NULL,'NMB','26b3126e-62de-40bc-bfcc-794fcd220251',1.000000,'2026-01-28 17:25:34','2026-01-28 17:25:34',NULL);

--
-- Table structure for table `bank_branches`
--

CREATE TABLE `bank_branches` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bank_branches_bank_id_name_unique` (`bank_id`,`name`),
  CONSTRAINT `bank_branches_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_branches`
--

INSERT INTO `bank_branches` VALUES ('ec3cfb1a-a58c-4525-8b65-9794c2edb95d','e177a182-ef03-44de-826a-d520dfea8cba','MANONGA',NULL,NULL,'2026-01-28 17:21:48','2026-01-28 17:21:48',NULL);

--
-- Table structure for table `bank_statement_column_mappings`
--

CREATE TABLE `bank_statement_column_mappings` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `debit_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance_col` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bank_statement_column_mappings_bank_id_foreign` (`bank_id`),
  CONSTRAINT `bank_statement_column_mappings_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_statement_column_mappings`
--


--
-- Table structure for table `bank_statements`
--

CREATE TABLE `bank_statements` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_account_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `statement_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statement_date` date NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `opening_balance` decimal(15,2) NOT NULL,
  `closing_balance` decimal(15,2) NOT NULL,
  `total_credits` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_debits` decimal(15,2) NOT NULL DEFAULT '0.00',
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `statement_period` varchar(255) COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (concat(`start_date`,_utf8mb4' to ',`end_date`)) VIRTUAL,
  `version` int NOT NULL DEFAULT '1',
  `previous_version_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uploaded_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bank_statements_bank_account_id_version_unique` (`bank_account_id`,`version`),
  KEY `bank_statements_file_id_foreign` (`file_id`),
  KEY `bank_statements_uploaded_by_foreign` (`uploaded_by`),
  KEY `bank_statements_bank_account_id_statement_date_index` (`bank_account_id`,`statement_date`),
  KEY `bank_statements_bank_account_id_end_date_index` (`bank_account_id`,`end_date`),
  KEY `bank_statements_organisation_id_statement_date_index` (`organisation_id`,`statement_date`),
  CONSTRAINT `bank_statements_bank_account_id_foreign` FOREIGN KEY (`bank_account_id`) REFERENCES `bank_accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_statements_file_id_foreign` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_statements_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_statements_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_statements`
--


--
-- Table structure for table `bank_transactions`
--

CREATE TABLE `bank_transactions` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_statement_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_date` date NOT NULL,
  `reference_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `narration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `debit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `credit` decimal(15,2) NOT NULL DEFAULT '0.00',
  `balance` decimal(15,2) DEFAULT NULL,
  `journal_transaction_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_reconciled` tinyint(1) NOT NULL DEFAULT '0',
  `reconciled_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reconciled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bank_transactions_bank_statement_id_foreign` (`bank_statement_id`),
  KEY `bank_transactions_journal_transaction_id_foreign` (`journal_transaction_id`),
  KEY `bank_transactions_transaction_date_bank_statement_id_index` (`transaction_date`,`bank_statement_id`),
  KEY `bank_transactions_reference_number_index` (`reference_number`),
  CONSTRAINT `bank_transactions_bank_statement_id_foreign` FOREIGN KEY (`bank_statement_id`) REFERENCES `bank_statements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bank_transactions_journal_transaction_id_foreign` FOREIGN KEY (`journal_transaction_id`) REFERENCES `journal_transactions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_transactions`
--


--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES ('e177a182-ef03-44de-826a-d520dfea8cba','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','NMB','nmb@nmbtz.com',NULL,'2026-01-28 17:21:48','2026-01-28 17:21:48',NULL);

--
-- Table structure for table `batch_dependencies`
--

CREATE TABLE `batch_dependencies` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `child_batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity_used` decimal(15,3) NOT NULL,
  `uom_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `batch_dependencies_parent_batch_id_foreign` (`parent_batch_id`),
  KEY `batch_dependencies_child_batch_id_foreign` (`child_batch_id`),
  KEY `batch_dependencies_uom_id_foreign` (`uom_id`),
  CONSTRAINT `batch_dependencies_child_batch_id_foreign` FOREIGN KEY (`child_batch_id`) REFERENCES `production_batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `batch_dependencies_parent_batch_id_foreign` FOREIGN KEY (`parent_batch_id`) REFERENCES `production_batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `batch_dependencies_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `unit_of_measures` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `batch_dependencies`
--


--
-- Table structure for table `batch_material_usages`
--

CREATE TABLE `batch_material_usages` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `material_request_item_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uom_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_cost` decimal(15,2) NOT NULL DEFAULT '0.00',
  `qty_issued` decimal(15,3) NOT NULL,
  `qty_returned` decimal(15,3) NOT NULL DEFAULT '0.000',
  `qty_used` decimal(15,3) GENERATED ALWAYS AS ((`qty_issued` - `qty_returned`)) STORED,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `batch_material_usages_batch_id_foreign` (`batch_id`),
  KEY `batch_material_usages_material_request_item_id_foreign` (`material_request_item_id`),
  KEY `batch_material_usages_item_id_foreign` (`item_id`),
  KEY `batch_material_usages_uom_id_foreign` (`uom_id`),
  CONSTRAINT `batch_material_usages_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `production_batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `batch_material_usages_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `batch_material_usages_material_request_item_id_foreign` FOREIGN KEY (`material_request_item_id`) REFERENCES `material_request_items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `batch_material_usages_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `unit_of_measures` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `batch_material_usages`
--


--
-- Table structure for table `bill_of_material_items`
--

CREATE TABLE `bill_of_material_items` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bom_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uom_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(15,3) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bill_of_material_items_bom_id_foreign` (`bom_id`),
  KEY `bill_of_material_items_item_id_foreign` (`item_id`),
  KEY `bill_of_material_items_uom_id_foreign` (`uom_id`),
  CONSTRAINT `bill_of_material_items_bom_id_foreign` FOREIGN KEY (`bom_id`) REFERENCES `bill_of_materials` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bill_of_material_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `bill_of_material_items_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `unit_of_measures` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bill_of_material_items`
--

INSERT INTO `bill_of_material_items` VALUES ('8ee9adc2-8e6f-4012-8124-86437a2563d8','21789d55-1765-4afb-9493-aafca6c42975','eafbd702-c7ae-4800-97d8-1dbad407168d','5cb3d985-bf20-4635-8e02-ca4021850d21',5.000,NULL,NULL,NULL);

--
-- Table structure for table `bill_of_materials`
--

CREATE TABLE `bill_of_materials` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1.0',
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bill_of_materials_organisation_id_foreign` (`organisation_id`),
  KEY `bill_of_materials_item_id_foreign` (`item_id`),
  CONSTRAINT `bill_of_materials_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
  CONSTRAINT `bill_of_materials_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bill_of_materials`
--

INSERT INTO `bill_of_materials` VALUES ('21789d55-1765-4afb-9493-aafca6c42975','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','8e8c0df4-5931-4e30-833f-74e26b3aeb58','001',NULL,'2026-01-23 14:58:06','2026-01-23 14:58:06',NULL);

--
-- Table structure for table `billing_cycles`
--

CREATE TABLE `billing_cycles` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billing_cycles`
--


--
-- Table structure for table `billing_terms`
--

CREATE TABLE `billing_terms` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_order_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_type` enum('hourly','daily','weekly','monthly','fixed-fee','contingency') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'hourly',
  `rate` decimal(12,2) NOT NULL,
  `payment_due_days` int NOT NULL DEFAULT '30',
  `fee_percentage` decimal(5,2) DEFAULT NULL,
  `min_fee` decimal(12,2) DEFAULT NULL,
  `max_fee` decimal(12,2) DEFAULT NULL,
  `expenses_billable` tinyint(1) NOT NULL DEFAULT '1',
  `expense_markup_percentage` decimal(5,2) DEFAULT NULL,
  `discount_type` enum('percentage','fixed') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_amount` decimal(12,2) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billing_terms_contract_id_foreign` (`contract_id`),
  KEY `billing_terms_job_order_id_foreign` (`job_order_id`),
  KEY `billing_terms_currency_id_foreign` (`currency_id`),
  CONSTRAINT `billing_terms_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contract_terms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `billing_terms_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `billing_terms_job_order_id_foreign` FOREIGN KEY (`job_order_id`) REFERENCES `job_orders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billing_terms`
--


--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timezone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EAT — Eastern Africa Time',
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `branches_organisation_id_foreign` (`organisation_id`),
  CONSTRAINT `branches_organisation_id_foreign` FOREIGN KEY (`organisation_id`) REFERENCES `organisations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` VALUES ('07ed4bf3-eea2-489d-8b80-c379e67636e9','Main Branch','001','025-2820124',NULL,'info@shinyanga.org',NULL,'6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','EAT — Eastern Africa Time',NULL,'2026-01-20 02:08:20','2026-01-20 02:08:20',NULL),('858c0ecb-4bb8-4011-9bd6-de45ff674bbc','main','01',NULL,NULL,'info@shinyanga.org',NULL,'6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','EAT — Eastern Africa Time',NULL,'2026-01-20 02:08:22','2026-01-20 02:08:22',NULL);

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--


--
-- Table structure for table `budget_allocations`
--

CREATE TABLE `budget_allocations` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_category_id` bigint unsigned NOT NULL,
  `allocated_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `committed_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `spent_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `remaining_amount` decimal(20,2) GENERATED ALWAYS AS ((`allocated_amount` - `spent_amount`)) STORED,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `budget_allocations_account_category_id_foreign` (`account_category_id`),
  KEY `budget_allocations_budget_id_index` (`budget_id`),
  CONSTRAINT `budget_allocations_account_category_id_foreign` FOREIGN KEY (`account_category_id`) REFERENCES `account_sub_categories` (`id`),
  CONSTRAINT `budget_allocations_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_allocations`
--


--
-- Table structure for table `budget_approvals`
--

CREATE TABLE `budget_approvals` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approvable_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approvable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approver_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approval_level_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','requires_revision') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `comments` text COLLATE utf8mb4_unicode_ci,
  `approved_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `budget_approvals_approval_level_id_foreign` (`approval_level_id`),
  KEY `budget_approvals_approver_id_foreign` (`approver_id`),
  KEY `budget_approvals_approvable_id_approvable_type_index` (`approvable_id`,`approvable_type`),
  CONSTRAINT `budget_approvals_approval_level_id_foreign` FOREIGN KEY (`approval_level_id`) REFERENCES `approval_levels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budget_approvals_approver_id_foreign` FOREIGN KEY (`approver_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_approvals`
--


--
-- Table structure for table `budget_constraints`
--

CREATE TABLE `budget_constraints` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('max_per_transaction','category_cap','time_restriction') COLLATE utf8mb4_unicode_ci NOT NULL,
  `limit_amount` decimal(20,2) DEFAULT NULL,
  `conditions` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_constraints`
--


--
-- Table structure for table `budget_documents`
--

CREATE TABLE `budget_documents` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `doc_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `budget_documents_budget_id_foreign` (`budget_id`),
  CONSTRAINT `budget_documents_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_documents`
--


--
-- Table structure for table `budget_item_periods`
--

CREATE TABLE `budget_item_periods` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_item_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `period_start` date NOT NULL,
  `period_end` date NOT NULL,
  `period_amount` decimal(20,2) NOT NULL,
  `period_spent` decimal(20,2) NOT NULL DEFAULT '0.00',
  `period_remaining` decimal(20,2) GENERATED ALWAYS AS ((`period_amount` - `period_spent`)) STORED,
  `frequency` enum('Weekly','Monthly','Quarterly','Yearly') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Monthly',
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_item_periods`
--


--
-- Table structure for table `budget_items`
--

CREATE TABLE `budget_items` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `allocation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `type` enum('Revenue','Expense') COLLATE utf8mb4_unicode_ci NOT NULL,
  `spent_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `remaining_amount` decimal(20,2) GENERATED ALWAYS AS ((`amount` - `spent_amount`)) STORED,
  `coa` bigint unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `budget_items_coa_allocation_id_unique` (`coa`,`allocation_id`),
  KEY `budget_items_coa_allocation_id_index` (`coa`,`allocation_id`),
  KEY `budget_items_allocation_id_foreign` (`allocation_id`),
  CONSTRAINT `budget_items_allocation_id_foreign` FOREIGN KEY (`allocation_id`) REFERENCES `budget_allocations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budget_items_coa_foreign` FOREIGN KEY (`coa`) REFERENCES `chart_of_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_items`
--


--
-- Table structure for table `budget_revisions`
--

CREATE TABLE `budget_revisions` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `changes` json NOT NULL,
  `revised_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revised_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_revisions`
--


--
-- Table structure for table `budget_templates`
--

CREATE TABLE `budget_templates` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_structure` json NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_templates`
--


--
-- Table structure for table `budget_transfers`
--

CREATE TABLE `budget_transfers` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to_budget_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_date` timestamp NOT NULL,
  `status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budget_transfers`
--


--
-- Table structure for table `budgets`
--

CREATE TABLE `budgets` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fiscal_year_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `current_approval_level` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_allocated_expenses` decimal(20,2) NOT NULL DEFAULT '0.00',
  `total_allocated_income` decimal(20,2) NOT NULL DEFAULT '0.00',
  `total_spent_expenses` decimal(20,2) NOT NULL DEFAULT '0.00',
  `total_spent_income` decimal(20,2) NOT NULL DEFAULT '0.00',
  `remaining_expenses` decimal(20,2) GENERATED ALWAYS AS ((`total_allocated_expenses` - `total_spent_expenses`)) STORED,
  `remaining_income` decimal(20,2) GENERATED ALWAYS AS ((`total_allocated_income` - `total_spent_income`)) STORED,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `budget_category_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `budget_category` enum('Operational','Capital Expenditure') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Operational',
  `status` enum('draft','submitted','in_review','requires_revision','approved','rejected','cancelled','archived') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `submitted_at` timestamp NULL DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `submitted_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approved_by` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_budget_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revision_number` int NOT NULL DEFAULT '1',
  `is_latest` tinyint(1) NOT NULL DEFAULT '1',
  `version_metadata` json DEFAULT NULL,
  `created_from_version` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `budgets_budget_category_id_foreign` (`budget_category_id`),
  KEY `budgets_parent_id_foreign` (`parent_id`),
  KEY `budgets_currency_id_foreign` (`currency_id`),
  KEY `budgets_fiscal_year_id_foreign` (`fiscal_year_id`),
  KEY `budgets_submitted_by_foreign` (`submitted_by`),
  KEY `budgets_approved_by_foreign` (`approved_by`),
  KEY `budgets_current_approval_level_foreign` (`current_approval_level`),
  CONSTRAINT `budgets_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `employees` (`id`),
  CONSTRAINT `budgets_budget_category_id_foreign` FOREIGN KEY (`budget_category_id`) REFERENCES `budget_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budgets_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budgets_current_approval_level_foreign` FOREIGN KEY (`current_approval_level`) REFERENCES `approval_levels` (`id`),
  CONSTRAINT `budgets_fiscal_year_id_foreign` FOREIGN KEY (`fiscal_year_id`) REFERENCES `fiscal_years` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budgets_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `budgets_submitted_by_foreign` FOREIGN KEY (`submitted_by`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budgets`
--


--
-- Table structure for table `buyers`
--

CREATE TABLE `buyers` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `buyers`
--


--
-- Table structure for table `candidate_number_sequences`
--

CREATE TABLE `candidate_number_sequences` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `use_year_month` tinyint(1) NOT NULL DEFAULT '1',
  `use_branch_number` tinyint(1) NOT NULL DEFAULT '0',
  `last_sequence` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_sequence_per_org` (`organisation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidate_number_sequences`
--

INSERT INTO `candidate_number_sequences` VALUES ('9c2f844d-19cd-4fb1-85aa-8ff1b0b6b158','6d09af6b-ca58-4967-bbb1-02d0ecafc7e9','HAYS',1,0,0,NULL,NULL,NULL);

--
-- Table structure for table `candidate_skills`
--

CREATE TABLE `candidate_skills` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `candidate_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `skill_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `proficiency_level` enum('Beginner','Intermediate','Advanced','Expert') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Beginner',
  `years_experience` int DEFAULT NULL,
  `last_used` date DEFAULT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `candidate_skills_candidate_id_foreign` (`candidate_id`),
  KEY `candidate_skills_skill_id_foreign` (`skill_id`),
  CONSTRAINT `candidate_skills_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_skills_skill_id_foreign` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidate_skills`
--


--
-- Table structure for table `candidates`
--

CREATE TABLE `candidates` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organisation_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `registered_by` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `candidate_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_job_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_employer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `years_experience` int DEFAULT NULL,
  `availability` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_expectations` decimal(10,2) DEFAULT NULL,
  `notice_period` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` enum('Website','Walk-ins','LinkedIn','Google','Referrals','Internal Candidates','Socials','Others') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Website',
  `status` enum('New','Old') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'New',
  `department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `github_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `portfolio_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `consent_date` timestamp NULL DEFAULT NULL,
  `data_retention_period` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `candidates_candidate_number_unique` (`candidate_number`),
  KEY `candidates_registered_by_foreign` (`registered_by`),
  KEY `candidates_branch_id_foreign` (`branch_id`),
  CONSTRAINT `candidates_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidates_registered_by_foreign` FOREIGN KEY (`registered_by`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidates`
--


--
-- Table structure for table `cash_flow_mappings`
--

CREATE TABLE `cash_flow_mappings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_sub_category_id` bigint unsigned NOT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `treatment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Add or Subtract for indirect method adjustments',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_flow_mappings_account_sub_category_id_foreign` (`account_sub_category_id`),
  CONSTRAINT `cash_flow_mappings_account_sub_category_id_foreign` FOREIGN KEY (`account_sub_category_id`) REFERENCES `account_sub_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_flow_mappings`
--

INSERT INTO `cash_flow_mappings` VALUES (1,2,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(2,3,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-26 12:40:52',NULL),(3,4,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-26 12:40:52',NULL),(4,5,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-26 12:40:52',NULL),(5,6,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(6,8,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(7,9,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(8,10,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(9,11,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(10,12,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-26 12:40:53',NULL),(11,13,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(12,16,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-26 12:40:53',NULL),(13,28,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(14,29,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(15,32,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(16,34,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(17,39,'Non-cash item. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-26 12:40:53',NULL),(18,40,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(19,41,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(20,42,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(21,43,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(22,44,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(23,47,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(24,67,'Remove gains from operating activities','Subtract','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(25,88,'Non-cash item. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(26,2,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(27,3,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(28,4,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(29,5,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(30,6,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(31,8,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(32,9,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(33,10,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(34,11,'Category: Investing activity','None','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(35,12,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(36,13,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(37,16,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(38,28,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(39,29,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(40,32,'Non-cash item','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(41,34,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(42,39,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(43,40,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(44,41,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(45,42,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(46,43,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(47,44,'Working capital increase = cash inflow','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(48,47,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(49,67,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(50,88,'Non-cash item. Category: Operating activity','Add','2026-01-20 02:08:22','2026-01-20 02:08:22',NULL),(51,1,'Category: Investing activity','None','2026-01-26 12:40:52','2026-01-26 12:40:52',NULL),(52,14,'Working capital increase = cash inflow','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(53,15,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(54,17,'Working capital increase = cash inflow','Add','2026-01-26 12:40:53','2026-01-26 12:56:03',NULL),(55,18,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(56,19,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:56:03',NULL),(57,20,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(58,26,'Remove gains from operating activities','Subtract','2026-01-26 12:40:53','2026-01-26 13:04:35',NULL),(59,1,'Category: Investing activity','None','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(60,3,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(61,4,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(62,5,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(63,11,'Category: Investing activity','None','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(64,12,'Category: Investing activity','None','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(65,14,'Working capital increase = cash inflow','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(66,15,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(67,16,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(68,17,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(69,18,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(70,19,'Working capital increase = cash inflow','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(71,20,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(72,26,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(73,39,'Non-cash item. Category: Operating activity','Add','2026-01-26 12:40:53','2026-01-26 12:40:53',NULL),(74,21,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:03','2026-01-26 12:56:03',NULL),(75,22,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:03','2026-01-30 10:31:38',NULL),(76,23,'Working capital increase = cash inflow','Add','2026-01-26 12:56:03','2026-01-30 10:31:38',NULL),(77,1,'Category: Investing activity','None','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(78,3,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(79,4,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(80,5,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(81,11,'Category: Investing activity','None','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(82,12,'Category: Investing activity','None','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(83,17,'Working capital increase = cash inflow','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(84,18,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(85,19,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(86,20,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(87,21,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(88,22,'Working capital increase = cash inflow','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(89,23,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(90,26,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(91,39,'Non-cash item. Category: Operating activity','Add','2026-01-26 12:56:04','2026-01-26 12:56:04',NULL),(92,1,'Category: Investing activity','None','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(93,3,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(94,4,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(95,5,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(96,11,'Category: Investing activity','None','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(97,12,'Category: Investing activity','None','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(98,17,'Working capital increase = cash inflow','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(99,18,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(100,19,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(101,20,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(102,21,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(103,22,'Working capital increase = cash inflow','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(104,23,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(105,26,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(106,39,'Non-cash item. Category: Operating activity','Add','2026-01-26 13:04:35','2026-01-26 13:04:35',NULL),(107,24,'Working capital increase = cash inflow','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(108,31,'Remove gains from operating activities','Subtract','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(109,1,'Category: Investing activity','None','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(110,3,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(111,4,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(112,5,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(113,11,'Category: Investing activity','None','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(114,12,'Category: Investing activity','None','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(115,17,'Working capital increase = cash inflow','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(116,18,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(117,19,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(118,20,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(119,21,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(120,22,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(121,23,'Working capital increase = cash inflow','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(122,24,'Working capital increase = cash inflow','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL),(123,31,'Working capital increase = cash inflow. Category: Operating activity','Add','2026-01-30 10:31:38','2026-01-30 10:31:38',NULL);

--
-- Table structure for table `cash_flow_statement_cache`
--

CREATE TABLE `cash_flow_statement_cache` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fiscal_year_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operating_activities` json NOT NULL,
  `investing_activities` json NOT NULL,
  `financing_activities` json NOT NULL,
  `net_cash_flow` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_flow_statement_cache_fiscal_year_id_foreign` (`fiscal_year_id`),
  CONSTRAINT `cash_flow_statement_cache_fiscal_year_id_foreign` FOREIGN KEY (`fiscal_year_id`) REFERENCES `fiscal_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_flow_statement_cache`
--


--
-- Table structure for table `cash_requisition_item_approvals`
--

CREATE TABLE `cash_requisition_item_approvals` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cash_requisition_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cash_requisition_item_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approval_level_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approver_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Approved','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved_quantity` int DEFAULT NULL,
  `approved_unit_cost` decimal(20,2) NOT NULL DEFAULT '0.00',
  `approved_total_cost` decimal(20,2) GENERATED ALWAYS AS ((`approved_quantity` * `approved_unit_cost`)) STORED,
  `date_approved` date NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_requisition_item_approvals_cash_requisition_id_foreign` (`cash_requisition_id`),
  KEY `cash_requisition_item_approvals_cash_requisition_item_id_foreign` (`cash_requisition_item_id`),
  KEY `cash_requisition_item_approvals_approver_id_foreign` (`approver_id`),
  KEY `cash_requisition_item_approvals_approval_level_id_foreign` (`approval_level_id`),
  CONSTRAINT `cash_requisition_item_approvals_approval_level_id_foreign` FOREIGN KEY (`approval_level_id`) REFERENCES `approval_levels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_requisition_item_approvals_approver_id_foreign` FOREIGN KEY (`approver_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_requisition_item_approvals_cash_requisition_id_foreign` FOREIGN KEY (`cash_requisition_id`) REFERENCES `cash_requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_requisition_item_approvals_cash_requisition_item_id_foreign` FOREIGN KEY (`cash_requisition_item_id`) REFERENCES `cash_requisition_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_requisition_item_approvals`
--

INSERT INTO `cash_requisition_item_approvals` (`id`, `cash_requisition_id`, `cash_requisition_item_id`, `approval_level_id`, `approver_id`, `status`, `approved_quantity`, `approved_unit_cost`, `date_approved`, `comments`, `created_at`, `updated_at`) VALUES ('04cd6a15-1957-4422-8c30-c64f0e2b499a','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','cf4d4008-a582-471d-a9d6-c25f3c403270','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,700000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('0b8e0861-d5ec-4cc7-ab47-a910e40fbdcc','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','6269d6c0-f6bc-46e0-95e4-f3718fe3215f','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('0c8cbb10-59b1-4e9f-b2f8-086c98c59dd1','cd026383-dd57-464d-a999-2c70d6cf82b8','23a72ae5-860a-4d45-aa5b-4681f9653ab8','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,100000.00,'2026-01-22','Approved as requested','2026-01-22 16:03:02','2026-01-22 16:03:02'),('177a601e-56ac-4de0-b7a1-71489c4a6b4d','21cf16d1-e670-4040-94aa-c88b849919e8','1151ff40-3703-48b8-ad2b-d69a1c66e8d9','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',10,1040000.00,'2026-01-28','Approved as requested','2026-01-28 16:51:47','2026-01-28 16:51:47'),('1b027463-36d7-49c7-89fa-8e4cae3f57e3','55955b02-1fed-48c2-aa89-15c94e34fcfa','6879e143-b367-4cce-982e-f427857f2e42','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,130000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29'),('26e89beb-2a3e-44bc-8300-dae9bcea9fbf','55955b02-1fed-48c2-aa89-15c94e34fcfa','618898ca-9983-4034-932f-f0171b942a13','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('2b18479e-ff33-42f0-93b2-7e6616debd2e','55955b02-1fed-48c2-aa89-15c94e34fcfa','0bfc0148-ba75-45ac-9ff7-b11a8c80548e','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',5,100000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('2f21051e-a325-4a74-b0ab-18fefedfd292','55955b02-1fed-48c2-aa89-15c94e34fcfa','653a4c7e-221e-4d71-8ac8-3ccad63293c9','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('33552497-1704-402c-8d6c-1138d77bb0cf','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','6269d6c0-f6bc-46e0-95e4-f3718fe3215f','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('3613b51f-9115-466b-b82d-d0642325f17c','55955b02-1fed-48c2-aa89-15c94e34fcfa','653a4c7e-221e-4d71-8ac8-3ccad63293c9','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29'),('36f7bd99-f309-4fb4-a843-24cfe563e7e0','55955b02-1fed-48c2-aa89-15c94e34fcfa','d3970a6a-615b-4e2b-af6a-5c0b60f96c8c','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29'),('3cb58875-5db7-4a01-b5ab-43bc37217e22','cd026383-dd57-464d-a999-2c70d6cf82b8','23a72ae5-860a-4d45-aa5b-4681f9653ab8','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,100000.00,'2026-01-22','Approved as requested','2026-01-22 16:02:23','2026-01-22 16:02:23'),('3cbb1ce2-bdf4-4b19-aa63-7224b73ca198','bae35a1a-3500-4e8f-a5f0-8208dbf8e5c3','65696d98-67c9-48cb-801d-b739fa9bd52d','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,200000.00,'2026-01-21','good',NULL,NULL),('4108c5d6-4122-4cd6-846e-3a0169b1669c','cd026383-dd57-464d-a999-2c70d6cf82b8','23a72ae5-860a-4d45-aa5b-4681f9653ab8','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,100000.00,'2026-01-22','Approved as requested','2026-01-22 15:59:57','2026-01-22 15:59:57'),('43def33f-27ae-4d6c-9bf5-360bf1b478f1','2a7d2a11-00db-4460-a4d9-df413b05a29d','8505a4f7-eebd-498d-928b-ca4ebe2f170d','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,5000000.00,'2026-01-23','GOOD','2026-01-23 12:01:56','2026-01-23 12:01:56'),('45413bdd-7a1d-4547-bdc3-fef66017cdb9','55955b02-1fed-48c2-aa89-15c94e34fcfa','618898ca-9983-4034-932f-f0171b942a13','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('4597dcba-915b-43ce-b798-977bfb54bfd6','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','dbb17899-e30f-4e3b-ad24-9cca5c9ac796','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,900000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('4b2b427f-79ab-47e8-90f1-797b6008f293','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','4dddbd7e-6690-440e-b3a4-2d6d6d2144ba','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('4be0d594-6d53-4442-b97e-e402eaa3acfb','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','8b836b33-29fc-4a6f-9f6c-a64d5eafcf6d','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('4ca840d3-20b4-4ef6-a209-118e929e55e7','21cf16d1-e670-4040-94aa-c88b849919e8','1151ff40-3703-48b8-ad2b-d69a1c66e8d9','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',10,1040000.00,'2026-01-28','Malipo yanaweza kuendelea','2026-01-28 16:50:04','2026-01-28 16:50:04'),('54641b52-174f-449e-a67d-3b0a9855f3bb','55955b02-1fed-48c2-aa89-15c94e34fcfa','c3d08f2b-5f17-4bcf-aeee-8987197f0a07','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29'),('584b0a97-d949-414f-9590-3a0fa012bd75','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','8b836b33-29fc-4a6f-9f6c-a64d5eafcf6d','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('5c9c312a-68ef-4081-acb1-f69ef78e8ae7','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','0dc6cca5-426b-42ab-a48e-21c99748d03a','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('61fa5b4c-0cdb-44b0-bead-4ca6fb13e378','55955b02-1fed-48c2-aa89-15c94e34fcfa','653a4c7e-221e-4d71-8ac8-3ccad63293c9','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('66df05f1-b21d-4edb-a75d-03ff851899ed','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','dbb17899-e30f-4e3b-ad24-9cca5c9ac796','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,900000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('71eea021-b1b0-433a-83c0-2b77109ff9a3','55955b02-1fed-48c2-aa89-15c94e34fcfa','6879e143-b367-4cce-982e-f427857f2e42','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,130000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('751f424f-bcd1-42ee-b776-3ff11f88d073','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','4dddbd7e-6690-440e-b3a4-2d6d6d2144ba','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('7bd51a87-0b7e-4665-a208-e6c016684dde','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','dbb17899-e30f-4e3b-ad24-9cca5c9ac796','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,900000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('8079b43a-c56e-4be8-ab5b-d89d12d5d32f','21cf16d1-e670-4040-94aa-c88b849919e8','1151ff40-3703-48b8-ad2b-d69a1c66e8d9','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',10,1040000.00,'2026-01-28','It may proceed the budget for the request is present','2026-01-28 16:41:50','2026-01-28 16:41:50'),('86982ad4-57c3-49a9-ae4a-cb2266a0fe9e','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','0dc6cca5-426b-42ab-a48e-21c99748d03a','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('8ab2829d-2a75-4c59-a9e2-59335c5a59fd','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','cf4d4008-a582-471d-a9d6-c25f3c403270','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,700000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('910e5cae-c10c-405f-baeb-45d0af301490','55955b02-1fed-48c2-aa89-15c94e34fcfa','d3970a6a-615b-4e2b-af6a-5c0b60f96c8c','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('91cd3b46-919b-4421-bbd6-ac31a35a40c1','55955b02-1fed-48c2-aa89-15c94e34fcfa','0bfc0148-ba75-45ac-9ff7-b11a8c80548e','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',5,100000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29'),('9852c699-dff0-4bc9-9415-22143d927011','55955b02-1fed-48c2-aa89-15c94e34fcfa','6879e143-b367-4cce-982e-f427857f2e42','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,130000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('98c56ff3-f004-4afe-966d-9e03453ea3ef','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','caab8318-99f0-4f5b-aca9-814e04b343eb','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,2000000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('9d4bab3d-4e03-44f6-8804-f61c79c97c20','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','0dc6cca5-426b-42ab-a48e-21c99748d03a','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('9ee83e09-8799-4cf4-89e7-0924d5ed9e2f','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','cf4d4008-a582-471d-a9d6-c25f3c403270','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,700000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('a1fa521b-139d-42aa-b9e0-383a7432aac3','55955b02-1fed-48c2-aa89-15c94e34fcfa','0bfc0148-ba75-45ac-9ff7-b11a8c80548e','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',5,100000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('a4cc625e-0e7b-4160-bcd8-fc72211674eb','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','caab8318-99f0-4f5b-aca9-814e04b343eb','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,2000000.00,'2026-01-28','Approved as requested','2026-01-28 17:05:03','2026-01-28 17:05:03'),('a6901a2e-5ca1-4f55-818e-c4aa59308923','55955b02-1fed-48c2-aa89-15c94e34fcfa','d3970a6a-615b-4e2b-af6a-5c0b60f96c8c','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('aa7c0ce3-cc68-40b7-8fe9-5857cd1096d9','55955b02-1fed-48c2-aa89-15c94e34fcfa','c3d08f2b-5f17-4bcf-aeee-8987197f0a07','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:30','2026-01-30 10:29:30'),('adcdbcdb-75a2-4005-9688-34ae062f220c','fe4edea6-0273-462d-a2de-73098e616d31','94a3cb9e-7f3f-4ec0-9a00-c6bade66804a','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',5,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:24:17','2026-01-30 10:24:17'),('bcca7efb-a089-4572-b0be-6d654fb3b4f4','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','8b836b33-29fc-4a6f-9f6c-a64d5eafcf6d','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,1500000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('bd0e9110-3321-4fd0-ac05-ddfd29801d20','2a7d2a11-00db-4460-a4d9-df413b05a29d','8505a4f7-eebd-498d-928b-ca4ebe2f170d','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,5000000.00,'2026-01-23','Approved as requested','2026-01-23 12:08:04','2026-01-23 12:08:04'),('c34d9cef-f89e-4dbc-a652-74296718fec4','2a7d2a11-00db-4460-a4d9-df413b05a29d','8505a4f7-eebd-498d-928b-ca4ebe2f170d','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,5000000.00,'2026-01-23','Approved as requested','2026-01-23 12:06:49','2026-01-23 12:06:49'),('cc628f2b-af8a-4bd0-b772-f6a06152589c','fe4edea6-0273-462d-a2de-73098e616d31','94a3cb9e-7f3f-4ec0-9a00-c6bade66804a','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',5,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:29:46','2026-01-30 10:29:46'),('dc581e0f-f4d1-4043-b8d8-d68271341fa3','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','6269d6c0-f6bc-46e0-95e4-f3718fe3215f','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('e45a2b6d-2933-4aa4-b906-4c7bc42e36c5','fe4edea6-0273-462d-a2de-73098e616d31','94a3cb9e-7f3f-4ec0-9a00-c6bade66804a','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',5,200000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:48','2026-01-30 10:28:48'),('f2396595-5731-4eb2-bb5a-cd1692e98dbd','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','4dddbd7e-6690-440e-b3a4-2d6d6d2144ba','b01ae9e8-5184-4b7c-aa52-7e7aff36e0a7','96455ad8-19dc-4d71-ac7c-19e23d7b3e0c','Approved',1,1300000.00,'2026-01-28','Approved as requested','2026-01-28 17:07:41','2026-01-28 17:07:41'),('f57305b1-955d-4ec6-aa58-34541d3282e6','55955b02-1fed-48c2-aa89-15c94e34fcfa','c3d08f2b-5f17-4bcf-aeee-8987197f0a07','83ff4650-056c-493a-8804-84794c710e09','3de7c572-94cb-4a65-b30e-ba55d6c94893','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:23:43','2026-01-30 10:23:43'),('fb5dfd18-d828-42bd-ae15-0642d1deddfb','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','caab8318-99f0-4f5b-aca9-814e04b343eb','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,2000000.00,'2026-01-28','Approved as requested','2026-01-28 17:06:33','2026-01-28 17:06:33'),('ff07ac53-069b-4927-a12c-1944a04d95b6','55955b02-1fed-48c2-aa89-15c94e34fcfa','618898ca-9983-4034-932f-f0171b942a13','f6f5e135-6735-4aa9-8741-524aa0a92458','c4eaf525-c9e9-465b-a06b-a40f9979dee0','Approved',1,150000.00,'2026-01-30','Approved as requested','2026-01-30 10:28:29','2026-01-30 10:28:29');

--
-- Table structure for table `cash_requisition_items`
--

CREATE TABLE `cash_requisition_items` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cash_requisition_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `budget_item_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chart_of_account_id` bigint unsigned NOT NULL,
  `unit_cost` decimal(20,2) NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `total_cost` decimal(20,2) GENERATED ALWAYS AS ((`quantity` * `unit_cost`)) STORED,
  `approved_quantity` int DEFAULT NULL,
  `approved_unit_cost` decimal(20,2) NOT NULL DEFAULT '0.00',
  `approved_total_cost` decimal(20,2) GENERATED ALWAYS AS ((`approved_quantity` * `approved_unit_cost`)) STORED,
  `disbursed_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `status` enum('Pending','Reviewed','Approved','Rejected','Partially_Disbursed','Disbursed','needs_audit') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `retirement_verified` tinyint(1) NOT NULL DEFAULT '0',
  `specifications` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cash_requisition_items_chart_of_account_id_foreign` (`chart_of_account_id`),
  KEY `cash_requisition_items_cash_requisition_id_foreign` (`cash_requisition_id`),
  KEY `cash_requisition_items_currency_id_foreign` (`currency_id`),
  KEY `cash_requisition_items_budget_item_id_foreign` (`budget_item_id`),
  CONSTRAINT `cash_requisition_items_budget_item_id_foreign` FOREIGN KEY (`budget_item_id`) REFERENCES `budget_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_requisition_items_cash_requisition_id_foreign` FOREIGN KEY (`cash_requisition_id`) REFERENCES `cash_requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cash_requisition_items_chart_of_account_id_foreign` FOREIGN KEY (`chart_of_account_id`) REFERENCES `chart_of_accounts` (`id`),
  CONSTRAINT `cash_requisition_items_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_requisition_items`
--

INSERT INTO `cash_requisition_items` (`id`, `cash_requisition_id`, `budget_item_id`, `currency_id`, `chart_of_account_id`, `unit_cost`, `quantity`, `approved_quantity`, `approved_unit_cost`, `disbursed_amount`, `status`, `retirement_verified`, `specifications`, `created_at`, `updated_at`, `deleted_at`) VALUES ('0bfc0148-ba75-45ac-9ff7-b11a8c80548e','55955b02-1fed-48c2-aa89-15c94e34fcfa','0fa51624-c4e8-4cb8-a32f-3e8d93fd6560','26b3126e-62de-40bc-bfcc-794fcd220251',108,100000.00,5.00,5,100000.00,0.00,'Reviewed',0,'NAULI ZA WATENDAJI KWENDA NA KURUDI ( DODOMA)\n1. ALPHA MAKASI - 100,000/=\n2. JOSEPH BUKOMBE - 100,000/=\n3. WILSON GATANI - 100,000/=\n4. KELVIN PETER - 100,000/=\n5. HAPPINESS KABOGO - 100,000/=','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('0dc6cca5-426b-42ab-a48e-21c99748d03a','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,1500000.00,1.00,1,1500000.00,1500000.00,'Reviewed',0,'THOMAS ERNEST','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('1151ff40-3703-48b8-ad2b-d69a1c66e8d9','21cf16d1-e670-4040-94aa-c88b849919e8','aa3c90e8-15ea-4b15-b49d-849db0560244','26b3126e-62de-40bc-bfcc-794fcd220251',105,1040000.00,10.00,10,1040000.00,10400000.00,'Reviewed',0,'1. Alpha Makasi - 200,000\n2. Joseph Bukombe - 150,000\n3. Thomas Ernest - 150,000\n4. Wilson Gatani - 130,000\n5. Kelvin Peter - 130,000\n6. Rachel Mahona - 100,000\n7. Masele Kunji - 100,000\n8. Happiness Kabogo - 80,000','2026-01-28 16:29:56','2026-01-28 17:05:28',NULL),('23a72ae5-860a-4d45-aa5b-4681f9653ab8','cd026383-dd57-464d-a999-2c70d6cf82b8','45a64a35-f4f3-4d9c-80df-5d909a79543c','26b3126e-62de-40bc-bfcc-794fcd220251',413,100000.00,1.00,1,100000.00,100000.00,'Reviewed',0,'WILSON GATANI','2026-01-22 15:58:34','2026-01-24 11:11:51',NULL),('4dddbd7e-6690-440e-b3a4-2d6d6d2144ba','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,1300000.00,1.00,1,1300000.00,1300000.00,'Reviewed',0,'WILSON GATANI','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('618898ca-9983-4034-932f-f0171b942a13','55955b02-1fed-48c2-aa89-15c94e34fcfa','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,150000.00,1.00,1,150000.00,0.00,'Reviewed',0,'JOSEPH BUKOMBE','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('6269d6c0-f6bc-46e0-95e4-f3718fe3215f','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,1300000.00,1.00,1,1300000.00,1300000.00,'Reviewed',0,'KELVIN PETER','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('653a4c7e-221e-4d71-8ac8-3ccad63293c9','55955b02-1fed-48c2-aa89-15c94e34fcfa','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,200000.00,1.00,1,200000.00,0.00,'Reviewed',0,'ALPHA MAKASI','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('65696d98-67c9-48cb-801d-b739fa9bd52d','bae35a1a-3500-4e8f-a5f0-8208dbf8e5c3','45a64a35-f4f3-4d9c-80df-5d909a79543c','26b3126e-62de-40bc-bfcc-794fcd220251',413,200000.00,1.00,1,200000.00,200000.00,'Reviewed',0,'gharama za mafunzo kwa watumishi','2026-01-21 18:24:17','2026-01-24 11:11:36',NULL),('6879e143-b367-4cce-982e-f427857f2e42','55955b02-1fed-48c2-aa89-15c94e34fcfa','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,130000.00,1.00,1,130000.00,0.00,'Reviewed',0,'HAPPINESS KABOGO','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('8505a4f7-eebd-498d-928b-ca4ebe2f170d','2a7d2a11-00db-4460-a4d9-df413b05a29d','50d6c6d4-ef67-42f2-bd2a-93aabb398c84','26b3126e-62de-40bc-bfcc-794fcd220251',406,5000000.00,1.00,1,5000000.00,5000000.00,'Reviewed',0,'GOOD','2026-01-23 12:01:28','2026-01-23 12:51:32',NULL),('8b836b33-29fc-4a6f-9f6c-a64d5eafcf6d','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,1500000.00,1.00,1,1500000.00,1500000.00,'Reviewed',0,'JOSEPH BUKOMBE','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('94a3cb9e-7f3f-4ec0-9a00-c6bade66804a','fe4edea6-0273-462d-a2de-73098e616d31','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,200000.00,5.00,5,200000.00,0.00,'Reviewed',0,NULL,'2026-01-30 10:13:36','2026-01-30 10:29:46',NULL),('c3d08f2b-5f17-4bcf-aeee-8987197f0a07','55955b02-1fed-48c2-aa89-15c94e34fcfa','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,150000.00,1.00,1,150000.00,0.00,'Reviewed',0,'WILSON GATANI','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('caab8318-99f0-4f5b-aca9-814e04b343eb','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,2000000.00,1.00,1,2000000.00,2000000.00,'Reviewed',0,'ALPHA MAKASI','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('cf4d4008-a582-471d-a9d6-c25f3c403270','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,700000.00,1.00,1,700000.00,700000.00,'Reviewed',0,'HAPPINESS KABOGO','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL),('d3970a6a-615b-4e2b-af6a-5c0b60f96c8c','55955b02-1fed-48c2-aa89-15c94e34fcfa','3228a611-107f-41b4-98a4-5dcbfd92325a','26b3126e-62de-40bc-bfcc-794fcd220251',94,150000.00,1.00,1,150000.00,0.00,'Reviewed',0,'KELVIN PETER','2026-01-30 10:20:48','2026-01-30 10:29:30',NULL),('dbb17899-e30f-4e3b-ad24-9cca5c9ac796','a3fe4878-9b68-4d3e-93f6-c83b2b4e4b49','10def100-8e4f-4181-97b7-9e197874a4ee','26b3126e-62de-40bc-bfcc-794fcd220251',100,900000.00,1.00,1,900000.00,900000.00,'Reviewed',0,'RACHEL MAHONA','2026-01-28 17:03:22','2026-01-28 17:08:59',NULL);

--
