0 / 0
Go back to the English version of the documentation
监管工件报告表
Last updated: 2024年12月13日
监管工件报告表

检查 Postgres Db2 语句中与监管工件相关的表。

主题区域 表名 描述
监管工件 管理工件 系统中定义的处于 "已发布" 状态的监管工件。
监管工件 管理工件 分配给已发布工件的元数据管理员的列表。
监管工件 管理工件关联 监管工件之间的关系。
监管工件 artifact_tags 与工件关联的标记。
监管工件 业务术语缩写 分配给业务术语工件（类型为 glossary_term）的缩写。

管理工件表

此表包含有关系统中定义的处于 "已发布" 状态的监管工件的信息。

此表具有以下列:

  • artifact_id -工件的标识。
  • version_id -工件的版本标识。
  • artifact_type -工件的类型，例如 glossary_term ， classification ， data_class ， reference_data ， rule 或 policy。
  • name -工件的名称。
  • description -工件的描述。
  • created_by -创建工件的用户的标识。
  • created_on -创建工件时的时间戳记。
  • modified_by -上次修改工件的用户的标识
  • modified_on -上次修改工件时的时间戳记。
  • primary_category_id -工件的主类别的标识。
  • workflow_id -用于发布工件的工作流程配置的标识。
  • effective_start_date -分配给工件的生效开始日期。
  • effective_end_date -分配给工件的生效结束日期。
  • system_id -关联监管工件的系统标识或全局标识。
  • rds_values_total_counts--参考数据工件类型的参考数据值计数。
Postgres

CREATE TABLE 语句:

CREATE TABLE "globalschema".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,
  rds_values_total_counts bigint DEFAULT 0 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 语句:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE 语句:

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 语句:

CREATE TABLE "globalschema".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,
  rds_values_total_counts bigint DEFAULT 0 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 语句:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE 语句:

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
MS SQL Server

CREATE TABLE 语句:

CREATE TABLE "globalschema".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 varchar(MAX),
  created_on DATETIME2 NOT NULL,
  created_by varchar(128) NOT NULL,
  modified_on DATETIME2,
  modified_by varchar(128),
  primary_category_id varchar(128) NOT NULL,
  effective_start DATETIME2,
  effective_end DATETIME2,
  system_id varchar(128) DEFAULT '' NOT NULL,
  rds_values_total_counts bigint DEFAULT 0 NOT NULL,
  tech_start DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
  tech_end DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
  ts_id DATETIME2 DEFAULT CURRENT_TIMESTAMP NOT NULL,
  CONSTRAINT PK_governance_artifacts_globalschema PRIMARY KEY(artifact_id),
  PERIOD FOR SYSTEM_TIME (tech_start, tech_end)
) WITH (
  SYSTEM_VERSIONING = ON (
    HISTORY_TABLE = "globalschema".hist_governance_artifacts
  )
)

管理的 artifact_stewards 表

此表包含分配给已发布工件的元数据管理员的列表。

此表具有以下列:

  • artifact_id -工件的标识。
  • user_id -分配为管理者的用户的标识。
Postgres

CREATE TABLE 语句:

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 语句:

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 语句:

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 语句:

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

管理的工件关联表

此表包含有关监管工件之间的关系的信息。

此表具有以下列:

  • end1_artifact_id -源工件的标识。
  • end2_artifact_id -目标工件的标识。
  • end1_artifact_type -源工件的类型。
  • end2_artifact_type -目标工件的类型。
  • relationship_type -关系类型。
Postgres

CREATE TABLE 语句:

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 语句:

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 语句:

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 语句:

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 表

此表包含有关与工件关联的标记的信息。

此表具有以下列:

  • tag_name -关联标记的名称。
  • artifact_id -工件的标识。
  • artifact_type -工件的类型，例如 glossary_term ， classification ， data_class ， reference_data ， rule 或 policy。
Postgres

CREATE TABLE 语句:

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 语句:

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 语句:

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 语句:

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

业务术语缩略语表

本表包含分配给业务术语工件（词汇表_术语类型的工件）的缩写信息。

此表具有以下列:

  • artifact_id--词汇表术语（业务术语）工件的标识符。
  • abbreviation--人工制品的缩写。
Postgres

CREATE TABLE 语句:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation 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, abbreviation)
)
Db2

CREATE TABLE 语句:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation 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, abbreviation)
)
MS SQL Server

CREATE TABLE 语句:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation varchar(128) NOT NULL,
  tech_start DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
  tech_end DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
  ts_id DATETIME2 DEFAULT CURRENT_TIMESTAMP NOT NULL,
  CONSTRAINT PK_business_term_abbreviations_globalschema PRIMARY KEY(artifact_id, abbreviation),
  PERIOD FOR SYSTEM_TIME (tech_start, tech_end)
) WITH (
  SYSTEM_VERSIONING = ON (
    HISTORY_TABLE = "globalschema".hist_business_term_abbreviations
  )
)

了解更多信息

父主题: 报告表

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