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 configurationname
- The name of the workflow configurationtemplate_key
- The identifier of the template to which the workflow belongsstate
- 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 taskkey
- 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