create table urls (
  raw text,
  protocol text,
  host ,
  path ,
  port text,
  query ,
  hash text,
  variable 
);

comment on column urls.raw is '
  The string representation of the request URL, including the protocol, host, path, hash, query parameter(s) and path variable(s).
';
comment on column urls.protocol is '
  The protocol_ associated with the request, E.g: 'http'
';
comment on column urls.host is '
  The host for the URL, E.g: api.yourdomain.com. Can be stored as a string or as an array of strings.
';
comment on column urls.port is '
  The port number present in this URL. An empty value implies 80/443 depending on whether the protocol_ field contains http/https.
';
comment on column urls.hash is '
  Contains the URL fragment (if any). Usually this is not transmitted over the network, but it could be useful to store this in some cases.
';
comment on column urls.variable is '
  Postman supports path variables with the syntax /path/:variableName/to/somewhere. These variables are stored in this field.
';