--
-- Host: localhost    Database: chinarhomes_db
-- ------------------------------------------------------


--
-- Current Database: `chinarhomes_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `chinarhomes_db` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `chinarhomes_db`;

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `for` enum('property','project') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'property' COMMENT 'Property or Project',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slider,HomeScreen,ProductListing',
  `slider_id` int DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `property_id` int DEFAULT NULL,
  `project_id` bigint unsigned DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `is_enable` tinyint(1) NOT NULL,
  `status` int NOT NULL COMMENT '0=approved,1=pending,2=rejected,3=expired',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `advertisements_project_id_foreign` (`project_id`),
  CONSTRAINT `advertisements_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` VALUES (3,33,'2025-08-17','2025-09-16','property','HomeScreen',NULL,NULL,NULL,18,NULL,8,1,3,'2025-08-17 01:52:38','2025-09-26 09:38:36',NULL),(4,56,'2025-09-10','2025-10-10','property','HomeScreen',NULL,NULL,NULL,25,NULL,5,1,0,'2025-09-10 12:25:48','2025-09-10 12:25:48',NULL),(5,56,'2025-09-14','2025-10-14','property','HomeScreen',NULL,NULL,NULL,26,NULL,5,1,0,'2025-09-14 02:10:14','2025-09-14 02:10:14',NULL),(6,56,'2025-09-14','2025-10-14','property','HomeScreen',NULL,NULL,NULL,24,NULL,5,1,0,'2025-09-14 02:14:57','2025-09-14 02:14:57',NULL),(7,37,'2025-09-14','2025-10-14','property','HomeScreen',NULL,NULL,NULL,19,NULL,8,1,0,'2025-09-14 02:35:49','2025-09-14 02:35:49',NULL),(8,56,'2025-09-14','2025-10-14','property','HomeScreen',NULL,NULL,NULL,27,NULL,5,1,0,'2025-09-14 05:12:59','2025-09-14 05:12:59',NULL),(9,56,'2025-09-23','2025-10-23','property','HomeScreen',NULL,NULL,NULL,28,NULL,5,1,0,'2025-09-23 02:35:13','2025-09-23 02:35:13',NULL),(10,56,'2025-10-05','2025-11-04','property','HomeScreen',NULL,NULL,NULL,31,NULL,8,1,0,'2025-10-05 07:30:25','2025-10-05 07:30:25',NULL),(11,56,'2025-10-05','2025-11-04','property','HomeScreen',NULL,NULL,NULL,32,NULL,8,1,0,'2025-10-05 11:15:03','2025-10-05 11:15:03',NULL),(12,56,'2025-10-05','2025-11-04','property','HomeScreen',NULL,NULL,NULL,29,NULL,8,1,0,'2025-10-05 11:34:49','2025-10-05 11:34:49',NULL);

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `slug_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `articles_slug_id_unique` (`slug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` VALUES (1,'owning a Piece of Paradise: Exploring Land and Homeownership in Kashmir','1752839322.7201.jpg','<h1 data-start=\"314\" data-end=\"916\">Nestled amidst the breathtaking landscapes of the Himalayas, Kashmir offers a unique blend of natural beauty and rich cultural heritage that makes owning land or a home here truly special. At Chinar Homes, we understand that real estate in Kashmir is not just about property&mdash;it&rsquo;s about embracing a lifestyle filled with serenity, tradition, and the promise of a peaceful retreat. Whether you are seeking a charming cottage overlooking pristine valleys or a sprawling plot to build your dream estate, Kashmir&rsquo;s real estate market presents opportunities that connect you deeply with nature and community.</h1>\r\n<p data-start=\"918\" data-end=\"1403\">Investing in land or houses in Kashmir through Chinar Homes means securing a future where comfort meets tranquility. Our expert team guides you through every step, ensuring your investment aligns with both your personal aspirations and the region&rsquo;s regulatory framework. As Kashmir continues to develop, owning property here is not only a wise nvestment but also a gateway to experiencing the unmatched beauty and cultural richness of one of the most picturesque regions in the world.</p>','2025-07-19 15:18:42','2025-07-19 15:18:42','4','owning-a-piece-of-paradise-exploring-land-and-homeownership-in-kashmir','Buy Land & Homes in Paradise | Chinar Homes','Discover the beauty and value of owning property in Kashmir with Chinar Homes.','Kashmir real estate, buy land in Kashmir, Kashmir property, homes in Kashmir, Chinar Homes, Kashmir plots, invest in Kashmir, Kashmiri houses',NULL),(2,'🏡 How to Upload Your Property on ChinarHomes.com Sell or Rent Your Home in Kashmir—Fast, Easy & Online Looking to sell or rent your property in Kashmir?','1755630330.5821.jpg','<p>🏡 How to Upload Your Property on ChinarHomes.com<br />Sell or Rent Your Home in Kashmir&mdash;Fast, Easy &amp; Online<br />Looking to sell or rent your property in Kashmir?</p>\r\n<p>ChinarHomes.com makes it simple to showcase your home, land, or apartment to thousands of potential buyers and renters&mdash;all from the comfort of your phone or laptop. Here\'s your quick, step-by-step guide to getting your listing live and attracting the right audience.</p>\r\n<p>1️⃣ Sign In or Create an Account<br />Start by visiting ChinarHomes.com.</p>\r\n<p>Click Login / Register in the top menu</p>\r\n<p>New users can sign up using their name, email, and phone number</p>\r\n<p>Verify your email or mobile number if prompted</p>\r\n<p>🔐 Tip: Use a strong password and keep your login info safe for future updates.</p>\r\n<p>2️⃣ Access the Listing Dashboard<br />Once logged in:</p>\r\n<p>Navigate to &ldquo;Upload Property&rdquo; or &ldquo;Add Property&rdquo;</p>\r\n<p>This opens the property submission form where you&rsquo;ll enter all the details</p>\r\n<p>🧭 Tip: Bookmark your dashboard for quick access next time.</p>\r\n<p>3️⃣ Fill in Property Details<br />Make your listing stand out with clear, honest information:</p>\r\n<p>Title: e.g., &ldquo;2BHK Apartment in Rajbagh with Balcony&rdquo;</p>\r\n<p>Type: Choose between Sell or Rent</p>\r\n<p>Category: House, Apartment, Land, Commercial</p>\r\n<p>Location: Include city, area, and nearby landmarks</p>\r\n<p>Price: Use realistic figures&mdash;avoid vague terms like &ldquo;negotiable&rdquo; unless truly flexible</p>\r\n<p>📌 Tip: Mention if the price includes furnishings or maintenance.</p>\r\n<p>4️⃣ Upload Photos &amp; Videos<br />Visuals are everything.</p>\r\n<p>Add high-resolution images of the exterior, interior, and neighborhood</p>\r\n<p>If possible, upload a short walk-through video</p>\r\n<p>Use natural daylight and clean angles to showcase the space</p>\r\n<p>📷 Tip: Highlight unique features like wooden ceilings, garden views, or modular kitchens.</p>\r\n<p>5️⃣ Add Extra Features<br />Give buyers or renters the full picture:</p>\r\n<p>Bedrooms, bathrooms, furnishing status</p>\r\n<p>Parking availability, garden, heating, water supply</p>\r\n<p>Nearby schools, hospitals, markets, or transport links</p>\r\n<p>🛠 Tip: Mention recent renovations or upgrades&mdash;it adds value.</p>\r\n<p>6️⃣ Review &amp; Publish<br />Before submitting:</p>\r\n<p>Double-check spelling, price, and contact info</p>\r\n<p>Click Submit / Publish</p>\r\n<p>Your listing will be reviewed by ChinarHomes before going live</p>\r\n<p>🚀 Tip: You&rsquo;ll receive a confirmation once your property is approved and visible to users.</p>\r\n<p>📣 Final Thoughts<br />ChinarHomes is Kashmir&rsquo;s first dedicated real estate platform&mdash;built to empower local sellers, agents, and homeowners. Whether you\'re listing a cozy 1BHK in downtown Srinagar or a sprawling villa in Nishat, this platform helps you reach the right audience fast.</p>\r\n<p>&nbsp;</p>\r\n<p>create of image of this<br />Visualizing property upload steps&hellip;</p>','2025-08-19 13:35:30','2025-08-19 13:35:30','0','chinarhomes','#Kashmir #KashmirRealEstate','#Kashmir #KashmirRealEstate #KashmirFirstRealEstateApp #ChinarHomes','#Kashmir #KashmirRealEstate #KashmirFirstRealEstateApp #ChinarHomes',NULL);

--
-- Table structure for table `assign_parameters`
--

CREATE TABLE `assign_parameters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `modal_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modal_id` bigint unsigned NOT NULL,
  `property_id` int NOT NULL,
  `parameter_id` int NOT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assign_parameters_modal_type_modal_id_index` (`modal_type`,`modal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assign_parameters`
--

INSERT INTO `assign_parameters` VALUES (4,'App\\Models\\Property',1,0,1,'null','2025-06-18 05:07:17','2025-06-18 05:07:17'),(5,'App\\Models\\Property',2,0,1,'hello','2025-06-18 07:29:30','2025-06-18 07:29:30'),(6,'App\\Models\\Property',12,0,3,'Spacious and well-lit commercial space ideal for a showroom, boutique, or retail outlet. Located in a high-footfall area with excellent visibility and easy access.','2025-07-31 05:24:01','2025-07-31 05:24:01'),(7,'App\\Models\\Property',12,0,6,'Ready To Move','2025-07-31 05:24:01','2025-07-31 05:24:01'),(8,'App\\Models\\Property',12,0,7,'Agent','2025-07-31 05:24:01','2025-07-31 05:24:01'),(9,'App\\Models\\Property',13,0,6,'Ready To Move','2025-07-31 07:07:59','2025-07-31 07:07:59'),(10,'App\\Models\\Property',14,0,7,'Owner','2025-08-13 10:44:54','2025-08-13 10:44:54'),(11,'App\\Models\\Property',15,0,3,'\"✨ Property Highlights:\\r\\n- 📍 Prime location: Just minutes from Central University of Kashmir, Nunner Campus\\r\\n- 🚪 1spacious rooms available\\r\\n- 🚿 Attached bathrooms in every room\\r\\n- 🔋 I','2025-08-16 16:54:29','2025-08-16 16:54:29'),(12,'App\\Models\\Property',15,0,6,'\"Ready To Move\"','2025-08-16 16:54:29','2025-08-16 16:54:29'),(13,'App\\Models\\Property',16,0,3,'\"\\\"Looking for comfortable accommodation near campus? We’ve got you covered!\\\\r\\\\n\\\\r\\\\n✨ Property Highlights:\\\\r\\\\n- 📍 Prime location: Just minutes from Central University of Kashmir, Nunner','2025-08-17 11:11:08','2025-08-17 11:11:08'),(14,'App\\Models\\Property',16,0,6,'\"Ready To Move\"','2025-08-17 11:11:08','2025-08-17 11:11:08'),(15,'App\\Models\\Property',17,0,3,'shool offers excellent visibility and foot traffic. Ideal for retail, pharmacy, tuition center, or fast food outlet.\r\n\r\n📍 Location: Main Highway, Nunner (near Evergreen High School)\r\n\r\n🏠 Size','2025-08-17 00:24:42','2025-08-17 00:24:42'),(16,'App\\Models\\Property',17,0,6,'Ready To Move','2025-08-17 00:24:42','2025-08-17 00:24:42'),(17,'App\\Models\\Property',17,0,7,'Owner','2025-08-17 00:24:42','2025-08-17 00:24:42'),(18,'App\\Models\\Property',18,0,3,'\"\\\"4 Fully-Furnished Rooms for Rent\\\\r\\\\n\\\\r\\\\nDiscover comfort, convenience, and connectivity in this beautifully maintained 4-room rental located near Central University of Kashmir, Nunner ','2025-08-17 12:42:53','2025-08-17 12:42:53'),(19,'App\\Models\\Property',18,0,4,'\"https://web.chinarhomes.com/images/parameter_img//\\\"https://web.chinarhomes.com/images/parameter_img//1755414773.0404.jpg\\\"\"','2025-08-17 12:42:53','2025-08-17 12:42:53'),(20,'App\\Models\\Property',18,0,6,'\"Ready To Move\"','2025-08-17 12:42:53','2025-08-17 12:42:53'),(21,'App\\Models\\Property',19,0,6,'Ready To Move','2025-08-17 02:27:58','2025-08-17 02:27:58'),(22,'App\\Models\\Property',19,0,7,'Owner','2025-08-17 02:27:58','2025-08-17 02:27:58'),(23,'App\\Models\\Property',20,0,3,'### 🌟 **Unique Selling Points**\r\n\r\n- 🛣️ **National Highway Frontage**  \r\n  Your shops are directly on the highway—maximum exposure to daily traffic, travelers, and locals. Perfect for brandin','2025-08-20 01:14:18','2025-08-20 01:14:18'),(24,'App\\Models\\Property',20,0,6,'Ready To Move','2025-08-20 01:14:18','2025-08-20 01:14:18'),(25,'App\\Models\\Property',20,0,7,'Owner','2025-08-20 01:14:18','2025-08-20 01:14:18'),(26,'App\\Models\\Property',21,0,3,'Cozy rooms\r\nBest for study purpose \r\nFamily like environment \r\nHighly secure','2025-08-24 04:52:15','2025-08-24 04:52:15'),(27,'App\\Models\\Property',21,0,4,'1756030935.8816.jpg','2025-08-24 04:52:15','2025-08-24 04:52:15'),(28,'App\\Models\\Property',21,0,6,'Ready To Move','2025-08-24 04:52:15','2025-08-24 04:52:15'),(29,'App\\Models\\Property',22,0,6,'Ready To Move','2025-08-26 02:52:32','2025-08-26 02:52:32'),(30,'App\\Models\\Property',22,0,7,'Owner','2025-08-26 02:52:32','2025-08-26 02:52:32'),(32,'App\\Models\\Property',24,0,3,'Prime Location: Near Islamia College in Srinagar—visibility and prestige baked in.\r\n\r\nMove-In Ready: No setup, no stress. That’s a huge win for startups and professionals.\r\n\r\nCustomizable Spa','2025-09-09 02:58:14','2025-09-09 02:58:14'),(33,'App\\Models\\Property',24,0,6,'Ready To Move','2025-09-09 02:58:14','2025-09-09 02:58:14'),(34,'App\\Models\\Property',24,0,7,'Agent','2025-09-09 02:58:14','2025-09-09 02:58:14'),(35,'App\\Models\\Property',25,0,3,'\"**versatility and location**—a rare combination in Srinagar’s real estate market. Here’s what gives it an edge:\\r\\n\\r\\n### ✨ Key Highlights\\r\\n\\r\\n- **Prime Location**: Situated in Friends C','2025-09-10 17:25:01','2025-09-10 17:25:01'),(36,'App\\Models\\Property',25,0,6,'\"Ready To Move\"','2025-09-10 17:25:01','2025-09-10 17:25:01'),(37,'App\\Models\\Property',26,0,3,'\"operty Highlights:\\r\\n✅ Prime location near District Hospital\\r\\n✅ Ideal for residential or investment purposes\\r\\n✅ Easy accessibility\"','2025-09-14 07:36:44','2025-09-14 07:36:44'),(38,'App\\Models\\Property',26,0,7,'\"Agent\"','2025-09-14 07:36:44','2025-09-14 07:36:44'),(39,'App\\Models\\Property',27,0,3,'New 3-Room House for Sale in Bathindi, Jammu  \r\n📍 Location: بٹھنڈی Bathindi, Jammu  \r\n📐 Size: 4 Marla  \r\n💰 Price: ₹45 Lakhs  \r\n📞 Contact: 8082036771\r\n\r\nStep into comfort and convenience with ','2025-09-14 05:12:50','2025-09-14 05:12:50'),(40,'App\\Models\\Property',27,0,6,'Ready To Move','2025-09-14 05:12:50','2025-09-14 05:12:50'),(41,'App\\Models\\Property',28,0,3,'🚶‍♂️ 5-minute access to Central University of Kashmir—perfect for students, staff, and visiting faculty\r\n\r\n🏠 Stylish multi-story design with Gothic windows and carved woodwork\r\n\r\n🌿 Private ga','2025-09-23 02:34:52','2025-09-23 02:34:52'),(42,'App\\Models\\Property',28,0,4,'1758614692.8191.png','2025-09-23 02:34:52','2025-09-23 02:34:52'),(43,'App\\Models\\Property',28,0,6,'Ready To Move','2025-09-23 02:34:52','2025-09-23 02:34:52'),(44,'App\\Models\\Property',29,0,3,'✅ Full Malki Ownership:*\r\n* No leasehold or shared rights—complete legal ownership for peace of mind.\r\n- **📍 VIP Location in Channi Jammu:** Situated in one of Jammu’s most prestigious and we','2025-09-28 11:29:40','2025-09-28 11:29:40'),(45,'App\\Models\\Property',29,0,4,'1759078780.8524.png','2025-09-28 11:29:40','2025-09-28 11:29:40'),(46,'App\\Models\\Property',29,0,7,'Agent','2025-09-28 11:29:40','2025-09-28 11:29:40'),(47,'App\\Models\\Property',30,0,3,'✅ Full Malki Ownership: No leasehold or shared rights—buyers get complete legal ownership.\r\n\r\n📍 Strategic Location: Just off the Jammu–Akhnoor Highway, offering smooth connectivity to the cit','2025-09-28 12:22:51','2025-09-28 12:22:51'),(48,'App\\Models\\Property',30,0,7,'Agent','2025-09-28 12:22:51','2025-09-28 12:22:51'),(49,'App\\Models\\Property',31,0,3,'This guest house in Firozpur Tangmarg isn’t just a place to stay—it’s an experience wrapped in Kashmiri warmth and mountain serenity. What sets it apart:\r\n\r\n🏡 Architectural Elegance: A striki','2025-10-05 07:29:59','2025-10-05 07:29:59'),(50,'App\\Models\\Property',31,0,4,'1759669199.7687.png','2025-10-05 07:29:59','2025-10-05 07:29:59'),(51,'App\\Models\\Property',31,0,6,'Ready To Move','2025-10-05 07:29:59','2025-10-05 07:29:59'),(52,'App\\Models\\Property',32,0,3,'This one-storey brick house offers the perfect blend of comfort, location, and value. Built on 8 Marla of prime land, it features a spacious layout, a lush garden, and private parking for up ','2025-10-05 07:45:34','2025-10-05 07:45:34'),(53,'App\\Models\\Property',32,0,4,'1759670134.6323.jpg','2025-10-05 07:45:34','2025-10-05 07:45:34'),(54,'App\\Models\\Property',32,0,6,'Ready To Move','2025-10-05 07:45:34','2025-10-05 07:45:34');

--
-- Table structure for table `assigned_outdoor_facilities`
--

CREATE TABLE `assigned_outdoor_facilities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` int NOT NULL,
  `facility_id` int NOT NULL,
  `distance` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assigned_outdoor_facilities`
--

INSERT INTO `assigned_outdoor_facilities` VALUES (48,17,2,1,'2025-08-17 00:24:42','2025-08-17 00:24:42'),(49,17,3,1,'2025-08-17 00:24:42','2025-08-17 00:24:42'),(50,17,4,3,'2025-08-17 00:24:42','2025-08-17 00:24:42'),(51,17,5,2,'2025-08-17 00:24:42','2025-08-17 00:24:42'),(52,17,6,0,'2025-08-17 00:24:42','2025-08-17 00:24:42'),(53,15,2,1,'2025-08-17 00:32:04','2025-08-17 00:32:04'),(54,15,3,2,'2025-08-17 00:32:04','2025-08-17 00:32:04'),(55,15,4,2,'2025-08-17 00:32:04','2025-08-17 00:32:04'),(56,15,5,2,'2025-08-17 00:32:04','2025-08-17 00:32:04'),(57,15,6,1,'2025-08-17 00:32:04','2025-08-17 00:32:04'),(58,16,2,1,'2025-08-17 00:35:53','2025-08-17 00:35:53'),(59,16,3,1,'2025-08-17 00:35:53','2025-08-17 00:35:53'),(60,16,4,1,'2025-08-17 00:35:53','2025-08-17 00:35:53'),(61,16,5,2,'2025-08-17 00:35:53','2025-08-17 00:35:53'),(62,16,6,0.5,'2025-08-17 00:35:53','2025-08-17 00:35:53'),(73,18,2,1,'2025-08-17 01:53:47','2025-08-17 01:53:47'),(74,18,3,2,'2025-08-17 01:53:47','2025-08-17 01:53:47'),(75,18,4,6,'2025-08-17 01:53:47','2025-08-17 01:53:47'),(76,18,5,2,'2025-08-17 01:53:47','2025-08-17 01:53:47'),(77,18,6,0,'2025-08-17 01:53:47','2025-08-17 01:53:47'),(78,19,2,1,'2025-08-17 02:27:58','2025-08-17 02:27:58'),(79,19,3,1,'2025-08-17 02:27:58','2025-08-17 02:27:58'),(80,19,4,6,'2025-08-17 02:27:58','2025-08-17 02:27:58'),(81,19,5,1,'2025-08-17 02:27:58','2025-08-17 02:27:58'),(82,19,6,0,'2025-08-17 02:27:58','2025-08-17 02:27:58'),(83,20,2,0,'2025-08-20 01:14:18','2025-08-20 01:14:18'),(84,20,3,2,'2025-08-20 01:14:18','2025-08-20 01:14:18'),(85,20,4,1,'2025-08-20 01:14:18','2025-08-20 01:14:18'),(86,20,5,1,'2025-08-20 01:14:18','2025-08-20 01:14:18'),(87,20,6,0,'2025-08-20 01:14:18','2025-08-20 01:14:18'),(88,21,2,1,'2025-08-24 04:52:15','2025-08-24 04:52:15'),(89,21,3,1,'2025-08-24 04:52:15','2025-08-24 04:52:15'),(90,21,4,1,'2025-08-24 04:52:15','2025-08-24 04:52:15'),(91,21,5,1,'2025-08-24 04:52:15','2025-08-24 04:52:15'),(92,21,6,1,'2025-08-24 04:52:15','2025-08-24 04:52:15'),(93,22,2,1,'2025-08-26 02:52:32','2025-08-26 02:52:32'),(94,22,3,2,'2025-08-26 02:52:32','2025-08-26 02:52:32'),(95,22,4,2,'2025-08-26 02:52:32','2025-08-26 02:52:32'),(96,22,5,1,'2025-08-26 02:52:32','2025-08-26 02:52:32'),(97,22,6,0,'2025-08-26 02:52:32','2025-08-26 02:52:32'),(103,24,2,1,'2025-09-09 02:58:14','2025-09-09 02:58:14'),(104,24,3,2,'2025-09-09 02:58:14','2025-09-09 02:58:14'),(105,24,4,2,'2025-09-09 02:58:14','2025-09-09 02:58:14'),(106,24,5,1,'2025-09-09 02:58:14','2025-09-09 02:58:14'),(107,24,6,1,'2025-09-09 02:58:14','2025-09-09 02:58:14'),(113,25,2,1,'2025-09-10 11:56:36','2025-09-10 11:56:36'),(114,25,3,2,'2025-09-10 11:56:36','2025-09-10 11:56:36'),(115,25,4,2,'2025-09-10 11:56:36','2025-09-10 11:56:36'),(116,25,5,1,'2025-09-10 11:56:36','2025-09-10 11:56:36'),(117,25,6,1,'2025-09-10 11:56:36','2025-09-10 11:56:36'),(123,26,2,1,'2025-09-14 02:13:30','2025-09-14 02:13:30'),(124,26,3,2,'2025-09-14 02:13:30','2025-09-14 02:13:30'),(125,26,4,1,'2025-09-14 02:13:30','2025-09-14 02:13:30'),(126,26,5,1,'2025-09-14 02:13:30','2025-09-14 02:13:30'),(127,26,6,1,'2025-09-14 02:13:30','2025-09-14 02:13:30'),(128,27,2,1,'2025-09-14 05:12:50','2025-09-14 05:12:50'),(129,27,3,2,'2025-09-14 05:12:50','2025-09-14 05:12:50'),(130,27,4,1,'2025-09-14 05:12:50','2025-09-14 05:12:50'),(131,27,5,2,'2025-09-14 05:12:50','2025-09-14 05:12:50'),(132,27,6,1,'2025-09-14 05:12:50','2025-09-14 05:12:50'),(133,28,2,1,'2025-09-23 02:34:52','2025-09-23 02:34:52'),(134,28,3,2,'2025-09-23 02:34:52','2025-09-23 02:34:52'),(135,28,4,2,'2025-09-23 02:34:52','2025-09-23 02:34:52'),(136,28,5,1,'2025-09-23 02:34:52','2025-09-23 02:34:52'),(137,28,6,1,'2025-09-23 02:34:52','2025-09-23 02:34:52'),(138,29,2,2,'2025-09-28 11:29:40','2025-09-28 11:29:40'),(139,29,3,2,'2025-09-28 11:29:40','2025-09-28 11:29:40'),(140,29,4,3,'2025-09-28 11:29:40','2025-09-28 11:29:40'),(141,29,5,1,'2025-09-28 11:29:40','2025-09-28 11:29:40'),(142,29,6,1,'2025-09-28 11:29:40','2025-09-28 11:29:40'),(143,30,2,1,'2025-09-28 12:22:51','2025-09-28 12:22:51'),(144,30,3,1,'2025-09-28 12:22:51','2025-09-28 12:22:51'),(145,30,4,2,'2025-09-28 12:22:51','2025-09-28 12:22:51'),(146,30,5,1,'2025-09-28 12:22:51','2025-09-28 12:22:51'),(147,30,6,1,'2025-09-28 12:22:51','2025-09-28 12:22:51'),(148,31,2,1,'2025-10-05 07:29:59','2025-10-05 07:29:59'),(149,31,3,2,'2025-10-05 07:29:59','2025-10-05 07:29:59'),(150,31,4,2,'2025-10-05 07:29:59','2025-10-05 07:29:59'),(151,31,5,1,'2025-10-05 07:29:59','2025-10-05 07:29:59'),(152,31,6,1,'2025-10-05 07:29:59','2025-10-05 07:29:59'),(153,32,2,1,'2025-10-05 07:45:34','2025-10-05 07:45:34'),(154,32,3,2,'2025-10-05 07:45:34','2025-10-05 07:45:34'),(155,32,4,2,'2025-10-05 07:45:34','2025-10-05 07:45:34'),(156,32,5,1,'2025-10-05 07:45:34','2025-10-05 07:45:34'),(157,32,6,1,'2025-10-05 07:45:34','2025-10-05 07:45:34');

--
-- Table structure for table `bank_receipt_files`
--

CREATE TABLE `bank_receipt_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_transaction_id` bigint unsigned NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bank_receipt_files_payment_transaction_id_foreign` (`payment_transaction_id`),
  CONSTRAINT `bank_receipt_files_payment_transaction_id_foreign` FOREIGN KEY (`payment_transaction_id`) REFERENCES `payment_transactions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_receipt_files`
--


--
-- Table structure for table `blocked_chat_users`
--

CREATE TABLE `blocked_chat_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `by_user_id` bigint unsigned DEFAULT NULL COMMENT 'Block by user',
  `by_admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Block by admin',
  `user_id` bigint unsigned DEFAULT NULL COMMENT 'Block to user',
  `admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Block to admin',
  `reason` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blocked_chat_users_by_user_id_foreign` (`by_user_id`),
  KEY `blocked_chat_users_user_id_foreign` (`user_id`),
  CONSTRAINT `blocked_chat_users_by_user_id_foreign` FOREIGN KEY (`by_user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blocked_chat_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blocked_chat_users`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parameter_types` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0:DeActive 1:Active',
  `sequence` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_id_unique` (`slug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Category1','1','1748343212.652.svg',0,0,'2025-05-27 05:23:32','2025-07-18 03:19:52','category1','this is category 1 from chinar homes','Residential Properties (Houses, Apartments, Villas)\r\n Residential Properties (Houses, Apartments, Villas)','category 1, chinar homes, sell, rent',NULL),(2,'Category2','2','1748343347.8836.svg',1,0,'2025-05-27 05:25:47','2025-08-24 13:15:50','category2','cateogry 2 of chinar homes','Residential Properties (Houses, Apartments, Villas) Residential Properties (Houses, Apartments, Villas) Residential Properties (Houses, Apartments, Villas)','chinar homes, sell, rent , and buy',NULL),(3,'land','3,4,7','1752124912.6896.svg',1,0,'2025-07-10 05:21:52','2025-07-10 05:22:44','land','Buy & Sell Land in Kashmir | ChinarHomes','Discover premium land for sale in Kashmir with ChinarHomes. Browse residential, agricultural & commercial plots. Buy, sell & invest in Kashmir real estate today.','land for sale in Kashmir,   buy land Kashmir,   sell land Kashmir,   Kashmir land plots,   residential land Kashmir,   agricultural land Kashmir,   commercial land Kashmir,   Kashmir land investment,   ChinarHomes land,   invest in Kashmir property,   affordable land Kashmir,   Kashmir real estate,   land parcels Kashmir,   property investment Kashmir',NULL),(4,'House','3,4,6','1752125257.4964.svg',1,0,'2025-07-10 05:27:37','2025-07-10 05:27:46','house','Buy, Sell & Rent Homes in Kashmir | ChinarHomes','ChinarHomes: Your one‑stop platform to buy, sell & rent homes in Kashmir. Explore premium listings, compare prices, and secure your dream property today!','buy homes Kashmir,   sell homes Kashmir,   rent homes Kashmir,   Kashmir house listings,   ChinarHomes homes,   residential properties Kashmir,   home investment Kashmir,   affordable homes Kashmir,   Kashmir real estate,   long-term home rentals Kashmir,   quick home sales Kashmir',NULL),(5,'Flats','3,4,6,7','1752125510.1147.svg',1,0,'2025-07-10 05:31:50','2025-07-10 05:32:00','flats','Buy, Sell & Rent Flats in Kashmir | ChinarHomes','ChinarHomes offers the best flats in Kashmir to buy, sell & rent. Explore affordable apartments, luxury flats & short‑term rentals. Find your perfect home today!','buy flats Kashmir,   sell flats Kashmir,   rent flats Kashmir,   Kashmir apartments,   ChinarHomes flats,   residential flats Kashmir,   affordable flats Kashmir,   luxury flats Kashmir,   apartment listings Kashmir,   invest in Kashmir property,   long-term apartment rentals Kashmir,   short-term apartment rentals Kashmir,   Kashmir real estate,   flat investment Kashmir',NULL),(6,'shops','3,4,6,7','1753958307.4008.svg',1,0,'2025-07-31 05:08:27','2025-07-31 05:09:12','shops','Buy, Sell & Rent shops in Kashmir | ChinarHomes','get best shops in kashmir','Kashmir real estate, buy land in Kashmir, Kashmir property, homes in Kashmir, Chinar Homes, Kashmir plots, invest in Kashmir, Kashmiri houses',NULL);

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `property_id` int NOT NULL,
  `message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'by receiver',
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chats`
--

INSERT INTO `chats` VALUES (12,0,27,15,'hii',0,'',NULL,'2025-08-16 11:41:35','2025-08-16 11:41:35'),(25,60,53,21,'hi',0,'','','2025-09-27 05:03:13','2025-09-27 05:03:13');

--
-- Table structure for table `city_images`
--

CREATE TABLE `city_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `city_images_city_unique` (`city`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `city_images`
--

INSERT INTO `city_images` VALUES (1,'Srinagar','1756031729.8667.png',1,'2025-06-20 03:29:30','2025-08-01 03:43:18',NULL),(2,'Anantnag','1756033866.9012.png',0,'2025-07-30 10:43:14','2025-09-23 05:34:29',NULL),(3,'Gulmarg','1756034229.0205.png',1,'2025-07-31 10:11:36','2025-07-31 10:11:36',NULL),(4,'Jammu','1756034449.362.png',1,'2025-07-31 15:46:12','2025-07-31 15:46:12',NULL),(5,'Badgam','1756033081.1437.png',1,'2025-07-31 15:53:45','2025-07-31 15:53:45',NULL),(6,'Nuner','1756032523.9364.png',1,'2025-08-13 21:44:54','2025-08-13 21:44:54',NULL),(7,'Ganderbal','1756030779.6963.png',1,'2025-08-19 21:54:29','2025-08-19 21:54:29',NULL),(9,'Akhoon Sahib in Hawal, Srinagar,','1757527615.7564.png',1,'2025-09-09 08:28:14','2025-09-09 08:28:14',NULL),(10,'Friends Colony Lane 10, Natipora, Srinagar','1757527557.9484.png',1,'2025-09-10 22:55:01','2025-09-10 22:55:01',NULL),(11,'Channi JAMMU','1759683022.1248.png',1,'2025-09-28 22:29:40','2025-09-28 22:29:40',NULL),(12,'AKHNOOR Jammu','1759680816.9539.png',1,'2025-09-28 23:22:51','2025-09-28 23:22:51',NULL),(13,'Firozpur Tangmarg Gulmarg','1759680046.1075.png',1,'2025-10-05 18:29:59','2025-10-05 18:29:59',NULL),(14,'BEMINA Srinagar','1759670865.3398.png',1,'2025-10-05 18:45:34','2025-10-05 18:45:34',NULL);

--
-- Table structure for table `contactrequests`
--

CREATE TABLE `contactrequests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contactrequests`
--

INSERT INTO `contactrequests` VALUES (1,'jasim','muzamil','webinvolve@webinvolve.com','mjhgbkgbk,gkhghkgbv','jmkhbkjgkjhgvhkjv','2025-06-14 07:12:00','2025-06-14 07:12:00'),(2,'Arjumand','wani','arjumand.wani22@gmail.com','yes','helo','2025-09-03 23:15:51','2025-09-03 23:15:51');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'What is Chinar Homes?','Chinar Homes is a trusted real estate platform based in Kashmir that helps users buy, sell, or rent residential and commercial properties. We connect property seekers with verified listings across Srinagar, Baramulla, Anantnag, and other regions in Jammu & Kashmir.',1,'2025-05-27 05:09:58','2025-05-27 05:09:58',NULL),(2,'How do I list my property on Chinar Homes?','Listing your property is simple. Just create an account, click on “Post Property,” and fill in the property details including location, photos, and pricing. Once submitted, our team will verify the listing before publishing it live.',1,'2025-05-27 05:10:37','2025-05-27 05:10:37',NULL),(3,'Can I rent a property through Chinar Homes?','Absolutely. Our platform features verified rental properties including houses, apartments, and commercial spaces across Kashmir. You can directly contact property owners or agents through the listing.',1,'2025-05-27 05:11:08','2025-05-27 05:11:08',NULL),(4,'How do I contact Chinar Homes for support?','You can visit our Contact Us page to reach our support team via phone, email, or the inquiry form. We’re happy to assist with any property-related questions.',1,'2025-05-27 05:11:40','2025-05-27 05:11:40',NULL);

--
-- Table structure for table `favourites`
--

CREATE TABLE `favourites` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `property_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favourites`
--

INSERT INTO `favourites` VALUES (7,1,3,'2025-07-31 00:43:28','2025-07-31 00:43:28'),(18,57,18,'2025-09-03 23:20:36','2025-09-03 23:20:36'),(20,43,24,'2025-09-10 13:10:31','2025-09-10 13:10:31'),(21,43,18,'2025-09-10 13:10:44','2025-09-10 13:10:44'),(22,43,25,'2025-09-10 13:10:45','2025-09-10 13:10:45'),(23,43,16,'2025-09-10 13:11:02','2025-09-10 13:11:02'),(24,43,14,'2025-09-10 13:11:25','2025-09-10 13:11:25'),(25,43,15,'2025-09-10 13:11:27','2025-09-10 13:11:27'),(26,43,17,'2025-09-10 13:11:29','2025-09-10 13:11:29'),(29,27,25,'2025-09-10 22:21:09','2025-09-10 22:21:09'),(30,60,25,'2025-09-11 23:05:38','2025-09-11 23:05:38'),(31,60,15,'2025-09-11 23:31:44','2025-09-11 23:31:44'),(32,60,16,'2025-09-11 23:31:45','2025-09-11 23:31:45'),(33,60,17,'2025-09-11 23:31:49','2025-09-11 23:31:49'),(39,10,18,'2025-09-12 01:34:19','2025-09-12 01:34:19'),(40,10,16,'2025-09-12 01:34:26','2025-09-12 01:34:26'),(41,60,19,'2025-09-14 00:08:56','2025-09-14 00:08:56'),(42,60,14,'2025-09-14 00:08:57','2025-09-14 00:08:57'),(43,105,18,'2025-09-24 08:17:08','2025-09-24 08:17:08'),(44,25,27,'2025-09-25 11:34:29','2025-09-25 11:34:29'),(45,60,18,'2025-09-27 05:02:55','2025-09-27 05:02:55');

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--

INSERT INTO `features` VALUES (1,'Property List',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL),(2,'Property Feature List',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL),(3,'Project List',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL),(4,'Project Feature List',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL),(5,'Mortgage Calculator Detail Access',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL),(6,'Premium Properties Access',1,'2025-05-24 05:41:07','2025-08-30 12:18:14',NULL),(7,'Project List Access',1,'2025-05-24 05:41:07','2025-05-24 05:41:07',NULL);

--
-- Table structure for table `homepage_sections`
--

CREATE TABLE `homepage_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `section_type` enum('agents_list_section','articles_section','categories_section','faqs_section','featured_properties_section','featured_projects_section','most_liked_properties_section','most_viewed_properties_section','nearby_properties_section','projects_section','premium_properties_section','user_recommendations_section','properties_by_cities_section') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `homepage_sections`
--

INSERT INTO `homepage_sections` VALUES (1,'Agents List','agents_list_section',1,2,'2025-05-25 03:41:07','2025-09-18 07:41:47'),(2,'Articles','articles_section',0,3,'2025-05-25 20:11:07','2025-09-18 07:41:47'),(3,'Categories','categories_section',1,1,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(4,'FAQs','faqs_section',0,4,'2025-05-25 09:11:07','2025-09-18 07:41:47'),(5,'Featured Properties','featured_properties_section',1,5,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(6,'Featured Projects','featured_projects_section',1,6,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(7,'Most Liked Properties','most_liked_properties_section',1,7,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(8,'Most Viewed Properties','most_viewed_properties_section',1,8,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(9,'Nearby Properties','nearby_properties_section',1,9,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(10,'Projects','projects_section',1,10,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(11,'Premium Properties','premium_properties_section',1,11,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(12,'User Recommendations','user_recommendations_section',1,12,'2025-05-24 05:41:07','2025-09-18 07:41:47'),(13,'Properties by Cities','properties_by_cities_section',1,13,'2025-05-24 05:41:07','2025-09-18 07:41:47');

--
-- Table structure for table `interested_users`
--

CREATE TABLE `interested_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-No,1-Yes',
  `property_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interested_users`
--

INSERT INTO `interested_users` VALUES (3,0,14,27,'2025-08-17 02:42:29','2025-08-17 02:42:29'),(4,0,20,25,'2025-08-21 21:24:10','2025-08-21 21:24:10'),(6,0,25,60,'2025-09-12 00:17:57','2025-09-12 00:17:57'),(7,0,24,60,'2025-09-12 03:44:49','2025-09-12 03:44:49'),(8,0,27,25,'2025-09-25 11:34:48','2025-09-25 11:34:48');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '1=>active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `rtl` tinyint(1) NOT NULL COMMENT '0=false,1=true',
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'English','en-new','en-new.json',1,NULL,NULL,NULL,0);

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2018_08_08_100000_create_telescope_entries_table',1),(2,'2019_12_14_000001_create_personal_access_tokens_table',1),(3,'2023_03_18_033231_create_users_table',1),(4,'2023_03_18_033352_create_password_resets_table',1),(5,'2023_03_18_033442_create_failed_jobs_table',1),(6,'2023_03_18_033634_create_categories_table',1),(7,'2023_03_18_033727_create_settings_table',1),(8,'2023_03_18_033816_create_customers_table',1),(9,'2023_03_18_033916_create_sliders_table',1),(10,'2023_03_18_034006_create_propertys_table',1),(11,'2023_03_18_034055_create_property_images_table',1),(12,'2023_03_18_034200_create_notification_table',1),(13,'2023_03_18_034245_create_parameters_table',1),(14,'2023_03_18_034321_create_favourites_table',1),(15,'2023_03_18_034420_create_assign_parameters_table',1),(16,'2023_03_18_034454_create_articles_table',1),(17,'2023_03_18_034735_create_packages_table',1),(18,'2023_03_18_034813_create_user_purchased_packages_table',1),(19,'2023_03_18_034855_create_languages_table',1),(20,'2023_03_18_034939_cretate_advertisements_table',1),(21,'2023_03_18_035027_create_interested_users_table',1),(22,'2023_03_18_035059_create_payments_table',1),(23,'2023_03_18_035130_create_chats_table',1),(24,'2023_04_07_054100_rename_file_column_in_languages_table',1),(25,'2023_04_07_055215_alter_table_propertys_change_latitude_latitude',1),(26,'2023_04_25_091951_alter_table_payments_change_amount',1),(27,'2023_04_26_060301_alter_tabele_propertys_change_price',1),(28,'2023_05_11_055149_add_rtl__to_languages_table',1),(29,'2023_06_13_100955_create_users_tokens_table',1),(30,'2023_06_28_104556_create_outdoor_facilities_table',1),(31,'2023_06_28_112848_create_assigned_outdoor_facilities_table',1),(32,'2023_07_04_085912_add_rentduration_to_propertys_table',1),(33,'2023_07_17_122324_create_report_reasons_table',1),(34,'2023_07_17_122354_create_user_reports_table',1),(35,'2023_08_02_130025_make_email_value_in_assign_parameters_table',1),(36,'2023_08_22_054625_add_category_to_article__table',1),(37,'2023_08_22_062456_create_user_interests_table',1),(38,'2023_11_07_081457_add_columns_to_customers',1),(39,'2023_11_17_052005_create_contactrequests_table',1),(40,'2023_11_23_042600_make_data_column_nullable_in_settings_table',1),(41,'2023_12_18_103036_add_column_to_categories_table',1),(42,'2023_12_18_103148_add_column_to_articles_table',1),(43,'2023_12_18_103226_add_column_to_propertys_table',1),(44,'2023_12_18_103514_change_datatype_to_settings_table',1),(45,'2024_01_02_053848_create_seo_settings_table',1),(46,'2024_01_02_054734_add_columns_to_propertys_table',1),(47,'2024_01_02_054837_add_columns_to_articles_table',1),(48,'2024_01_02_055754_add_columns_to_categories_table',1),(49,'2024_01_24_121526_make_message_column_nullable_in_chats_table',1),(50,'2024_02_07_124810_add_coumns_to_customers_table',1),(51,'2024_02_16_121015_add_coumns_to_packages_table',1),(52,'2024_02_26_055053_add_coumns_to_packages_table',1),(53,'2024_02_26_055535_add_coumns_to_user_purchased_packages_table',1),(54,'2024_02_26_061106_add_coumns_to_customers_table',1),(55,'2024_02_26_085212_add_coumns_to_propertys_table',1),(56,'2024_02_27_100246_create_projects_table',1),(57,'2024_02_27_101454_create_project_documents_table',1),(58,'2024_03_01_113401_create_project_plans_table',1),(59,'2024_03_20_095532_make_seo_columns_nullable',1),(60,'2024_03_28_070334_add_columns_to_projects_table',1),(61,'2024_04_19_084914_version_1.1.4',1),(62,'2024_05_25_054809_version_1.1.5',1),(63,'2024_06_07_085606_1_1_6_version',1),(64,'2024_08_08_053034_1_1_7_version',1),(65,'2024_09_08_084744_1_1_8_version',1),(66,'2024_09_26_112115_1_1_9_version',1),(67,'2024_11_12_114051_1_2_0_version',1),(68,'2024_12_10_102159_1_2_5_version',1),(69,'2025_01_07_062042_1_2_2_version',1),(70,'2025_02_14_054054_1_2_3_version',1),(71,'2025_04_13_121951_1_2_4_version',1);

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint NOT NULL COMMENT '0: General 1: Inquiry',
  `send_type` tinyint NOT NULL COMMENT '0: Selected 1: All 2:property',
  `customers_id` text COLLATE utf8mb4_unicode_ci,
  `propertys_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` VALUES (8,'Project Updated','Your Project Post Approved by Administrator ','',1,0,'13',NULL,'2025-07-31 05:51:28','2025-07-31 05:51:28'),(9,'Project Updated','Your Project Post Approved by Administrator ','',1,0,'13',NULL,'2025-07-31 05:52:12','2025-07-31 05:52:12'),(11,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'1',NULL,'2025-08-08 04:39:10','2025-08-08 04:39:10'),(12,'Property Inquiry Updated','Your Advertisement Request is Approved','',1,0,'13',2,'2025-08-08 07:06:15','2025-08-08 07:06:15'),(13,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'32',NULL,'2025-08-13 12:19:39','2025-08-13 12:19:39'),(14,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'33',NULL,'2025-08-16 08:09:54','2025-08-16 08:09:54'),(15,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'32',14,'2025-08-16 08:54:14','2025-08-16 08:54:14'),(16,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'33',NULL,'2025-08-16 09:45:57','2025-08-16 09:45:57'),(17,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'33',NULL,'2025-08-16 10:45:11','2025-08-16 10:45:11'),(18,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'27',NULL,'2025-08-16 11:07:54','2025-08-16 11:07:54'),(19,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'27',15,'2025-08-16 11:29:14','2025-08-16 11:29:14'),(20,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'27',NULL,'2025-08-16 11:41:02','2025-08-16 11:41:02'),(21,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'27',15,'2025-08-16 11:50:41','2025-08-16 11:50:41'),(22,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'36',NULL,'2025-08-16 23:52:27','2025-08-16 23:52:27'),(23,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'36',NULL,'2025-08-17 00:11:52','2025-08-17 00:11:52'),(24,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'36',16,'2025-08-17 00:13:01','2025-08-17 00:13:01'),(25,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'36',17,'2025-08-17 00:25:29','2025-08-17 00:25:29'),(26,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'27',15,'2025-08-17 00:28:23','2025-08-17 00:28:23'),(27,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'36',16,'2025-08-17 00:28:31','2025-08-17 00:28:31'),(28,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'36',17,'2025-08-17 00:36:31','2025-08-17 00:36:31'),(29,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'27',15,'2025-08-17 00:36:43','2025-08-17 00:36:43'),(30,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'36',16,'2025-08-17 00:36:50','2025-08-17 00:36:50'),(31,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'33',NULL,'2025-08-17 01:44:23','2025-08-17 01:44:23'),(32,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'33',18,'2025-08-17 01:48:22','2025-08-17 01:48:22'),(33,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'33',18,'2025-08-17 01:56:37','2025-08-17 01:56:37'),(34,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'37',NULL,'2025-08-17 02:12:18','2025-08-17 02:12:18'),(35,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'37',19,'2025-08-17 02:28:57','2025-08-17 02:28:57'),(36,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'33',18,'2025-08-17 02:31:21','2025-08-17 02:31:21'),(37,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'52',20,'2025-08-20 01:15:54','2025-08-20 01:15:54'),(38,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'52',NULL,'2025-08-20 01:23:07','2025-08-20 01:23:07'),(39,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'52',NULL,'2025-08-20 13:12:20','2025-08-20 13:12:20'),(40,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'52',20,'2025-08-20 13:14:50','2025-08-20 13:14:50'),(41,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'53',NULL,'2025-08-24 04:41:43','2025-08-24 04:41:43'),(42,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'53',NULL,'2025-08-24 04:45:49','2025-08-24 04:45:49'),(43,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'53',21,'2025-08-24 04:55:49','2025-08-24 04:55:49'),(44,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'52',20,'2025-08-24 04:57:00','2025-08-24 04:57:00'),(45,'Project Updated','Your Project Post Approved by Administrator ','',1,0,'13',NULL,'2025-08-24 05:51:17','2025-08-24 05:51:17'),(46,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'1',NULL,'2025-08-24 13:14:24','2025-08-24 13:14:24'),(47,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'54',NULL,'2025-08-26 02:29:52','2025-08-26 02:29:52'),(48,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'54',22,'2025-08-26 02:53:21','2025-08-26 02:53:21'),(49,'Project Updated','Your Project Post Approved by Administrator ','',1,0,'13',NULL,'2025-08-30 12:03:12','2025-08-30 12:03:12'),(50,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'58',NULL,'2025-09-07 09:38:05','2025-09-07 09:38:05'),(51,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'56',NULL,'2025-09-07 09:50:41','2025-09-07 09:50:41'),(52,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'60',NULL,'2025-09-08 23:39:08','2025-09-08 23:39:08'),(53,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'74',NULL,'2025-09-09 03:14:58','2025-09-09 03:14:58'),(54,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',25,'2025-09-10 11:57:54','2025-09-10 11:57:54'),(55,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'74',NULL,'2025-09-12 11:22:33','2025-09-12 11:22:33'),(56,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',26,'2025-09-14 02:14:30','2025-09-14 02:14:30'),(57,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',28,'2025-09-23 03:22:51','2025-09-23 03:22:51'),(58,'Agent Verification Request Updated','Your Agent Verification Request is Approved','',1,0,'60',NULL,'2025-09-26 07:51:21','2025-09-26 07:51:21'),(65,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',29,'2025-09-28 11:34:26','2025-09-28 11:34:26'),(66,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',30,'2025-09-28 12:23:34','2025-09-28 12:23:34'),(67,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',30,'2025-09-28 12:28:44','2025-09-28 12:28:44'),(68,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',32,'2025-10-05 07:46:33','2025-10-05 07:46:33'),(69,'Property Updated','Your Property Post Approved by Administrator ','',1,0,'56',31,'2025-10-05 07:46:44','2025-10-05 07:46:44'),(70,'Project Updated','Your Project Post Rejected by Administrator ','',1,0,'13',NULL,'2025-10-05 11:33:12','2025-10-05 11:33:12'),(71,'Project Updated','Your Project Post Rejected by Administrator ','',1,0,'60',NULL,'2025-10-05 11:33:31','2025-10-05 11:33:31');

--
-- Table structure for table `old_packages`
--

CREATE TABLE `old_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ios_product_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int NOT NULL COMMENT 'Months',
  `price` double NOT NULL,
  `status` int NOT NULL COMMENT '0:off,1:onn',
  `property_limit` int DEFAULT NULL,
  `advertisement_limit` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'product_listing/premium_user',
  PRIMARY KEY (`id`),
  UNIQUE KEY `packages_ios_product_id_unique` (`ios_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_packages`
--

INSERT INTO `old_packages` VALUES (1,NULL,'Trial Package',30,0,1,10,10,NULL,NULL,'');

--
-- Table structure for table `old_payments`
--

CREATE TABLE `old_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `payment_gateway` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1=success,2=fail',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_payments`
--


--
-- Table structure for table `old_user_purchased_packages`
--

CREATE TABLE `old_user_purchased_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `modal_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modal_id` bigint unsigned NOT NULL,
  `package_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `used_limit_for_property` int NOT NULL DEFAULT '0',
  `used_limit_for_advertisement` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `prop_status` tinyint(1) NOT NULL DEFAULT '1',
  `adv_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `user_purchased_packages_modal_type_modal_id_index` (`modal_type`,`modal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `old_user_purchased_packages`
--


--
-- Table structure for table `outdoor_facilities`
--

CREATE TABLE `outdoor_facilities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outdoor_facilities`
--

INSERT INTO `outdoor_facilities` VALUES (2,'Market','1752828991.8243.svg','2025-07-18 03:26:31','2025-07-18 03:26:31'),(3,'Gym','1752829142.6016.svg','2025-07-18 03:29:02','2025-07-18 03:29:02'),(4,'Hospital','1752829692.5921.svg','2025-07-18 03:38:12','2025-07-18 03:38:12'),(5,'Masjid','1752829796.2544.svg','2025-07-18 03:39:56','2025-07-18 03:39:56'),(6,'Main road','1752829907.1603.svg','2025-07-18 09:11:47','2025-07-18 09:11:47');

--
-- Table structure for table `package_features`
--

CREATE TABLE `package_features` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint unsigned NOT NULL,
  `feature_id` bigint unsigned NOT NULL,
  `limit_type` enum('limited','unlimited') COLLATE utf8mb4_unicode_ci NOT NULL,
  `limit` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_ids` (`package_id`,`feature_id`),
  KEY `package_features_feature_id_foreign` (`feature_id`),
  CONSTRAINT `package_features_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE,
  CONSTRAINT `package_features_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_features`
--

INSERT INTO `package_features` VALUES (1,1,1,'unlimited',NULL,'2025-06-18 07:21:05','2025-06-18 07:21:05',NULL),(2,2,1,'unlimited',NULL,'2025-06-18 07:24:22','2025-06-18 07:24:22',NULL),(3,2,5,'unlimited',NULL,'2025-06-18 07:24:22','2025-06-18 07:24:22',NULL),(4,2,2,'unlimited',NULL,'2025-06-18 07:24:22','2025-06-18 07:24:22',NULL),(5,3,1,'limited',1,'2025-07-21 05:49:17','2025-07-21 05:49:17',NULL),(6,3,2,'limited',5,'2025-07-21 05:49:17','2025-07-21 05:49:17',NULL),(7,3,5,'unlimited',NULL,'2025-07-21 05:49:17','2025-07-21 05:49:17',NULL),(8,4,1,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(9,4,2,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(10,4,3,'limited',3,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(11,4,4,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(12,4,5,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(13,4,6,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(14,4,7,'unlimited',NULL,'2025-07-21 05:54:42','2025-07-21 05:54:42',NULL),(15,5,1,'limited',2,'2025-07-21 05:58:55','2025-07-21 05:58:55',NULL),(16,5,2,'limited',5,'2025-07-21 05:58:55','2025-07-21 05:58:55',NULL),(17,5,5,'unlimited',NULL,'2025-07-21 05:58:55','2025-07-21 05:58:55',NULL),(18,6,1,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(19,6,2,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(20,6,3,'limited',3,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(21,6,4,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(22,6,5,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(23,6,6,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(24,6,7,'unlimited',NULL,'2025-07-21 06:00:15','2025-07-21 06:00:15',NULL),(25,7,1,'unlimited',NULL,'2025-07-31 04:26:45','2025-07-31 04:26:45',NULL),(26,7,2,'unlimited',NULL,'2025-07-31 04:26:45','2025-07-31 04:26:45',NULL),(27,7,3,'unlimited',NULL,'2025-07-31 04:26:45','2025-07-31 04:26:45',NULL),(28,8,1,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(29,8,2,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(30,8,3,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(31,8,4,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(32,8,5,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(33,8,6,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL),(34,8,7,'unlimited',NULL,'2025-07-31 04:27:52','2025-07-31 04:27:52',NULL);

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ios_product_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_type` enum('free','paid') COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(10,2) DEFAULT NULL,
  `duration` int NOT NULL COMMENT 'In Hours',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `packages_ios_product_id_unique` (`ios_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` VALUES (1,'test',NULL,'free',NULL,720,0,'2025-06-18 07:21:05','2025-07-21 05:58:06','2025-07-21 05:58:06'),(2,'test2',NULL,'paid',800.00,480,0,'2025-06-18 07:24:22','2025-07-21 05:58:02','2025-07-21 05:58:02'),(3,'Basic Plan (Free)',NULL,'free',NULL,720,1,'2025-07-21 05:49:17','2025-07-21 05:58:14','2025-07-21 05:58:14'),(4,'Premium Plan (Paid)',NULL,'paid',1500.00,720,1,'2025-07-21 05:54:42','2025-07-21 05:58:19','2025-07-21 05:58:19'),(5,'Basic Plan (Free)',NULL,'free',NULL,720,1,'2025-07-21 05:58:55','2025-08-30 12:32:04',NULL),(6,'Premium Plan (Paid)',NULL,'paid',500.00,720,1,'2025-07-21 06:00:15','2025-08-30 12:32:01',NULL),(7,'test',NULL,'free',NULL,720,0,'2025-07-31 04:26:45','2025-07-31 04:27:07','2025-07-31 04:27:07'),(8,'Free',NULL,'free',NULL,720,1,'2025-07-31 04:27:52','2025-08-30 12:31:58',NULL);

--
-- Table structure for table `packages_backup`
--

CREATE TABLE `packages_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint unsigned NOT NULL,
  `ios_product_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `packages_backup_package_id_foreign` (`package_id`),
  CONSTRAINT `packages_backup_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `old_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages_backup`
--


--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_of_parameter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_values` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` VALUES (1,'Facility 1','textbox',NULL,'1748343103.4383.svg',0,'2025-05-27 05:21:43','2025-05-27 05:21:43'),(2,'Facility 2','textbox',NULL,'1748343297.9357.svg',0,'2025-05-27 05:24:57','2025-05-27 05:24:57'),(3,'What makes your property special?','textarea',NULL,'1752835968.8004.svg',0,'2025-07-18 10:52:48','2025-07-18 10:52:48'),(4,'Property Brochure','file',NULL,'1752836235.18.svg',0,'2025-07-18 05:27:15','2025-07-18 05:27:15'),(5,'Extra Facilities','checkbox','{\"0\":\"Park\\/Garden\",\"1\":\"Pool\",\"2\":\"Main Road\",\"3\":\"Gym\",\"4\":\"Club\"}','1752836388.2501.svg',0,'2025-07-18 05:29:48','2025-07-18 05:29:48'),(6,'Construction Status','radiobutton','{\"0\":\"Ready To Move\",\"1\":\"Under Construction\",\"2\":\"New launch\"}','1752836729.8987.svg',0,'2025-07-18 05:35:29','2025-07-18 05:35:29'),(7,'List By','dropdown','{\"0\":\"Owner\",\"1\":\"Dealer\",\"2\":\"Agent\",\"3\":\"Broker\"}','1752837248.6714.svg',0,'2025-07-18 05:44:08','2025-07-18 05:44:08'),(8,'Furnishing','radiobutton','{\"0\":\"Furnished\",\"1\":\"Semi-Furnished\",\"2\":\"Unfurnished\"}','1752837414.568.svg',0,'2025-07-18 05:46:54','2025-07-18 05:46:54'),(9,'Carpet Area (ft2)','number',NULL,'1752837557.6287.svg',0,'2025-07-18 05:49:17','2025-07-18 05:49:17'),(10,'Build Area (ft2)','number',NULL,'1752837653.3536.svg',0,'2025-07-18 05:50:53','2025-07-18 05:50:53'),(11,'Layout - Number','number',NULL,'1752837822.548.svg',0,'2025-07-18 11:22:44','2025-07-18 11:22:44'),(12,'Colors included','textarea',NULL,'1752837867.6254.svg',0,'2025-07-18 05:54:27','2025-07-18 05:54:27'),(13,'Wifi','textbox',NULL,'1752837963.5395.svg',0,'2025-07-18 05:56:03','2025-07-18 05:56:03'),(14,'Elevator','number',NULL,'1752838053.747.svg',0,'2025-07-18 05:57:33','2025-07-18 05:57:33'),(15,'Center','number',NULL,'1752838240.4507.svg',0,'2025-07-18 06:00:40','2025-07-18 06:00:40');

--
-- Table structure for table `payment_transactions`
--

CREATE TABLE `payment_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL COMMENT 'Customers',
  `package_id` bigint unsigned NOT NULL,
  `amount` double(10,2) NOT NULL,
  `payment_gateway` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_type` enum('online payment','bank transfer','free') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Type of payment transaction',
  `reject_reason` text COLLATE utf8mb4_unicode_ci,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Payment Intent Id / Order Id',
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Success Transaction Id',
  `payment_status` enum('success','failed','pending','review','rejected') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniques` (`payment_gateway`,`order_id`,`transaction_id`,`user_id`),
  KEY `payment_transactions_user_id_foreign` (`user_id`),
  KEY `payment_transactions_package_id_foreign` (`package_id`),
  CONSTRAINT `payment_transactions_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payment_transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_transactions`
--

INSERT INTO `payment_transactions` VALUES (1,1,1,0.00,NULL,'free',NULL,'8b71e2dc-751f-426f-ab59-a96ce3a9fa1b','88ec4d85-7f4d-4c43-aff2-383126a99a53','success','2025-06-18 07:26:21','2025-06-18 07:26:21'),(4,11,1,0.00,NULL,'free',NULL,'1661a1c3-2e08-4051-94c6-fb556e100b87','73efb75c-f81a-4444-b595-a2a8c99a27b2','success','2025-07-05 04:24:17','2025-07-05 04:24:17'),(10,1,5,0.00,NULL,'free',NULL,'ecbce0a3-5c78-4de4-b872-b1d18d6dbe7f','ef3f0075-2e4e-4d60-8402-798ef3de8a9d','success','2025-07-29 07:10:38','2025-07-29 07:10:38'),(11,13,5,0.00,NULL,'free',NULL,'0e0c11cf-dc1e-4a0d-b0e5-8cf2d1a041c8','6f987f3b-eedc-448c-bbe6-c00ba7398542','success','2025-07-30 00:08:13','2025-07-30 00:08:13'),(15,13,8,0.00,NULL,'free',NULL,'4332c2e5-ed03-43af-a4d1-a92e73879808','076fd6ad-21f9-4467-aa36-871b6d0e296d','success','2025-07-31 04:28:48','2025-07-31 04:28:48'),(16,26,8,0.00,NULL,'free',NULL,'3fee5fbc-f09a-4086-b0f9-1547ab596820','3d8a5196-fc6e-4b9c-b9bd-f4b1580e5a12','success','2025-08-01 05:11:45','2025-08-01 05:11:45'),(17,1,8,0.00,NULL,'free',NULL,'ecefcb10-4605-4b83-9a24-f169230e1550','7f18bb14-ea56-4a64-95b8-77872cd55d59','success','2025-08-01 08:29:47','2025-08-01 08:29:47'),(19,11,8,0.00,NULL,'free',NULL,'b5e11d76-5bcb-492a-aa7b-557cb1fd591f','192eacd5-979b-4fd6-8663-2bd54fad6428','success','2025-08-07 05:43:47','2025-08-07 05:43:47'),(20,18,8,0.00,NULL,'free',NULL,'48bcf5d5-b66d-4258-8c2f-4da7482cc974','7cc4d240-8006-42a1-8f1f-0fa0a76dcf56','success','2025-08-08 05:01:00','2025-08-08 05:01:00'),(21,32,8,0.00,NULL,'free',NULL,'f1d4bb8e-bfcb-4dd4-86cc-b8a3097f253d','d1ae8425-276e-4b3e-b294-9a4cfc9a482d','success','2025-08-13 09:25:16','2025-08-13 09:25:16'),(22,33,8,0.00,NULL,'free',NULL,'7c048206-b376-4f01-a7c6-0f86ea0a494d','25697a34-3bf6-4575-881f-5e08c8be13a2','success','2025-08-16 08:08:53','2025-08-16 08:08:53'),(23,27,8,0.00,NULL,'free',NULL,'515b7fab-eb93-407d-82c0-1ee6d1cc30a4','bce81197-c7ec-49f3-bee3-e10e6173cc26','success','2025-08-16 11:08:23','2025-08-16 11:08:23'),(25,36,8,0.00,NULL,'free',NULL,'a7d6d4aa-b9ed-4fa2-aae2-ffb2d5fadc46','611e3e74-33d9-4d3b-96e4-f2e4774c7705','success','2025-08-16 23:53:17','2025-08-16 23:53:17'),(26,37,8,0.00,NULL,'free',NULL,'033a4de2-f8c9-4b71-94ac-c63a1c729d64','8a0ad869-588d-4d26-8e97-676bc3a0e4c3','success','2025-08-17 02:12:56','2025-08-17 02:12:56'),(27,37,8,0.00,NULL,'free',NULL,'41fde936-04c3-495a-8ddf-cd1c69d0fa94','9edb0eba-ee9f-4729-9370-6489c34cbec7','success','2025-08-17 02:12:58','2025-08-17 02:12:58'),(28,51,8,0.00,NULL,'free',NULL,'f97ee61c-8deb-4899-8cb2-385eeb5de15f','42bfb599-688d-4147-813a-187a5340cab2','success','2025-08-19 11:14:20','2025-08-19 11:14:20'),(29,52,8,0.00,NULL,'free',NULL,'8fb356b5-385d-4d52-8022-78b1001fc50e','ef6138d3-dcde-4e2a-a391-c6aa772279bb','success','2025-08-20 00:58:44','2025-08-20 00:58:44'),(31,25,8,0.00,NULL,'free',NULL,'4cb3515b-8c3a-4ac1-be5d-f0c2be018336','ea13dcf4-3acd-45f8-ab63-f07fdd4569e2','success','2025-08-20 01:43:02','2025-08-20 01:43:02'),(32,10,8,0.00,NULL,'free',NULL,'76ac1460-fdcc-4729-816d-4baef692995f','390675fe-549e-4e16-8550-5b0e4ab95320','success','2025-08-21 06:22:41','2025-08-21 06:22:41'),(34,53,8,0.00,NULL,'free',NULL,'90eb3dec-c9d4-4ed8-8fa0-0adde5799fdd','dc7a63c1-34b9-450d-9003-0d667eae2c44','success','2025-08-24 04:22:06','2025-08-24 04:22:06'),(35,45,8,0.00,NULL,'free',NULL,'de51ae66-8a7f-44af-bb25-0963582fa2b4','a9bfdfe9-4400-4a04-b88c-b988b2e2ea7d','success','2025-08-25 01:51:34','2025-08-25 01:51:34'),(36,54,8,0.00,NULL,'free',NULL,'dedf49c4-db12-4856-bbd5-554edba9640e','e44084d8-313e-4efe-b8e3-fdbe4f0e8500','success','2025-08-26 02:30:11','2025-08-26 02:30:11'),(37,13,8,0.00,NULL,'free',NULL,'0801f529-4882-4ba7-aac9-9f299955b5cb','fba5e731-95d5-4ffb-92d0-935551c340ac','success','2025-08-30 21:50:05','2025-08-30 21:50:05'),(39,43,8,0.00,NULL,'free',NULL,'3d8133f3-1dcf-40e8-a89f-a24048f90b4a','a3e1f71a-fc34-4c6b-af34-f5dced84c5dd','success','2025-09-07 00:10:01','2025-09-07 00:10:01'),(40,43,8,0.00,NULL,'free',NULL,'70123a13-5c0f-4cd0-a179-efb7f96ae0d5','4b9cfc6a-6bf8-4dd1-860f-bbea74c5ddb9','success','2025-09-07 00:10:03','2025-09-07 00:10:03'),(41,58,5,0.00,NULL,'free',NULL,'f132e99e-8937-4836-8d71-425c69eca406','205b1fc9-e47f-4adc-8bd2-92139a405100','success','2025-09-07 07:38:00','2025-09-07 07:38:00'),(43,56,5,0.00,NULL,'free',NULL,'02508821-6c2b-4a80-ad0d-61d385433735','89af93ce-a4c5-421e-8d6e-301a225cafd4','success','2025-09-07 09:49:53','2025-09-07 09:49:53'),(44,56,8,0.00,NULL,'free',NULL,'d9bb3a70-3878-4486-8b92-7eeb338357ff','32e29be8-913b-4f1f-9792-59787cc87693','success','2025-09-09 02:27:38','2025-09-09 02:27:38'),(45,75,8,0.00,NULL,'free',NULL,'6a073a27-317f-4de6-90e2-bb073bad6265','c233295b-6b7f-4c39-b858-d20afc908d30','success','2025-09-09 03:21:20','2025-09-09 03:21:20'),(46,60,5,0.00,NULL,'free',NULL,'cb721205-8eea-4c48-82f1-5f09c49f77c7','5ce9b692-39a8-4701-81d2-f32d70a529c4','success','2025-09-10 00:26:32','2025-09-10 00:26:32'),(48,60,8,0.00,NULL,'free',NULL,'e525a41c-dd05-4fcc-bb1b-bc8ee4d35fe2','ebec010c-8a03-426e-811d-6aa5770ef03e','success','2025-09-11 00:30:26','2025-09-11 00:30:26'),(49,18,5,0.00,NULL,'free',NULL,'9e663145-2694-402f-9c23-c474c864f4f3','112820e8-3b1e-46fb-b3ad-800cb7b4bdcd','success','2025-09-11 01:04:25','2025-09-11 01:04:25'),(51,18,8,0.00,NULL,'free',NULL,'6a14b9fa-e5c6-4f85-9c10-4d0d72b5d022','bc8ccda4-4205-445c-9689-d3442bc1b87e','success','2025-09-11 01:10:58','2025-09-11 01:10:58'),(62,81,8,0.00,NULL,'free',NULL,'123c33ab-27eb-4479-a1c9-f6ca2e91218a','f849e11d-0e5e-47ef-a1a3-c28c831fe406','success','2025-09-14 04:02:19','2025-09-14 04:02:19'),(63,1,8,0.00,NULL,'free',NULL,'19caf36a-c089-44dd-b6b8-39431931bbc9','969f8a7d-7adf-4836-80bb-da8e2cb73a0d','success','2025-09-15 02:36:06','2025-09-15 02:36:06'),(64,95,8,0.00,NULL,'free',NULL,'610cca30-9d44-4e54-834b-81286868a517','84139fda-4dc1-4e89-8a3c-a1afe4bdb3af','success','2025-09-15 11:39:04','2025-09-15 11:39:04'),(65,105,5,0.00,NULL,'free',NULL,'01d3c383-bf19-4e14-9bed-f195137566ca','7233aa48-afb6-4087-aee7-533f234db26b','success','2025-09-22 05:19:48','2025-09-22 05:19:48'),(66,106,5,0.00,NULL,'free',NULL,'f877cf6a-a458-45d5-9813-d221b37481fa','8152774d-9182-43a5-8078-b8c565c07711','success','2025-09-23 02:59:10','2025-09-23 02:59:10'),(67,25,8,0.00,NULL,'free',NULL,'1fe8a9d9-d19b-436b-8ae3-f60d156428f0','1f095c99-1366-4825-b4b1-0b806ea01bfd','success','2025-09-25 11:33:02','2025-09-25 11:33:02'),(68,159,8,0.00,NULL,'free',NULL,'950b9317-4222-403a-8ee6-da7d6f331fa5','aac39eb8-cf5a-4c1d-becb-9f7395044290','success','2025-10-08 10:09:20','2025-10-08 10:09:20');

--
-- Table structure for table `project_documents`
--

CREATE TABLE `project_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'image/doc',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_documents_project_id_foreign` (`project_id`),
  CONSTRAINT `project_documents_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_documents`
--

INSERT INTO `project_documents` VALUES (2,'1757668944.3192.jpg','image','2025-09-12 03:52:24','2025-09-12 03:52:24',2),(3,'1757668944.3203.jpg','image','2025-09-12 03:52:24','2025-09-12 03:52:24',2),(4,'1757668944.3214.jpg','doc','2025-09-12 03:52:24','2025-09-12 03:52:24',2);

--
-- Table structure for table `project_plans`
--

CREATE TABLE `project_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `document` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_plans_project_id_foreign` (`project_id`),
  CONSTRAINT `project_plans_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_plans`
--

INSERT INTO `project_plans` VALUES (1,'ground floor','1757668944.3234.jpg','2025-09-12 03:52:24','2025-09-12 03:52:24',2);

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'under_construction,upcoming',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `added_by` bigint unsigned DEFAULT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `request_status` enum('approved','rejected','pending') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `total_click` bigint NOT NULL DEFAULT '0',
  `is_admin_listing` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `projects_slug_id_unique` (`slug_id`),
  KEY `projects_added_by_foreign` (`added_by`),
  KEY `projects_category_id_foreign` (`category_id`),
  CONSTRAINT `projects_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `projects_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (2,'property','property','good','good','good','yes','1757668944.3172.jpg','1757668944.3146.jpg',NULL,'nowgam byepass','','','srinagar','jammu and kashmir','india','upcoming','2025-09-12 03:52:24','2025-10-05 11:33:28',60,5,0,'rejected',0,0);

--
-- Table structure for table `properties_documents`
--

CREATE TABLE `properties_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'file name with folder',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'file type',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `properties_documents_property_id_foreign` (`property_id`),
  CONSTRAINT `properties_documents_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties_documents`
--


--
-- Table structure for table `property_images`
--

CREATE TABLE `property_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `propertys_id` bigint NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_images`
--

INSERT INTO `property_images` VALUES (3,14,'1755101694.5309.jpg','2025-08-13 10:44:54','2025-08-13 10:44:54'),(4,18,'1755414803.9211.jpg','2025-08-17 01:43:23','2025-08-17 01:43:23'),(5,19,'1755417478.2506.jpg','2025-08-17 02:27:58','2025-08-17 02:27:58'),(6,19,'1755417478.2566.jpg','2025-08-17 02:27:58','2025-08-17 02:27:58'),(7,20,'1755672258.777.jpg','2025-08-20 01:14:18','2025-08-20 01:14:18'),(8,20,'1755672258.7782.jpg','2025-08-20 01:14:18','2025-08-20 01:14:18'),(9,20,'1755672258.7792.jpg','2025-08-20 01:14:18','2025-08-20 01:14:18'),(10,22,'1756196552.4976.png','2025-08-26 02:52:32','2025-08-26 02:52:32'),(11,22,'1756196552.5012.jpg','2025-08-26 02:52:32','2025-08-26 02:52:32'),(12,22,'1756196552.5052.jpg','2025-08-26 02:52:32','2025-08-26 02:52:32'),(13,22,'1756196552.5086.png','2025-08-26 02:52:32','2025-08-26 02:52:32'),(17,24,'1757406494.4331.jpg','2025-09-09 02:58:14','2025-09-09 02:58:14'),(18,24,'1757406494.4355.jpg','2025-09-09 02:58:14','2025-09-09 02:58:14'),(19,24,'1757406494.4372.jpg','2025-09-09 02:58:14','2025-09-09 02:58:14'),(20,24,'1757406494.4385.jpg','2025-09-09 02:58:14','2025-09-09 02:58:14'),(21,25,'1757525101.0811.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(22,25,'1757525101.083.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(23,25,'1757525101.0843.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(24,25,'1757525101.0856.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(25,25,'1757525101.0866.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(26,25,'1757525101.0877.jpg','2025-09-10 11:55:01','2025-09-10 11:55:01'),(27,26,'1757835404.4171.jpg','2025-09-14 02:06:44','2025-09-14 02:06:44'),(28,27,'1757846570.7888.jpg','2025-09-14 05:12:50','2025-09-14 05:12:50'),(29,27,'1757846570.7903.jpg','2025-09-14 05:12:50','2025-09-14 05:12:50'),(30,28,'1758614692.8224.png','2025-09-23 02:34:52','2025-09-23 02:34:52'),(31,28,'1758614692.8266.png','2025-09-23 02:34:52','2025-09-23 02:34:52'),(32,28,'1758614692.83.png','2025-09-23 02:34:52','2025-09-23 02:34:52'),(33,28,'1758614692.834.jpg','2025-09-23 02:34:52','2025-09-23 02:34:52'),(34,28,'1758614692.8352.jpg','2025-09-23 02:34:52','2025-09-23 02:34:52'),(35,29,'1759078780.8575.jpg','2025-09-28 11:29:40','2025-09-28 11:29:40'),(36,29,'1759078780.8594.jpg','2025-09-28 11:29:40','2025-09-28 11:29:40'),(37,29,'1759078780.8612.png','2025-09-28 11:29:40','2025-09-28 11:29:40'),(38,29,'1759078780.8657.jpg','2025-09-28 11:29:40','2025-09-28 11:29:40'),(39,29,'1759078780.8684.jpg','2025-09-28 11:29:40','2025-09-28 11:29:40'),(40,30,'1759081971.229.png','2025-09-28 12:22:51','2025-09-28 12:22:51'),(41,30,'1759081971.2327.jpg','2025-09-28 12:22:51','2025-09-28 12:22:51'),(42,30,'1759081971.2338.jpg','2025-09-28 12:22:51','2025-09-28 12:22:51'),(43,32,'1759670134.634.png','2025-10-05 07:45:34','2025-10-05 07:45:34'),(44,32,'1759670134.6414.png','2025-10-05 07:45:34','2025-10-05 07:45:34');

--
-- Table structure for table `propertys`
--

CREATE TABLE `propertys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_id` int DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `propery_type` tinyint NOT NULL COMMENT '0:Sell 1:Rent',
  `price` bigint NOT NULL,
  `post_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '0 :admin 1:customer',
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'Kutch',
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `three_d_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_by` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT ' 0: Deactive 1: Active',
  `request_status` enum('approved','rejected','pending') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `total_click` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `rentduration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_premium` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `propertys_slug_id_unique` (`slug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `propertys`
--

INSERT INTO `propertys` VALUES (14,'5',NULL,'Home Stay','Rooms available for rent with all basic facilities.','Nunnar, Ganderbal','Nunar, Ganderbal',1,6000,'1','Nuner','India','Jammu and Kashmir','1755101694.5087.jpg','1755101694.5252.jpg','','34.2510933','74.8055811',32,1,'approved',10,'2025-08-13 10:44:54','2025-10-08 10:10:03','Monthly','home-stay','','Home Stay','Home Stay','1755101694.5117.jpg',1),(15,'4',NULL,'Rent Room','🏡 Rooms Available Near Central University of Kashmir – Nunner Campus\r\n\r\nLooking for comfortable accommodation near campus? We’ve got you covered!\r\n\r\n✨ Property Highlights:\r\n- 📍 Prime location: Just minutes from Central University of Kashmir, Nunner Campus\r\n- 🚪 1 spacious rooms available\r\n-','Nunner Ganderbal\r\nNear central university of Kashmir','191201 Nunner Ganderbal near Central University of Kashmir science Campus',1,3000,'1','Ganderbal','India','Jammu and kashmir','1755410524.0551.jpg','','','34.2164955','74.7719431',27,1,'approved',7,'2025-08-16 22:24:29','2025-09-10 00:42:27','Monthly','rent-room','Room available  for Rent','One room available for rent for student','Rent room, chinar Homes','1755363269.3869.jpg',1),(16,'4',NULL,'ROOM  FOR RENT','Looking for comfortable accommodation near campus? We’ve got you covered!\r\n\r\n✨ Property Highlights:\r\n- 📍 Prime location: Just minutes from Central University of Kashmir, Nunner Campus\r\n- 🚪 1  rooms \r\n- 🔋 Inverter backup for uninterrupted power\r\n- 🛏 Clean, secure, and well-maintained\r\n- 🌐 All essential amenities included','Nunner Ganderbal 191201  NEAR EVER GREEN HIGH SCHOOL','Nunner Ganderbal 191201 near ever green high school',1,3000,'1','Ganderbal','india','jammu and kashmir','1755410753.5938.jpg','1755410753.5987.jpg','','34.2164955','74.7719431',36,1,'approved',23,'2025-08-17 11:11:08','2025-09-11 08:24:51','Monthly','room-for-rent','ROOM FOR RENT','🏡 Rooms Available Near Central University of Kashmir – Nunner Campus\r\n\r\nLooking for comfortable accommodation near campus? We’ve got you covered!\r\n\r\n✨ Property Highlights:\r\n- 📍 Prime location: Just minutes from Central University of Kashmir, Nunner Campus\r\n- 🚪 4 spacious rooms available\r\n-\r\n- 🔋 Inverter backup for uninterrupted power\r\n- 🛏 Clean, secure, and well-maintained\r\n- 🌐 All essential amenities included\r\n\r\nPerfect for students, faculty, or working professionals seeking convenience and comfort.','ROOM FOR RENT , RENT ROOM , PG ROOM',NULL,1),(17,'6',NULL,'shop for rent','Shop available for rent on the highway near Evergreen High School, 📍 Location: Main Highway, Nunner (near Evergreen High School)\r\n\r\n\r\n\r\n🚗 Parking: Ample space available\r\n\r\n💡 Utilities: Water and electricity connections ready\r\n\r\n🛍️ Nearby: Schools, residential areas, and daily commuters\r\n\r\n💰 Rent: 2000','nunner ganderbal near ever green high school','Nunner Ganderbal 191201 near ever green high school',1,2000,'1','Nuner','indian','jammu and kashmir','1755410082.4162.png','1755410082.4199.png','','34.2510933','74.8055811',36,1,'approved',5,'2025-08-17 00:24:42','2025-08-24 10:46:04','Monthly','shop-for-rent','Shop available for rent on the highway near Evergreen High School, Nunner, Ganderbal.\"','','',NULL,1),(18,'4',NULL,'Room for Rent – Walk to University','4 Fully-Furnished Rooms for Rent\r\n\r\nDiscover comfort, convenience, and connectivity in this beautifully maintained 4-room rental located near Central University of Kashmir, Nunner Campus. Ideal for students, working professionals, or small families, each room is thoughtfully designed to offer privacy and functionality.\r\n\r\n✨ Key Features:\r\n- 4 Spacious Bedrooms – Well-lit, ventilated, and furnished with beds, wardrobes, and study desks  \r\n- Attached Bathrooms – Modern fittings, 24/7 water supply, and geysers for hot wa\r\n Power Backup – Stay connected and uninterrupted  \r\n- Secure Premises – Gated entry, CCTV surveillance, and peaceful neighborhood  \r\n- Prime Location – Walking distance to university, shops, and public transport  \r\n- Parking Available – Space for two-wheelers and compact cars','191201 Nunner Ganderbal Jammu and Kashmir','Nunner GAnderbal near central university of kashmir nunner  science campus',1,5500,'1','Ganderbal','Indian','Jammu and Kashmir','1755415427.0869.jpg','1755415427.0897.jpg','','34.2164955','74.7719431',33,1,'approved',90,'2025-08-17 12:42:53','2025-10-08 10:23:01','Monthly','room-for-rent-walk-to-university','Private Room for Rent – Walk to University','4 Fully-Furnished Rooms for Rent\r\n\r\nDiscover comfort, convenience, and connectivity in this beautifully maintained 4-room rental located near Central University of Kashmir, Nunner Campus. Ideal for students, working professionals, or small families, each room is thoughtfully designed to offer privacy and functionality.\r\n\r\n✨ Key Features:\r\n- 4 Spacious Bedrooms – Well-lit, ventilated, and furnished with beds, wardrobes, and study desks  \r\n- Attached Bathrooms – Modern fittings, 24/7 water supply, and geysers for hot water  \r\n- Fully Equipped Kitchen – Shared space with refrigerator, gas stove, utensils, and storage  \r\n- Wi-Fi & Power Backup – Stay connected and uninterrupted  \r\n- Secure Premises – Gated entry, CCTV surveillance, and peaceful neighborhood  \r\n- Prime Location – Walking distance to university, shops, and public transport  \r\n- Parking Available – Space for two-wheelers and compact cars  \r\n- Laundry Access – Washing machine and drying area included','“Affordable Rent, Unbeatable Location!”','1755414773.0345.jpg',0),(19,'5',NULL,'Furnished room near central university of kashmiri','7 Fully-Furnished Rooms for Rent\r\n\r\nDiscover comfort, convenience, and connectivity in this beautifully maintained 4-room rental located near Central University of Kashmir, Nunner Campus. Ideal for students, working professionals, or small families, each room is thoughtfully designed to offer privacy and functionality.\r\n\r\n✨ Key Features:\r\n- 4 Spacious Bedrooms – Well-lit, ventilated, and  affordable \r\n- Attached Bathrooms – Modern fittings, 24/7 water supply, and geysers for hot water  \r\n- Fully Equipped Kitchen – Shared space with refrigerator, gas stove, utensils, and storage  \r\n- Wi-Fi & Power Backup – Stay connected and uninterrupted  \r\n- Secure Premises – Gated entry, CCTV surveillance, and peaceful neighborhood  \r\n- Prime Location – Walking distance to university, shops, and public transport  \r\n- Parking Available – Space for two-wheelers and compact cars  \r\n-','191201 nunnar Ganderbal near fatech online solutions','nunnar ganderbal near  cuk campus i',1,4000,'1','Ganderbal','indian','jammu and kashmir','1755417478.2377.jpeg','1755417478.2423.jpg','','34.2164955','74.7719431',37,1,'approved',10,'2025-08-17 02:27:58','2025-10-06 05:55:13','Monthly','furnished-room-near-central-university-of-kashmiri','room rent in low badget','4 Fully-Furnished Rooms for Rent\r\n\r\nDiscover comfort, convenience, and connectivity in this beautifully maintained 4-room rental located near Central University of Kashmir, Nunner Campus. Ideal for students, working professionals, or small families, each room is thoughtfully designed to offer privacy and functionality.\r\n\r\n✨ Key Features:\r\n- 4 Spacious Bedrooms – Well-lit, ventilated, and furnished with beds, wardrobes, and study desks  \r\n- Attached Bathrooms – Modern fittings, 24/7 water supply, and geysers for hot water  \r\n- Fully Equipped Kitchen – Shared space with refrigerator, gas stove, utensils, and storage  \r\n- Wi-Fi & Power Backup – Stay connected and uninterrupted  \r\n- Secure Premises – Gated entry, CCTV surveillance, and peaceful neighborhood  \r\n- Prime Location – Walking distance to university, shops, and public transport  \r\n- Parking Available – Space for two-wheelers and compact cars  \r\n- Laundry Access – Washing machine and drying area included','room rent, central university of kashmiri','1755417478.2381.jpg',1),(20,'6',NULL,'I WANT TO SELL MY SHOPS ON GOODWILL AND ALSO ON RENT','Here’s a compelling property description tailored for your listing on ChinarHomes, based on your title and location:\r\n\r\n---\r\n\r\n### 🏬 **Prime Commercial Shops for Sale/Rent – SP Office Ganderbal**\r\n\r\nStrategically located **near SP Office Ganderbal**, these commercial shops offer unmatched visibility and accessibility right on the **National Highway**, making them ideal for retail, service centers, or branded outlets.\r\n\r\n**Key Highlights:**\r\n- 🚗 **Dedicated Parking Land**: Spacious outdoor area for customer and staff parking—rare to find in this zone.\r\n- 📍 **Highway Frontage**: Direct access from the National Highway ensures maximum footfall and brand exposure.\r\n- 🏢 **Multiple Shop Units**: Available for **sale on goodwill** or **monthly rental**, giving flexibility to investors and entrepreneurs.\r\n- 🛠️ **Ready for Customization**: Shell units that can be tailored to your business needs—whether it’s a pharmacy, grocery, showroom, or café.\r\n- 🧭 **Proximity to Key Institutions**: Located near administrative offices, , and residential —perfect for steady customer flow.\r\n\r\n**Ideal For:**\r\n- Retail chains\r\n- Local entrepreneurs\r\n- Service centers\r\n- Food outlets\r\n\r\n\r\nWhether you\'re looking to **launch a new venture** or **expand your footprint in Ganderbal**, this property offers the visibility, space, and location advantage to thrive.\r\n\r\n---\r\n\r\nWould you like help drafting a promotional image or slogan to go with this listing?','Beehama  Ganderbal 191201 near sp office','BEEHAMA GANDERBAL',0,4000,'1','Ganderbal','Indiia','jammand kashmir','1755672258.7696.jpg','1755672258.7706.jpg','','34.2164955','74.7719431',52,1,'approved',15,'2025-08-20 01:14:18','2025-09-12 01:34:30','','i-want-to-sell-my-shops-on-goodwill-and-also-on-rent','shops for sale Ganderbal, commercial property Ganderbal, shops on rent near SP Office, National Highway shops Kashmir, parking land Ganderbal, retail space Ganderbal, commercial shops Jammu and Kashmir, highway frontage shops, property near SP Office Ganderbal, business location Ganderbal, shop investment Kashmir, commercial real estate Ganderbal, Ganderbal property listing, shops with parking Kashmir, prime location shops Ganderbal','Discover prime commercial shops near SP Office Ganderbal, ideally located on the National Highway with dedicated parking land. Perfect for retail, rental, or investment—high visibility and easy access guaranteed.','shops for sale Ganderbal, commercial property Ganderbal, shops on rent near SP Office, National Highway shops Kashmir, parking land Ganderbal, retail space Ganderbal, commercial shops Jammu and Kashmir, highway frontage shops, property near SP Office Ganderbal, business location Ganderbal, shop investment Kashmir, commercial real estate Ganderbal, Ganderbal property listing, shops with parking Kashmir, prime location shops Ganderbal','1755672258.7702.jpg',1),(21,'4',NULL,'HAKIM MANZIL','ROOMS AND SET AVAILABLE FOR RENT ONLY FOR GIRLS','2QQP+FG4, near Jamia masjid, Hyderpora, Srinagar, 190014','Syed Hyder shah colony near Jamia masjid hyderpora',1,10000,'1','Srinagar','India','Jammu and Kashmir','1756030935.8756.jpg','','','34.03889676538561','74.78627447316177',53,1,'approved',6,'2025-08-24 04:52:15','2025-09-27 05:03:19','Yearly','hakim-manzil','Hakim manzil','Study property','Available','1756030935.8762.jpg',1),(22,'5',NULL,'Room available for Rent','Room for Rent Near Tehsil Office, Ganderbal\r\n\r\nKey Highlight \r\n\r\n- Prime location just a 2-minute walk from the Tehsil Office  \r\n- Quiet residential street with excellent neighbor relations  \r\n- Ground-floor room in a well-maintained single-family home  \r\n\r\nRoom Features\r\n\r\n- Spacious 12×10 ft carpeted area with large window facing east  \r\n- Built-in wardrobe and study nook ready to use  \r\n- Natural daylight throughout the day keeps the space bright and airy  \r\n\r\nShared Amenities\r\n\r\n- Shared bathroom with geyser and regular hot water supply  \r\n- Fully equipped kitchen available for tenant use  \r\n- High-speed broadband (100 Mbps) and Wi-Fi access  \r\n- Dedicated parking space for two-wheelers inside compound  \r\n- 24×7 water supply & inverter backup during power cuts','191201 Opposite Tehsil office\r\nBeehama Ganderbal','Opposite Tehsil office\r\nBeehama Ganderbal',1,3000,'1','Ganderbal','India','Jammu and Kashmir','1756196552.4866.jpg','','','33.57283384957201','75.1811523906403',54,1,'approved',0,'2025-08-26 02:52:32','2025-08-26 02:53:17','Monthly','room-available-for-rent','Room available near teshile office Ganderbal','HRoom for Rent Near Tehsil Office, Ganderbal\r\n\r\nKey Highlights\r\n\r\n- Prime location just a 2-minute walk from the Tehsil Office  \r\n- Quiet residential street with excellent neighbor relations  \r\n- Ground-floor room in a well-maintained single-family home  \r\n\r\nRoom Features\r\n\r\n- Spacious 12×10 ft carpeted area with large window facing east  \r\n- Built-in wardrobe and study nook ready to use  \r\n- Natural daylight throughout the day keeps the space bright and airy  \r\n\r\nShared Amenities\r\n\r\n- Shared bathroom with geyser and regular hot water supply  \r\n- Fully equipped kitchen available for tenant use  \r\n- High-speed broadband (100 Mbps) and Wi-Fi access  \r\n-','Rooms  available for rent  .Natural daylight throughout the day keeps the space bright and airy','1756196552.4894.jpg',1),(24,'5',NULL,'Office Space for Rent – Prime Location in Srinagar','🏢 Office Space for Rent – Prime Location in Srinagar Location:** Akhoon Sahib, near Islamia College, Srinagar  \r\nA sought-after area with excellent connectivity and visibility.\r\n\r\n📐 Space Details:\r\n- **Ground Floor:** 16×10 ft – perfect for reception or client-facing operations  \r\n- **First Floor:** 24×10 ft – ideal for workstations or private cabins  \r\n- **Additional Space:** Available on demand to suit your needs\r\n\r\n 🛠️ Amenities:\r\n- **Kitchen-cum-Washroom:** 10×6 ft (convertible for flexible use)  \r\n- **Fully Furnished:** Elegant tile finish on walls and floors  \r\n- **Zero Setup Costs:** Move in and start working immediately\r\n\r\n ✅ Ideal For:\r\n- Medical Clinics  \r\n- Chartered Accountants  \r\n- Legal or Consulting Firms  \r\n- Startups and Entrepreneurs  \r\n- Corporate Officers or Satellite Offices','Akhoon Sahib in Hawal, Srinagar,, near Islamia College, Srinagar','Akhoon Sahib, Srinagar',1,30000,'1','Akhoon Sahib in Hawal, Srinagar,','Indiia','jammand kashmir','1757406494.4235.jpg','1757406494.4245.jpg','','33.532742401981224','75.64514540214844',56,1,'approved',16,'2025-09-09 02:58:14','2025-09-15 11:41:50','Monthly','office-space-for-rent-prime-location-in-srinagar','Office Space for Rent – Prime Location in Srinagar','ffice Space for Rent in Srinagar\r\nKey Highlights:\r\n- Location: Akhoon Sahib, near Islamia College Srinagar (prime area)\r\n- Space:\r\n    - Ground floor: 16x10 ft\r\n    - First floor: 24x10 ft\r\n    - Additional space available on demand\r\n- Amenities:\r\n    - Kitchen-cum-washroom on the ground floor (10x6 ft) (convertible)\r\n    - Fully furnished with tiles on walls and floor\r\n    - No additional expenses\r\n- Ready to Move: No setup needed\r\n\r\nIdeal for:\r\n- Clinics\r\n- Chartered Accountant\r\n- Firms\r\n- Startups\r\n- Corporate Officers','office Space for Rent in Srinagar','1757406494.424.jpg',1),(25,'4',NULL,'4 Marla House for Sale in Friends Colony, Natipora','House for Sale – Friends Colony Lane 10, Natipora, Srinagar\r\n\r\n📏 Land Size: 4 Marlas (Milkiyat Land)\r\n\r\n📍 Location: Natipora, Srinagar\r\n\r\n💡 Special Feature: Ideal for use as a paying guest house\r\n\r\n📞 Contact: 9149558985\r\n\r\nThis charming property in the heart of Natipora offers a unique opportunity for buyers seeking a compact, well-located home with potential for rental income. Whether you\'re looking to settle down or invest, this house ticks the boxes for convenience and versatility.\r\n\r\n📌 Note: Chinarhomes is not a broker. They provide property advertising services only. Buyers are advised to conduct their own due diligence.','Friends Colony Lane 10, Natipora, Srinagar jammu and kashmir','Akhoon Sahib, Srinagar',0,7000000,'1','Friends Colony Lane 10, Natipora, Srinagar','India','Jammu and Kashmir','1757525196.8168.jpg','1757525196.8191.jpg','','33.60826185964909','74.92416761894532',56,1,'approved',43,'2025-09-10 17:25:01','2025-09-27 05:03:46','','4-marla-house-for-sale-in-friends-colony-natipora','4 Marla House for Sale in Natipora, Srinagar –',NULL,'\"House for Sale, Natipora Property, Srinagar Real Estate, 4 Marla House,  Buy Property Srinagar\">',NULL,1),(26,'3',NULL,'6 Marla Land for Sale – Near District Hospital Ganderbal','🏡 6 Marla Land for Sale – Near District Hospital Ganderbal\r\n\r\n📍 Location: Near District Hospital Ganderbal\r\n📐 Land Size: 6 Marla\r\n💰 Price: ₹12 Lakh\r\n\r\n✨ Property Highlights:\r\n✅ Prime location near District Hospital\r\n✅ Ideal for residential or investment purposes\r\n✅ Easy accessibility\r\n\r\n📞 Contact: 7889735012\r\n\r\n#LandForSale #Ganderbal #PropertyInvestment #RealEstateKashmir','191201 Beehama, Ganderbal, 191201','Akhoon Sahib, Srinagar',0,120000,'1','Ganderbal','India','Jammu and Kashmir','1757835810.0023.jpg','1757835810.0049.jpg','','34.2169877825763','74.78203199882813',56,1,'approved',4,'2025-09-14 07:36:44','2025-09-14 02:14:26','','6-marla-land-for-sale-near-district-hospital-ganderbal','6 Marla Land for Sale – Near District Hospital Ganderbal','6 Marla Land for Sale – Near District Hospital Ganderbal','6 Marla Land for Sale – Near District Hospital Ganderbal','1757835404.4107.jpg',1),(27,'4',NULL,'New 3-Room House for Sale in Bathindi, Jammu','New 3-Room House for Sale in Bathindi, Jammu  \r\n📍 Location: بٹھنڈی Bathindi, Jammu  \r\n📐 Size: 4 Marla  \r\n💰 Price: ₹45 Lakhs  \r\n📞 Contact: 8082036771\r\n\r\nStep into comfort and convenience with this newly constructed 3-room independent house in the heart of Bathindi. Designed for modern living, this home offers:\r\n\r\n- ✅ Spacious 3 Bedrooms with natural light and ventilation  \r\n- 🚗 Dedicated Car Parking space within the premises  \r\n- 🛁 Modern Bathroom fittings and tiled interiors  \r\n- 🏠 Fresh Construction—ready to move in  \r\n- 🌳 Peaceful residential area with easy access to schools, markets, and transport\r\n\r\nPerfect for small families, professionals, or investors looking for a well-located property in Jammu. Don\'t miss this opportunity to own a stylish and affordable home in a fast-developing neighborhood.','Bathindi, Jammu','Akhoon Sahib, Srinagar',0,4500000,'1','Jammu','India','Jammu and Kashmir','1757846570.7822.jpg','1757846570.7833.jpg','','32.7266016','74.8570259',56,1,'approved',4,'2025-09-14 05:12:50','2025-09-25 11:34:49','','new-3-room-house-for-sale-in-bathindi-jammu','New 3-Room House for Sale in Bathindi, Jammu','New 3-Room House for Sale in Bathindi, Jammu','New 3-Room House for Sale in Bathindi, Jammu','1757846570.7828.jpg',1),(28,'4',NULL,'🏡House  for Sale – Tullmulla, Ganderbal','🏡House  for Sale – Tullmulla, Ganderbal\r\n\r\n🏡House  for Sale – Tullmulla, Ganderbal\r\n\r\n📍 Location: Tullmulla, Ganderbal\r\n📏 Size: 1 Kanal \r\n📞 Contact: 9682325274\r\n\r\nDiscover your dream home nestled in the serene heart of Tullmulla, Ganderbal. This beautifully constructed house offers a perfect blend of traditional Kashmiri architecture and modern comfort. Whether you\'re looking to settle down or invest, this property promises peace, privacy, and potential.\r\n\r\nKey Features:\r\n\r\n✅ Spacious layout with natural light in every room\r\n\r\n✅ Private courtyard ideal for family gatherings\r\n\r\n✅ Located in a quiet, well-connected neighborhood\r\n\r\n✅ Close to schools, markets, and public transport\r\n\r\n✅ Ideal for families, professionals, or rental income','191131 Tullmulla, Ganderbal','Akhoon Sahib, Srinagar',0,15000000,'1','GANDERBAL','India','Jammu and Kashmir','1758614692.8074.png','1758614692.8126.png','','33.78935287781219','75.07248304863282',56,1,'approved',30,'2025-09-23 02:34:52','2025-09-23 13:01:17','','house-for-sale-tullmulla-ganderbal','House for Sale in Tullmulla, Ganderbal | ChinarHomes','Explore this elegant multi-story house for sale in Tullmulla, Ganderbal—featuring Gothic-style windows, carved wooden doors, and teal-tinted glass. Listed on ChinarHomes.com. Android & iOS apps launching soon!','House for sale Tullmulla, Ganderbal property, Chinar Homes real estate, Kashmir homes, buy house Ganderbal, Chinar Homes app, Kashmir property listing','1758614692.8101.png',1),(29,'3',NULL,'Premium 5 Marla+ Plots in Channi Jammu – Bank Loan Available','Premium Malki Plots in VIP Channi, Jammu – Limited Availability!\r\nDiscover 6 exclusive Malki plots located in the prestigious VIP area of Channi, Jammu. Ideal for residential or investment purposes, each plot starts at a spacious 5 Marla and offers full ownership rights.\r\n\r\n💰 Starting Price: ₹75 Lakh \r\n\r\n🏦 Bank Loan Facility Available 📍 Prime Location: VIP Zone, Channi Jammu \r\n📞 Call Now: 9797501769','VIP area of Channi Jammu 180015','Akhoon Sahib, Srinagar',0,7500000,'1','Channi JAMMU','INDIA','Jammu and Kashmir','1759078780.8399.png','1759078780.8468.jpg','','32.5678093','74.9990454',56,1,'approved',0,'2025-09-28 11:29:40','2025-09-28 11:34:22','','premium-5-marla-plots-in-channi-jammu-bank-loan-available','Malki Plots for Sale in VIP Channi Jammu – Starting ₹75L | ChinarHomes','Explore 6 premium Malki plots in the VIP area of Channi Jammu. Starting at ₹75 Lakh with full bank loan facility. Ideal for residential or investment. Call 9797501769.','Malki plots Channi Jammu, VIP plots Jammu, 5 Marla plots for sale, Channi Jammu real estate, residential plots Jammu, bank loan plots Jammu, ChinarHomes property, buy land Channi Jammu, Jammu property investment, plots with loan facility','1759078780.8435.png',1),(30,'3',NULL,'Own Land Near Akhnoor Highway – Starting ₹24 Lakh | ChinarHomes','Low Budget  Malki Plots Near Jammu–Akhnoor Highway\r\nLooking to own land near Jammu without breaking the bank? We’re offering affordable Malki plots just off the Jammu–Akhnoor Highway, ideal for residential or investment purposes.\r\n\r\n📐 Minimum Size: 5 Marla\r\n 💰 Starting Price: ₹24 Lakh \r\n🏦 Bank Loan Facility Available \r\n📍 Prime Location: Near Akhnoor Highway, Jammu\r\n 📞 Call Now: 9797501769\r\n\r\nThese plots come with full ownership rights, easy access to main roads, and strong future appreciation potential. Perfect for first-time buyers, budget-conscious families, or smart investors.','Jammu–Akhnoor Highway','Akhoon Sahib, Srinagar',0,2400000,'1','AKHNOOR Jammu','INDIA','Jammu and Kashmir','1759081971.2177.png','1759081971.2231.jpg','','32.7266016','74.8570259',56,1,'approved',0,'2025-09-28 12:22:51','2025-09-28 12:28:41','','own-land-near-akhnoor-highway-starting-24-lakh-chinarhomes','Low Budget Malki Plots Near Akhnoor Highway | Starting ₹24L | ChinarHomes','Low Budget Malki Plots Near Akhnoor Highway – Full Ownership & Loan Facility\r\nLooking to invest in land near Jammu without stretching your budget? ChinarHomes presents affordable Malki plots just off the Jammu–Akhnoor Highway, ideal for residential construction or long-term investment.\r\n\r\n📐 Minimum Size: 5 Marla 💰 Starting Price: ₹24 Lakh 🏦 Bank Loan Facility Available 📍 Location: Near Akhnoor Highway, Jammu 📞 Call Now: 9797501769\r\n\r\nThese plots offer full ownership rights, easy access to the highway, and strong appreciation potential in a fast-developing zone. Whether you\'re a first-time buyer or a strategic investor, this is your chance to secure land in a prime corridor.\r\n\r\n📱 ChinarHomes App Available on Play Store 🍎 Coming Soon to App Store','low budget plots Jammu, Akhnoor Highway land, Malki plots for sale, 5 Marla plots Jammu, affordable land Jammu, bank loan plots, ChinarHomes property, buy land Akhnoor, Jammu real estate, residential plots Jammu, investment plots Jammu','1759081971.2204.png',1),(31,'4',NULL,'Luxury Guest House Near Gulmarg – Scenic Views & Comfort _chinar homes','Escape to the serene beauty of Tang Marg with this charming two-story guest house nestled in the peaceful village of Firozpur. Just 15 minutes from Gulmarg, this cozy retreat offers the perfect blend of traditional Kashmiri architecture and modern comfort.\r\n\r\nFeaturing spacious rooms with large arched windows, a covered porch, and a private balcony, the guest house is designed to let in natural light and mountain views. Whether you\'re sipping noon chai under the shade of the garden tree or planning a snowy adventure in Gulmarg, this home provides a warm and welcoming base for every traveler.\r\n\r\nIdeal for families, couples, and solo explorers, the property includes:\r\n- ✅ Multiple bedrooms with scenic views  \r\n- ✅ A fully equipped kitchen and dining area  \r\n- ✅ High-speed Wi-Fi and 24/7 water supply  \r\n- ✅ Ample parking space and outdoor seating  \r\n- ✅ Easy access to local markets and transport\r\n\r\nBook your stay and experience Kashmiri hospitality at its finest—where every sunrise feels like a postcard.','Firozpur Tangmarg Gulmarg','Akhoon Sahib, Srinagar',1,20000,'1','Firozpur Tangmarg Gulmarg','INDIAN','Jammu and Kashmir','1759669199.7536.png','1759669199.7602.png','https://youtu.be/eWeUhZ_rIig?si=ac2An2WtgwXMhCSr','33.77622662919559','75.09514235039063',56,1,'approved',0,'2025-10-05 07:29:59','2025-10-05 07:46:40','Monthly','luxury-guest-house-near-gulmarg-scenic-views-comfort-chinar-homes','Cozy Guest House in Firozpur Tangmarg | Stay Near Gulmarg – Book Affordable Rooms Now -chinar homes','cmfort and Kashmiri charm at this beautifully designed guest house in **Firozpur Tangmarg**, just a short drive from the world-famous **Gulmarg ski resort**. This two-story brick home features a striking red gabled roof, large arched windows, and a welcoming porch—perfect for travelers seeking peace, warmth, and scenic beauty.\r\n\r\nWhether you\'re planning a family vacation, a romantic getaway, or a solo retreat, this guest house offers:\r\n- 🌄 Breathtaking views of surrounding hills and forests  \r\n- 🛏️ Spacious, well-lit rooms with modern furnishings  \r\n- 🍽️ Fully equipped kitchen and dining area  \r\n- 📶 High-speed Wi-Fi and 24/7 water supply  \r\n- 🚗 Private parking and easy access to local transport\r\n\r\nEnjoy the golden glow of twilight from the balcony, sip noon chai under the shade of the garden tree, or explore nearby attractions like Gulmarg, Drung Waterfall, and Tangmarg Market.\r\n\r\n**Contact: Shafiq Ahmed – 7006973509**  \r\n**Download the Chinar Homes App** – Available on both **Play Store** and **App Store**','Firozpur Tangmarg guest house, guest house near Gulmarg, Tangmarg stay, Gulmarg accommodation, Kashmir guest house, cozy guest house Kashmir, budget stay Gulmarg, ChinarHomes property, Shafiq Ahmed guest house, family stay Tangmarg, tourist stay near Gulmarg, Kashmir vacation rental, Gulmarg guest house booking','1759669199.7569.png',1),(32,'4',NULL,'Urgent Sale – Beautiful 1-Storey House on 8 Marla Land in Bemina, Srinagar','📝 Description  \r\nA rare opportunity to own a well-maintained, single-storey brick house in the heart of **Sheikh Noor Din Colony, Bay-8, Bemina**. Built on **8 Marla of prime land**, this property offers both comfort and convenience in one of Srinagar’s most sought-after residential areas.\r\n\r\nKey features include:\r\n- 🚗 **Spacious car parking** for 3–4 vehicles  \r\n- 🌿 **Lush garden** with flowering plants and green lawn  \r\n- 🪟 **Large windows** for natural light and ventilation  \r\n- 🧱 **Solid brick construction** with elegant exterior finish  \r\n- 🛣️ Easy access to main roads, schools, and local markets\r\n\r\n**Price: ₹49 Lakhs Only**  \r\nThis is an **urgent sale**, ideal for serious buyers looking for a ready-to-move-in home in a peaceful neighborhood.\r\n\r\n📞 **Contact: 9149809125**  \r\nSchedule a visit today and make this beautiful house your new home','3QX4+MW2, Bemina Srinagar, 190017','Akhoon Sahib, Srinagar',0,4900000,'1','BEMINA Srinagar','INDIAN','Jammu and Kashmir','1759670134.6265.jpg','1759670134.6275.jpg','','34.098945487922066','74.75679777641602',56,1,'approved',0,'2025-10-05 07:45:34','2025-10-05 07:46:30','','urgent-sale-beautiful-1-storey-house-on-8-marla-land-in-bemina-srinagar','House for Sale in Bemina Srinagar – 8 Marla | ₹49 Lakhs | Chinar Homes','🏠 Property Description\r\nUrgent Sale – Beautiful 1-Storey House in Bemina, Srinagar\r\n\r\nLocated in the peaceful and well-connected Sheikh Noor Din Colony, Bay-8, Bemina, this charming one-storey brick house sits on 8 Marla of prime residential land. With a spacious layout and a lush garden, it’s ideal for families seeking comfort, convenience, and a secure neighborhood.\r\n\r\nKey Features:\r\n\r\n🧱 Solid brick construction with elegant exterior finish\r\n\r\n🚗 Private car parking for 3–4 vehicles\r\n\r\n🌿 Well-maintained garden with flowering plants and green lawn\r\n\r\n🪟 Large windows for natural light and ventilation\r\n\r\n🏡 Ready-to-move-in condition with peaceful surroundings\r\n\r\n🛣️ Easy access to schools, markets, and main roads\r\n\r\nPrice: ₹49 Lakhs Only This is an urgent sale, perfect for buyers looking for a valuable property in Srinagar’s growing residential zone.\r\n\r\n📞 Contact: 9149809125 Listed on Chinar Homes App – Available on both Play Store and App Store','house for sale Bemina Srinagar, 8 Marla property Srinagar, urgent house sale Kashmir, single-storey house Bemina, Sheikh Noor Din Colony property, Srinagar real estate, affordable house Srinagar, Chinar Homes listings, Kashmir property deals, house with car parking Srinagar, buy house in Bemina, brick house for sale Srinagar','1759670134.627.jpg',1);

--
-- Table structure for table `propertys_inquiry`
--

CREATE TABLE `propertys_inquiry` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `propertys_id` bigint unsigned NOT NULL,
  `customers_id` bigint unsigned NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0 : Pending 1:Accept  2: Complete 3:Cancle',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `propertys_inquiry_propertys_id_foreign` (`propertys_id`),
  KEY `propertys_inquiry_customers_id_foreign` (`customers_id`),
  CONSTRAINT `propertys_inquiry_customers_id_foreign` FOREIGN KEY (`customers_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `propertys_inquiry_propertys_id_foreign` FOREIGN KEY (`propertys_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `propertys_inquiry`
--


--
-- Table structure for table `reject_reasons`
--

CREATE TABLE `reject_reasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` bigint unsigned DEFAULT NULL,
  `project_id` bigint unsigned DEFAULT NULL,
  `reason` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reject_reasons_property_id_foreign` (`property_id`),
  KEY `reject_reasons_project_id_foreign` (`project_id`),
  CONSTRAINT `reject_reasons_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reject_reasons_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reject_reasons`
--

INSERT INTO `reject_reasons` VALUES (8,NULL,2,'SDF','2025-10-05 11:33:28','2025-10-05 11:33:28',NULL);

--
-- Table structure for table `report_reasons`
--

CREATE TABLE `report_reasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `report_reasons`
--


--
-- Table structure for table `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `page` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seo_settings`
--

INSERT INTO `seo_settings` VALUES (1,'homepage','1748341664.7375.png','Chinar Homes – Your Trusted Property Partner in Kashmir','Chinar Homes is Kashmir’s and beyond. Easy, secure, and hassle-free property deals. Real estate services in Kashmir','Buy property in Kashmir, Sell property in Kashmir, Chinar Homes real estate, Real estate services in Kashmir','2025-05-27 10:27:44','2025-05-27 10:27:44'),(2,'about-us','1748342240.915.png','About Chinar Homes – Trusted Property Advisors in J & K','At Chinar Homes, we make real estate simple and trustworthy in Kashmir. find your perfect homes, plots, and rentals across the valley.','About Chinar Homes, Kashmir real estate team, Trusted real estate company in Kashmir, Buy, sell, rent homes in Kashmir','2025-05-27 05:07:20','2025-05-27 05:07:20'),(3,'contact-us','1749904844.6425.png','Contact Us | Any Time Any Where','We would love to Get in touch with Chinar Homes for expert property consultation.','chinar homes, contact us , enquiry at chinar homes','2025-06-14 07:10:44','2025-06-14 07:10:44'),(4,'faqs','1749905004.5364.png','FAQ | Ask any question you want','Find answers to common questions about buying property, legal support, pricing, and services at Chinar Homes. Everything you need to know, simplified.','Chinar Homes FAQ, Kashmir real estate questions, property buying in Kashmir','2025-06-14 07:13:24','2025-06-14 07:13:24'),(5,'articles','1749905151.5481.png','Real Estate Insights & Tips – Chinar Homes','Explore expert insights, tips, and guides on real estate trends, property buying, and investment in Kashmir from Chinar Homes. Stay informed and empowered.','Chinar Homes, Kashmir real estate, property investment, real estate tips, buying property in Kashmir, real estate articles, housing market Kashmir, property news, real estate insights, home buying guide','2025-06-14 07:15:51','2025-06-14 07:15:51'),(6,'featured-properties','1749905260.4212.png','Featured Properties in Kashmir – Chinar Homes','Discover premium featured properties in Kashmir with Chinar Homes. Explore handpicked homes, apartments, and land for sale in prime locations.','featured properties, Chinar Homes, Kashmir real estate, homes for sale in Kashmir, property listings, prime properties Kashmir, land for sale, luxury homes Kashmir, buy property Kashmir, real estate deals','2025-06-14 07:17:40','2025-06-14 07:17:40'),(7,'most-viewed-properties','1749905378.378.png','Most Viewed Properties in Kashmir – Chinar Homes','Explore the most viewed properties in Kashmir with Chinar Homes. See what’s trending in real estate and discover top-rated .','most viewed properties, Chinar Homes, trending properties Kashmir, popular homes for sale, top real estate Kashmir, property views, best selling homes, Kashmir property trends, hot properties, real estate insights','2025-06-14 07:19:38','2025-06-14 07:19:38'),(8,'privacy-policy','1749905520.8886.png','Privacy Policy – Chinar Homes','Learn how Chinar Homes collects, uses, and protects your personal information. Your privacy and data security are our top priorities.','Chinar Homes privacy policy, data protection, user data security, personal information policy, privacy terms, data usage, information confidentiality, online privacy, data privacy Kashmir, website privacy policy','2025-06-14 07:22:00','2025-06-14 07:22:00');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--



--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('1','2','3','4') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 - only image, 2 - category, 3 - property, 4 - link',
  `image` text COLLATE utf8mb4_unicode_ci COMMENT 'app_image',
  `web_image` text COLLATE utf8mb4_unicode_ci,
  `link` text COLLATE utf8mb4_unicode_ci,
  `sequence` tinyint NOT NULL DEFAULT '0',
  `category_id` bigint DEFAULT '0',
  `propertys_id` bigint DEFAULT '0',
  `show_property_details` tinyint(1) NOT NULL DEFAULT '0',
  `default_data` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` VALUES (1,'1','1749902172.1659.jpg','1749902049.0986.jpg',NULL,0,0,0,0,1,'2025-05-24 05:41:06','2025-06-14 06:26:12');

--
-- Table structure for table `telescope_entries`
--

CREATE TABLE `telescope_entries` (
  `sequence` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `telescope_entries_uuid_unique` (`uuid`),
  KEY `telescope_entries_batch_id_index` (`batch_id`),
  KEY `telescope_entries_family_hash_index` (`family_hash`),
  KEY `telescope_entries_created_at_index` (`created_at`),
  KEY `telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_entries`
--


--
-- Table structure for table `telescope_entries_tags`
--

CREATE TABLE `telescope_entries_tags` (
  `entry_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`entry_uuid`,`tag`),
  KEY `telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_entries_tags`
--


--
-- Table structure for table `telescope_monitoring`
--

CREATE TABLE `telescope_monitoring` (
  `tag` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_monitoring`
--


--
-- Table structure for table `user_interests`
--

CREATE TABLE `user_interests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `category_ids` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outdoor_facilitiy_ids` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_range` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_interests`
--

INSERT INTO `user_interests` VALUES (1,10,'',NULL,'2000,2500','Nuner','1','2025-07-14 17:25:28','2025-07-14 17:25:28'),(2,18,'3,4,5','2,3,4,5,6','200.0,200.0','','0,1','2025-07-30 07:48:40','2025-07-30 07:48:40'),(3,1,'3,4,5','2,3,5','200.0,200.0','','0,1','2025-07-30 17:35:17','2025-07-30 17:35:17'),(4,58,'3,4,6,5,2','4,5,6,3,2','2000.0,3000000.0','','0,1','2025-09-07 05:08:47','2025-09-07 05:08:47'),(5,60,'3,4,6,5','3','2000.0,7632969.0','','0','2025-09-12 03:52:02','2025-09-12 03:52:02');

--
-- Table structure for table `user_package_limits`
--

CREATE TABLE `user_package_limits` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_package_id` bigint unsigned NOT NULL,
  `package_feature_id` bigint unsigned NOT NULL,
  `total_limit` int NOT NULL,
  `used_limit` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_package_limits_user_package_id_foreign` (`user_package_id`),
  KEY `user_package_limits_package_feature_id_foreign` (`package_feature_id`),
  CONSTRAINT `user_package_limits_package_feature_id_foreign` FOREIGN KEY (`package_feature_id`) REFERENCES `package_features` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_package_limits_user_package_id_foreign` FOREIGN KEY (`user_package_id`) REFERENCES `user_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_package_limits`
--

INSERT INTO `user_package_limits` VALUES (1,3,15,2,1,'2025-07-29 12:40:38','2025-07-29 12:40:38'),(2,3,16,5,1,'2025-07-29 12:40:38','2025-07-29 12:40:38'),(3,4,15,2,2,'2025-07-30 11:08:13','2025-07-30 11:08:13'),(4,4,16,5,1,'2025-07-30 05:38:13','2025-07-30 05:38:13'),(5,26,15,2,0,'2025-09-07 07:38:00','2025-09-07 07:38:00'),(6,26,16,5,0,'2025-09-07 07:38:00','2025-09-07 07:38:00'),(7,27,15,2,2,'2025-09-07 20:49:53','2025-09-07 20:49:53'),(8,27,16,5,5,'2025-09-08 13:19:53','2025-09-08 13:19:53'),(9,30,15,2,0,'2025-09-10 00:26:32','2025-09-10 00:26:32'),(10,30,16,5,0,'2025-09-10 00:26:32','2025-09-10 00:26:32'),(11,32,15,2,0,'2025-09-11 01:04:25','2025-09-11 01:04:25'),(12,32,16,5,0,'2025-09-11 01:04:25','2025-09-11 01:04:25'),(13,37,15,2,0,'2025-09-22 05:19:48','2025-09-22 05:19:48'),(14,37,16,5,0,'2025-09-22 05:19:48','2025-09-22 05:19:48'),(15,38,15,2,0,'2025-09-23 02:59:10','2025-09-23 02:59:10'),(16,38,16,5,0,'2025-09-23 02:59:10','2025-09-23 02:59:10');

--
-- Table structure for table `user_packages`
--

CREATE TABLE `user_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL COMMENT 'customers',
  `package_id` bigint unsigned NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_packages_user_id_foreign` (`user_id`),
  KEY `user_packages_package_id_foreign` (`package_id`),
  CONSTRAINT `user_packages_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_packages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_packages`
--

INSERT INTO `user_packages` VALUES (1,1,1,'2025-06-18 12:56:21','2025-07-18 12:56:21','2025-06-18 07:26:21','2025-06-18 07:26:21',NULL),(2,11,1,'2025-07-05 09:54:17','2025-08-04 09:54:17','2025-07-05 04:24:17','2025-07-05 04:24:17',NULL),(3,1,5,'2025-07-29 12:40:38','2025-08-28 12:40:38','2025-07-29 07:10:38','2025-07-29 07:10:38',NULL),(4,13,5,'2025-07-30 05:38:13','2025-08-29 05:38:13','2025-07-30 00:08:13','2025-07-30 00:08:13',NULL),(5,13,8,'2025-07-31 09:58:48','2025-08-30 09:58:48','2025-07-31 04:28:48','2025-07-31 04:28:48',NULL),(6,26,8,'2025-08-01 10:41:45','2025-08-31 10:41:45','2025-08-01 05:11:45','2025-08-01 05:11:45',NULL),(7,1,8,'2025-08-01 13:59:47','2025-08-31 13:59:47','2025-08-01 08:29:47','2025-08-01 08:29:47',NULL),(8,11,8,'2025-08-07 11:13:47','2025-09-06 11:13:47','2025-08-07 05:43:47','2025-08-07 05:43:47',NULL),(9,18,8,'2025-08-08 10:31:00','2025-09-07 10:31:00','2025-08-08 05:01:00','2025-08-08 05:01:00',NULL),(10,32,8,'2025-08-13 14:55:16','2025-09-12 14:55:16','2025-08-13 09:25:16','2025-08-13 09:25:16',NULL),(11,33,8,'2025-08-16 13:38:53','2025-09-15 13:38:53','2025-08-16 08:08:53','2025-08-16 08:08:53',NULL),(12,27,8,'2025-08-16 16:38:23','2025-09-15 16:38:23','2025-08-16 11:08:23','2025-08-16 11:08:23',NULL),(13,36,8,'2025-08-17 05:23:17','2025-09-16 05:23:17','2025-08-16 23:53:17','2025-08-16 23:53:17',NULL),(14,37,8,'2025-08-17 07:42:56','2025-09-16 07:42:56','2025-08-17 02:12:56','2025-08-17 02:12:56',NULL),(15,37,8,'2025-08-17 07:42:58','2025-09-16 07:42:58','2025-08-17 02:12:58','2025-08-17 02:12:58',NULL),(16,51,8,'2025-08-19 16:44:20','2025-09-18 16:44:20','2025-08-19 11:14:20','2025-08-19 11:14:20',NULL),(17,52,8,'2025-08-20 06:28:44','2025-09-19 06:28:44','2025-08-20 00:58:44','2025-08-20 00:58:44',NULL),(18,25,8,'2025-08-20 07:13:02','2025-09-19 07:13:02','2025-08-20 01:43:02','2025-08-20 01:43:02',NULL),(19,10,8,'2025-08-21 11:52:41','2025-09-20 11:52:41','2025-08-21 06:22:41','2025-08-21 06:22:41',NULL),(20,53,8,'2025-08-24 09:52:06','2025-09-23 09:52:06','2025-08-24 04:22:06','2025-08-24 04:22:06',NULL),(21,45,8,'2025-08-25 07:21:34','2025-09-24 07:21:34','2025-08-25 01:51:34','2025-08-25 01:51:34',NULL),(22,54,8,'2025-08-26 08:00:11','2025-09-25 08:00:11','2025-08-26 02:30:11','2025-08-26 02:30:11',NULL),(23,13,8,'2025-08-31 03:20:05','2025-09-30 03:20:05','2025-08-30 21:50:05','2025-08-30 21:50:05',NULL),(24,43,8,'2025-09-07 05:40:01','2025-10-07 05:40:01','2025-09-07 00:10:01','2025-09-07 00:10:01',NULL),(25,43,8,'2025-09-07 05:40:03','2025-10-07 05:40:03','2025-09-07 00:10:03','2025-09-07 00:10:03',NULL),(26,58,5,'2025-09-07 13:08:00','2025-10-07 13:08:00','2025-09-07 07:38:00','2025-09-07 07:38:00',NULL),(27,56,5,'2025-09-07 15:19:53','2025-10-07 15:19:53','2025-09-07 09:49:53','2025-09-07 09:49:53',NULL),(28,56,8,'2025-09-09 07:57:38','2025-10-09 07:57:38','2025-09-09 02:27:38','2025-09-09 02:27:38',NULL),(29,75,8,'2025-09-09 08:51:20','2025-10-09 08:51:20','2025-09-09 03:21:20','2025-09-09 03:21:20',NULL),(30,60,5,'2025-09-10 05:56:32','2025-10-10 05:56:32','2025-09-10 00:26:32','2025-09-10 00:26:32',NULL),(31,60,8,'2025-09-11 06:00:26','2025-10-11 06:00:26','2025-09-11 00:30:26','2025-09-11 00:30:26',NULL),(32,18,5,'2025-09-11 06:34:25','2025-10-11 06:34:25','2025-09-11 01:04:25','2025-09-11 01:04:25',NULL),(33,18,8,'2025-09-11 06:40:58','2025-10-11 06:40:58','2025-09-11 01:10:58','2025-09-11 01:10:58',NULL),(34,81,8,'2025-09-14 09:32:19','2025-10-14 09:32:19','2025-09-14 04:02:19','2025-09-14 04:02:19',NULL),(35,1,8,'2025-09-15 08:06:06','2025-10-15 08:06:06','2025-09-15 02:36:06','2025-09-15 02:36:06',NULL),(36,95,8,'2025-09-15 17:09:04','2025-10-15 17:09:04','2025-09-15 11:39:04','2025-09-15 11:39:04',NULL),(37,105,5,'2025-09-22 10:49:48','2025-10-22 10:49:48','2025-09-22 05:19:48','2025-09-22 05:19:48',NULL),(38,106,5,'2025-09-23 08:29:10','2025-10-23 08:29:10','2025-09-23 02:59:10','2025-09-23 02:59:10',NULL),(39,25,8,'2025-09-25 17:03:02','2025-10-25 17:03:02','2025-09-25 11:33:02','2025-09-25 11:33:02',NULL),(40,159,8,'2025-10-08 15:39:20','2025-11-07 15:39:20','2025-10-08 10:09:20','2025-10-08 10:09:20',NULL);

--
-- Table structure for table `user_reports`
--

CREATE TABLE `user_reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reason_id` int NOT NULL,
  `customer_id` bigint NOT NULL,
  `property_id` bigint NOT NULL,
  `other_message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_reports`
--


--
-- Table structure for table `verify_customer_form_values`
--

CREATE TABLE `verify_customer_form_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `verify_customer_form_id` bigint unsigned NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `verify_customer_form_values_verify_customer_form_id_foreign` (`verify_customer_form_id`),
  CONSTRAINT `verify_customer_form_values_verify_customer_form_id_foreign` FOREIGN KEY (`verify_customer_form_id`) REFERENCES `verify_customer_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_form_values`
--


--
-- Table structure for table `verify_customer_forms`
--

CREATE TABLE `verify_customer_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_type` enum('text','number','radio','checkbox','dropdown','textarea','file') COLLATE utf8mb4_unicode_ci NOT NULL,
  `rank` int DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_forms`
--

INSERT INTO `verify_customer_forms` VALUES (1,'Contact information','text',NULL,'active','2025-08-08 04:33:58','2025-08-19 05:24:42',NULL);

--
-- Table structure for table `verify_customer_values`
--

CREATE TABLE `verify_customer_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `verify_customer_id` bigint unsigned NOT NULL,
  `verify_customer_form_id` bigint unsigned NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_id` (`verify_customer_id`,`verify_customer_form_id`),
  KEY `verify_customer_values_verify_customer_form_id_foreign` (`verify_customer_form_id`),
  CONSTRAINT `verify_customer_values_verify_customer_form_id_foreign` FOREIGN KEY (`verify_customer_form_id`) REFERENCES `verify_customer_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `verify_customer_values_verify_customer_id_foreign` FOREIGN KEY (`verify_customer_id`) REFERENCES `verify_customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_values`
--

INSERT INTO `verify_customer_values` VALUES (1,1,1,'testing ,1234567890','2025-08-08 04:38:25','2025-08-08 04:38:25',NULL),(2,2,1,'9469679994','2025-08-13 10:45:48','2025-08-13 10:45:48',NULL),(3,3,1,'9103553452','2025-08-16 08:09:25','2025-08-16 08:09:25',NULL),(4,4,1,'9103553452','2025-08-16 11:07:04','2025-08-16 11:07:04',NULL),(5,5,1,'6005921088','2025-08-16 23:51:38','2025-08-16 23:51:38',NULL),(6,6,1,'6005760687,9596121217','2025-08-17 02:08:31','2025-08-17 02:08:31',NULL),(7,7,1,'7006881901','2025-08-20 01:21:13','2025-08-20 01:21:13',NULL),(8,8,1,'9622229222','2025-08-24 04:22:27','2025-08-24 04:22:27',NULL),(9,9,1,'7780877112','2025-08-26 02:28:11','2025-08-26 02:28:11',NULL),(10,10,1,'7006569287','2025-09-07 09:25:06','2025-09-07 09:25:06',NULL),(11,11,1,'9103553452','2025-09-07 09:50:20','2025-09-07 09:50:20',NULL),(12,12,1,'7780868751','2025-09-08 01:33:06','2025-09-08 01:33:06',NULL),(13,13,1,'7780877112','2025-09-09 03:14:13','2025-09-09 03:14:13',NULL),(14,14,1,'7889402820','2025-09-09 04:51:27','2025-09-09 04:51:27',NULL),(15,15,1,'7889402820','2025-09-15 00:27:50','2025-09-15 00:27:50',NULL),(16,16,1,'yes','2025-09-24 08:17:32','2025-09-24 08:17:32',NULL);

--
-- Table structure for table `verify_customers`
--

CREATE TABLE `verify_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `status` enum('failed','success','pending') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `verify_customers_user_id_foreign` (`user_id`),
  CONSTRAINT `verify_customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customers`
--

INSERT INTO `verify_customers` VALUES (1,1,'success','2025-08-08 04:38:25','2025-08-24 13:14:24',NULL),(2,32,'success','2025-08-13 10:45:48','2025-08-13 12:19:39',NULL),(3,33,'success','2025-08-16 08:09:25','2025-08-17 01:44:23',NULL),(4,27,'success','2025-08-16 11:07:04','2025-08-16 11:41:02',NULL),(5,36,'success','2025-08-16 23:51:38','2025-08-17 00:11:52',NULL),(6,37,'success','2025-08-17 02:08:31','2025-08-17 02:12:18',NULL),(7,52,'success','2025-08-20 01:21:13','2025-08-20 13:12:20',NULL),(8,53,'success','2025-08-24 04:22:27','2025-08-24 04:45:49',NULL),(9,54,'success','2025-08-26 02:28:11','2025-08-26 02:29:52',NULL),(10,58,'success','2025-09-07 09:25:06','2025-09-07 09:38:05',NULL),(11,56,'success','2025-09-07 09:50:20','2025-09-07 09:50:41',NULL),(12,60,'success','2025-09-08 01:33:06','2025-09-26 07:51:20',NULL),(13,74,'success','2025-09-09 03:14:13','2025-09-12 11:22:33',NULL),(14,18,'pending','2025-09-09 04:51:27','2025-09-09 04:51:27',NULL),(15,80,'pending','2025-09-15 00:27:50','2025-09-15 00:27:50',NULL),(16,105,'pending','2025-09-24 08:17:32','2025-09-24 08:17:32',NULL);


