create table products (
  id bigint,
  title text,
  handle text,
  description text,
  description_html text,
  item_count integer,
  product_type text,
  gender text,
  colors ,
  sizes ,
  images ,
  variants ,
  breadcrumbs ,
  details ,
  created_at text,
  updated_at text
);

comment on column products.id is '
  An unsigned 64-bit integer that's used as a unique identifier for the product. Each id is unique across the Shopify system. No two products will have the same id, even if they're from different shops.
';
comment on column products.title is '
  The name of the product.
';
comment on column products.handle is '
  A unique human-friendly string for the product. Automatically generated from the product's title. Used by the Liquid templating language to refer to objects.
';
comment on column products.description is '
  A description of the product.
';
comment on column products.description_html is '
  A description of the product. Supports HTML formatting.
';
comment on column products.item_count is '
  The number of units included. If it is > 1, then it is a pack.
';
comment on column products.product_type is '
  The product type
';
comment on column products.gender is '
  The marketed gender of the products
';
comment on column products.created_at is '
  The date and time (ISO 8601 format) when the product was created.
';
comment on column products.updated_at is '
  The date and time (ISO 8601 format) when the product was last modified.
';