id	bigint(20) unsigned	NO	PRI
code	varchar(30)	NO	UNI
item_code_description	text	YES	
prefix_id	bigint(20) unsigned	YES	MUL
item_type	varchar(80)	YES	MUL
supplier_item_code	varchar(100)	YES	
description	varchar(255)	YES	
composition	varchar(255)	YES	
composition_json	text	YES	
construction	varchar(120)	YES	
weight	varchar(50)	YES	
weight_type	varchar(50)	YES	
color_id	bigint(20) unsigned	YES	MUL
finish_id	bigint(20) unsigned	YES	MUL
finish	varchar(120)	YES	
width_1	varchar(50)	YES	
width_type_1	varchar(50)	YES	
width_2	varchar(50)	YES	
width_type_2	varchar(50)	YES	
tex	varchar(50)	YES	
tkt	varchar(50)	YES	
yarn_count	varchar(50)	YES	
length_value	varchar(50)	YES	
length_type	varchar(50)	YES	
zipper_no	varchar(80)	YES	
lock_type	varchar(80)	YES	
end_type	varchar(80)	YES	
zipper_tape_color_id	bigint(20) unsigned	YES	MUL
default_uom_id	bigint(20) unsigned	YES	MUL
future_1	varchar(120)	YES	
future_2	varchar(120)	YES	
future_3	varchar(120)	YES	
future_4	varchar(120)	YES	
future_5	varchar(120)	YES	
future_6	varchar(120)	YES	
other_information	text	YES	
supplier_id	bigint(20) unsigned	YES	MUL
status	enum('active','inactive')	NO	
created_at	timestamp	NO	
updated_at	timestamp	NO	
deleted_at	timestamp	YES