create table clickouts (
  product_id text not null,
  seller text not null,
  seller_product_id text not null,
  price numeric not null,
  deep_url text not null,
  lowest_price numeric not null,
  highest_price numeric not null,
  offer_count integer not null default 1,
  offer_position integer not null,
  category_id text not null,
  tracking ,
  creation_time timestamptz not null
);
comment on table clickouts is '
  Represents an Offer click-out. It contains all the information needed to properly identify the offer, trace it ot the user navigating from search page, and relevant information about the offer at the click-out moment (e.g.: price, lowest price among other offers, etc.)
';

comment on column clickouts.product_id is '
  Product identifier
';
comment on column clickouts.seller is '
  Seller/Retailer unique identifier
';
comment on column clickouts.seller_product_id is '
  Product as identifier given by the seller/retailer
';
comment on column clickouts.price is '
  Offer price at the moment of the click-out
';
comment on column clickouts.deep_url is '
  Full product URL at the retailer side
';
comment on column clickouts.lowest_price is '
  Lowest price among all offers
';
comment on column clickouts.highest_price is '
  Seller/Retailer unique identifier
';
comment on column clickouts.offer_count is '
  Number of offers
';
comment on column clickouts.offer_position is '
  Offer position among other offers (e.g.: first, second, etc.)
';
comment on column clickouts.category_id is '
  Category where the product was put into
';
comment on column clickouts.tracking is '
  Tracking information
';
comment on column clickouts.creation_time is '
  When this click-out happened
';