Workflow reporting tables

Check the Postgres, Db2 statements for the tables that are related to workflows.

Subject area Table name Description
Workflow workflow_types The workflow types.
Workflow workflow_templates The workflow templates.
Workflow workflow_configurations The workflow configurations.
Workflow workflows The workflows.
Workflow workflow_tasks The workflow tasks.

workflow_types

This table contains information about workflow types.

This table has the following columns:

  • type_id - Identifier for the workflow type.
  • name - Specifies name of the workflow type.
  • type - The type (for example governanance_artifacts).

Postgres

CREATE TABLE statement:

create table workflow_types(type_id varchar(128) not null,
name varchar(256) not null,
type varchar(256) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(type_id))


Db2

CREATE TABLE statement:

create table workflow_types(type_id varchar(128) not null,
name varchar(256) not null,
type varchar(256) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(type_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

workflow_templates table

This table contains information about the workflow templates.

This table has the following columns:

  • template_key - Identifier of the workflow template.
  • type_id - Identifier of the workflow type this template belongs to.
  • name - The name of the workflow template.
  • is_suspended - Specifies whether the workflow template is suspended or active(boolean).

Postgres

CREATE TABLE statement:

create table workflow_templates(template_key varchar(128) not null,
type_id varchar(128) not null,
name varchar(256) not null,
is_suspended boolean not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(template_key))

ALTER TABLE statement:

alter table workflow_templates add constraint fk_workflow_templates_workflow_types_1 foreign key (type_id) references workflow_types(type_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table workflow_templates(template_key varchar(128) not null,
type_id varchar(128) not null,
name varchar(256) not null,
is_suspended boolean not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(template_key),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table workflow_templates add constraint fk_workflow_templates_workflow_types_1 foreign key (type_id) references workflow_types(type_id) on
delete
	cascade on
	update
	no action

workflow_configurations table

This table contains information about the workflow configurations.

This table has the following columns:

  • configuration_id - The identifier of the workflow configuration
  • name - The name of the workflow configuration
  • template_key - The identifier of the template to which the workflow belongs
  • state - Specifies whether the configuration is active or unavailable.

Postgres

CREATE TABLE statement:

create table workflow_configurations(configuration_id varchar(128) not null,
name varchar(256) not null,
template_key varchar(128) not null,
state varchar(256) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(configuration_id))

ALTER TABLE statement:

alter table workflow_configurations add constraint fk_workflow_configurations_workflow_templates_2 foreign key (template_key) references workflow_templates(template_key) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table workflow_configurations(configuration_id varchar(128) not null,
name varchar(256) not null,
template_key varchar(128) not null,
state varchar(256) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(configuration_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table workflow_configurations add constraint fk_workflow_configurations_workflow_templates_2 foreign key (template_key) references workflow_templates(template_key) on
delete
	cascade on
	update
	no action

workflows table

This table contains information about the workflows.

This table has the following columns:

  • workflow_id - The identifier of the workflow.
  • configuration_id - The identifier of the configuration under which the workflow is created.
  • instance_state - The state of the instance, whether completed or failed.
  • workflow_state - The state of the workflow (for example "published").
  • created_by - The person who created the workflow.
  • start_time - The time at which the workflow started.
  • end_time- The time at which the workflow was completed.

Postgres

CREATE TABLE statement:

create table workflows(workflow_id varchar(128) not null,
configuration_id varchar(128),
instance_state varchar(256),
workflow_state varchar(256),
created_by varchar(128) not null,
start_time timestamp(6),
end_time timestamp(6),
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(workflow_id))

ALTER TABLE statement:

alter table workflows add constraint fk_workflows_workflow_configurations_3 foreign key (configuration_id) references workflow_configurations(configuration_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table workflows(workflow_id varchar(128) not null,
configuration_id varchar(128),
instance_state varchar(256),
workflow_state varchar(256),
created_by varchar(128) not null,
start_time timestamp(12),
end_time timestamp(12),
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(workflow_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table workflows add constraint fk_workflows_workflow_configurations_3 foreign key (configuration_id) references workflow_configurations(configuration_id) on
delete
	cascade on
	update
	no action

workflow_tasks table

This table contains information about the workflow tasks.

This table has the following columns:

  • task_id - The identifier of the Workflow task
  • key - The current step of the workflow task (authoring, approval, review, publishing)
  • workflow_id - The identifier of the workflow under which the task belongs.
  • state - The state of the workflow task (for example "created").
  • assignee - The person who is assigned to this task.
  • create_time - The creation time of the workflow.
  • due_time - The due time of the workflow.
  • claim_time - The time at which the task was claimed.
  • end_time - The time at which the task ended.

Postgres

CREATE TABLE statement:

create table workflow_tasks(task_id varchar(128) not null,
key varchar(256),
workflow_id varchar(128),
state varchar(256),
assignee varchar(128),
create_time timestamp(6) not null,
due_time timestamp(6),
claim_time timestamp(6),
end_time timestamp(6),
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(task_id))

ALTER TABLE statement:

alter table workflow_tasks add constraint fk_workflow_tasks_workflows_4 foreign key (workflow_id) references workflows(workflow_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table workflow_tasks(task_id varchar(128) not null,
key varchar(256),
workflow_id varchar(128),
state varchar(256),
assignee varchar(128),
create_time timestamp(12) not null,
due_time timestamp(12),
claim_time timestamp(12),
end_time timestamp(12),
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(task_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table workflow_tasks add constraint fk_workflow_tasks_workflows_4 foreign key (workflow_id) references workflows(workflow_id) on
delete
	cascade on
	update
	no action

Learn more

Parent topic: Reporting tables