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

--
-- Table structure for table `parties`
--

CREATE TABLE `parties` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `party_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `address` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `gst_number` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `mobile` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `party_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `parties`
--

INSERT INTO `parties` (`id`, `deleted_at`, `created_at`, `updated_at`, `party_name`, `address`, `gst_number`, `email`, `mobile`, `party_type`) VALUES
(1, '2020-11-05 09:33:08', '2020-09-22 22:49:58', '2020-11-05 09:33:08', 'VNU COAL PVT LIMITED', 'GANDHIDHAM, GUJRAT ', 'AAAAAAAAAAAAAAAA', 'mr.vishalnarang@gmail.com', '', ''),
(2, '2020-11-05 09:33:13', '2020-09-22 22:50:27', '2020-11-05 09:33:13', 'DIWAN COAL ', 'GANDHIDHAM GUJRAT ', '', '', '', ''),
(4, NULL, '2020-10-18 08:52:45', '2020-10-18 08:52:45', 'Mahalaxmi coal', 'lkmnl', 'AAAAAAAAAAAAAAAb', 'paras190@gmail.com', '9814607080', ''),
(5, '2020-11-05 09:33:25', '2020-10-23 03:23:29', '2020-11-05 09:33:25', 'Consol ', 'Hydrabad\r\n', 'Dhfgtgcbkkvxfffg', 'mr.vishalnarang6@gmail.com', '9814607080', ''),
(6, '2020-11-05 09:34:40', '2020-10-24 10:45:26', '2020-11-05 09:34:40', 'gupta readers', '1212', 'AAAAAAAAAAAAAAAA', 'md.passproviders336@gmail.com', '9814607055', ''),
(7, NULL, '2021-05-09 19:55:23', '2021-05-09 19:55:23', 'coal shastra ', 'New Dehli', '1234567891234567', 'coalshastra@gmai.com', '9056040248', 'Creditors');
