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

START TRANSACTION;



--
-- Database: `real_estate_management`
--

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

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 DEFAULT NULL,
  `batch_uuid` char(36) COLLATE utf8mb4_unicode_ci 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 `activity_log`
--

INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
(1, 'نوع العقار', 'عملية انشاء , تم انشاء نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"11\"}', NULL, '2023-08-02 14:51:13', '2023-08-02 14:51:13'),
(2, 'نوع العقار', 'عملية تعديل , تم تعديل نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"111\"}', NULL, '2023-08-02 14:51:19', '2023-08-02 14:51:19'),
(3, 'نوع العقار', 'عملية حذف , تم حذف نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"111\"}', NULL, '2023-08-02 14:51:24', '2023-08-02 14:51:24'),
(4, 'الجنسيات', 'عملية انشاء , تم انشاء جنسية  ', 'App\\Models\\Nationalty', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"22\"}', NULL, '2023-08-02 14:51:46', '2023-08-02 14:51:46'),
(5, 'الجنسيات', 'عملية تعديل , تم تعديل جنسية  ', 'App\\Models\\Nationalty', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"11\"}', NULL, '2023-08-02 14:51:56', '2023-08-02 14:51:56'),
(6, 'الجنسيات', 'عملية حذف , تم حذف جنسية  ', 'App\\Models\\Nationalty', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"11\"}', NULL, '2023-08-02 14:52:01', '2023-08-02 14:52:01'),
(7, 'المناطق', 'عملية انشاء , تم انشاء  منطقة  ', 'App\\Models\\Region', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"11\"}', NULL, '2023-08-02 14:52:19', '2023-08-02 14:52:19'),
(8, 'المناطق', 'عملية تعديل , تم تعديل  منطقة  ', 'App\\Models\\Region', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"44\"}', NULL, '2023-08-02 14:52:28', '2023-08-02 14:52:28'),
(9, 'المناطق', 'عملية حذف , تم حذف  منطقة  ', 'App\\Models\\Region', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"44\"}', NULL, '2023-08-02 14:52:34', '2023-08-02 14:52:34'),
(10, 'المحافظات', 'عملية إنشاء , تم إنشاء محافظة جديدة ', 'App\\Models\\City', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0633\\u064a\\u0624\\u064a\\u0628\\u064a\"}', NULL, '2023-08-02 14:53:05', '2023-08-02 14:53:05'),
(11, 'المحافظات', 'عملية تعديل , تم تعديل محافظة  ', 'App\\Models\\City', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0628\\u064a\\u0635\\u062b\\u0633\\u0628\\u0633\"}', NULL, '2023-08-02 14:53:17', '2023-08-02 14:53:17'),
(12, 'المحافظات', 'عملية حذف , تم حذف محافظة  ', 'App\\Models\\City', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0628\\u064a\\u0635\\u062b\\u0633\\u0628\\u0633\"}', NULL, '2023-08-02 14:53:21', '2023-08-02 14:53:21'),
(13, 'المحافظات', 'عملية إنشاء , تم إنشاء محافظة جديدة ', 'App\\Models\\City', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u062c\\u062f\\u0629\"}', NULL, '2023-08-02 14:53:58', '2023-08-02 14:53:58'),
(14, 'الاحياء', 'عملية انشاء , تم انشاء حي  ', 'App\\Models\\District', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"22\"}', NULL, '2023-08-02 14:54:15', '2023-08-02 14:54:15'),
(15, 'الاحياء', 'عملية تعديل , تم تعديل حي  ', 'App\\Models\\District', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"2222\"}', NULL, '2023-08-02 14:54:25', '2023-08-02 14:54:25'),
(16, 'الاحياء', 'عملية حذف , تم حذف حي  ', 'App\\Models\\District', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"2222\"}', NULL, '2023-08-02 14:54:31', '2023-08-02 14:54:31'),
(17, 'البنوك', 'عملية إنشاء , تم إنشاء بنك جديد ', 'App\\Models\\Bank', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"22\"}', NULL, '2023-08-02 14:54:47', '2023-08-02 14:54:47'),
(18, 'البنوك', 'عملية تعديل , تم تعديل بنك  ', 'App\\Models\\Bank', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"22111\"}', NULL, '2023-08-02 14:55:10', '2023-08-02 14:55:10'),
(19, 'البنوك', 'عملية حذف , تم حذف بنك  ', 'App\\Models\\Bank', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"22111\"}', NULL, '2023-08-02 14:55:15', '2023-08-02 14:55:15'),
(20, 'انواع الصيانة', 'عملية انشاء , تم انشاء  نوع صيانة', 'App\\Models\\TypeOfMaintenance', NULL, 8, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-02 14:55:40', '2023-08-02 14:55:40'),
(21, 'انواع الصيانة', 'عملية تعديل , تم تعديل  نوع صيانة', 'App\\Models\\TypeOfMaintenance', NULL, 8, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u063132\"}', NULL, '2023-08-02 14:55:47', '2023-08-02 14:55:47'),
(22, 'انواع الصيانة', 'عملية حذف , تم حذف  نوع صيانة  ', 'App\\Models\\TypeOfMaintenance', NULL, 8, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u063132\"}', NULL, '2023-08-02 14:55:52', '2023-08-02 14:55:52'),
(23, 'انواع الوحدات العقارية', 'عملية انشاء , تم انشاء  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-02 14:56:47', '2023-08-02 14:56:47'),
(24, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u063131\"}', NULL, '2023-08-02 14:56:55', '2023-08-02 14:56:55'),
(25, 'انواع الوحدات العقارية', 'عملية حذف , تم حذف  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u063131\"}', NULL, '2023-08-02 14:57:01', '2023-08-02 14:57:01'),
(26, 'الملاك', 'عملية إنشاء , تم إنشاء مالك جديد ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed\"}', NULL, '2023-08-03 10:00:29', '2023-08-03 10:00:29'),
(27, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed\"}', NULL, '2023-08-03 12:05:35', '2023-08-03 12:05:35'),
(28, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed2\"}', NULL, '2023-08-03 12:06:34', '2023-08-03 12:06:34'),
(29, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed2\"}', NULL, '2023-08-03 12:08:14', '2023-08-03 12:08:14'),
(30, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed2\"}', NULL, '2023-08-03 12:11:38', '2023-08-03 12:11:38'),
(31, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed2\"}', NULL, '2023-08-03 12:33:07', '2023-08-03 12:33:07'),
(32, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0633\\u0643\\u0646\\u064a\"}', NULL, '2023-08-03 13:42:47', '2023-08-03 13:42:47'),
(33, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u062a\\u062c\\u0627\\u0631\\u064a\"}', NULL, '2023-08-03 13:42:57', '2023-08-03 13:42:57'),
(34, 'انواع الوحدات العقارية', 'عملية انشاء , تم انشاء  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0632\\u0631\\u0627\\u0639\\u064a\"}', NULL, '2023-08-03 13:43:18', '2023-08-03 13:43:18'),
(35, 'نوع العقار', 'عملية انشاء , تم انشاء نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0633\\u0643\\u0646\\u064a\\u0629\"}', NULL, '2023-08-03 14:51:12', '2023-08-03 14:51:12'),
(36, 'نوع العقار', 'عملية انشاء , تم انشاء نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u062a\\u062c\\u0627\\u0631\\u064a\\u0629\"}', NULL, '2023-08-03 14:51:21', '2023-08-03 14:51:21'),
(37, 'نوع العقار', 'عملية انشاء , تم انشاء نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0648\\u0627\\u0626\\u0644\"}', NULL, '2023-08-03 14:51:29', '2023-08-03 14:51:29'),
(38, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u06431\"}', NULL, '2023-08-03 17:17:38', '2023-08-03 17:17:38'),
(39, 'العقارات', 'عملية إنشاء , تم إنشاء عقار جديد ', 'App\\Models\\RealEstate', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-03 17:56:07', '2023-08-03 17:56:07'),
(40, 'نوع العقار', 'عملية انشاء , تم انشاء نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"rtfyrtyrty\"}', NULL, '2023-08-04 08:23:05', '2023-08-04 08:23:05'),
(41, 'نوع العقار', 'عملية حذف , تم حذف نوع العقار  ', 'App\\Models\\RealEstateType', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"rtfyrtyrty\"}', NULL, '2023-08-04 08:23:18', '2023-08-04 08:23:18'),
(42, 'المحافظات', 'عملية إنشاء , تم إنشاء محافظة جديدة ', 'App\\Models\\City', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"fgfdgfd\"}', NULL, '2023-08-04 08:26:25', '2023-08-04 08:26:25'),
(43, 'المحافظات', 'عملية حذف , تم حذف محافظة  ', 'App\\Models\\City', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"fgfdgfd\"}', NULL, '2023-08-04 08:26:32', '2023-08-04 08:26:32'),
(44, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u06431\"}', NULL, '2023-08-04 08:29:16', '2023-08-04 08:29:16'),
(45, 'الجنسيات', 'عملية انشاء , تم انشاء جنسية  ', 'App\\Models\\Nationalty', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-04 09:23:26', '2023-08-04 09:23:26'),
(46, 'المناطق', 'عملية انشاء , تم انشاء  منطقة  ', 'App\\Models\\Region', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed\"}', NULL, '2023-08-04 11:05:42', '2023-08-04 11:05:42'),
(47, 'المناطق', 'عملية تعديل , تم تعديل  منطقة  ', 'App\\Models\\Region', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"tttttttttttttt\"}', NULL, '2023-08-04 11:06:31', '2023-08-04 11:06:31'),
(48, 'المناطق', 'عملية تعديل , تم تعديل  منطقة  ', 'App\\Models\\Region', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"458625698\"}', NULL, '2023-08-04 11:09:20', '2023-08-04 11:09:20'),
(49, 'المناطق', 'عملية حذف , تم حذف  منطقة  ', 'App\\Models\\Region', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"458625698\"}', NULL, '2023-08-04 11:09:26', '2023-08-04 11:09:26'),
(50, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0632\\u0631\\u0627\\u0639\\u064a2\"}', NULL, '2023-08-04 11:19:12', '2023-08-04 11:19:12'),
(51, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0632\\u0631\\u0627\\u0639\\u064a\"}', NULL, '2023-08-04 11:19:18', '2023-08-04 11:19:18'),
(52, 'انواع الصيانة', 'عملية تعديل , تم تعديل  نوع صيانة', 'App\\Models\\TypeOfMaintenance', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0628\\u0646\\u0627\\u06212\"}', NULL, '2023-08-04 11:19:30', '2023-08-04 11:19:30'),
(53, 'انواع الصيانة', 'عملية تعديل , تم تعديل  نوع صيانة', 'App\\Models\\TypeOfMaintenance', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0628\\u0646\\u0627\\u0621\"}', NULL, '2023-08-04 11:19:35', '2023-08-04 11:19:35'),
(54, 'انواع الوحدات العقارية', 'عملية انشاء , تم انشاء  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"yyyyyyyyyyy\"}', NULL, '2023-08-04 11:23:32', '2023-08-04 11:23:32'),
(55, 'انواع الوحدات العقارية', 'عملية تعديل , تم تعديل  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"wwwwwwwwwwwwwwww\"}', NULL, '2023-08-04 11:23:39', '2023-08-04 11:23:39'),
(56, 'انواع الوحدات العقارية', 'عملية حذف , تم حذف  نوع الوحدة  ', 'App\\Models\\Unit', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"wwwwwwwwwwwwwwww\"}', NULL, '2023-08-04 11:23:48', '2023-08-04 11:23:48'),
(57, 'البنوك', 'عملية إنشاء , تم إنشاء بنك جديد ', 'App\\Models\\Bank', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"fdgfhfghrt\"}', NULL, '2023-08-04 11:57:11', '2023-08-04 11:57:11'),
(58, 'البنوك', 'عملية حذف , تم حذف بنك  ', 'App\\Models\\Bank', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"fdgfhfghrt\"}', NULL, '2023-08-04 11:57:28', '2023-08-04 11:57:28'),
(59, 'الملاك', 'عملية إنشاء , تم إنشاء مالك جديد ', 'App\\Models\\Owner', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u06432\"}', NULL, '2023-08-04 12:31:14', '2023-08-04 12:31:14'),
(60, 'الملاك', 'عملية تعديل , تم تعديل مالك  ', 'App\\Models\\Owner', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u06432-2\"}', NULL, '2023-08-04 12:32:02', '2023-08-04 12:32:02'),
(61, 'العقارات', 'عملية إنشاء , تم إنشاء عقار جديد ', 'App\\Models\\RealEstate', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u06312\"}', NULL, '2023-08-04 12:48:46', '2023-08-04 12:48:46'),
(62, 'العقارات', 'عملية حذف , تم حذف عقار  ', 'App\\Models\\RealEstate', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-04 12:58:50', '2023-08-04 12:58:50'),
(63, 'العقارات', 'عملية حذف , تم حذف عقار  ', 'App\\Models\\RealEstate', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0627\\u062e\\u062a\\u0628\\u0627\\u06313\"}', NULL, '2023-08-06 10:01:31', '2023-08-06 10:01:31'),
(64, 'العقارات', 'عملية حذف , تم حذف عقار  ', 'App\\Models\\RealEstate', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u06312\"}', NULL, '2023-08-06 10:01:36', '2023-08-06 10:01:36'),
(65, 'العقارات', 'عملية حذف , تم حذف عقار  ', 'App\\Models\\RealEstate', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u06312\"}', NULL, '2023-08-06 10:01:42', '2023-08-06 10:01:42'),
(66, 'العقارات', 'عملية تعديل , تم تعديل عقار  ', 'App\\Models\\RealEstate', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u06312\"}', NULL, '2023-08-06 10:02:02', '2023-08-06 10:02:02'),
(67, 'العقارات', 'عملية تعديل , تم تعديل عقار  ', 'App\\Models\\RealEstate', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u06312\"}', NULL, '2023-08-06 12:29:42', '2023-08-06 12:29:42'),
(68, 'المشرفين', 'عملية إنشاء , تم إنشاء مشرف جديد ', 'App\\Models\\Supervisor', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"a\"}', NULL, '2023-08-07 10:13:53', '2023-08-07 10:13:53'),
(69, 'المشرفين', 'عملية تعديل , تم تعديل   المشرف ', 'App\\Models\\Supervisor', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0634\\u0631\\u0641 1\"}', NULL, '2023-08-07 11:11:18', '2023-08-07 11:11:18'),
(70, 'العقارات', 'عملية تعديل , تم تعديل عقار  ', 'App\\Models\\RealEstate', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u0631 1\"}', NULL, '2023-08-07 11:27:17', '2023-08-07 11:27:17'),
(71, 'العقارات', 'عملية إنشاء , تم إنشاء عقار جديد ', 'App\\Models\\RealEstate', NULL, 7, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u0631 3\"}', NULL, '2023-08-07 11:28:30', '2023-08-07 11:28:30'),
(72, 'المشرفين', 'عملية إنشاء , تم إنشاء مشرف جديد ', 'App\\Models\\Supervisor', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0634\\u0631\\u0641 2\"}', NULL, '2023-08-07 13:06:57', '2023-08-07 13:06:57'),
(73, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 1-1\"}', NULL, '2023-08-08 09:47:22', '2023-08-08 09:47:22'),
(74, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 1-2\"}', NULL, '2023-08-08 09:48:03', '2023-08-08 09:48:03'),
(75, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 2-1\"}', NULL, '2023-08-08 09:48:56', '2023-08-08 09:48:56'),
(76, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 2-2\"}', NULL, '2023-08-08 09:49:55', '2023-08-08 09:49:55'),
(77, 'الجنسيات', 'عملية تعديل , تم تعديل جنسية  ', 'App\\Models\\Nationalty', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0633\\u0648\\u062f\\u0627\\u0646\\u064a\"}', NULL, '2023-08-08 09:50:24', '2023-08-08 09:50:24'),
(78, 'الجنسيات', 'عملية انشاء , تم انشاء جنسية  ', 'App\\Models\\Nationalty', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0633\\u0639\\u0648\\u062f\\u064a\"}', NULL, '2023-08-08 09:50:31', '2023-08-08 09:50:31'),
(79, 'المستاجرين', 'عملية إنشاء , تم إنشاء مستاجر جديد ', 'App\\Models\\Tenant', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0633\\u062a\\u0627\\u062c\\u0631 1\"}', NULL, '2023-08-08 09:51:10', '2023-08-08 09:51:10'),
(80, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 09:53:00', '2023-08-08 09:53:00'),
(81, 'الجنسيات', 'عملية انشاء , تم انشاء جنسية  ', 'App\\Models\\Nationalty', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed\"}', NULL, '2023-08-08 11:54:27', '2023-08-08 11:54:27'),
(82, 'الجنسيات', 'عملية حذف , تم حذف جنسية  ', 'App\\Models\\Nationalty', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"ahmed\"}', NULL, '2023-08-08 11:54:32', '2023-08-08 11:54:32'),
(83, 'العقودات', 'عملية تعديل , تم تعديل عقد  ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 12:44:47', '2023-08-08 12:44:47'),
(84, 'العقودات', 'عملية تعديل , تم تعديل عقد  ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 12:46:00', '2023-08-08 12:46:00'),
(85, 'العقودات', 'عملية تعديل , تم تعديل عقد  ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 13:05:40', '2023-08-08 13:05:40'),
(86, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 14:14:19', '2023-08-08 14:14:19'),
(87, 'المستاجرين', 'عملية إنشاء , تم إنشاء مستاجر جديد ', 'App\\Models\\Tenant', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0633\\u062a\\u0627\\u062c\\u0631 2\"}', NULL, '2023-08-08 14:46:48', '2023-08-08 14:46:48'),
(88, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 14:47:46', '2023-08-08 14:47:46'),
(89, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 14:48:41', '2023-08-08 14:48:41'),
(90, 'العقودات', 'عملية تعديل , تم تعديل عقد  ', 'App\\Models\\Contract', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-08 14:53:09', '2023-08-08 14:53:09'),
(91, 'الجنسيات', 'عملية انشاء , تم انشاء جنسية  ', 'App\\Models\\Nationalty', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0628\\u0627\\u0643\\u0633\\u062a\\u0627\\u0646\\u064a\"}', NULL, '2023-08-08 15:04:33', '2023-08-08 15:04:33'),
(92, 'العقارات', 'عملية تعديل , تم تعديل عقار  ', 'App\\Models\\RealEstate', NULL, 7, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u0631 3\"}', NULL, '2023-08-08 15:13:07', '2023-08-08 15:13:07'),
(93, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"111111\"}', NULL, '2023-08-08 15:14:11', '2023-08-08 15:14:11'),
(94, 'المشرفين', 'عملية إنشاء , تم إنشاء مشرف جديد ', 'App\\Models\\Supervisor', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0634\\u0631\\u0641 3\"}', NULL, '2023-08-08 15:15:03', '2023-08-08 15:15:03'),
(95, 'المستاجرين', 'عملية تعديل , تم تعديل مستاجر  ', 'App\\Models\\Tenant', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0633\\u062a\\u0627\\u062c\\u0631 2\"}', NULL, '2023-08-08 15:20:31', '2023-08-08 15:20:31'),
(96, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-09 10:03:19', '2023-08-09 10:03:19'),
(97, 'الملاك', 'عملية تعديل , تم تعديل مالك ', 'App\\Models\\Owner', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u06432\"}', NULL, '2023-08-10 16:46:22', '2023-08-10 16:46:22'),
(98, 'الملاك', 'عملية إنشاء , تم إنشاء مالك جديد ', 'App\\Models\\Owner', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0627\\u0644\\u0643 4\"}', NULL, '2023-08-10 16:47:02', '2023-08-10 16:47:02'),
(99, 'العقارات', 'عملية إنشاء , تم إنشاء عقار جديد ', 'App\\Models\\RealEstate', NULL, 8, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0639\\u0642\\u0627\\u0631 4\"}', NULL, '2023-08-10 16:48:18', '2023-08-10 16:48:18'),
(100, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 4\"}', NULL, '2023-08-10 16:49:05', '2023-08-10 16:49:05'),
(101, 'المستاجرين', 'عملية إنشاء , تم إنشاء مستاجر جديد ', 'App\\Models\\Tenant', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0633\\u062a\\u0627\\u062c\\u0631 4\"}', NULL, '2023-08-10 16:49:54', '2023-08-10 16:49:54'),
(102, 'المستاجرين', 'عملية إنشاء , تم إنشاء مستاجر جديد ', 'App\\Models\\Tenant', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0645\\u0633\\u062a\\u0627\\u062c\\u0631 3\"}', NULL, '2023-08-10 16:50:45', '2023-08-10 16:50:45'),
(103, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-10 17:35:30', '2023-08-10 17:35:30'),
(104, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-10 17:45:02', '2023-08-10 17:45:02'),
(105, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-10 18:35:02', '2023-08-10 18:35:02'),
(106, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-11 09:51:39', '2023-08-11 09:51:39'),
(107, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-11 09:52:10', '2023-08-11 09:52:10'),
(108, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 1, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 1-1\"}', NULL, '2023-08-12 08:14:22', '2023-08-12 08:14:22'),
(109, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 2, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 1-2\"}', NULL, '2023-08-12 08:15:04', '2023-08-12 08:15:04'),
(110, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 3, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 1-3\"}', NULL, '2023-08-12 08:15:39', '2023-08-12 08:15:39'),
(111, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0647 2-1\"}', NULL, '2023-08-12 08:17:00', '2023-08-12 08:17:00'),
(112, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0647 2-2\"}', NULL, '2023-08-12 08:17:35', '2023-08-12 08:17:35'),
(113, 'الوحدات العقارية', 'عملية إنشاء , تم إنشاء وحدة عقارية جديدة ', 'App\\Models\\RealEstateUnit', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":\"\\u0648\\u062d\\u062f\\u0629 3-1\"}', NULL, '2023-08-12 08:18:19', '2023-08-12 08:18:19'),
(114, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 08:43:54', '2023-08-12 08:43:54'),
(115, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 4, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 09:55:55', '2023-08-12 09:55:55'),
(116, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 10:03:35', '2023-08-12 10:03:35'),
(117, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 5, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 10:05:29', '2023-08-12 10:05:29'),
(118, 'العقودات', 'عملية إنشاء , تم إنشاء عقد جديد ', 'App\\Models\\Contract', NULL, 7, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 10:07:42', '2023-08-12 10:07:42'),
(119, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 6, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 12:53:55', '2023-08-12 12:53:55'),
(120, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 7, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 13:00:17', '2023-08-12 13:00:17'),
(121, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 8, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 13:01:01', '2023-08-12 13:01:01'),
(122, 'التحصيل', 'عملية إنشاء , تم إنشاء تحصيل جديد ', 'App\\Models\\Payment', NULL, 9, 'Bitfumes\\Multiauth\\Model\\Admin', 1, '{\"name\":null}', NULL, '2023-08-12 13:41:08', '2023-08-12 13:41:08');

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

--
-- Table structure for table `admin_permission`
--

CREATE TABLE `admin_permission` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `permission_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 `admin_role`
--

CREATE TABLE `admin_role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_role`
--

INSERT INTO `admin_role` (`id`, `role_id`, `admin_id`) VALUES
(1, 1, 1),
(2, 2, 2),
(3, 2, 3);

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

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

CREATE TABLE `banks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `banks` (`id`, `name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'test', NULL, NULL, '2023-08-02 12:33:02', '2023-08-02 12:33:02'),
(2, '5rthgftg', NULL, '2023-08-02 12:33:17', '2023-08-02 12:33:07', '2023-08-02 12:33:17'),
(3, '111', 'Super Admin', '2023-08-02 14:31:00', '2023-08-02 14:30:47', '2023-08-02 14:31:00'),
(4, '22111', 'Super Admin', '2023-08-02 14:55:15', '2023-08-02 14:54:47', '2023-08-02 14:55:15'),
(5, 'fdgfhfghrt', 'Super Admin', '2023-08-04 11:57:28', '2023-08-04 11:57:11', '2023-08-04 11:57:28');

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

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

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

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

INSERT INTO `cities` (`id`, `region_id`, `name`, `created_at`, `updated_at`, `deleted_by`, `deleted_at`) VALUES
(1, 1, 'جدة1', '2023-08-02 14:22:17', '2023-08-02 14:27:41', 'Super Admin', '2023-08-02 14:27:41'),
(2, 1, 'بيصثسبس', '2023-08-02 14:53:05', '2023-08-02 14:53:21', 'Super Admin', '2023-08-02 14:53:21'),
(3, 1, 'جدة', '2023-08-02 14:53:58', '2023-08-02 14:53:58', NULL, NULL),
(4, 1, 'fgfdgfd', '2023-08-04 08:26:25', '2023-08-04 08:26:32', 'Super Admin', '2023-08-04 08:26:32');

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

--
-- Table structure for table `contracts`
--

CREATE TABLE `contracts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contract_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_contract` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `beginning_of_contract_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ending_of_contract_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_days` int(11) NOT NULL,
  `number_of_month` int(11) NOT NULL,
  `payment_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `real_estate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tenant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `cancle_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancle_reason` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contracts`
--

INSERT INTO `contracts` (`id`, `contract_number`, `date_of_contract`, `beginning_of_contract_date`, `ending_of_contract_date`, `contract_value`, `contract_days`, `number_of_month`, `payment_type_id`, `real_estate_id`, `tenant_id`, `status`, `cancle_date`, `cancle_reason`, `notes`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(5, '10128906', '2023-08-12', '2023-08-12', '2024-08-06', '26000', 360, 12, 1, 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '2023-08-12 08:43:54', '2023-08-12 08:43:54'),
(6, '527628', '2023-08-12', '2023-08-12', '2024-08-06', '40000', 360, 12, 1, 7, 4, 1, NULL, NULL, NULL, NULL, NULL, '2023-08-12 10:03:35', '2023-08-12 10:03:35');

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

--
-- Table structure for table `contract_real_estate_units`
--

CREATE TABLE `contract_real_estate_units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contract_id` bigint(20) UNSIGNED DEFAULT NULL,
  `real_estate_unit_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 `contract_real_estate_units`
--

INSERT INTO `contract_real_estate_units` (`id`, `contract_id`, `real_estate_unit_id`, `created_at`, `updated_at`) VALUES
(15, 5, 1, '2023-08-12 08:43:54', '2023-08-12 08:43:54'),
(16, 5, 2, '2023-08-12 08:43:54', '2023-08-12 08:43:54'),
(17, 6, 6, '2023-08-12 10:03:35', '2023-08-12 10:03:35');

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

--
-- Table structure for table `districts`
--

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

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `city_id`, `name`, `created_at`, `updated_at`, `deleted_by`, `deleted_at`) VALUES
(1, 3, '2222', '2023-08-02 14:54:15', '2023-08-02 14:54:31', NULL, NULL);

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

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

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

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\RealEstate', 4, '0f444322-0b3f-473c-a7e1-da9cf85c5f3e', 'files', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-06 10:02:01', '2023-08-06 10:02:01'),
(2, 'App\\Models\\RealEstate', 4, 'd0a89ad6-5d1d-4b84-92f2-28fddd862c04', 'images', 'WhatsApp Image 2022-11-05 at 10.44.43 AM', 'WhatsApp-Image-2022-11-05-at-10.44.43-AM.jpeg', 'image/jpeg', 'public', 'public', 6519, '[]', '[]', '[]', '[]', 2, '2023-08-06 10:02:02', '2023-08-06 10:02:02'),
(3, 'App\\Models\\Supervisor', 1, '75c5c935-4aa7-4b13-937f-36a3f397760b', 'identity_image', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-07 10:13:52', '2023-08-07 10:13:52'),
(4, 'App\\Models\\Supervisor', 2, 'd7852039-de7e-4d07-9a3f-ba5428073772', 'identity_image', 'Flag_of_Iraq.svg', 'Flag_of_Iraq.svg.png', 'image/png', 'public', 'public', 24091, '[]', '[]', '[]', '[]', 1, '2023-08-07 13:06:57', '2023-08-07 13:06:57'),
(5, 'App\\Models\\Tenant', 1, '29a7607d-1433-4d8c-a379-a32bad08aa06', 'files', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-08 09:51:10', '2023-08-08 09:51:10'),
(13, 'App\\Models\\Contract', 2, '89daa543-bdf9-4464-b08f-a506c58f073b', 'files', 'Flag_of_Iraq.svg', 'Flag_of_Iraq.svg.png', 'image/png', 'public', 'public', 24091, '[]', '[]', '[]', '[]', 1, '2023-08-08 14:53:09', '2023-08-08 14:53:09'),
(14, 'App\\Models\\RealEstate', 7, 'f093c151-8cfb-443a-ab98-c4ef194e1dcd', 'files', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-08 15:13:07', '2023-08-08 15:13:07'),
(15, 'App\\Models\\RealEstate', 7, '98fa3971-cfc0-4e2d-9eee-e44d21e43702', 'images', 'Flag_of_Iraq.svg', 'Flag_of_Iraq.svg.png', 'image/png', 'public', 'public', 24091, '[]', '[]', '[]', '[]', 2, '2023-08-08 15:13:07', '2023-08-08 15:13:07'),
(16, 'App\\Models\\Supervisor', 3, '9df32212-0093-4444-be50-a820a26c0057', 'identity_image', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-08 15:15:03', '2023-08-08 15:15:03'),
(17, 'App\\Models\\Tenant', 2, 'd6c2d4b1-309e-45b6-8961-d37683b2e8e5', 'files', 'WhatsApp Image 2022-09-27 at 2.51.02 PM', 'WhatsApp-Image-2022-09-27-at-2.51.02-PM.jpeg', 'image/jpeg', 'public', 'public', 51238, '[]', '[]', '[]', '[]', 1, '2023-08-08 15:20:31', '2023-08-08 15:20:31'),
(18, 'App\\Models\\Tenant', 2, 'd0ca51ac-6959-4d24-bd19-644dc8b9706d', 'files', '2730360-hand-help-inkcontober-united_112704', '2730360-hand-help-inkcontober-united_112704.png', 'image/png', 'public', 'public', 16996, '[]', '[]', '[]', '[]', 2, '2023-08-08 15:20:31', '2023-08-08 15:20:31'),
(19, 'App\\Models\\Payment', 1, 'e76803a4-de93-4b0b-ab0c-bfbe287fd000', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-09 10:03:19', '2023-08-09 10:03:19'),
(20, 'App\\Models\\Payment', 2, '843e9383-decd-4e3e-8b32-92670456822f', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-11 09:51:38', '2023-08-11 09:51:38'),
(21, 'App\\Models\\Payment', 4, 'ebca9887-59d5-4ea8-8a8e-1c6fc8f1789b', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-12 09:55:55', '2023-08-12 09:55:55'),
(22, 'App\\Models\\Payment', 5, '01904c04-e1a0-4f22-8880-2a4d5815ec95', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-12 10:05:28', '2023-08-12 10:05:28'),
(23, 'App\\Models\\Payment', 6, '8aca770b-fb59-4668-bfe2-e340eb4d991a', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-12 12:53:54', '2023-08-12 12:53:54'),
(24, 'App\\Models\\Payment', 7, 'df45a6d6-aab9-4405-a4d8-53b797344d21', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-12 13:00:17', '2023-08-12 13:00:17'),
(25, 'App\\Models\\Payment', 8, '0eb4a4ad-0aef-4274-a3d2-397cef7de30e', 'file', 'avater', 'avater.png', 'image/png', 'public', 'public', 5956, '[]', '[]', '[]', '[]', 1, '2023-08-12 13:01:01', '2023-08-12 13:01:01');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2017_03_06_023521_create_admins_table', 1),
(4, '2017_03_06_053834_create_admin_role_table', 1),
(5, '2018_03_06_023523_create_roles_table', 1),
(6, '2019_08_19_000000_create_failed_jobs_table', 1),
(7, '2019_12_01_120121_create_permissions_table', 1),
(8, '2019_12_01_163205_create_permission_role_table', 1),
(9, '2019_12_01_163233_create_admin_permission_table', 1),
(10, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(11, '2023_08_01_180440_create_real_estate_types_table', 1),
(12, '2023_08_02_091336_create_nationalties_table', 1),
(13, '2023_08_02_095725_create_regions_table', 1),
(14, '2023_08_02_095732_create_cities_table', 1),
(15, '2023_08_02_095741_create_districts_table', 1),
(16, '2023_08_02_122717_create_banks_table', 1),
(17, '2023_08_02_153212_create_type_of_maintenances_table', 2),
(18, '2023_08_02_155643_create_units_table', 3),
(19, '2023_08_02_165953_create_activity_log_table', 4),
(20, '2023_08_02_165954_add_event_column_to_activity_log_table', 4),
(21, '2023_08_02_165955_add_batch_uuid_column_to_activity_log_table', 4),
(22, '2023_08_03_062337_create_owners_table', 5),
(23, '2023_08_03_074457_create_owner_files_table', 5),
(25, '2023_08_03_171427_create_real_estate_files_table', 6),
(27, '2023_08_03_163743_create_real_estates_table', 7),
(28, '2023_08_04_154300_create_real_estate_images_table', 8),
(29, '2023_08_05_093453_create_media_table', 9),
(31, '2023_08_07_111330_create_supervisors_table', 11),
(32, '2023_08_07_143150_create_supervisor_real_estates_table', 12),
(34, '2023_08_08_061923_create_tenants_table', 13),
(36, '2023_08_08_102846_create_contract_real_estate_units_table', 13),
(38, '2023_08_09_061101_create_payment_statuses_table', 15),
(39, '2023_08_09_061107_create_payments_table', 15),
(41, '2023_08_07_1501810_create_payment_types_table', 16),
(43, '2023_08_08_100553_create_contracts_table', 17),
(44, '2023_08_06_154117_create_real_estate_units_table', 18);

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

--
-- Table structure for table `nationalties`
--

CREATE TABLE `nationalties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nationalties`
--

INSERT INTO `nationalties` (`id`, `name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '11', 'Super Admin', '2023-08-02 14:52:01', '2023-08-02 14:51:46', '2023-08-02 14:52:01'),
(2, 'سوداني', NULL, NULL, '2023-08-04 09:23:26', '2023-08-08 09:50:24'),
(3, 'سعودي', NULL, NULL, '2023-08-08 09:50:31', '2023-08-08 09:50:31'),
(4, 'ahmed', 'Super Admin', '2023-08-08 11:54:32', '2023-08-08 11:54:27', '2023-08-08 11:54:32'),
(5, 'باكستاني', NULL, NULL, '2023-08-08 15:04:33', '2023-08-08 15:04:33');

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

--
-- Table structure for table `owner_files`
--

CREATE TABLE `owner_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `owner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `owner_files`
--

INSERT INTO `owner_files` (`id`, `owner_id`, `file`, `file_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'attachment_file/owners/owners_files/File-755112_8028588396.jpg', 'File-755112_8028588396', NULL, '2023-08-04 08:28:09', '2023-08-03 10:00:29', '2023-08-04 08:28:09'),
(2, 1, 'attachment_file/owners/owners_files/File-755112_4065279548.png', 'File-755112_4065279548', NULL, '2023-08-03 12:31:48', '2023-08-03 10:00:29', '2023-08-03 12:31:48'),
(3, 1, 'attachment_file/owners/owners_files/File-755112_9630545856.png', 'File-755112_9630545856', NULL, '2023-08-03 12:31:43', '2023-08-03 10:00:29', '2023-08-03 12:31:43'),
(4, 1, 'attachment_file/owners/owners_files/File-973983_4583176427.pdf', 'File-973983_4583176427', NULL, '2023-08-03 12:11:10', '2023-08-03 12:06:34', '2023-08-03 12:11:10'),
(5, 1, 'attachment_file/owners/owners_files/File-973983_2808969057.pdf', 'File-973983_2808969057', NULL, '2023-08-03 12:11:05', '2023-08-03 12:06:34', '2023-08-03 12:11:05'),
(6, 1, 'attachment_file/owners/owners_files/File-218174_7164841883.csv', 'File-218174_7164841883', NULL, '2023-08-03 12:10:56', '2023-08-03 12:08:14', '2023-08-03 12:10:56'),
(7, 1, 'attachment_file/owners/owners_files/File-258221_1753977330.png', 'File-258221_1753977330', NULL, NULL, '2023-08-03 12:11:38', '2023-08-03 12:11:38'),
(8, 1, 'attachment_file/owners/owners_files/File-328959_1148055333.pdf', 'File-328959_1148055333', NULL, NULL, '2023-08-03 12:33:07', '2023-08-03 12:33:07'),
(9, 1, 'attachment_file/owners/owners_files/File-782546_5677941608.pdf', 'File-782546_5677941608', NULL, NULL, '2023-08-04 08:29:16', '2023-08-04 08:29:16'),
(10, 2, 'attachment_file/owners/owners_files/File-680250_7657644986.png', 'File-680250_7657644986', NULL, NULL, '2023-08-04 12:31:14', '2023-08-04 12:31:14'),
(11, 2, 'attachment_file/owners/owners_files/File-376878_2943037260.png', 'File-376878_2943037260', NULL, NULL, '2023-08-04 12:32:02', '2023-08-04 12:32:02');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_status_id` bigint(20) UNSIGNED DEFAULT NULL,
  `contract_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forfeit_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `payment_status_id`, `contract_id`, `payment_amount`, `forfeit_amount`, `payment_date`, `notes`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(4, 1, 5, '2166', NULL, '2023-08-12', NULL, NULL, NULL, '2023-08-12 09:55:53', '2023-08-12 09:55:53'),
(5, 1, 6, '3333', NULL, '2023-08-12', NULL, NULL, NULL, '2023-08-12 10:05:27', '2023-08-12 10:05:27'),
(8, 1, 5, '23834', NULL, '2023-08-12', NULL, NULL, NULL, '2023-08-12 13:01:01', '2023-08-12 13:01:01'),
(9, 2, 6, NULL, '100', '2023-08-12', NULL, NULL, NULL, '2023-08-12 13:41:07', '2023-08-12 13:41:07');

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

--
-- Table structure for table `payment_statuses`
--

CREATE TABLE `payment_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `payment_statuses`
--

INSERT INTO `payment_statuses` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'تحصيل', NULL, NULL),
(2, 'غرامة', NULL, NULL);

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

--
-- Table structure for table `payment_types`
--

CREATE TABLE `payment_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `regular_rent_payment` int(11) NOT NULL,
  `payment_after` int(11) 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 `payment_types`
--

INSERT INTO `payment_types` (`id`, `name`, `regular_rent_payment`, `payment_after`, `created_at`, `updated_at`) VALUES
(1, 'شهري', 1, 30, NULL, NULL),
(2, 'ربع سنوي', 3, 90, NULL, NULL),
(3, 'نص سنوي', 6, 180, NULL, NULL),
(4, 'سنوي', 12, 360, NULL, NULL);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` varchar(200) COLLATE utf8mb4_unicode_ci 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 `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `parent`, `created_at`, `updated_at`) VALUES
(1, 'إضافة مستخدم', 'المستخدمين', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(2, 'إضافة دور', 'الادوار', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(3, 'عرض المستخدمين', 'المستخدمين', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(4, 'عرض الادوار', 'الادوار', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(5, 'تعديل مستخدم', 'المستخدمين', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(6, 'تعديل دور', 'الادوار', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(7, 'حذف مستخدم', 'المستخدمين', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(8, 'حذف دور', 'الادوار', '2023-08-01 09:26:46', '2023-08-01 09:26:46'),
(9, 'عرض الملاك', 'المُلاك', NULL, NULL),
(10, 'إضافة مالك', 'المُلاك', NULL, NULL),
(11, 'تعديل مالك', 'المُلاك', NULL, NULL),
(12, 'حذف مالك', 'المُلاك', NULL, NULL),
(13, 'عرض العقارات', 'العقارات', NULL, NULL),
(14, 'إضافة عقار', 'العقارات', NULL, NULL),
(15, 'تعديل عقار', 'العقارات', NULL, NULL),
(16, 'حذف عقار', 'العقارات', NULL, NULL),
(17, 'عرض المشرفين', 'المشرفين', NULL, NULL),
(18, 'إضافة مشرف', 'المشرفين', NULL, NULL),
(19, 'تعديل مشرف', 'المشرفين', NULL, NULL),
(20, 'حذف مشرف', 'المشرفين', NULL, NULL),
(21, 'عرض المستأجرين', 'المستأجرين', NULL, NULL),
(22, 'إضافة مستاجر', 'المستأجرين', NULL, NULL),
(23, 'تعديل مستاجر', 'المستأجرين', NULL, NULL),
(24, 'حذف مستاجر', 'المستأجرين', NULL, NULL),
(25, 'عرض العقود', 'العقود', NULL, NULL),
(26, 'إضافة عقد', 'العقود', NULL, NULL),
(27, 'تعديل عقد', 'العقود', NULL, NULL),
(28, 'حذف عقد', 'العقود', NULL, NULL),
(29, 'عرض التحصيل', 'التحصيل', NULL, NULL),
(30, 'إضافة تحصيل', 'التحصيل', NULL, NULL),
(31, 'تعديل تحصيل', 'التحصيل', NULL, NULL),
(32, 'حذف تحصيل', 'التحصيل', NULL, NULL),
(33, 'عرض التقارير', 'التقارير', NULL, NULL),
(34, 'عرض الانواع', 'أنواع العقارات', NULL, NULL),
(35, 'إضافة نوع', 'أنواع العقارات', NULL, NULL),
(36, 'تعديل نوع', 'أنواع العقارات', NULL, NULL),
(37, 'حذف نوع', 'أنواع العقارات', NULL, NULL),
(38, 'عرض الجنسيات', 'الجنسيات', NULL, NULL),
(39, 'إضافة جنسية', 'الجنسيات', NULL, NULL),
(40, 'تعديل جنسية', 'الجنسيات', NULL, NULL),
(41, 'حذف جنسية', 'الجنسيات', NULL, NULL),
(42, 'عرض المناطق', 'المناطق', NULL, NULL),
(43, 'إضافة منطقة', 'المناطق', NULL, NULL),
(44, 'تعديل منطقة', 'المناطق', NULL, NULL),
(45, 'حذف منطقة', 'المناطق', NULL, NULL),
(46, 'عرض المحافظات', 'المحافظات', NULL, NULL),
(47, 'إضافة محافظة', 'المحافظات', NULL, NULL),
(48, 'تعديل محافظة', 'المحافظات', NULL, NULL),
(49, 'حذف محافظة', 'المحافظات', NULL, NULL),
(50, 'عرض الاحياء', 'الأحياء', NULL, NULL),
(51, 'إضافة حي', 'الأحياء', NULL, NULL),
(52, 'تعديل حي', 'الأحياء', NULL, NULL),
(53, 'حذف حي', 'الأحياء', NULL, NULL),
(54, 'عرض البنوك', 'البنوك', NULL, NULL),
(55, 'إضافة بنك', 'البنوك', NULL, NULL),
(56, 'تعديل بنك', 'البنوك', NULL, NULL),
(57, 'حذف بنك', 'البنوك', NULL, NULL),
(58, 'عرض انواع الصيانه', 'أنواع الصيانة', NULL, NULL),
(59, 'إضافة نوع صيانة', 'أنواع الصيانة', NULL, NULL),
(60, 'تعديل نوع صيانة', 'أنواع الصيانة', NULL, NULL),
(61, 'حذف نوع صيانة', 'أنواع الصيانة', NULL, NULL),
(62, 'عرض الوحدات', 'أنواع الوحدات العقارية', NULL, NULL),
(63, 'إضافة وحدة', 'أنواع الوحدات العقارية', NULL, NULL),
(64, 'تعديل وحدة', 'أنواع الوحدات العقارية', NULL, NULL),
(65, 'حذف وحدة', 'أنواع الوحدات العقارية', NULL, NULL),
(66, 'عرض الوحدات العقارية', 'الوحدات العقارية', NULL, NULL),
(67, 'إضافة وحدة عقارية', 'الوحدات العقارية', NULL, NULL),
(68, 'تعديل وحدة عقارية', 'الوحدات العقارية', NULL, NULL),
(69, 'حذف وحدة عقارية', 'الوحدات العقارية', NULL, NULL);

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_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 `permission_role`
--

INSERT INTO `permission_role` (`id`, `role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
(9, 1, 1, NULL, NULL),
(10, 1, 3, NULL, NULL),
(11, 1, 5, NULL, NULL),
(12, 1, 7, NULL, NULL),
(13, 1, 2, NULL, NULL),
(14, 1, 4, NULL, NULL),
(15, 1, 6, NULL, NULL),
(16, 1, 8, NULL, NULL),
(17, 1, 9, NULL, NULL),
(18, 1, 10, NULL, NULL),
(19, 1, 11, NULL, NULL),
(20, 1, 12, NULL, NULL),
(21, 1, 13, NULL, NULL),
(22, 1, 14, NULL, NULL),
(23, 1, 15, NULL, NULL),
(24, 1, 16, NULL, NULL),
(25, 1, 17, NULL, NULL),
(26, 1, 18, NULL, NULL),
(27, 1, 19, NULL, NULL),
(28, 1, 20, NULL, NULL),
(29, 1, 21, NULL, NULL),
(30, 1, 22, NULL, NULL),
(31, 1, 23, NULL, NULL),
(32, 1, 24, NULL, NULL),
(33, 1, 25, NULL, NULL),
(34, 1, 26, NULL, NULL),
(35, 1, 27, NULL, NULL),
(36, 1, 28, NULL, NULL),
(37, 1, 29, NULL, NULL),
(38, 1, 30, NULL, NULL),
(39, 1, 31, NULL, NULL),
(40, 1, 32, NULL, NULL),
(41, 1, 33, NULL, NULL),
(42, 1, 34, NULL, NULL),
(43, 1, 35, NULL, NULL),
(44, 1, 36, NULL, NULL),
(45, 1, 37, NULL, NULL),
(46, 1, 38, NULL, NULL),
(47, 1, 39, NULL, NULL),
(48, 1, 40, NULL, NULL),
(49, 1, 41, NULL, NULL),
(50, 1, 42, NULL, NULL),
(51, 1, 43, NULL, NULL),
(52, 1, 44, NULL, NULL),
(53, 1, 45, NULL, NULL),
(54, 1, 46, NULL, NULL),
(55, 1, 47, NULL, NULL),
(56, 1, 48, NULL, NULL),
(57, 1, 49, NULL, NULL),
(58, 1, 50, NULL, NULL),
(59, 1, 51, NULL, NULL),
(60, 1, 52, NULL, NULL),
(61, 1, 53, NULL, NULL),
(62, 1, 54, NULL, NULL),
(63, 1, 55, NULL, NULL),
(64, 1, 56, NULL, NULL),
(65, 1, 57, NULL, NULL),
(66, 1, 58, NULL, NULL),
(67, 1, 59, NULL, NULL),
(68, 1, 60, NULL, NULL),
(69, 1, 61, NULL, NULL),
(70, 1, 62, NULL, NULL),
(71, 1, 63, NULL, NULL),
(72, 1, 64, NULL, NULL),
(73, 1, 65, NULL, NULL),
(74, 2, 21, NULL, NULL),
(75, 2, 22, NULL, NULL),
(76, 2, 23, NULL, NULL),
(77, 2, 24, NULL, NULL),
(78, 2, 9, NULL, NULL),
(79, 2, 10, NULL, NULL),
(80, 2, 11, NULL, NULL),
(81, 2, 12, NULL, NULL),
(82, 2, 42, NULL, NULL),
(83, 2, 43, NULL, NULL),
(84, 2, 44, NULL, NULL),
(85, 2, 45, NULL, NULL),
(86, 2, 46, NULL, NULL),
(87, 2, 47, NULL, NULL),
(88, 2, 48, NULL, NULL),
(89, 2, 49, NULL, NULL),
(90, 2, 50, NULL, NULL),
(91, 2, 51, NULL, NULL),
(92, 2, 52, NULL, NULL),
(93, 2, 53, NULL, NULL),
(94, 1, 66, NULL, NULL),
(95, 1, 67, NULL, NULL),
(96, 1, 68, NULL, NULL),
(97, 1, 69, NULL, NULL);

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

--
-- Table structure for table `real_estates`
--

CREATE TABLE `real_estates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `real_estate_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flowers_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `real_estate_unit_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `instrument_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instrument_date` date DEFAULT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agency_date` date DEFAULT NULL,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_service_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `water_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `virtual_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operating_ratio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `real_estates`
--

INSERT INTO `real_estates` (`id`, `name`, `real_estate_type_id`, `number`, `flowers_number`, `real_estate_unit_number`, `owner_id`, `instrument_number`, `instrument_date`, `agent`, `agent_number`, `agency_date`, `district_id`, `address`, `national_address`, `address_link`, `electricity_account_number`, `electricity_service_number`, `water_account_number`, `virtual_value`, `operating_ratio`, `notes`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'اختبار3', 2, '5432456', '5', '5', 1, '65949', '2023-08-03', 'وكيل1', '8956458', '2023-08-03', 1, 'ombda', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '7857857', '7857856785', '7578578', '1200', '50', NULL, 'Super Admin', '2023-08-06 10:01:31', '2023-08-03 17:52:12', '2023-08-06 10:01:31'),
(2, 'عقار 1', 2, '5432456', '5', '5', 1, '65949', '2023-08-03', 'وكيل1', '8956458', '2023-08-03', 1, 'ombda', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '7857857', '7857856785', '7578578', '1200', '50', NULL, NULL, NULL, '2023-08-03 17:54:49', '2023-08-07 11:27:17'),
(3, 'اختبار3', 2, '5432456', '5', '5', 1, '65949', '2023-08-03', 'وكيل1', '8956458', '2023-08-03', 1, 'ombda', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '7857857', '7857856785', '7578578', '1200', '50', NULL, 'Super Admin', '2023-08-04 12:58:50', '2023-08-03 17:56:07', '2023-08-04 12:58:50'),
(4, 'عقار2', 3, '8954894', '3', '3', 2, '53453', '2023-08-04', 'وكيل2', '5903485034', '2023-08-04', 1, 'jeddah', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '34543534534', '355434324523', '43243243242', '130000', '40', NULL, NULL, NULL, '2023-08-04 12:46:24', '2023-08-04 12:46:24'),
(5, 'عقار2', 3, '8954894', '3', '3', 2, '53453', '2023-08-04', 'وكيل2', '5903485034', '2023-08-04', 1, 'jeddah', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '34543534534', '355434324523', '43243243242', '130000', '40', NULL, 'Super Admin', '2023-08-06 10:01:42', '2023-08-04 12:48:29', '2023-08-06 10:01:42'),
(6, 'عقار2', 3, '8954894', '3', '3', 2, '53453', '2023-08-04', 'وكيل2', '5903485034', '2023-08-04', 1, 'jeddah', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '34543534534', '355434324523', '43243243242', '130000', '40', NULL, 'Super Admin', '2023-08-06 10:01:36', '2023-08-04 12:48:46', '2023-08-06 10:01:36'),
(7, 'عقار 3', 3, '111111111111', '3', '3', 2, '3333333', '2023-08-07', 'وكيل3', '33333333', '2023-08-07', 1, 'jeddah', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '33333333', '33333333333', '3333333', '1200', '22', NULL, NULL, NULL, '2023-08-07 11:28:30', '2023-08-07 11:28:30'),
(8, 'عقار 4', 2, '659598454', '4', '4', 3, '568598749', '2023-08-10', 'وكيل4', '241949889', '2023-08-10', 1, 'jeddah', '5494998', 'https://www.google.com/maps/place/%D9%83%D8%AA%D9%8A%D9%83%D8%AA+%7C+KTAYKIT%E2%80%AD/@21.3943573,39.310245,15z/data=!4m6!3m5!1s0x15c3cb38c76da477:0x784255a149c615a!8m2!3d21.399591!4d39.292507!16s%2Fg%2F11h5_vxlgf?entry=ttu', '444444', '444444', '444444', '1200', '4', NULL, NULL, NULL, '2023-08-10 16:48:18', '2023-08-10 16:48:18');

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

--
-- Table structure for table `real_estate_files`
--

CREATE TABLE `real_estate_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `real_estate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `real_estate_files`
--

INSERT INTO `real_estate_files` (`id`, `real_estate_id`, `file`, `file_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 3, 'attachment_file/RealEstates/RealEstates_files/File-273863_3904137467.png', 'File-273863_3904137467', NULL, '2023-08-04 12:58:50', '2023-08-03 17:56:07', '2023-08-04 12:58:50'),
(2, 3, 'attachment_file/RealEstates/RealEstates_files/File-273863_5546299211.png', 'File-273863_5546299211', NULL, '2023-08-04 12:58:50', '2023-08-03 17:56:07', '2023-08-04 12:58:50'),
(3, 4, 'attachment_file/RealEstates/RealEstates_files/File-715573_3982024786.png', 'File-715573_3982024786', NULL, NULL, '2023-08-04 12:46:24', '2023-08-04 12:46:24'),
(4, 4, 'attachment_file/RealEstates/RealEstates_files/File-715573_6037239013.jpeg', 'File-715573_6037239013', NULL, NULL, '2023-08-04 12:46:24', '2023-08-04 12:46:24'),
(5, 5, 'attachment_file/RealEstates/RealEstates_files/File-691642_9897122207.png', 'File-691642_9897122207', NULL, NULL, '2023-08-04 12:48:29', '2023-08-04 12:48:29'),
(6, 5, 'attachment_file/RealEstates/RealEstates_files/File-691642_9944249610.jpeg', 'File-691642_9944249610', NULL, NULL, '2023-08-04 12:48:29', '2023-08-04 12:48:29'),
(7, 6, 'attachment_file/RealEstates/RealEstates_files/File-316904_1049641250.png', 'File-316904_1049641250', NULL, NULL, '2023-08-04 12:48:46', '2023-08-04 12:48:46'),
(8, 6, 'attachment_file/RealEstates/RealEstates_files/File-316904_2828354478.jpeg', 'File-316904_2828354478', NULL, NULL, '2023-08-04 12:48:46', '2023-08-04 12:48:46');

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

--
-- Table structure for table `real_estate_images`
--

CREATE TABLE `real_estate_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `real_estate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `real_estate_images`
--

INSERT INTO `real_estate_images` (`id`, `real_estate_id`, `image`, `image_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 6, 'attachment_file/RealEstates/RealEstates_images/Image-976628_3562117744.png', 'Image-976628_3562117744', NULL, NULL, '2023-08-04 12:48:46', '2023-08-04 12:48:46'),
(2, 6, 'attachment_file/RealEstates/RealEstates_images/Image-976628_4557810440.png', 'Image-976628_4557810440', NULL, NULL, '2023-08-04 12:48:46', '2023-08-04 12:48:46');

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

--
-- Table structure for table `real_estate_types`
--

CREATE TABLE `real_estate_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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 `real_estate_types`
--

INSERT INTO `real_estate_types` (`id`, `name`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '111', NULL, '2023-08-02 14:51:13', '2023-08-02 14:51:24', '2023-08-02 14:51:24'),
(2, 'سكنية', NULL, '2023-08-03 14:51:12', '2023-08-03 14:51:12', NULL),
(3, 'تجارية', NULL, '2023-08-03 14:51:21', '2023-08-03 14:51:21', NULL),
(4, 'عوائل', NULL, '2023-08-03 14:51:29', '2023-08-03 14:51:29', NULL),
(5, 'rtfyrtyrty', NULL, '2023-08-04 08:23:05', '2023-08-04 08:23:18', '2023-08-04 08:23:18');

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

--
-- Table structure for table `real_estate_units`
--

CREATE TABLE `real_estate_units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `real_estate_id` bigint(20) UNSIGNED NOT NULL,
  `real_estate_type_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `lounges_count` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `room_count` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bathrooms_count` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `external_doors_count` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `floor` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `space` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `virtual_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `electricity_service_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `water_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `real_estate_units`
--

INSERT INTO `real_estate_units` (`id`, `name`, `real_estate_id`, `real_estate_type_id`, `unit_id`, `lounges_count`, `room_count`, `bathrooms_count`, `external_doors_count`, `floor`, `space`, `virtual_value`, `electricity_account_number`, `electricity_service_number`, `water_account_number`, `status`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'وحدة 1-1', 2, 2, 2, '1', '1', '1', '1', '1', '100 متر مربع', '1000', '111', NULL, '111', 1, NULL, NULL, '2023-08-12 08:14:22', '2023-08-12 08:43:54'),
(2, 'وحدة 1-2', 2, 2, 2, '2', '2', '2', '2', '2', '200 متر مربع', '2000', '222', NULL, '222', 1, NULL, NULL, '2023-08-12 08:15:04', '2023-08-12 08:43:54'),
(3, 'وحدة 1-3', 2, 2, 2, '3', '3', '3', '3', '3', '300 متر مربع', '3000', '333', NULL, '333', 1, NULL, NULL, '2023-08-12 08:15:39', '2023-08-12 10:07:42'),
(4, 'وحده 2-1', 4, 3, 1, '1', '1', '1', '1', '1', '100 متر مربع', '1000', '1111', NULL, '1111', 0, NULL, NULL, '2023-08-12 08:17:00', '2023-08-12 08:17:00'),
(5, 'وحده 2-2', 4, 2, 2, '2', '2', '2', '2', '2', '200 متر مربع', '200', '2222', NULL, '2222', 0, NULL, NULL, '2023-08-12 08:17:35', '2023-08-12 08:17:35'),
(6, 'وحدة 3-1', 7, 2, 2, '3', '3', '3', '3', '3', '300 متر مربع', '3000', '3333', NULL, '3333', 1, NULL, NULL, '2023-08-12 08:18:19', '2023-08-12 10:03:35');

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

--
-- Table structure for table `regions`
--

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

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `name`, `created_at`, `updated_at`, `deleted_by`, `deleted_at`) VALUES
(1, 'منطقة مكة المكرمة', '2023-08-02 14:22:01', '2023-08-02 14:22:01', NULL, NULL),
(2, '44', '2023-08-02 14:52:19', '2023-08-02 14:52:34', 'Super Admin', '2023-08-02 14:52:34'),
(3, '458625698', '2023-08-04 11:05:42', '2023-08-04 11:09:26', 'Super Admin', '2023-08-04 11:09:26');

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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, 'المشرف العام للنظام', '2023-08-02 10:03:01', '2023-08-02 10:03:01'),
(2, 'ادخال مستاجرين', '2023-08-02 12:19:45', '2023-08-02 12:19:45');

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

--
-- Table structure for table `supervisors`
--

CREATE TABLE `supervisors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supervisors`
--

INSERT INTO `supervisors` (`id`, `name`, `phone`, `identity_number`, `identity_type`, `email`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'مشرف 1', '0555739937', '12345678', '2', 'g@g.g', NULL, NULL, '2023-08-07 10:13:52', '2023-08-07 11:11:18'),
(2, 'مشرف 2', '9874346832482', '8748374347834', '2', 's@s.s', NULL, NULL, '2023-08-07 13:06:55', '2023-08-07 13:06:55'),
(3, 'مشرف 3', '0510586472', '56765765765', '2', 't@t.t', NULL, NULL, '2023-08-08 15:15:02', '2023-08-08 15:15:02');

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

--
-- Table structure for table `supervisor_real_estates`
--

CREATE TABLE `supervisor_real_estates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `real_estate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supervisor_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 `supervisor_real_estates`
--

INSERT INTO `supervisor_real_estates` (`id`, `real_estate_id`, `supervisor_id`, `created_at`, `updated_at`) VALUES
(7, 4, 2, '2023-08-07 13:40:39', '2023-08-07 13:40:39'),
(8, 2, 1, '2023-08-07 13:41:11', '2023-08-07 13:41:11'),
(9, 7, 2, '2023-08-08 15:17:17', '2023-08-08 15:17:17');

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

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nationalty_id` bigint(20) UNSIGNED DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` (`id`, `name`, `district_id`, `nationalty_id`, `phone`, `email`, `identity_number`, `identity_type`, `address`, `notes`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'مستاجر 1', 1, 2, '2345678', 'g@g.g', '23456787654', '2', 'jeddah', NULL, NULL, NULL, '2023-08-08 09:51:08', '2023-08-08 09:51:08'),
(2, 'مستاجر 2', 1, 3, '4444444444444', 's@ks.a', '444444444', '2', '44444444444', NULL, NULL, NULL, '2023-08-08 14:46:48', '2023-08-08 14:46:48'),
(3, 'مستاجر 4', 1, 2, '0514587895', 'r@r.r', '2536897485', '2', 'ombda', NULL, NULL, NULL, '2023-08-10 16:49:54', '2023-08-10 16:49:54'),
(4, 'مستاجر 3', 1, 3, '0532167904', 'admin@admin.com3', '25689748659', '2', 'ombda', NULL, NULL, NULL, '2023-08-10 16:50:45', '2023-08-10 16:50:45');

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

--
-- Table structure for table `type_of_maintenances`
--

CREATE TABLE `type_of_maintenances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_of_maintenances`
--

INSERT INTO `type_of_maintenances` (`id`, `name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'كهرباء', NULL, NULL, '2023-08-02 12:43:32', '2023-08-02 12:49:32'),
(2, 'test222', NULL, '2023-08-02 12:44:48', '2023-08-02 12:44:00', '2023-08-02 12:44:48'),
(3, 'test', NULL, '2023-08-02 12:45:21', '2023-08-02 12:45:16', '2023-08-02 12:45:21'),
(4, 'ali', 'Super Admin', '2023-08-02 12:47:03', '2023-08-02 12:46:58', '2023-08-02 12:47:03'),
(5, 'سباكة', NULL, NULL, '2023-08-02 12:49:39', '2023-08-02 12:49:49'),
(6, 'بناء', NULL, NULL, '2023-08-02 12:50:03', '2023-08-04 11:19:35'),
(7, 'اختبار3', 'Super Admin', '2023-08-02 12:50:39', '2023-08-02 12:50:35', '2023-08-02 12:50:39'),
(8, 'اختبار32', 'Super Admin', '2023-08-02 14:55:52', '2023-08-02 14:55:40', '2023-08-02 14:55:52');

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

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`id`, `name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'تجاري', NULL, NULL, '2023-08-02 13:06:26', '2023-08-03 13:42:57'),
(2, 'سكني', NULL, NULL, '2023-08-02 13:06:30', '2023-08-03 13:42:47'),
(3, '44', 'Super Admin', '2023-08-02 13:06:45', '2023-08-02 13:06:35', '2023-08-02 13:06:45'),
(4, 'اختبار31', 'Super Admin', '2023-08-02 14:57:01', '2023-08-02 14:56:47', '2023-08-02 14:57:01'),
(5, 'زراعي', NULL, NULL, '2023-08-03 13:43:18', '2023-08-04 11:19:17'),
(6, 'wwwwwwwwwwwwwwww', 'Super Admin', '2023-08-04 11:23:48', '2023-08-04 11:23:32', '2023-08-04 11:23:48');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

--
-- Indexes for table `admin_permission`
--
ALTER TABLE `admin_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_permission_admin_id_permission_id_unique` (`admin_id`,`permission_id`),
  ADD KEY `admin_permission_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `admin_role`
--
ALTER TABLE `admin_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_role_admin_id_foreign` (`admin_id`);

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

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

--
-- Indexes for table `contracts`
--
ALTER TABLE `contracts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `contracts_contract_number_unique` (`contract_number`),
  ADD KEY `contracts_payment_type_id_foreign` (`payment_type_id`),
  ADD KEY `contracts_real_estate_id_foreign` (`real_estate_id`),
  ADD KEY `contracts_tenant_id_foreign` (`tenant_id`);

--
-- Indexes for table `contract_real_estate_units`
--
ALTER TABLE `contract_real_estate_units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contract_real_estate_units_contract_id_foreign` (`contract_id`),
  ADD KEY `contract_real_estate_units_real_estate_unit_id_foreign` (`real_estate_unit_id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_city_id_foreign` (`city_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 `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

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

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

--
-- Indexes for table `owner_files`
--
ALTER TABLE `owner_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `owner_files_owner_id_foreign` (`owner_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_payment_status_id_foreign` (`payment_status_id`),
  ADD KEY `payments_contract_id_foreign` (`contract_id`);

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

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_name_index` (`name`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permission_role_role_id_permission_id_unique` (`role_id`,`permission_id`),
  ADD KEY `permission_role_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `real_estates`
--
ALTER TABLE `real_estates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `real_estates_real_estate_type_id_foreign` (`real_estate_type_id`),
  ADD KEY `real_estates_owner_id_foreign` (`owner_id`),
  ADD KEY `real_estates_district_id_foreign` (`district_id`);

--
-- Indexes for table `real_estate_files`
--
ALTER TABLE `real_estate_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `real_estate_files_real_estate_id_foreign` (`real_estate_id`);

--
-- Indexes for table `real_estate_images`
--
ALTER TABLE `real_estate_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `real_estate_images_real_estate_id_foreign` (`real_estate_id`);

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

--
-- Indexes for table `real_estate_units`
--
ALTER TABLE `real_estate_units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `real_estate_units_real_estate_id_foreign` (`real_estate_id`),
  ADD KEY `real_estate_units_real_estate_type_id_foreign` (`real_estate_type_id`),
  ADD KEY `real_estate_units_unit_id_foreign` (`unit_id`);

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `supervisors`
--
ALTER TABLE `supervisors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `supervisors_phone_unique` (`phone`),
  ADD UNIQUE KEY `supervisors_identity_number_unique` (`identity_number`),
  ADD UNIQUE KEY `supervisors_email_unique` (`email`);

--
-- Indexes for table `supervisor_real_estates`
--
ALTER TABLE `supervisor_real_estates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supervisor_real_estates_real_estate_id_foreign` (`real_estate_id`),
  ADD KEY `supervisor_real_estates_supervisor_id_foreign` (`supervisor_id`);

--
-- Indexes for table `tenants`
--
ALTER TABLE `tenants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tenants_phone_unique` (`phone`),
  ADD UNIQUE KEY `tenants_email_unique` (`email`),
  ADD UNIQUE KEY `tenants_identity_number_unique` (`identity_number`),
  ADD KEY `tenants_district_id_foreign` (`district_id`),
  ADD KEY `tenants_nationalty_id_foreign` (`nationalty_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_permission`
--
ALTER TABLE `admin_permission`
  ADD CONSTRAINT `admin_permission_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `admin_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `admin_role`
--
ALTER TABLE `admin_role`
  ADD CONSTRAINT `admin_role_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contracts`
--
ALTER TABLE `contracts`
  ADD CONSTRAINT `contracts_payment_type_id_foreign` FOREIGN KEY (`payment_type_id`) REFERENCES `payment_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contracts_real_estate_id_foreign` FOREIGN KEY (`real_estate_id`) REFERENCES `real_estates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contracts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contract_real_estate_units`
--
ALTER TABLE `contract_real_estate_units`
  ADD CONSTRAINT `contract_real_estate_units_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contract_real_estate_units_real_estate_unit_id_foreign` FOREIGN KEY (`real_estate_unit_id`) REFERENCES `real_estate_units` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `owner_files`
--
ALTER TABLE `owner_files`
  ADD CONSTRAINT `owner_files_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_payment_status_id_foreign` FOREIGN KEY (`payment_status_id`) REFERENCES `payment_statuses` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `real_estates`
--
ALTER TABLE `real_estates`
  ADD CONSTRAINT `real_estates_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `real_estates_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `real_estates_real_estate_type_id_foreign` FOREIGN KEY (`real_estate_type_id`) REFERENCES `real_estate_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `real_estate_files`
--
ALTER TABLE `real_estate_files`
  ADD CONSTRAINT `real_estate_files_real_estate_id_foreign` FOREIGN KEY (`real_estate_id`) REFERENCES `real_estates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `real_estate_images`
--
ALTER TABLE `real_estate_images`
  ADD CONSTRAINT `real_estate_images_real_estate_id_foreign` FOREIGN KEY (`real_estate_id`) REFERENCES `real_estates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `real_estate_units`
--
ALTER TABLE `real_estate_units`
  ADD CONSTRAINT `real_estate_units_real_estate_id_foreign` FOREIGN KEY (`real_estate_id`) REFERENCES `real_estates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `real_estate_units_real_estate_type_id_foreign` FOREIGN KEY (`real_estate_type_id`) REFERENCES `real_estate_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `real_estate_units_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `supervisor_real_estates`
--
ALTER TABLE `supervisor_real_estates`
  ADD CONSTRAINT `supervisor_real_estates_real_estate_id_foreign` FOREIGN KEY (`real_estate_id`) REFERENCES `real_estates` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supervisor_real_estates_supervisor_id_foreign` FOREIGN KEY (`supervisor_id`) REFERENCES `supervisors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tenants`
--
ALTER TABLE `tenants`
  ADD CONSTRAINT `tenants_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tenants_nationalty_id_foreign` FOREIGN KEY (`nationalty_id`) REFERENCES `nationalties` (`id`) ON DELETE CASCADE;
COMMIT;

