CREATE TABLE workflow (
  workflow_id       integer not null primary key,
  type              varchar(50) not null,
  state             varchar(30) not null,
  last_update       timestamp
);

CREATE TABLE workflow_history (
  workflow_hist_id  integer not null primary key,
  workflow_id       int not null,
  action            varchar(25) not null,
  description       varchar(255) null,
  state             varchar(30) not null,
  workflow_user     varchar(50) null,
  history_date      timestamp,
  foreign key (workflow_id) references workflow(workflow_id)
);