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 artifactmodified_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