1JLrXpsT

1CREATE TABLE IF NOT EXISTS Item(
2                                    i_item_sk integer ,
3                                    i_item_id char(16) NOT NULL,
4                                    i_rec_start_date date,
5                                    i_rec_end_date date,
6                                    i_item_desc varchar(200),
7                                    i_current_price decimal(7,2),
8                                    i_wholesale_cost decimal (7,2),
9                                    i_brand_id integer,
10                                    i_brand char(50),
11                                    i_class_id integer default ,
12                                    i_class char(50),
13                                    i_category_id integer,
14                                    i_category char(50),
15                                    i_manufact_id integer,
16                                    i_manufact char(50),
17                                    i_size char(20),
18                                    i_formulation char(20),
19                                    i_color char(20),
20                                    i_units char(10),
21                                    i_container char(10),
22                                    i_manager_id integer,
23                                    i_product_name char(50),
24                                    PRIMARY KEY (i_item_sk)
25);