create table deployment_lifecycle_events (
  name text not null,
  start_time timestamptz not null,
  end_time timestamptz not null,
  status text not null,
  error_log_tail text,
  error_message text,
  script_name text
);

comment on column deployment_lifecycle_events.name is '
  The deployment lifecycle event name
';
comment on column deployment_lifecycle_events.start_time is '
  Time the deployment lifecycle event started
';
comment on column deployment_lifecycle_events.end_time is '
  Time the deployment lifecycle event ended
';
comment on column deployment_lifecycle_events.status is '
  The status of the deployment lifecycle event
';
comment on column deployment_lifecycle_events.error_log_tail is '
  The deployment lifecycle event log tail if it failed
';
comment on column deployment_lifecycle_events.error_message is '
  The deployment lifecycle event error message if it failed
';
comment on column deployment_lifecycle_events.script_name is '
  The deployment lifecycle event script filename if it failed
';