工件关系报告表 | IBM Cloud Pak for Data as a Service

Go back to the English version of the documentation

工件关系报告表

Last updated: 2024年12月13日

工件关系报告表

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

主题区域	表名	描述
工件关系	辅助分类关联	将工件分配到的辅助类别的列表。
工件关系	business_term_关联	业务术语之间的关系。
工件关系	数据类关联	数据类之间的关系。
工件关系	策略关联	策略之间的关系。
工件关系	引用数据集关联	参考数据集之间的关系。
工件关系	分类关联	分类之间的关系。
工件关系	管理规则关联	监管规则之间的关系。
工件关系	artifact_enforcement_rule_activities	监管工件与实施规则之间的隐式关系。
工件关系	artifact_category_activities	监管工件与类别之间的关系。

secondary_category_协会表

此表包含将工件分配到的辅助类别的列表。

此表具有以下列:

artifact_id -工件的标识。
category_id -指定工件的辅助类别的标识。

Postgres

CREATE TABLE 语句:

create table secondary_category_associations(category_id varchar(128) not null,
artifact_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(category_id,
artifact_id));

ALTER TABLE 语句:

alter table secondary_category_associations add constraint fk_secondary_category_associations_categories_22 foreign key (category_id) references categories(category_id) on
delete
	cascade on
	update
	no action

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

Db2

CREATE TABLE 语句:

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

ALTER TABLE 语句:

alter table secondary_category_associations add constraint fk_secondary_category_associations_categories_22 foreign key (category_id) references categories(category_id) on
delete
	cascade on
	update
	no action

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

business_term_rules 表

此表包含有关业务术语之间的关系的信息。

此表具有以下列:

end1_term_artifact_id -源工件的标识。
end2_term_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table business_term_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 business_term_associations add constraint fk_business_term_associations_glossary_custom_relationship_def_1 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 business_term_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 business_term_associations add constraint fk_business_term_associations_glossary_custom_relationship_def_1 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

data_class_关联表

此表包含有关数据类之间关系的信息。

此表具有以下列:

end1_data_class_artifact_id -源工件的标识。
end2_data_class_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table data_class_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 data_class_associations add constraint fk_data_class_associations_glossary_custom_relationship_def_3 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 data_class_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 data_class_associations add constraint fk_data_class_associations_glossary_custom_relationship_def_3 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

策略关联

此表包含有关策略之间关系的信息。

此表具有以下列:

end1_policy_artifact_id -源工件的标识。
end2_policy_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table policy_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 policy_associations add constraint fk_policy_associations_glossary_custom_relationship_def_4 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 policy_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 policy_associations add constraint fk_policy_associations_glossary_custom_relationship_def_4 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

reference_data_set_activities 表

此表包含有关参考数据集之间的关系的信息。

此表具有以下列:

end1_rds_artifact_id -源工件的标识。
end2_rds_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table reference_data_set_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 reference_data_set_associations ADD CONSTRAINT fk_reference_data_set_associations_glossary_custom_relationship_def_5 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 reference_data_set_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 reference_data_set_associations add constraint fk_reference_data_set_associations_glossary_custom_relationship_def_5 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

Classification_关联表

此表包含有关分类之间关系的信息。

此表具有以下列:

end1_classifiaction_artifact_id -源工件的标识。
end2_classifiaction_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table classification_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 classification_associations add constraint fk_classification_associations_glossary_custom_relationship_def_2 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 classification_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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 classification_associations add constraint fk_classification_associations_glossary_custom_relationship_def_2 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

管理规则关联表

此表包含有关监管规则之间的关系的信息。

此表具有以下列:

end1_rule_artifact_id -源工件的标识。
end2_rule_artifact_id -目标工件的标识。
relationship_type -从源工件到目标工件的关系类型。
reverse_relationship_type -从目标工件到源工件的关系类型。

Postgres

CREATE TABLE 语句:

create table governance_rule_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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_rule_associations add constraint fk_governance_rule_associations_glossary_custom_relationship_def_6 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

CREATE TABLE 语句:

create table governance_rule_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
reverse_relationship_type varchar(128),
cr_definition_id varchar(128),
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_rule_associations add constraint fk_governance_rule_associations_glossary_custom_relationship_def_6 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

artifact_enforcement_rule_activities 表

此表包含有关监管工件与实施规则之间的隐式关系的信息。

此表具有以下列:

artifact_id -关联监管工件的标识。
rule_id -关联工件所属的实施规则的标识。

Postgres

CREATE TABLE 语句:

create table artifact_enforcement_rule_associations(artifact_id varchar(128) not null,
rule_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,
rule_id));

ALTER TABLE 语句:

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

alter table artifact_enforcement_rule_associations add constraint fk_artifact_enforcement_rule_associations_enforcement_rules_19 foreign key (rule_id) references enforcement_rules(rule_id) on
delete
	cascade on
	update
	no action

Db2

CREATE TABLE 语句:

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

ALTER TABLE 语句:

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

alter table artifact_enforcement_rule_associations add constraint fk_artifact_enforcement_rule_associations_enforcement_rules_19 foreign key (rule_id) references enforcement_rules(rule_id) on
delete
	cascade on
	update
	no action

artifact_category_activities 表

此表包含有关监管工件与类别之间的关联的信息。

此表具有以下列:

category_id-工件类别的标识。
artifact_id -定制关系定义的标识。
relationship_type -从工件到类别的关系类型。
cr_definition_id -定制关系定义的标识。
reverse_relationship_type -从类别到工件的关系类型。

Postgres

CREATE TABLE 语句:

create table artifact_category_associations(category_id varchar(128) not null,
artifact_id varchar(128) not null,
cr_definition_id varchar(128),
relationship_type varchar(256) not null,
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(category_id,
artifact_id,
relationship_type))

ALTER TABLE 语句:

alter table artifact_category_associations add constraint fk_artifact_category_associations_glossary_custom_relationship_def_9 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 artifact_category_associations(category_id varchar(128) not null,
artifact_id varchar(128) not null,
cr_definition_id varchar(128),
relationship_type varchar(256) not null,
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(category_id,
artifact_id,
relationship_type),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE 语句:

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

了解更多信息

父主题: 报告表