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

--
-- Table structure for table `create_quotations`
--

CREATE TABLE `create_quotations` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `company_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `suggested_package_nm` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pasic_pack_amount` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gst` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `total_bill_amount :` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone_no` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `gstin` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pan_no` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_time` timestamp NOT NULL,
  `quotation_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `create_quotations` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_by` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `create_quotations`
--

INSERT INTO `create_quotations` (`id`, `deleted_at`, `created_at`, `updated_at`, `customer_type`, `user_id`, `name`, `company_name`, `suggested_package_nm`, `pasic_pack_amount`, `gst`, `total_bill_amount :`, `email`, `phone_no`, `address`, `gstin`, `pan_no`, `date_time`, `quotation_id`, `create_quotations`, `created_by`) VALUES
(1, NULL, '2022-08-27 16:39:03', '2022-08-27 16:39:03', 'new', '1', 'vishal narang', 'pass', 'dsad', 'asdas', 'dasd', '', 'sdad', 'asdassa', 'dasdas', 'dasdas', 'dasdasd', '0000-00-00 00:00:00', '1', 'asdasdas', '1'),
(2, NULL, '2022-09-15 04:59:54', '2022-09-15 04:59:54', '', '1856', 'ranjeet singh', 'abc', '', '25000', '4500', '', 'ranjeet.passproviders@gmail.com', '7986515358', 'abc address', 'No GST', 'NO PAN', '0000-00-00 00:00:00', '150', '', '1');
