0 / 0
Governance artifacts reporting tables

Governance artifacts reporting tables

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

Subject area Table name Description
Governance artifacts governance_artifacts The governance artifacts that are defined in the system that are in the published state.
Governance artifacts governance_artifact_stewards A list of stewards that are assigned to a published artifact.
Governance artifacts governance_artifact_associations The relationships between the governance artifacts.
Governance artifacts artifact_tags The tags that are associated with an artifact.

governance_artifacts table

This table contains information about the governance artifacts that are defined in the system that are in the published state.

This table has the following columns:

  • artifact_id - The identifier of the artifact.
  • version_id - The version identifier of the artifact.
  • artifact_type - The type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.
  • name - The name of the artifact.
  • description - The description of the artifact.
  • created_by - The identifier of the user that created the artifact.
  • created_on - The timestamp when the artifact was created.
  • modified_by - The identifier of the user that last modified the artifact
  • modified_on - The timestamp when the artifact was last modified.
  • primary_category_id - The identifier of the primary category of the artifact.
  • workflow_id - The identifier of the workflow configuration that was used to publish the artifact.
  • effective_start_date - The effective start date that is assigned to the artifact.
  • effective_end_date - The effective end date that is assigned to the artifact.
  • system_id - The system identifier or global identifier of the associated governance artifact.

Postgres

CREATE TABLE statement:

create table governance_artifacts(artifact_id varchar(128) not null,
version_id varchar(128) not null,
artifact_type varchar(128) not null,
name varchar(256) not null,
description text,
created_on timestamp(6) not null,
created_by varchar(128) not null,
modified_on timestamp(6),
modified_by varchar(128),
primary_category_id varchar(128) not null,
effective_start timestamp(6),
effective_end timestamp(6),
system_id varchar(128) default '' 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(artifact_id));

CREATE INDEX statement:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE statement:

alter table governance_artifacts add constraint fk_governance_artifacts_categories_21 foreign key (primary_category_id) references categories(category_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table governance_artifacts(artifact_id varchar(128) not null,
version_id varchar(128) not null,
artifact_type varchar(128) not null,
name varchar(256) not null,
description clob,
created_on timestamp(12) not null,
created_by varchar(128) not null,
modified_on timestamp(12),
modified_by varchar(128),
primary_category_id varchar(128) not null,
effective_start timestamp(12),
effective_end timestamp(12),
system_id varchar(128) default '' 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(artifact_id),
period SYSTEM_TIME (tech_start,
tech_end) )

CREATE INDEX statement:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE statement:

ALTER TABLE governance_artifacts ADD CONSTRAINT fk_governance_artifacts_categories_21 FOREIGN KEY (primary_category_id) REFERENCES categories(category_id) ON DELETE CASCADE  ON UPDATE NO ACTION

governance_artifact_stewards table

This table contains a list of stewards that are assigned to a published artifact.

This table has the following columns:

  • artifact_id - The identifier of the artifact.
  • user_id - The identifier of the user that is assigned as a steward.

Postgres

CREATE TABLE statement:

create table governance_artifact_stewards(artifact_id varchar(128) not null,
user_id varchar(128) 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(artifact_id,
user_id));

ALTER TABLE statement:

alter table governance_artifact_stewards add constraint fk_governance_artifact_stewards_governance_artifacts_3 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table governance_artifact_stewards(artifact_id varchar(128) not null,
user_id varchar(128) 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(artifact_id,
user_id),
period SYSTEM_TIME (tech_start,
tech_end) )

ALTER TABLE statement:

alter table governance_artifact_stewards add constraint fk_governance_artifact_stewards_governance_artifacts_3 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

governance_artifact_associations table

This table contains information about the relationships between the governance artifacts.

This table has the following columns:

  • end1_artifact_id - The identifier of the source artifact.
  • end2_artifact_id - The identifier of the target artifact.
  • end1_artifact_type - The type of the source artifact.
  • end2_artifact_type - The type of the target artifact.
  • relationship_type - The relationship type.

Postgres

CREATE TABLE statement:

create table governance_artifact_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
end1_artifact_type varchar(128) not null,
end2_artifact_type varchar(128) not null,
cr_definition_id varchar(128),
reverse_relationship_type varchar(256),
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(end1_artifact_id,
end2_artifact_id,
relationship_type))

ALTER TABLE statement:

alter table governance_artifact_associations add constraint fk_governance_artifact_associations_glossary_custom_relationship_def_8 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table governance_artifact_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
end1_artifact_type varchar(128) not null,
end2_artifact_type varchar(128) not null,
cr_definition_id varchar(128),
reverse_relationship_type varchar(256),
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(end1_artifact_id,
end2_artifact_id,
relationship_type),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table governance_artifact_associations add constraint fk_governance_artifact_associations_glossary_custom_relationship_def_8 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

artifact_tags table

This table contains information about the tags that are associated with an artifact.

This table has the following columns:

  • tag_name - The name of the associated tag.
  • artifact_id - The identifier of the artifact.
  • artifact_type - The type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.

Postgres

CREATE TABLE statement:

create table artifact_tags(tag_name varchar(256) not null,
artifact_id varchar(128) not null,
artifact_type varchar(128) 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(tag_name,
artifact_id));

ALTER TABLE statements:

alter table artifact_tags add constraint fk_artifact_tags_governance_artifacts_24 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action
alter table artifact_tags add constraint fk_artifact_tags_tags_26 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table artifact_tags(tag_name varchar(256) not null,
artifact_id varchar(128) not null,
artifact_type varchar(128) 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(tag_name,
artifact_id),
period SYSTEM_TIME (tech_start,
tech_end) )

ALTER TABLE statements:

alter table artifact_tags add constraint fk_artifact_tags_governance_artifacts_24 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action
alter table artifact_tags add constraint fk_artifact_tags_tags_26 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action

Learn more

Parent topic: Reporting tables

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more