create table items (
  svs_number integer not null,
  sku_number integer not null,
  upc_number integer,
  class_number integer,
  color text,
  size text,
  current_status text not null,
  department integer not null,
  sign_on_delivery text,
  gift_wrapped boolean,
  cost_amount numeric,
  margin_amount numeric,
  description text not null,
  price numeric not null,
  extended_price numeric not null,
  quantity integer not null,
  group_number integer not null,
  shipping_address ,
  shipping_method text not null,
  shipping_country text not null
);
comment on table items is '
  Single item
';

comment on column items.svs_number is '
  Product style number (parent number)
';
comment on column items.sku_number is '
  HBC internally generated number for items (alias SKN)
';
comment on column items.upc_number is '
  The number on the barcode that could be used across different retailers
';
comment on column items.class_number is '
  Signifies business category of an item (pants, tops, shirts, etc.)
';
comment on column items.price is '
  Price of single item
';
comment on column items.extended_price is '
  Total price of all items ordered
';