create table recommendations (
  product_id text not null,
  product_name text not null,
  product_url text not null,
  product_image_url text not null,
  brand_name text not null,
  price ,
  rating numeric,
  num_reviews bigint
);

comment on column recommendations.rating is '
  customer review's rating
';
comment on column recommendations.num_reviews is '
  number of customers that reviewed the product
';