create table deployments (
  id text not null,
  created timestamptz not null,
  started timestamptz not null,
  completed timestamptz not null,
  creator text not null,
  deployment_group_name text not null,
  failed integer not null,
  skipped integer not null,
  in_progress integer not null,
  pending integer not null,
  succeeded integer not null,
  status text not null,
  error_message text,
  revision_location text not null,
  instances 
);

comment on column deployments.id is '
  The deployment id
';
comment on column deployments.created is '
  Date deployment created
';
comment on column deployments.started is '
  Date deployment started
';
comment on column deployments.completed is '
  Date deployment created
';
comment on column deployments.deployment_group_name is '
  The deployment group name
';
comment on column deployments.failed is '
  The number of instances failed deployment
';
comment on column deployments.skipped is '
  The number of instances skipped deployment
';
comment on column deployments.in_progress is '
  The number of instances currently deploying
';
comment on column deployments.pending is '
  The number of instances pending deployment
';
comment on column deployments.succeeded is '
  The number of instances succeeded at deployment
';
comment on column deployments.status is '
  The status of the deployment
';
comment on column deployments.error_message is '
  A error message if the deployment failed
';
comment on column deployments.revision_location is '
  The location of the revision
';
comment on column deployments.instances is '
  The instances involved in this deployment
';