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

START TRANSACTION;



--
-- Database: `goaservicedb`
--

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

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

CREATE TABLE `applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_number` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT 'request',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `referral_code` varchar(255) DEFAULT NULL,
  `files` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `project_name` varchar(255) DEFAULT NULL,
  `id_number` varchar(255) DEFAULT NULL,
  `tin` varchar(255) DEFAULT NULL,
  `proposal_file` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `full_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`full_name`)),
  `hkb_id_number` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`hkb_id_number`)),
  `hw_id_number` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`hw_id_number`)),
  `gender` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`gender`)),
  `phone` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`phone`)),
  `gov_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`gov_id`)),
  `hw_photos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`hw_photos`)),
  `departments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`departments`)),
  `education_level` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`education_level`)),
  `age` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`age`)),
  `is_hire` tinyint(1) DEFAULT NULL,
  `officer_form` varchar(255) DEFAULT NULL,
  `school_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `apply_type` varchar(25) NOT NULL DEFAULT 'online',
  `created_by_id` bigint(20) DEFAULT NULL,
  `customer_service_id` varchar(20) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `letter_case` varchar(255) DEFAULT NULL,
  `carta_number` varchar(255) DEFAULT NULL,
  `building_service` varchar(255) DEFAULT NULL,
  `consultant_phone` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `applications` (`id`, `application_number`, `status`, `user_id`, `service_id`, `referral_code`, `files`, `description`, `project_name`, `id_number`, `tin`, `proposal_file`, `photo`, `full_name`, `hkb_id_number`, `hw_id_number`, `gender`, `phone`, `gov_id`, `hw_photos`, `departments`, `education_level`, `age`, `is_hire`, `officer_form`, `school_name`, `type`, `apply_type`, `created_by_id`, `customer_service_id`, `level`, `letter_case`, `carta_number`, `building_service`, `consultant_phone`, `created_at`, `updated_at`) VALUES
(29, 'GOA-683A753DC0400', 'approved', 4, 2, NULL, 'uploads/document/1748661565_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renew', 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 00:19:25', '2025-05-31 00:20:11'),
(30, 'GOA-683A7B20F2233', 'rejected', 4, 3, NULL, 'uploads/document/1748663072_file.pdf', 'Lakk. Tiin akkaa naaf kennamuun barbaadaa.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 00:44:32', '2025-05-31 00:46:35'),
(31, 'GOA-683A9D787E4C6', 'approved', 4, 2, NULL, 'uploads/document/1748671864_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renew', 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 03:11:04', '2025-06-03 19:09:46'),
(32, 'GOA-683AD5DD11CF9', 'approved', 4, 3, NULL, 'uploads/document/1748686301_file.pdf', 'Home based request', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 07:11:41', '2025-05-31 11:52:58'),
(33, 'GOA-683B168942EF1', 'approved', 7, 2, NULL, 'uploads/document/1748702857_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renew', 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 11:47:37', '2025-05-31 11:48:56'),
(34, 'GOA-683B18BFA853A', 'approved', 7, 2, NULL, 'uploads/document/1748703423_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renew', 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 11:57:03', '2025-05-31 11:57:52'),
(35, 'GOA-683B1D22A2A0B', 'approved', 7, 21, NULL, 'uploads/document/1748704546_file.pdf', 'Maallaqaa dhimmaf barbaadamu hunda isaa galchinee jira. garuu koobiilin naaf hingallee, qaamni dhimmi ilaallatu akka nuuf sirreessu jennaa.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 12:15:46', '2025-05-31 12:18:31'),
(36, 'GOA-683B1F4BE000E', 'approved', 7, 21, NULL, 'uploads/document/1748705099_file.pdf', 'Haalaan Iyyaata kooti naaf ilaalaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 12:24:59', '2025-05-31 12:26:09'),
(37, 'GOA-683C52953F36C', 'approved', 7, 21, NULL, 'uploads/document/1748783765_file.pdf', 'Komii koo naaf ilaalaa.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-01 10:16:05', '2025-06-01 10:28:44'),
(38, 'GOA-683D18B5CD321', 'rejected', 7, 3, NULL, 'uploads/document/1748834485_file.pdf', 'Lakk Tin naaf kennamu didee naaf laalaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-02 00:21:25', '2025-06-02 00:32:49'),
(39, 'GOA-683D40035D20E', 'approved', 7, 3, NULL, 'uploads/document/1748844547_file.pdf', 'Komiin koo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-02 03:09:07', '2025-06-02 03:09:32'),
(40, 'GOA-683D5249C2AF3', 'approved', 7, 2, NULL, 'uploads/document/1748849225_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renew', 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-02 04:27:05', '2025-06-02 04:28:40'),
(41, 'GOA-683D99591FB0A', 'rejected', 8, 18, NULL, 'uploads/document/1748867417_file.pdf', 'Muuxaannoo akkaa naaf kenitaan isiin gafadha.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-02 09:30:17', '2025-06-02 09:32:15'),
(42, 'GOA-683D9BC8AE931', 'approved', 9, 38, NULL, 'uploads/document/1748868040_file.pdf', 'Heeyyaam guhuumsa Oguummaa akka naaf haaromsamuun barbaada.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-02 09:40:40', '2025-06-02 09:42:10'),
(43, 'GOA-683F6D7B11F75', 'request', 4, 4, NULL, 'uploads/document/1748987259_file.pdf', 'waldaa gurmaa\'ee hommtu naaf hin kennamenee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:47:39', '2025-06-03 18:47:39'),
(44, 'GOA-683F6DB897055', 'request', 4, 5, NULL, 'uploads/document/1748987320_file.pdf', NULL, NULL, NULL, NULL, NULL, NULL, '\"[\\\"Dejene kasa\\\"]\"', '\"[\\\"234234\\\"]\"', NULL, '\"[\\\"male\\\"]\"', '\"[\\\"0927374744\\\"]\"', '\"[\\\"gov_ids\\\\\\/HJ7WW8yFDbI2ep6ADW436TqOcBwW8YJV9h2Dj8eq.pdf\\\"]\"', '\"[\\\"hw_photos\\\\\\/683f6dba1c28f.jpg\\\"]\"', '\"[\\\"SE\\\"]\"', '\"[\\\"bsc_degree\\\"]\"', '\"[\\\"23\\\"]\"', NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:48:42', '2025-06-03 18:48:42'),
(45, 'GOA-683F6DE8B231A', 'request', 4, 6, NULL, 'uploads/document/1748987368_file.pdf', 'bishaan waan hunda galchee naaf hin gadhiifamnee', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:49:28', '2025-06-03 18:49:28'),
(46, 'GOA-683F6EB64CAED', 'request', 4, 7, NULL, 'uploads/document/1748987574_file.pdf', 'Hojii hin qabu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:52:54', '2025-06-03 18:52:54'),
(47, 'GOA-683F6ED1D033D', 'request', 4, 8, NULL, 'uploads/document/1748987601_file.pdf', 'Insurance fayyaa hawaasaa naaf keennaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:53:21', '2025-06-03 18:53:21'),
(48, 'GOA-683F6EF2229C1', 'request', 4, 9, NULL, 'uploads/document/1748987634_file.pdf', 'Xalayaa deggersaa naaf keennaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:53:54', '2025-06-03 18:53:54'),
(49, 'GOA-683FED49051E0', 'request', 8, 38, NULL, 'uploads/document/1749019977_file.pdf', 'Heyyaam koo naaf haaromsii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-04 03:52:57', '2025-06-04 03:52:57'),
(50, 'GOA-6841381096822', 'request', 13, 75, NULL, 'uploads/document/1749104656_file.pdf', '<p>Warshaa daaku dfsf sdfs</p>', 'Warshaa daaku', '13214234', NULL, 'uploads/document/proposal/1749104656_proposal.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-05 03:24:16', '2025-06-05 03:24:16'),
(51, 'GOA-6844179E57BB0', 'request', 6, 3, NULL, 'uploads/document/1749292958_file.pdf', 'Tiin naaf keennaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 07:42:38', '2025-06-07 07:42:38'),
(52, 'GOA-6844179F0C0CC', 'approved', 6, 3, NULL, 'uploads/document/1749292959_file.pdf', 'Tiin naaf keennaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 07:42:39', '2025-06-07 07:45:01'),
(53, 'GOA-68446EE732988', 'request', 6, 18, NULL, 'uploads/document/1749315303_file.pdf', 'xalayaa deggarsaa barbaada', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 13:55:03', '2025-06-07 13:55:03'),
(54, 'GOA-6844ADBDB2729', 'request', 6, 38, NULL, 'uploads/document/1749331389_file.pdf', 'type here', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:23:09', '2025-06-07 18:23:09'),
(55, 'GOA-6844B06ED3DBB', 'request', 6, 21, NULL, 'uploads/document/1749332078_file.pdf', 'naaf haa ilaallamu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:34:38', '2025-06-07 18:34:38'),
(56, 'GOA-6844B0B84B9CB', 'request', 6, 21, NULL, 'uploads/document/1749332152_file.pdf', 'naaf haa ilaalla,uu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:35:52', '2025-06-07 18:35:52'),
(57, 'GOA-6844B105E8224', 'approved', 17, 2, NULL, 'uploads/document/1749332229_file.pdf', 'uuuu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:37:09', '2025-06-07 18:37:49'),
(58, 'GOA-6845C4289625C', 'request', 17, 2, NULL, 'uploads/document/1749402664_file.pdf', 'Waraqaa eenyummaa naaf kennii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-08 14:11:04', '2025-06-08 14:11:04'),
(59, 'GOA-6846910EEC302', 'request', 17, 3, NULL, 'uploads/document/1749455119_file.pdf', 'ewRFSD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-09 04:45:19', '2025-06-09 04:45:19'),
(60, 'GOA-6847F2D1330D7', 'request', 17, 21, NULL, NULL, 'komii', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'physical', 6, '77690788', NULL, NULL, NULL, NULL, NULL, '2025-06-10 05:54:41', '2025-06-10 05:54:41');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Adama', NULL, NULL);

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

--
-- Table structure for table `customer_applications`
--

CREATE TABLE `customer_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_id` varchar(12) NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'City', NULL, NULL),
(2, 'Subcity', NULL, NULL),
(3, 'Woreda', NULL, NULL);

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

--
-- Table structure for table `mayor_applications`
--

CREATE TABLE `mayor_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_subcity` bigint(20) UNSIGNED DEFAULT NULL,
  `user_woreda` bigint(20) UNSIGNED DEFAULT NULL,
  `is_paid` tinyint(1) NOT NULL DEFAULT 0,
  `is_ordered` tinyint(1) NOT NULL DEFAULT 0,
  `application_number` varchar(255) NOT NULL,
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `rejected_by` bigint(20) UNSIGNED DEFAULT NULL,
  `accepted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `followup_by` bigint(20) UNSIGNED DEFAULT NULL,
  `service_name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'request',
  `approved_description` longtext DEFAULT NULL,
  `rejected_description` longtext DEFAULT NULL,
  `followup_description` longtext DEFAULT NULL,
  `accepted_at` date DEFAULT NULL,
  `approved_at` date DEFAULT NULL,
  `rejected_at` date DEFAULT NULL,
  `followup_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000001_create_cache_table', 1),
