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

--
-- Table structure for table `coal_buy_materials`
--

CREATE TABLE `coal_buy_materials` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `coal` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `quantity` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `price` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `deals_in` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pref_area_city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pref_area_state` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `community` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `duration` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mobile` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `data_from` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `priority` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `quoted_price` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `target_price` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `quoted_unit` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `target_unit` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call_time` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remarks` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coal_buy_materials`
--

INSERT INTO `coal_buy_materials` (`id`, `deleted_at`, `created_at`, `updated_at`, `coal`, `quantity`, `price`, `company`, `deals_in`, `pref_area_city`, `pref_area_state`, `state`, `city`, `community`, `duration`, `mobile`, `email`, `data_from`, `name`, `priority`, `quoted_price`, `target_price`, `quoted_unit`, `target_unit`, `call_time`, `remarks`) VALUES
(2, NULL, '2023-02-14 09:44:09', '2023-02-14 09:44:09', 'USA Thermal Coal  (High GCV) Vessel : MV  Samjohn ', '22', '50', '', '', NULL, NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, NULL, '2023-02-14 11:47:40', '2023-02-14 11:47:40', 'USA Thermal Coal  (High GCV) Vessel : MV  Samjohn ', '22', '1000', '', '', NULL, NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, NULL, '2023-02-14 11:56:02', '2023-02-14 11:56:02', 'USA Thermal Coal  (High GCV) Vessel : MV  Samjohn ', '22', '1000', '', '', NULL, NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, NULL, '2023-02-14 12:10:40', '2023-02-14 12:10:40', 'USA Thermal Coal  (High GCV) Vessel : MV  Samjohn ', '22', '1000', '', '', NULL, NULL, '', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, NULL, '2024-03-06 06:58:19', '2024-03-06 06:58:19', '', '1000', NULL, 'Company Name', '1', '1106', '11', '11', '1106', 'All India Fuel Community ', '4 Year', '9814607080', 'md.passproviders@gmail.com', 'Fuel Suppliers', 'Karan Shaota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, NULL, '2024-03-06 08:33:34', '2024-03-06 08:33:34', '', '1000', NULL, 'Company Name', '1', '4083', '28', '28', '4083', 'All India Fuel Community ', '3 Year', '9814607080', 'md.passproviders@gmail.com', 'Fuel Suppliers', 'Karan Sahota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, NULL, '2024-03-06 08:34:53', '2024-03-06 08:34:53', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', '2', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, NULL, '2024-03-06 08:35:00', '2024-03-06 08:35:00', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', '2', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, NULL, '2024-03-06 08:35:15', '2024-03-06 08:35:15', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', 'demo', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, NULL, '2024-03-06 08:35:15', '2024-03-06 08:35:15', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', 'demo', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, NULL, '2024-03-06 08:35:15', '2024-03-06 08:35:15', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', 'demo', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, NULL, '2024-03-06 08:35:15', '2024-03-06 08:35:15', '', 'demo', NULL, 'demo', '1', '733', '7', '16', '1873', 'demo', '3 Year', '9988661129', 'demo@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, NULL, '2024-03-06 08:46:56', '2024-03-06 08:46:56', '', '1000', NULL, 'Company Name', '1', '4083', '28', '28', '4083', 'All India Fuel Community ', '3 Year', '9814607080', 'md.passproviders@gmail.com', 'Fuel Suppliers', 'Karan Sahota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, NULL, '2024-03-06 08:48:11', '2024-03-06 08:48:11', '', '1000', NULL, 'Company Name', '1', '4083', '28', '28', '4083', 'All India Fuel Community ', '5 Year', '9814607080', 'md.passproviders@gmail.com', 'Fuel Suppliers', 'Karan Sahota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, NULL, '2024-03-06 08:49:43', '2024-03-06 08:49:43', '', '1000', NULL, 'Company Name', '1', '1873', '16', '16', '1873', 'All India Fuel Community ', '3 Year', '9592607080', 'md.passproviders@gmail.com', 'Fuel Suppliers', 'Karan Sahota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, NULL, '2024-03-06 08:53:07', '2024-03-06 08:53:07', '', 'test', NULL, 'demo', '1', '4083', '28', '29', '4404', 'JILANI', '2 Year', '09814607080', 'mr.vishalnarang@gmail.com', 'Fuel Suppliers', 'pass', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, NULL, '2024-03-06 09:03:25', '2024-03-06 09:03:25', '', NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, '9592607080', NULL, 'Sale Material', 'Karan Sahota', 'Medium (2 - 3 Days)', '9999', '9999', 'MT', 'MT', '3 PM - 6 PM', 'Remarks'),
(19, NULL, '2024-03-06 09:04:11', '2024-03-06 09:04:11', '', '42', NULL, 'Coal Trading', '1', '4670', '31', '35', '5960', 'JILANI', '2 Year', '09814607080', 'mr.vishalnarang@gmail.com', 'Fuel Suppliers', 'Vishal Narang', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, NULL, '2024-03-07 07:14:09', '2024-03-07 07:14:09', '', '20000 mt ', NULL, 'vishwas impex', '794', '4083', '28', '16', '1873', 'JILANI', '5 Year', '09814607080', 'mr.vishalnarang@gmail.com', 'Fuel Suppliers', 'Vishal Narang', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, NULL, '2024-03-08 10:00:27', '2024-03-08 10:00:27', '', '50', NULL, 'Shubh', '795', '5961', '35', '35', '5963', '8', '2 Year', '6283968392', 'admin20@gmail.com', 'Fuel Suppliers', 'shubh', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, NULL, '2024-03-11 05:40:14', '2024-03-11 05:40:14', '', NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, '6283968392', NULL, 'Sale Material', 'vishal', 'High (Today Urgent)', '11500', '12000', 'Quintal', 'MT', '9 AM - 11 AM', 'Remarks'),
(23, NULL, '2024-03-11 05:43:17', '2024-03-11 05:43:17', '', NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, '9988661129', NULL, 'Sale Material', 'vishal', 'Low (1 Week)', '11500', '12000', 'Quintal', 'MT', '9 AM - 11 AM', 'wqwqw'),
(24, NULL, '2024-03-11 05:45:04', '2024-03-11 05:45:04', '', '45', NULL, 'B&S Coal', '779', '1873', '16', '31', '4670', '54', '3 Year', '6283968392', 'admin27@gmail.com', 'Fuel Suppliers', 'myimages', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, NULL, '2024-03-13 06:28:13', '2024-03-13 06:28:13', '', '45', NULL, 'B&S Coal', '782', '4586', '31', '21', '3209', '54', '2 Year', '9988661129', 'admin27@gmail.com', 'Fuel Suppliers', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, NULL, '2024-03-13 06:49:45', '2024-03-13 06:49:45', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9988661129', NULL, 'Sale Material', 'new ', NULL, '11500', '12000', NULL, NULL, NULL, '1000'),
(27, NULL, '2024-03-30 10:18:11', '2024-03-30 10:18:11', '', '50', NULL, 'buy and sell fuel', '778', '4083', '28', '28', '4083', '8', '1 Year', '6283968392', 'vishalsingh.passproviders@gmail.com', 'Fuel Suppliers', 'vishal singh', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, NULL, '2024-04-13 10:56:58', '2024-04-13 10:56:58', '', '200', NULL, 'demo company', '778', '4083', '28', '3', '220', 'no', '2 Year', '7986515358', 'ranjeet.passproviders@gmail.com', 'Fuel Suppliers', 'demo', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, NULL, '2024-04-14 08:14:12', '2024-04-14 08:14:12', '', '200', NULL, 'demo company', '780', '4083', '28', '35', '5964', '000', '3 Year', '7986515358', 'ranjeet.passproviders@gmail.com', 'Fuel Suppliers', 'Users ( New )', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, NULL, '2024-06-07 10:32:25', '2024-06-07 10:32:25', '', '89', NULL, 'company name', '778', '4083', '28', '28', '4101', 'demo', '2 Year', '6363636365', 'shubhpreetsingh7878@gmail.com', 'Fuel Suppliers', 'vishal singh', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, NULL, '2024-06-07 11:36:11', '2024-06-07 11:36:11', '', '12000', NULL, 'VISHWAS IMPEX', '778', '4670', '31', '12', '1319', '', 'More Than 5 Year', '09814607080', 'mr.vishalnarang5@gmail.com ', 'Fuel Suppliers', 'Vishal Narang', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, NULL, '2024-06-08 03:57:11', '2024-06-08 03:57:11', '', '89', NULL, 'sell coal', '794', '4083', '28', '12', '1321', 'xyz', '1 Year', '9292929292', 'shubhpreetsingh7878@gmail.com', 'Fuel Suppliers', 'SUBHPREET Singh', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, NULL, '2024-07-31 13:57:18', '2024-07-31 13:57:18', '', '150000', NULL, 'Company Name (For Established Firms)', '778', '4083', '28', '28', '4083', '15000', '1 Year', '6283968392', 'karan@gmail.com', 'Fuel Suppliers', 'Karan Sahota', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, NULL, '2024-12-10 06:17:57', '2024-12-10 06:17:57', '', '0990990', NULL, 'EMD Co.', '799', '220', '3', '31', '4586', 'kokoko', '5 Year', '7986515358', 'ranjeet.passproviders@gmail.com', 'Fuel Suppliers', 'name from rfuel supploer', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, NULL, '2024-12-10 06:42:40', '2024-12-10 06:42:40', '', '9009', NULL, 'COMPANY FROM SUPLLIER', '781', '4083', '28', '12', '1319', 'kokoko', '5 Year', '7986515358', 'ranjeet.passproviders@gmail.com', 'Fuel Suppliers', 'name from supplier', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, NULL, '2024-12-10 07:18:46', '2024-12-10 07:18:46', '', '0990990', NULL, 'COMPANY FROM SUPLLIER', '785', '4582', '31', '28', '4074', 'kokokop', 'More Than 5 Year', '7986515358', 'ranjeet.passproviders@gmail.com', 'Fuel Suppliers', 'name from supplier', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, NULL, '2024-12-10 07:24:41', '2024-12-10 07:24:41', '', '9009', NULL, 'comapny name from vendor', '783', '2219', '17', '16', '1873', 'kokokop', 'More Than 5 Year', '7986515358', 'rahul.passproviders@gmail.com', 'Fuel Suppliers', 'name from rfuel supploer', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, NULL, '2024-12-10 07:32:42', '2024-12-10 07:32:42', '', '0990990', NULL, 'COMPANY FROM SUPLLIER', '787', '742', '7', '16', '1873', 'kokokop', 'More Than 5 Year', '7986515358', 'ranjeet@gmail.com', 'Fuel Suppliers', 'name from supplier', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, NULL, '2024-12-10 07:34:25', '2024-12-10 07:34:25', '', '0990990', NULL, 'Company Name (For Established Firms)', '782', '733', '7', '7', '733', 'kokoko', '1 Year', '8888888808', 'ranjeet.passpvvroviders@gmail.com', 'Fuel Suppliers', 'Please fill your Name', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, NULL, '2024-12-10 07:36:46', '2024-12-10 07:36:46', '', '9009', NULL, 'Company Name (For Established Firms)', '786', '6073', '35', '35', '6012', 'kokokop', '5 Year', '7986515358', 'ranjeet.passpvvroviders@gmail.com', 'Fuel Suppliers', 'Ranjeet Singh', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
