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

--
-- Table structure for table `field_mappings`
--

CREATE TABLE `field_mappings` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_order_value` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `needed_for` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `usage_application` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `size` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `color` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pattern` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `fabric` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `preferred_brand` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `voltage` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `storage_capacity` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `why_want` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `packaging_type` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `rfq_id` int NOT NULL,
  `quantity` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `requirement_details` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `price` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coal_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pet_coal_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `port` int UNSIGNED NOT NULL DEFAULT '1',
  `vessel` int UNSIGNED NOT NULL DEFAULT '1',
  `size_list` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coa_report` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]',
  `expire_dt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `emd` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lifting_from` date NOT NULL,
  `lifting_till` date NOT NULL,
  `token_money` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `is_tcs` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `available_state` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]',
  `product_img` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '[]',
  `pending_amount` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `application` int UNSIGNED NOT NULL DEFAULT '1',
  `material` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `i_am_interested_in` int UNSIGNED NOT NULL DEFAULT '1',
  `age` int UNSIGNED NOT NULL DEFAULT '1',
  `age_group` int UNSIGNED NOT NULL DEFAULT '1',
  `lighting_color` int UNSIGNED NOT NULL DEFAULT '1',
  `locality_type` int UNSIGNED NOT NULL DEFAULT '1',
  `max_bind_sheet_width` int UNSIGNED NOT NULL DEFAULT '1',
  `set_contains` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `size_diameter` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `Size_Inch` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `size_required` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `what_you_intersted` int UNSIGNED NOT NULL DEFAULT '1',
  `cumin_seed_required` int UNSIGNED NOT NULL DEFAULT '1',
  `waste_input` int UNSIGNED NOT NULL DEFAULT '1',
  `wood_type` int UNSIGNED NOT NULL DEFAULT '1',
  `required_from` date NOT NULL,
  `billing_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `avail_ppp-service` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `loading_authority` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `my_demo_field` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `payment _emd_terms` int UNSIGNED NOT NULL DEFAULT '1',
  `add_number_of_days` int UNSIGNED NOT NULL DEFAULT '1',
  `volatile_matter` int UNSIGNED NOT NULL DEFAULT '1',
  `fixed_carbon` int UNSIGNED NOT NULL DEFAULT '1',
  `sulfur` int UNSIGNED NOT NULL DEFAULT '1',
  `rejection` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `packing` int UNSIGNED NOT NULL DEFAULT '1',
  `gcv` int UNSIGNED NOT NULL DEFAULT '1',
  `particle_size` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `requirement_tenure` int UNSIGNED NOT NULL DEFAULT '1',
  `yearly_quantity` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `acceptable_order` int UNSIGNED NOT NULL DEFAULT '1',
  `rejection_moisture` int UNSIGNED NOT NULL DEFAULT '1',
  `quantity_period_type` int UNSIGNED NOT NULL DEFAULT '1',
  `min_accept_order` int UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `field_mappings`
--

INSERT INTO `field_mappings` (`id`, `deleted_at`, `created_at`, `updated_at`, `total_order_value`, `needed_for`, `usage_application`, `size`, `color`, `pattern`, `fabric`, `preferred_brand`, `voltage`, `storage_capacity`, `why_want`, `packaging_type`, `rfq_id`, `quantity`, `type`, `requirement_details`, `price`, `coal_type`, `pet_coal_type`, `port`, `vessel`, `size_list`, `coa_report`, `expire_dt`, `emd`, `lifting_from`, `lifting_till`, `token_money`, `is_tcs`, `available_state`, `product_img`, `pending_amount`, `application`, `material`, `i_am_interested_in`, `age`, `age_group`, `lighting_color`, `locality_type`, `max_bind_sheet_width`, `set_contains`, `size_diameter`, `Size_Inch`, `size_required`, `what_you_intersted`, `cumin_seed_required`, `waste_input`, `wood_type`, `required_from`, `billing_type`, `avail_ppp-service`, `loading_authority`, `my_demo_field`, `payment _emd_terms`, `add_number_of_days`, `volatile_matter`, `fixed_carbon`, `sulfur`, `rejection`, `packing`, `gcv`, `particle_size`, `requirement_tenure`, `yearly_quantity`, `acceptable_order`, `rejection_moisture`, `quantity_period_type`, `min_accept_order`) VALUES
(1, NULL, '2020-12-26 23:00:27', '2020-12-26 23:00:27', '', '', '', '100 mm ', '', '', '', '', '', '', '', '', 4, '', '', '', '', '', '', 1, 1, '', '[]', '', '', '0000-00-00', '0000-00-00', '', '', '[]', '[]', '', 1, '', 1, 1, 1, 1, 1, 1, '', '', '', '', 1, 1, 1, 1, '0000-00-00', '', '', '', '', 1, 1, 1, 1, 1, '', 1, 1, '', 1, '', 1, 1, 1, 1);