(2, '0001_01_01_000002_create_jobs_table', 1),
(3, '2025_05_21_203815_create_cities_table', 1),
(4, '2025_05_21_203825_create_subcities_table', 1),
(5, '2025_05_21_203841_create_woredas_table', 1),
(8, '2025_05_21_203947_create_roles_table', 1),
(9, '2025_05_21_203955_create_levels_table', 1),
(10, '2025_06_01_000000_create_users_table', 1),
(12, '2025_05_24_190830_create_offices_table', 3),
(13, '2025_05_27_171338_create_customer_applications_table', 4),
(14, '2025_05_27_183827_create_mayor_applications_table', 5),
(15, '2025_05_28_074949_create_applications_table', 6),
(16, '2025_05_28_094747_create_statuses_table', 7),
(17, '2025_05_29_114327_create_service_user_table', 8),
(18, '2025_05_21_203910_create_windows_table', 9),
(19, '2025_05_21_203934_create_services_table', 10);

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

--
-- Table structure for table `offices`
--

CREATE TABLE `offices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offices`
--

INSERT INTO `offices` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Waajjiraa Kantibaa', '2025-05-24 16:52:50', '2025-05-24 16:52:50'),
(2, 'Waajjira Lafaa', '2025-05-24 17:00:42', '2025-05-24 17:00:42'),
(3, 'Waajjiraa Inveestimantii', '2025-05-24 17:01:55', '2025-05-24 17:01:55'),
(4, 'Mana Qopheessaa', '2025-05-24 17:44:01', '2025-05-24 17:44:01'),
(5, 'Waajjiraa Galii', '2025-05-24 16:52:50', '2025-05-24 16:52:50'),
(6, 'Waajjira Carraa Hojii Uumuu', '2025-05-24 17:00:42', '2025-05-24 17:00:42'),
(7, 'Waajjiraa Bishaani', '2025-05-24 17:01:55', '2025-05-24 17:01:55'),
(8, 'Waajjira Geejibaa', '2025-05-24 17:44:01', '2025-05-24 17:44:01'),
(9, 'Waldaa Hojii Gamtaa', '2025-05-24 17:44:01', '2025-05-24 17:44:01');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', NULL, NULL),
(2, 'GOA Admin', NULL, NULL),
(3, 'Officer', NULL, NULL),
(4, 'Customer', NULL, NULL),
(5, 'Data Encoder', NULL, NULL);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `has_payment` tinyint(1) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `processing_time` varchar(255) DEFAULT NULL,
  `window_id` bigint(20) UNSIGNED NOT NULL,
  `ref_window_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `name`, `route`, `description`, `has_payment`, `payment`, `processing_time`, `window_id`, `ref_window_id`, `created_at`, `updated_at`) VALUES
(2, 'Kenna waraqaa eenyummaa', 'customer/application/mq/idNewOrRenew/create/2', 'Kenna waraqaa eenyummaa', 0, NULL, '30min', 1, NULL, '2025-05-29 01:28:26', '2025-05-29 01:28:26'),
(3, 'Lakk TIN kennuu', 'customer/application/gali/tin-kennu/3', 'Lakk TIN kennuu', 0, NULL, '30min', 1, NULL, '2025-05-29 01:30:27', '2025-05-29 01:30:27'),
(4, 'Waldaalee gurmaa\'aniif qaama seerummaa kennuu', 'customer/application/chuo/qseerumma-kennu/4', 'Waldaalee gurmaa\'aniif qaama seerummaa kennuu', 0, NULL, NULL, 1, NULL, '2025-05-29 01:31:18', '2025-05-29 01:31:18'),
(5, 'Kaardii hojii dhabdummaa kennuu', 'customer/application/hawasuma/joblessId/create/5', 'Kaardii hojii dhabdummaa kennuu', 0, NULL, NULL, 1, NULL, '2025-05-29 01:32:12', '2025-05-29 01:32:12'),
(6, 'Simannaa maamila haaraafi Lakk. bishaanii kennuu (Taj.Bish.Dhug.)', 'customer/application/water/simannaa/6', '.Simannaa maamila haaraafi Lakk. bishaanii kennuu (Taj.Bish.Dhug.)', 0, NULL, NULL, 1, NULL, '2025-05-29 01:33:26', '2025-05-29 01:33:26'),
(7, 'Hoji barbaaddota galmeessuu', 'customer/application/chuo/unemployeement-registration/7', 'Hoji barbaaddota galmeessuu', 0, NULL, NULL, 1, NULL, '2025-05-29 01:34:10', '2025-05-29 01:34:10'),
(8, 'Inshuuraansii fayyaa hawaasaa kennuu fi haaromsuu', 'customer/application/health/healthinsurance/8', 'Inshuuraansii fayyaa hawaasaa kennuu fi haaromsuu', 0, NULL, NULL, 1, NULL, '2025-05-29 01:36:02', '2025-05-29 01:36:02'),
(9, 'Waldaalee Hojii Gamtaa invastimentiitti ce’aniif xalayaa deggersaa kennuu', 'customer/application/chuo/qseerumma-kennu/9', 'Waldaalee Hojii Gamtaa invastimentiitti ce’aniif xalayaa deggersaa kennuu', 0, NULL, NULL, 1, NULL, '2025-05-29 01:36:38', '2025-05-29 01:36:38'),
(10, 'Xalayaa deggarsaa adda addaa waldaaleefi Walitti hidhamiinsa gabaa waldaalee Hojii Gamtaa uumuu kennuu', 'https://etrade.gov.et/auth/register', 'Xalayaa deggarsaa adda addaa waldaaleefi Walitti hidhamiinsa gabaa waldaalee Hojii Gamtaa uumuu kennuu', 0, NULL, NULL, 2, NULL, '2025-05-29 03:26:44', '2025-05-29 03:26:44'),
(11, 'Xalayaa deggarsaa adda addaa fi Walitti hidhamiinsa gabaa omisha qonnaafi induustirii uumuu kennuu', 'https://etrade.gov.et/auth/register', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:27:42', '2025-05-29 03:27:42'),
(12, 'Xalayaa deeggarsaa Waldaalee IMX’f walitti hidhamiinsa gabaa uumuu', 'customer/application/chuo/supportive-letter-imx/12', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:28:19', '2025-05-29 03:28:19'),
(13, 'Xalayaa Waldaaleen IMX eyyama daldalaa akka argataniifi Paakeejiiwwan deggersaa waldaalee IMX\' kennuu', 'customer/application/chuo/supportive-letter-new-permit-imx/13', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:28:50', '2025-05-29 03:28:50'),
(14, 'Xalayaa deggarsaa Qonnaan bulaa investimentiitti ce’aniifi  walitti hidhamiinsa gabaa uumuu kennuu', 'customer/application/qmagala/supportiveletter/14', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:29:27', '2025-05-29 03:29:27'),
(15, 'Xalayaa deggersaa maxxansa nagahee kaffalaa gibiraa kennuu (Kaffalaa gibiraa A fi B)', 'customer/application/gali/supportive-letter/15', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:30:30', '2025-05-29 03:30:30'),
(16, 'Waldaalee invastimantiitti ce’aniifi ce\'umsa interpraayizootaaf waraqaa ragaa kennu', 'customer/application/chuo/certificate-association/16', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:31:01', '2025-05-29 03:31:01'),
(17, 'Xalayaa deggarsa adda addaa kennuu', '/customer/application/mayor/17', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:31:33', '2025-05-29 03:31:33'),
(18, 'Xalayaa deggersa adda addaa kennuu', '/customer/application/mayor/18', NULL, 0, NULL, NULL, 2, 2, '2025-05-29 03:32:06', '2025-05-29 03:34:12'),
(19, 'Xalayaa deg. B/sotaa fi hoggansa M/Barumsaaf adda adda kennuu', 'customer/application/edu/teacher-supportive/create/19', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:34:52', '2025-05-29 03:34:52'),
(20, 'Xalayaa adda addaa qaama ilaaluuf barreessuu', 'customer/application/policy/write-letter-for-client/', NULL, 0, NULL, NULL, 2, NULL, '2025-05-29 03:36:29', '2025-05-29 03:36:29'),
(21, 'Iyyannoo fi komii adda addaa', 'customer/application/mayor/21', NULL, NULL, NULL, NULL, 3, NULL, '2025-05-29 03:37:08', '2025-05-29 03:37:08'),
(22, 'Komii hojjetaa mootummaa keessummeessuu', 'customer/application/psmqn/komii-hojjeta-motummaa/22', NULL, NULL, NULL, NULL, 3, NULL, '2025-05-29 03:37:45', '2025-05-29 03:37:45'),
(23, 'Deggersa bu\'uuraalee misoomaa (ibsaa, daandii, bishaan, …) kennuu', 'customer/application/mq/light-water-road-letter/23', NULL, NULL, NULL, NULL, 3, NULL, '2025-05-29 03:38:26', '2025-05-29 03:38:26'),
(24, 'Hayyama ijaarsaa, fooyya’iinsa pilaanii, babal’ifannaa, mirga itti fayyadama gamoo, diigiinsa gamoo kennuu fi haaromsuu', 'customer/application/construction/plan-agreement/24', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:53:13', '2025-05-29 03:53:13'),
(25, 'Hayyama suphaa mana mootummaa kennuu', 'customer/application/mq/kiraaManneenHaaroomsuu/create/25', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:53:54', '2025-05-29 03:53:54'),
(26, 'Hayyama mana gandaa deebisanii misoomsuu kennuu fi haaromsuu', 'customer/application/mq/kiraaManneenHaaroomsuu/create/26', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:54:47', '2025-05-29 03:54:47'),
(27, 'Mirkaneessa dizaayinii haaraa, fooyya’iinsa fi babal’innaa kennuu', 'customer/application/construction/design-evaluation/27', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:55:49', '2025-05-29 03:55:49'),
(28, 'Sanadoota caalbaasii ijaarsa gamoo mirkaneessuu', 'customer/application/construction/bid-documents/28', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:56:37', '2025-05-29 03:56:37'),
(29, 'Sadarkaa ijaarsaa irra jiru kennuu', 'customer/application/construction/building-level/29', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:58:03', '2025-05-29 03:58:03'),
(30, 'Hayyama ogummaa haaromsuu', 'customer/application/health/renewlicense/30', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 03:58:55', '2025-05-29 03:58:55'),
(31, 'Hayyama manneen yaalaa dhuunfaa kennuu fi haaromsuu', 'customer/application/health/privatelicense/31', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 04:01:22', '2025-05-29 04:01:22'),
(32, 'Hayyama gahumsa manneen barnoota dhuunfaa kennuu, haaromsuu fi haquu', 'customer/application/edu/private-school-permite/create/32', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 04:02:05', '2025-05-29 04:02:05'),
(33, 'Gahumsa ogummaa dhaabbata leenjii konkolaachisummaa mirkaneessuu', 'customer/application/gejiba/33', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 04:02:56', '2025-05-29 04:02:56'),
(34, 'Mallattoo maxxantuu (boolloo) waggaa haaraa kennuu, haaromsuu fi haquu', 'customer/application/gejiba/34', NULL, 0, NULL, NULL, 4, NULL, '2025-05-29 04:04:26', '2025-05-29 04:16:02'),
(35, 'Hayyama bareessitootaa dhimma seeraa kennuufi haaromsuu', 'customer/application/alanga/writer-permit/35', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 04:04:57', '2025-05-29 04:04:57'),
(36, 'Hayyama konkolaachisaa kennuu fi haaromsuu (konkol. fi opiratara)', 'customer/application/gejiba/36', NULL, NULL, NULL, NULL, 4, NULL, '2025-05-29 04:06:45', '2025-05-29 04:06:45'),
(37, 'Kennaa fi haaromsa gahumsaa ogummaa ogeessota, dhaabilee, waldaalee fi gorsitootaa kennuu, dheeressuu fi haquu', 'customer/application/construction/professional-certificate/37', NULL, 0, NULL, NULL, 5, NULL, '2025-05-29 04:08:18', '2025-05-29 04:12:09'),
(38, 'Gahumsa hayyama ijaarsaa haaromsuu', 'customer/application/construction/professional-certificate/38', NULL, 0, NULL, NULL, 5, NULL, '2025-05-29 04:08:58', '2025-05-29 04:10:35'),
(39, 'Waraqaa qulqullinaa gahumsa dhaabilee daldalaa kennuu fi haaromsuu', 'customer/application/health/trade-org-certificate/39', NULL, NULL, NULL, NULL, 5, NULL, '2025-05-29 04:16:49', '2025-05-29 04:16:49'),
(40, 'Waraqaa qulqullinaa gahumsa dhaabilee daldalaa kennuu fi haaromsuu', 'customer/application/health/trade-org-certificate/40', NULL, NULL, NULL, NULL, 5, NULL, '2025-05-29 04:18:21', '2025-05-29 04:18:21'),
(41, 'Hayyama gahumsa ogummaa dhaabilee aadaa kennuu, haaromsuu, haquu', 'customer/application/tourism/cultural-permit/41', NULL, NULL, NULL, NULL, 5, NULL, '2025-05-29 04:19:18', '2025-05-29 04:19:18'),
(42, 'Mirkaneessa gahumsa dhaabilee tuurizimii', 'customer/application/tourism/cultural-certificate-org/41', NULL, NULL, NULL, NULL, 5, NULL, '2025-05-29 04:20:35', '2025-05-29 04:20:35'),
(43, 'Hayyama daldalaa haaraa galmeessuu', 'https://etrade.gov.et/auth/register', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:27:47', '2025-05-29 04:27:47'),
(44, 'Hayyama waldaalee hawaasaa adda addaa kennuu fi haaromsuu', 'customer/application/Daldala/hayyamaaWaldaaleeHawaasaa/create/44', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:28:31', '2025-05-29 04:28:31'),
(45, 'Hayyama daldalaa kennuu, haaromsuu, haquu fi fooyyessuu', 'customer/application/Daldala/HayyamaaDaldalakennu/create/45', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:28:58', '2025-05-29 04:28:58'),
(46, 'Moggaasa maqaa daldalaa kennuu', 'customer/application/Daldala/mogasamaqadaldala/create/46', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:29:31', '2025-05-29 04:29:31'),
(47, 'Hayyama tajaajila qalmaa kennuu', 'customer/application/Daldala/tajqalma/create/47', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:29:53', '2025-05-29 04:29:53'),
(48, 'Hayyama omisha albuudaa kennuu fi haaromsuu', 'customer/application/Daldala/omishaalbuudaa/create/48', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:30:21', '2025-05-29 04:30:21'),
(49, 'Hayyama oomisha (misooma) bishaanii kennuu', 'customer/application/Daldala/missonmabishani/create/49', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:30:59', '2025-05-29 04:30:59'),
(50, 'Hayyama tajaajila geejibaa ykn haaromsa eeyyama waldaa', 'customer/application/Daldala/tajgejiba/create/50', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:31:29', '2025-05-29 04:31:29'),
(51, 'Hayyama Bobbii Konkoolaataa kennuu', 'customer/application/Daldala/BobbiiKonkoolaataa/create/51', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:32:29', '2025-05-29 04:32:29'),
(52, 'Hayyama ejensii hHojjetaafi hojjechiisaa biyya keessaa walquunnamsiisuu kennuu, haaromsuu fi haquu', 'customer/application/Daldala/Hayyamaejensii/create/52', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:33:30', '2025-05-29 04:33:30'),
(53, 'Galmeessa waraqaa ragaa A/Qabeenyummaa konkolaataa kennuu', 'customer/application/Daldala/waraqaaRagaaAQabeenyummaa/create/53', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:34:12', '2025-05-29 04:34:12'),
(54, 'Jijjiirraa maqaa abbaa qabeenyummaa raawwachuu', 'customer/application/Daldala/JijjiirraaMaqaaAbbaaQabeenyummaa/create/54', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:35:43', '2025-05-29 04:35:43'),
(55, 'Ragaalee konkolaataa fi konkolaachisaa badan haaraan bakka buusuu', 'customer/application/Daldala/Ragaaleekonkolaataa/create/55', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:37:11', '2025-05-29 04:37:11'),
(56, 'Dhorka konkolaataa raawwachuu fi haquu', 'customer/application/Daldala/Dhorkakonkolaataa/create/56', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:37:46', '2025-05-29 04:37:46'),
(57, 'Galmeessa ragaa dhuunfaa dhorkuu, fooyyessuufi kaasuu', 'customer/application/Daldala/GalmeessaRagaaDhuunfaa/create/57', NULL, NULL, NULL, NULL, 6, NULL, '2025-05-29 04:38:24', '2025-05-29 04:38:24'),
(58, 'Galmeessaa waldaalee daldalaa IMX', 'customer/application/F7/daldalaaIMX/create/58', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:39:31', '2025-05-29 04:39:31'),
(59, 'Galmeessa waldaa haawaasaa siivilii', 'customer/application/F7/walhawasaSivil/create/59', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:40:13', '2025-05-29 04:40:13'),
(60, 'Waliigaltee galmeessuu', 'customer/application/F7/WaliigalteeGalmeessuu/create/60', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:40:36', '2025-05-29 04:40:36'),
(61, 'Bakka bu’ummaa galmeessuu fi kennuu', 'customer/application/F7/BakkabuummaaGalmeessuu/create/61', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:41:19', '2025-05-29 04:41:19'),
(62, 'Galmeessa waliigaltee liqii', 'customer/application/F7/waliigalteeLiqii/create/62', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:41:50', '2025-05-29 04:41:50'),
(63, 'Waliigaltee mirkaneessuu', 'customer/application/F7/WaliigalteeMirkaneessuu/create/63', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:42:15', '2025-05-29 04:42:15'),
(64, 'Mirkaneessa sanadoota siivilii', 'customer/application/F7/sanadootaSiivilii/create/64', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:45:37', '2025-05-29 04:45:37'),
(65, 'Gurmii waldaalee WHG mirkaneessuu', 'customer/application/F7/WHGmirkaneessuu/create/65', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:50:47', '2025-05-29 04:50:47'),
(66, 'Sanadootaa adda addaa mirkaneessuu', 'customer/application/F7/SanadootaaAdaAda/create/66', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:51:43', '2025-05-29 04:51:43'),
(67, 'Mirkaneessa seera qabeessummaa turjumaanaa kennuu', 'customer/application/F7/MirkaneessaSeeraQabeessummaa/create/67', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:52:11', '2025-05-29 04:52:11'),
(68, 'Seera ittiin bulmaata daldalaa mirkaneessuu-PLC', 'customer/application/F7/daldalaamirkaneessuu-PLC/create/68', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:52:39', '2025-05-29 04:52:39'),
(69, 'Waliigaltee walsimsiisa pilaanii raawwachuu', 'customer/application/F7/walsimsiisaPilaanii/create/69', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:53:00', '2025-05-29 04:53:00'),
(70, 'Gurmii waldaalee lafaafi mana jirreenyaa', 'customer/application/F7/GurmiiWaldaaleeLafaa/create/70', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:54:10', '2025-05-29 04:54:10'),
(71, 'Waliigaltee mana mootummaa raawwachuu (m/gandaafi kondominiyeemii', 'customer/application/F7/WaliigalteeManaMootummaa/create/71', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:55:09', '2025-05-29 04:55:09'),
(72, 'Waliigaltee kireessaa fi kireeffataa kennuu D/Manneenii', 'customer/application/F7/WaliigalteeKireessaa/create/72', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:55:52', '2025-05-29 04:55:52'),
(73, 'Waliigaltee pirojektii gulaaluu', 'customer/application/F7/WaliigalteePirojektiiGulaaluu/create/73', NULL, NULL, NULL, NULL, 7, NULL, '2025-05-29 04:56:37', '2025-05-29 04:56:37'),
(74, 'Waliigaltee Qacarii ogeesoota fayyaa fi Mahaandisoota dhaabilee dhuunfaa(DH H)', 'customer/application/F7/WaliigalteeQacariiOgeesootaFayyaafiMahaandiso/create/74', NULL, 0, NULL, NULL, 7, NULL, '2025-05-29 04:58:28', '2025-05-29 05:04:30'),
(75, 'Simannaa pirojektiiwwan fi Babal’ifannaa pirojektiifi haaraa', '/customer/application/investment/75', '', NULL, NULL, NULL, 8, NULL, '2025-05-29 05:05:32', '2025-05-29 05:05:32'),
(76, 'Tajaajila Qophii fi Baankii Lafaa', '/customer/application/banki-lafa/76', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:07:01', '2025-05-29 05:07:01'),
(77, 'Mirkaneessa qorannoo haala dhiibbaa naannoo', 'customer/application/F7/MirkaneessaQorannooHaala/create/77', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:07:32', '2025-05-29 05:07:32'),
(78, 'Waliigaltee invastimantii fi jijjiirraa maqaa murtee boodaa galchisisuu', '/customer/application/name-change/78', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:07:51', '2025-05-29 05:07:51'),
(79, 'Waliigaltee liizii  galchuu', '/customer/application/investment-agreement/79', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:08:20', '2025-05-29 05:08:20'),
(80, 'Tajaajila Dabarsaa fi Qabiyyee Lafaa', 'customer/application/F7/TajaajilaDabarsaafiQabiyyeeLafaa/create/80', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:08:49', '2025-05-29 05:08:49'),
(81, 'Tajaajila Heyyama Ijaarsa', '/customer/application/building-permit/81', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:09:10', '2025-05-29 05:09:10'),
(82, 'Hayyama invastimantii kennuu, haaromsu, babal\'isu fi addan kutuu', '/customer/application/investment-new-permit/82', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:10:59', '2025-05-29 05:10:59'),
(83, 'Hayyama invastimantii kennuu, haaromsu, babal\'isu fi addan kutuu', '/customer/application/investment-new-permit/82', NULL, NULL, NULL, NULL, 8, NULL, '2025-05-29 05:12:54', '2025-05-29 05:12:54'),
(84, 'Gaaffii lafaa simachuu', 'customer/application/lafa/Gaaffiilafaasimachuu/create/84', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:13:45', '2025-05-29 05:13:45'),
(85, 'Lafa Qaama Angoo qabuun murtaa’e  dabarsuu', 'customer/application/lafa/LafaQaamaAngoo/create/85', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:14:12', '2025-05-29 05:14:12'),
(86, 'Hojii Qabiyyee Haaraa Mirkaneessuu', 'customer/application/lafa/HojiiQabiyyeeHaaraaMirkaneessuu/create/86', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:14:36', '2025-05-29 05:14:36'),
(87, 'Galmeessaa fi Kaartaa dijitaalawaa kennuu', 'customer/application/lafa/Kaartaadijitaalawaa/create/87', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:15:05', '2025-05-29 05:15:05'),
(88, 'Mirga qabiiyee dabarsu(Jijjiirraa Maqaa) Raawwachuu', 'customer/application/lafa/MirgaqabiiyeedabarsuRaawwachuu/create/88', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:15:31', '2025-05-29 05:15:31'),
(89, 'Qabiyyee fi sirna qabiyyee lafaa adda baasuu, walitti makuu fi kaasuu', 'customer/application/lafa/Qabiyyeesirna/create/89', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:16:05', '2025-05-29 05:16:05'),
(90, 'Tilmaama qabeenyaa raawachuu', 'customer/application/lafa/TilmamaQabegna/create/90', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:16:29', '2025-05-29 05:16:29'),
(91, 'Waliigaltee liizii galchuu', 'customer/application/lafa/Waliigalteeliiziigalchuu/create/91', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:16:56', '2025-05-29 05:16:56'),
(92, 'Dhorka Baankii fi mana murtii galmeessuu fi haquu', 'customer/application/lafa/DhorkaBaankiimanamurti/create/92', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:17:21', '2025-05-29 05:17:21'),
(93, 'Wabummaa fi Bakka Bu’ummaa galmeessuu, kaasuun kuusaa dhuunfaan walqabsiisuu', 'customer/application/lafa/WabummaafiBakkaBuummaa/create/93', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:18:28', '2025-05-29 05:18:28'),
(94, 'Tajaajila Seeraa Dhimma Lafaa Kennuu', 'customer/application/lafa/TajaajilaSeeraaDhimma/create/94', NULL, NULL, NULL, NULL, 9, NULL, '2025-05-29 05:18:48', '2025-05-29 05:18:48'),
(95, 'Sassaabbii Galii idilee', 'customer/application/gali/kaffaltii/95', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:19:22', '2025-05-29 05:19:22'),
(96, 'Sassaabii Galii M/Qopheessaa', 'customer/application/gali/kaffaltii/96', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:19:46', '2025-05-29 05:19:46'),
(97, 'Buusii miseensummaa sassaabuu', 'customer/application/gali/kaffaltii/97', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:20:09', '2025-05-29 05:20:09'),
(98, 'Sassaabbii galii Buusaa Gonofaa', 'customer/application/gali/kaffaltii/98', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:20:49', '2025-05-29 05:20:49'),
(99, 'Biilii Bishaanii gurguruu', 'customer/application/gali/kaffaltii/99', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:21:08', '2025-05-29 05:21:08'),
(100, 'Kaffaltii tajaajila ibsaa raawwachuu', 'customer/application/gali/kaffaltii/100', NULL, 0, NULL, NULL, 10, NULL, '2025-05-29 05:22:07', '2025-05-29 05:22:07'),
(101, 'Kaffaltii tilmaama meeshaa bishaanii raawwachuu', 'customer/application/gali/kaffaltii/101', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:22:31', '2025-05-29 05:22:31'),
(102, 'Kaffaltii adabbii seera darbitootaa', 'customer/application/gali/kaffaltii/102', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:22:57', '2025-05-29 05:22:57'),
(103, 'Kaffaltii boolloo raawwachuu', 'Kaffaltii-boolloo/103', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:23:19', '2025-05-29 05:23:19'),
(104, 'Murtii Taaksiifi Kaffaltii VAT, TOT fi witholding galmeessuu', 'customer/application/gali/kaffaltii/104', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:23:48', '2025-05-29 05:23:48'),
(105, 'Kaffaltii taarifaa raawwachiisuu', 'customer/application/gali/kaffaltii/104', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:24:13', '2025-05-29 05:24:13'),
(106, 'Waraqaa qulqullinaa idaarraa biliisa ta’uu ibsu kennuu', 'waraqaa-qulqullummaa-idaarraa/106', NULL, NULL, NULL, NULL, 10, NULL, '2025-05-29 05:24:41', '2025-05-29 05:24:41'),
(107, 'Kaffaltii projektii raawwachuu', 'kaffaltii-beenyaa-raawwachuu/107', NULL, NULL, NULL, NULL, 11, NULL, '2025-05-29 05:25:14', '2025-05-29 05:25:14'),
(108, 'Kafaltii bittaa meeshaalee fi tajaajilaa raawwachuu', 'kaffaltii-beenyaa-raawwachuu/108', NULL, NULL, NULL, NULL, 11, NULL, '2025-05-29 05:25:43', '2025-05-29 05:25:43'),
(109, 'Kaffaltii beenyaa raawwachuu', 'kaffaltii-beenyaa-raawwachuu/109', NULL, NULL, NULL, NULL, 11, NULL, '2025-05-29 05:26:09', '2025-05-29 05:26:09'),
(110, '112.Kaffaltiiwwan foddaa galii irraa ajajame mirkaneessuun akkaawuntii ajajametti galchuu', 'customer/application/gali/kaffaltii-to account/110', NULL, NULL, NULL, NULL, 12, NULL, '2025-05-29 05:26:44', '2025-05-29 05:26:44'),
(111, 'Kaffaltiiwwan adda addaa giddugalichaaf ajajamu raawwachuu', 'customer/application/gali/kaffaltii/111', NULL, NULL, NULL, NULL, 12, NULL, '2025-05-29 05:27:13', '2025-05-29 05:27:13');

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

--
-- Table structure for table `service_user`
--

CREATE TABLE `service_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_user`
--

INSERT INTO `service_user` (`id`, `user_id`, `service_id`, `created_at`, `updated_at`) VALUES
(1, 6, 1, NULL, NULL),
(2, 6, 2, NULL, NULL),
(3, 6, 21, NULL, NULL),
(4, 6, 3, NULL, NULL),
(5, 6, 18, NULL, NULL),
(6, 6, 38, NULL, NULL),
(7, 11, 43, NULL, NULL),
(8, 11, 44, NULL, NULL),
(10, 2, 9, NULL, NULL),
(11, 2, 2, NULL, NULL),
(12, 2, 3, NULL, NULL),
(13, 2, 4, NULL, NULL),
(14, 2, 5, NULL, NULL),
(15, 2, 6, NULL, NULL),
(16, 2, 7, NULL, NULL),
(17, 2, 8, NULL, NULL);

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('xZqtS63aWf2gAaTr19b8ATxaShgATvjz3u4vGQv5', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiU0tQUDlxblRTenE2OXVuVDRTODU2emZRR1F5SEZxVjZTd3BxUjJuVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sYW5ndWFnZXMvY3JlYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo2OiJsb2NhbGUiO3M6MjoiYW0iO3M6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1749719837),
('zExbOKIZwYMLt4dxdReYflivAig3CGf2sOvozxL1', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUGdZUXo1WGZSSWEwYjJMUFJMT3R5TzZ1WlVNY2toZFVodTl3a3dCViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1749733212);

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_id` bigint(20) UNSIGNED NOT NULL,
  `accept_by_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_by_id` bigint(20) UNSIGNED DEFAULT NULL,
  `rejected_by_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_description` longtext DEFAULT NULL,
  `rejected_description` longtext DEFAULT NULL,
  `accepted_description` longtext DEFAULT NULL,
  `final_file` varchar(255) DEFAULT NULL,
  `accepted_at` varchar(255) DEFAULT NULL,
  `approved_at` varchar(255) DEFAULT NULL,
  `rejected_at` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `application_id`, `accept_by_id`, `approved_by_id`, `rejected_by_id`, `approved_description`, `rejected_description`, `accepted_description`, `final_file`, `accepted_at`, `approved_at`, `rejected_at`, `created_at`, `updated_at`) VALUES
