CREATE TABLE `tabItem` (
	`name` VARCHAR(140) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`creation` DATETIME(6) NULL DEFAULT NULL,
	`modified` DATETIME(6) NULL DEFAULT NULL,
	`modified_by` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`owner` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`docstatus` INT(1) NOT NULL DEFAULT '0',
	`parent` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`parentfield` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`parenttype` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`idx` INT(8) NOT NULL DEFAULT '0',
	`naming_series` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`item_code` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`variant_of` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`item_name` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`item_group` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`is_item_from_hub` INT(1) NOT NULL DEFAULT '0',
	`stock_uom` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`disabled` INT(1) NOT NULL DEFAULT '0',
	`allow_alternative_item` INT(1) NOT NULL DEFAULT '0',
	`is_stock_item` INT(1) NOT NULL DEFAULT '1',
	`include_item_in_manufacturing` INT(1) NOT NULL DEFAULT '1',
	`opening_stock` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`valuation_rate` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`standard_rate` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`is_fixed_asset` INT(1) NOT NULL DEFAULT '0',
	`auto_create_assets` INT(1) NOT NULL DEFAULT '0',
	`asset_category` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`asset_naming_series` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`over_delivery_receipt_allowance` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`over_billing_allowance` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`image` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`brand` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`description` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`shelf_life_in_days` INT(11) NOT NULL DEFAULT '0',
	`end_of_life` DATE NULL DEFAULT '2099-12-31',
	`default_material_request_type` VARCHAR(140) NULL DEFAULT 'Purchase' COLLATE 'utf8mb4_unicode_ci',
	`valuation_method` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`warranty_period` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`weight_per_unit` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`weight_uom` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`has_batch_no` INT(1) NOT NULL DEFAULT '0',
	`create_new_batch` INT(1) NOT NULL DEFAULT '0',
	`batch_number_series` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`has_expiry_date` INT(1) NOT NULL DEFAULT '0',
	`retain_sample` INT(1) NOT NULL DEFAULT '0',
	`sample_quantity` INT(11) NOT NULL DEFAULT '0',
	`has_serial_no` INT(1) NOT NULL DEFAULT '0',
	`serial_no_series` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`has_variants` INT(1) NOT NULL DEFAULT '0',
	`variant_based_on` VARCHAR(140) NULL DEFAULT 'Item Attribute' COLLATE 'utf8mb4_unicode_ci',
	`is_purchase_item` INT(1) NOT NULL DEFAULT '1',
	`purchase_uom` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`min_order_qty` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`safety_stock` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`lead_time_days` INT(11) NOT NULL DEFAULT '0',
	`last_purchase_rate` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`is_customer_provided_item` INT(1) NOT NULL DEFAULT '0',
	`customer` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`delivered_by_supplier` INT(1) NOT NULL DEFAULT '0',
	`country_of_origin` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`customs_tariff_number` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`sales_uom` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`is_sales_item` INT(1) NOT NULL DEFAULT '1',
	`max_discount` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`deferred_revenue_account` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`enable_deferred_revenue` INT(1) NOT NULL DEFAULT '0',
	`no_of_months` INT(11) NOT NULL DEFAULT '0',
	`deferred_expense_account` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`enable_deferred_expense` INT(1) NOT NULL DEFAULT '0',
	`no_of_months_exp` INT(11) NOT NULL DEFAULT '0',
	`inspection_required_before_purchase` INT(1) NOT NULL DEFAULT '0',
	`inspection_required_before_delivery` INT(1) NOT NULL DEFAULT '0',
	`quality_inspection_template` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`default_bom` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`is_sub_contracted_item` INT(1) NOT NULL DEFAULT '0',
	`customer_code` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`default_item_manufacturer` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`default_manufacturer_part_no` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`show_in_website` INT(1) NOT NULL DEFAULT '0',
	`show_variant_in_website` INT(1) NOT NULL DEFAULT '0',
	`route` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`weightage` INT(11) NOT NULL DEFAULT '0',
	`slideshow` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`website_image` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`website_image_alt` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`thumbnail` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`website_warehouse` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`web_long_description` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`website_content` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`total_projected_qty` DECIMAL(18,6) NOT NULL DEFAULT '0.000000',
	`publish_in_hub` INT(1) NOT NULL DEFAULT '0',
	`hub_category_to_publish` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`hub_warehouse` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`synced_with_hub` INT(1) NOT NULL DEFAULT '0',
	`_user_tags` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`_comments` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`_assign` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`_liked_by` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`hub_sync_id` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`gst_hsn_code` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`is_nil_exempt` INT(1) NOT NULL DEFAULT '0',
	`is_non_gst` INT(1) NOT NULL DEFAULT '0',
	`test` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`ab` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`print_code` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`mfg_part_no` VARCHAR(140) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	PRIMARY KEY (`name`) USING BTREE,
	UNIQUE INDEX `item_code` (`item_code`) USING BTREE,
	UNIQUE INDEX `hub_sync_id` (`hub_sync_id`) USING BTREE,
	UNIQUE INDEX `ab` (`ab`) USING BTREE,
	UNIQUE INDEX `ab_2` (`ab`) USING BTREE,
	INDEX `variant_of` (`variant_of`) USING BTREE,
	INDEX `item_name` (`item_name`) USING BTREE,
	INDEX `item_group` (`item_group`) USING BTREE,
	INDEX `show_in_website` (`show_in_website`) USING BTREE,
	INDEX `show_variant_in_website` (`show_variant_in_website`) USING BTREE,
	INDEX `parent` (`parent`) USING BTREE,
	INDEX `modified` (`modified`) USING BTREE,
	INDEX `route_index` (`route`(500)) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
;