- 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
- ;