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

--
-- Table structure for table `customer_property_type`
--

CREATE TABLE `customer_property_type` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `property_category` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `property_type` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `user_id` int DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'Pending',
  `reason` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `product_id` int DEFAULT NULL,
  `host` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customer_property_type`
--

INSERT INTO `customer_property_type` (`id`, `deleted_at`, `created_at`, `updated_at`, `property_category`, `property_type`, `user_id`, `status`, `reason`, `product_id`, `host`) VALUES
(10, NULL, '2025-11-21 18:23:20', '2025-11-21 12:53:20', 'Commercial Building', 'Commercial Building', 5286, 'Pending', NULL, 1017052, NULL),
(11, NULL, '2025-11-21 18:23:56', '2025-11-21 12:53:56', 'Commercial Shop', 'Commercial Shop', 5286, 'Pending', NULL, 1017053, NULL),
(12, NULL, '2025-11-22 19:06:03', '2025-11-22 13:36:03', 'Commercial Property', 'Two Wheeler Showroom', 5129, 'Pending', NULL, 1017054, NULL),
(14, NULL, '2025-11-23 14:10:33', '2025-11-23 08:40:33', 'Agricultural Real Estate', 'Land Leased To Ntpc For Solar Project ( Ownership + Rental Opportunity)', 5314, 'Pending', NULL, 1017056, NULL),
(15, NULL, '2025-11-23 15:54:35', '2025-11-23 10:24:35', 'Industrial Real Estate', 'Factory (Shed And Land) Setup', 5316, 'Pending', NULL, 1017057, NULL),
(16, NULL, '2025-11-25 13:33:50', '2025-11-25 08:03:50', 'Industrial Real Estate', 'Running Biomass Pellets Plant', 5318, 'Pending', NULL, 1017058, NULL),
(17, NULL, '2025-11-25 13:33:50', '2025-11-25 08:04:24', 'Industrial Real Estate', 'Closed Biomass Pellets Plant', 5318, 'Pending', NULL, 1017060, NULL),
(18, NULL, '2025-11-25 13:35:31', '2025-11-25 08:05:31', 'Industrial Real Estate', 'Closed Biomass Briquettes Plant', 5318, 'Pending', NULL, 1017061, NULL),
(19, NULL, '2025-11-25 13:36:00', '2025-11-25 08:06:00', 'Industrial Real Estate', 'Running Biomass Briquettes Plant', 5318, 'Pending', NULL, 1017062, NULL),
(20, NULL, '2025-11-25 13:36:34', '2025-11-25 08:06:34', 'Industrial Real Estate', 'Running Steel Plant', 5318, 'Pending', NULL, 1017063, NULL),
(21, NULL, '2025-11-25 13:37:11', '2025-11-25 08:07:11', 'Industrial Real Estate', 'Running Plywood Plant', 5318, 'Pending', NULL, 1017064, NULL),
(22, NULL, '2025-11-25 13:37:11', '2025-11-25 08:07:11', 'Industrial Real Estate', 'Running Plywood Plant', 5318, 'Pending', NULL, 1017065, NULL),
(23, NULL, '2025-11-25 13:37:58', '2025-11-25 08:07:58', 'Industrial Real Estate', 'Running Rice Sheller', 5318, 'Pending', NULL, 1017066, NULL),
(24, NULL, '2025-11-25 13:38:45', '2025-11-25 08:08:45', 'Industrial Real Estate', 'Closed Rice Sheller Land & Building', 5318, 'Pending', NULL, 1017067, NULL),
(25, NULL, '2025-11-26 13:20:59', '2025-11-26 07:50:59', 'Residential Real Estate', 'Residential Villa', 5129, 'Pending', NULL, 1017068, NULL),
(26, '2025-11-26 07:51:28', '2025-11-26 13:20:59', '2025-11-26 07:50:59', 'Residential Real Estate', 'Residential Villa', 5129, 'Pending', NULL, 1017069, NULL),
(27, NULL, '2025-11-26 13:21:50', '2025-11-26 07:51:50', 'Commercial Real Estate', 'Commercial Villa', 5129, 'Pending', NULL, 1017070, NULL),
(40, '2025-11-28 05:29:32', '2025-11-26 18:46:27', '2025-11-26 13:16:27', 'Other Property', 'Jj', 1, 'Already Exist', NULL, 1017091, NULL),
(41, '2025-11-28 05:29:32', '2025-11-28 10:52:03', '2025-11-28 05:22:03', '', 'Ccc', 1, 'Pending', NULL, 1017092, 'propertydeal4u.com'),
(42, '2025-11-28 05:29:32', '2025-11-28 10:54:22', '2025-11-28 05:24:22', 'Other Property', 'Sfdf', 1, 'Pending', NULL, 1017093, NULL),
(43, '2025-11-28 05:29:34', '2025-11-28 10:55:07', '2025-11-28 05:25:07', 'Other Property', 'Ccc', 1, 'Already Exist', NULL, 1017092, NULL),
(44, '2025-11-28 05:29:34', '2025-11-28 10:56:18', '2025-11-28 05:26:18', '', 'S', 1, 'Pending', NULL, 1017055, 'propertydeal4u.com'),
(45, '2025-11-28 05:29:33', '2025-11-28 10:57:37', '2025-11-28 05:27:37', 'Other Property', 'Sddd', 1, 'Pending', NULL, 1017094, 'propertydeal4u.com'),
(46, NULL, '2025-12-04 16:26:23', '2025-12-04 10:56:23', 'Industrial Real Estate', 'Running Rice Sheller For Paddy Shelling', 1, 'Pending', NULL, 1017095, 'propertydeal4u.com'),
(47, NULL, '2025-12-04 16:28:32', '2025-12-04 10:58:32', 'Industrial Real Estate', 'Complete Non-Running Rice Sheller For Biomass Pellet Unit', 1, 'Pending', NULL, 1017096, 'propertydeal4u.com'),
(48, NULL, '2025-12-04 16:29:28', '2025-12-04 10:59:28', 'Industrial Real Estate', 'Partial Non-Running Rice Sheller For Biomass Pellet Plant', 1, 'Pending', NULL, 1017097, 'propertydeal4u.com'),
(49, NULL, '2025-12-04 16:30:18', '2025-12-04 11:00:18', 'Agricultural Real Estate', 'Agricultural Land For Farming', 1, 'Pending', NULL, 1017098, 'propertydeal4u.com'),
(50, NULL, '2025-12-04 16:31:06', '2025-12-04 11:01:06', 'Agricultural Real Estate', 'Agricultural Land For Paddy Straw / Cane Trash Stock', 1, 'Pending', NULL, 1017099, 'propertydeal4u.com'),
(51, NULL, '2025-12-04 16:32:00', '2025-12-04 11:02:00', 'Commercial Real Estate', 'Showroom For Brands', 1, 'Pending', NULL, 1017100, 'propertydeal4u.com'),
(52, NULL, '2025-12-04 16:32:30', '2025-12-04 11:03:09', 'Commercial Real Estate', 'Showroom Without Roof For Retail', 1, 'Pending', NULL, 1017102, 'propertydeal4u.com'),
(53, NULL, '2025-12-04 16:33:54', '2025-12-04 11:03:54', 'Commercial Real Estate', 'Showroom With First Floor For Retail', 1, 'Pending', NULL, 1017103, 'propertydeal4u.com'),
(54, NULL, '2025-12-04 19:03:31', '2025-12-04 13:33:31', 'Industrial Real Estate', 'C L U Land For Biomass Pellets Plant With Office Without Electricity Connection', 4859, 'Pending', NULL, 1017104, 'propertydeal4u.com'),
(55, NULL, '2025-12-04 19:04:25', '2025-12-04 13:34:25', 'Industrial Real Estate', 'C L U Land With Electricity Connection For Biomass Pellets Plant With Office', 4859, 'Pending', NULL, 1017105, 'propertydeal4u.com'),
(56, NULL, '2025-12-11 21:25:45', '2025-12-11 15:55:45', 'Commercial Real Estate', 'Leased Hospital', 5129, 'Pending', NULL, 1017111, 'propertydeal4u.com'),
(57, NULL, '2025-12-11 21:26:15', '2025-12-11 15:56:15', 'Commercial Real Estate', 'Leased Hotel', 5129, 'Pending', NULL, 1017112, 'propertydeal4u.com'),
(58, NULL, '2025-12-12 11:48:46', '2025-12-12 06:18:46', 'Residential Real Estate', 'Residential Kothi Fully Furnished', 5262, 'Pending', NULL, 1017117, 'propertydeal4u.com'),
(59, NULL, '2025-12-15 22:33:25', '2025-12-15 17:03:25', 'Commercial Real Estate', 'Plot For S C O (Shop Cum Office)', 5129, 'Pending', NULL, 1017118, 'propertydeal4u.com'),
(60, NULL, '2025-12-25 20:27:46', '2025-12-25 14:57:46', 'Commercial Real Estate', 'Commercial Floors For Hospital With Stretcher Lift', 5129, 'Pending', NULL, 1017119, 'propertydeal4u.com');