(26, 29, NULL, 6, NULL, 'Tajaajillli keessaan milka\'ee jira.', NULL, NULL, 'uploads/approvals/7vSRbHJZYct72NIfaXrlVSo1WmcTwAMpt8YUaoT6.pdf', NULL, '2025-05-31 03:20:11', NULL, '2025-05-31 00:19:25', '2025-05-31 00:20:12'),
(27, 30, NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-31 03:46:35', '2025-05-31 00:44:33', '2025-05-31 00:46:35'),
(28, 31, NULL, 6, NULL, 'Siif milka\'ee jira.', NULL, NULL, 'uploads/approvals/QKpInFtnsO5JTWABWo4VKkyKoYyPwpzV3UhvROMH.png', NULL, '2025-06-03 22:09:46', NULL, '2025-05-31 03:11:04', '2025-06-03 19:09:46'),
(29, 32, NULL, 6, NULL, 'good', NULL, NULL, 'uploads/approvals/IVWNMVC1axNq0AYauPu2RSIkjVry0h0abn7lLsyW.pdf', NULL, '2025-05-31 14:54:22', NULL, '2025-05-31 07:11:41', '2025-05-31 11:54:22'),
(30, 33, NULL, 6, NULL, 'Tajaajilli keessaan Milkaa\'ee jira', NULL, NULL, 'uploads/approvals/hOI7jyOmh2X1c8SmTM9KcUAPjBwa4Ki7dyEl9LXP.pdf', NULL, '2025-05-31 14:48:56', NULL, '2025-05-31 11:47:37', '2025-05-31 11:48:56'),
(31, 34, NULL, 6, NULL, 'Milkaa\'ee jira', NULL, NULL, 'uploads/approvals/DLY77w0qO5PdypUXeZIMWPWt1t5xkFUn4zLY8pDc.pdf', NULL, '2025-05-31 14:57:53', NULL, '2025-05-31 11:57:03', '2025-05-31 11:57:53'),
(32, 35, NULL, 6, NULL, 'Komii keessaan Arginee jira. Kaanaf guyyaa boruu irraa kaasee isiinif ni gala. Obsaa keessaniif galatooma.', NULL, NULL, 'uploads/approvals/yPi0SEEmEH4gRQAZIXAbAta7yNUEhDFkzmxGRzGJ.pdf', NULL, '2025-05-31 15:18:31', NULL, '2025-05-31 12:15:46', '2025-05-31 12:18:31'),
(33, 36, NULL, 7, NULL, 'siif milkaa\'ee jira', NULL, NULL, 'uploads/approvals/6VNwXMCMrKh3FQyqfeqdJrMbUl5F725zzSx4s4dI.pdf', NULL, '2025-06-01 13:12:35', NULL, '2025-05-31 12:24:59', '2025-06-01 10:12:35'),
(34, 37, NULL, 6, NULL, 'Siif milka\'ee jira', NULL, NULL, 'uploads/approvals/bPGj6QOyKOHhFTCWPDoXsAqvXhu5CjqeOBu06eqI.pdf', NULL, '2025-06-01 13:36:59', NULL, '2025-06-01 10:16:05', '2025-06-01 10:36:59'),
(35, 38, NULL, NULL, 6, NULL, 'Haqamee jira.', NULL, NULL, NULL, NULL, '2025-06-02 03:32:51', '2025-06-02 00:21:25', '2025-06-02 00:32:51'),
(36, 39, NULL, 6, NULL, 'siif milka\'e jira.', NULL, NULL, 'uploads/approvals/nlHF2UkhPgEfzw9xLohJRp2MmW1cy1x50Qo1f2Pg.pdf', NULL, '2025-06-02 06:16:53', NULL, '2025-06-02 03:09:07', '2025-06-02 03:16:53'),
(37, 40, NULL, 6, NULL, 'isiinf milka\'ee jira.', NULL, NULL, 'uploads/approvals/BOlgZ4mU5eBzYH2mo092tfocVYD03Qmn10byZChd.pdf', NULL, '2025-06-02 07:28:40', NULL, '2025-06-02 04:27:05', '2025-06-02 04:28:40'),
(38, 41, NULL, NULL, 6, NULL, 'ulagalee isiin barbaachisuun hunda upload hin goone', NULL, NULL, NULL, NULL, '2025-06-02 12:34:24', '2025-06-02 09:30:17', '2025-06-02 09:34:24'),
(39, 42, NULL, 6, NULL, 'Siif milka\'ee jira.', NULL, NULL, 'uploads/approvals/8gvGigIkMPWZ2kBuEdQPCtRHYTGN9d2TUot2Ux0o.pdf', NULL, '2025-06-02 12:42:10', NULL, '2025-06-02 09:40:40', '2025-06-02 09:42:10'),
(40, 43, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:47:39', '2025-06-03 18:47:39'),
(41, 44, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:48:42', '2025-06-03 18:48:42'),
(42, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:49:28', '2025-06-03 18:49:28'),
(43, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:52:54', '2025-06-03 18:52:54'),
(44, 47, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:53:21', '2025-06-03 18:53:21'),
(45, 48, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-03 18:53:54', '2025-06-03 18:53:54'),
(46, 49, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-04 03:52:57', '2025-06-04 03:52:57'),
(47, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-05 03:24:16', '2025-06-05 03:24:16'),
(48, 51, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-07 07:42:38', '2025-06-07 07:42:38'),
(49, 52, NULL, 6, NULL, 'siif mirkanaa\'ee jira.', NULL, NULL, NULL, NULL, '2025-06-07 10:45:01', NULL, '2025-06-07 07:42:39', '2025-06-07 07:45:01'),
(50, 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-07 13:55:03', '2025-06-07 13:55:03'),
(51, 54, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:23:09', '2025-06-07 18:23:09'),
(52, 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:34:38', '2025-06-07 18:34:38'),
(53, 56, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-07 18:35:52', '2025-06-07 18:35:52'),
(54, 57, NULL, 6, NULL, 'isiif milka\'ee jira.', NULL, NULL, 'uploads/approvals/sBtyUQwf4UJD9T1WtPJ45j31hwRIMsW3bkKCijh8.pdf', NULL, '2025-06-07 21:37:49', NULL, '2025-06-07 18:37:09', '2025-06-07 18:37:50'),
(55, 58, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-08 14:11:04', '2025-06-08 14:11:04'),
(56, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-09 04:45:19', '2025-06-09 04:45:19'),
(57, 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-10 05:54:41', '2025-06-10 05:54:41');

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

--
-- Table structure for table `subcities`
--

CREATE TABLE `subcities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subcities`
--

INSERT INTO `subcities` (`id`, `name`, `city_id`, `created_at`, `updated_at`) VALUES
(1, 'Kutaa Magaalaa Boolee', 1, NULL, NULL),
(2, 'Kutaa Magaalaa Abbaa Gadaa', 1, NULL, NULL),
(3, 'Kutaa Magaalaa Bokkuu Shanan', 1, NULL, NULL),
(4, 'Kutaa Magaalaa Daabee Soloqqee', 1, NULL, NULL),
(5, 'Kutaa Magaalaa Luugoo', 1, NULL, NULL),
(6, 'Kutaa Magaala Dambalaa ', 1, NULL, NULL);

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

--
-- Table structure for table `windows`
--

CREATE TABLE `windows` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `windows`
--

INSERT INTO `windows` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Foddaa 1: Kenna Ragaalee Bu’uuraa ', '2025-05-29 04:25:15', '2025-05-29 04:25:15'),
(2, 'Foddaa 2:Xalayaa  Deggersa Adda Addaa Kennuu', '2025-05-29 05:16:57', '2025-05-29 05:16:57'),
(3, 'Foddaa 3 : Tajaajiloota Dhimmoota Bulchiinsaa', '2025-05-29 05:17:58', '2025-05-29 05:17:58'),
(4, 'Foddaa 4 : Kenna Hayyama Ogummaa fi Ijaarsaa', '2025-05-29 05:18:39', '2025-05-29 05:18:39'),
(5, 'Foddaa 5 : Mirkaneessa Gahumsa Ogummaa', '2025-05-29 05:19:12', '2025-05-29 05:19:12'),
(6, 'Foddaa 6 : Hayyamaa Daldala', '2025-05-29 05:19:39', '2025-05-29 05:19:39'),
(7, 'Foddaa 7 : Galmeessa, Mirkaneessa Sanadootaafi Waliigaltee', '2025-05-29 05:20:08', '2025-05-29 05:20:08'),
(8, 'Foddaa 8 : Kenna Tajaajila Investimentii', '2025-05-29 05:20:46', '2025-05-29 05:20:46'),
(9, 'Foddaa 9 : Kenna Tajaajila lafaa', '2025-05-29 05:21:14', '2025-05-29 05:21:14'),
(10, 'Foddaa 10 : Sassaabbii Galii fi Simannaa Dhimmoota Taaksii Gibiraa', '2025-05-29 05:21:37', '2025-05-29 05:21:37'),
(11, 'Foddaa 11 : Kaffaltii Adda Addaa', '2025-05-29 05:22:03', '2025-05-29 05:22:03'),
(12, 'Foddaa 12 : Baankii', '2025-05-29 05:22:31', '2025-05-29 05:22:31');

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

--
-- Table structure for table `woredas`
--

CREATE TABLE `woredas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `subcity_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `woredas`
--

INSERT INTO `woredas` (`id`, `name`, `subcity_id`, `created_at`, `updated_at`) VALUES
(1, 'Aanaa Gadaa', 2, NULL, NULL),
(2, 'Aanaa Gurmuu', 2, NULL, NULL),
(3, 'Aanaa Odaa', 2, NULL, NULL),
(4, 'Aanaa Badhaatuu', 2, NULL, NULL),
(5, 'Dhadacha Araaraa', 1, NULL, NULL),
(6, 'Gooroo', 1, NULL, NULL),
(7, 'Dhakaa Adii', 1, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `applications_application_number_unique` (`application_number`),
  ADD KEY `applications_user_id_foreign` (`user_id`),
  ADD KEY `applications_service_id_foreign` (`service_id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_applications`
--
ALTER TABLE `customer_applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_applications_service_id_foreign` (`service_id`),
  ADD KEY `customer_applications_user_id_foreign` (`user_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `levels`
--
ALTER TABLE `levels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mayor_applications`
--
ALTER TABLE `mayor_applications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offices`
--
ALTER TABLE `offices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_window_id_foreign` (`window_id`),
  ADD KEY `services_ref_window_id_foreign` (`ref_window_id`);

--
-- Indexes for table `service_user`
--
ALTER TABLE `service_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_user_user_id_foreign` (`user_id`),
  ADD KEY `service_user_service_id_foreign` (`service_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `statuses_application_id_foreign` (`application_id`),
  ADD KEY `statuses_accept_by_id_foreign` (`accept_by_id`),
  ADD KEY `statuses_approved_by_id_foreign` (`approved_by_id`),
  ADD KEY `statuses_rejected_by_id_foreign` (`rejected_by_id`);

--
-- Indexes for table `subcities`
--
ALTER TABLE `subcities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subcities_city_id_foreign` (`city_id`);

--
-- Indexes for table `windows`
--
ALTER TABLE `windows`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woredas`
--
ALTER TABLE `woredas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `woredas_subcity_id_foreign` (`subcity_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customer_applications`
--
ALTER TABLE `customer_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `levels`
--
ALTER TABLE `levels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mayor_applications`
--
ALTER TABLE `mayor_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `offices`
--
ALTER TABLE `offices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `service_user`
--
ALTER TABLE `service_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `subcities`
--
ALTER TABLE `subcities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `windows`
--
ALTER TABLE `windows`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `woredas`
--
ALTER TABLE `woredas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `applications`
--
ALTER TABLE `applications`
  ADD CONSTRAINT `applications_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`),
  ADD CONSTRAINT `applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `customer_applications`
--
ALTER TABLE `customer_applications`
  ADD CONSTRAINT `customer_applications_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_ref_window_id_foreign` FOREIGN KEY (`ref_window_id`) REFERENCES `windows` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `services_window_id_foreign` FOREIGN KEY (`window_id`) REFERENCES `windows` (`id`);

--
-- Constraints for table `service_user`
--
ALTER TABLE `service_user`
  ADD CONSTRAINT `service_user_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `service_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `statuses`
--
ALTER TABLE `statuses`
  ADD CONSTRAINT `statuses_accept_by_id_foreign` FOREIGN KEY (`accept_by_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `statuses_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`),
  ADD CONSTRAINT `statuses_approved_by_id_foreign` FOREIGN KEY (`approved_by_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `statuses_rejected_by_id_foreign` FOREIGN KEY (`rejected_by_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `subcities`
--
ALTER TABLE `subcities`
  ADD CONSTRAINT `subcities_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `woredas`
--
ALTER TABLE `woredas`
  ADD CONSTRAINT `woredas_subcity_id_foreign` FOREIGN KEY (`subcity_id`) REFERENCES `subcities` (`id`) ON DELETE CASCADE;
COMMIT;

