Tablas de informes sobre relaciones patrimoniales

Consulte las sentencias « PostgreSQL, », « Db2 » y « Oracle » para las tablas relacionadas con las relaciones de activos.

Área temática	Nombre de tabla	Descripción
Relaciones de activos	relaciones_entre_activos_y_artefactos	Las relaciones entre los activos y los elementos de gobernanza.
Relaciones de activos	container_assets_associations	Las relaciones entre los elementos del catálogo.
Relaciones de activos	asset_tags	Las etiquetas asociadas a un activo.
Relaciones de activos	asociaciones de contenedores de artefactos de gobernanza	El elemento de gobernanza, que está asociado a un activo del catálogo.
Relaciones de activos	data_asset_column_artifact_associations	Los artefactos de gobernanza, que están asociados a la columna del activo de datos.
Relaciones de activos	relaciones_entre_columnas_y_activos	Las relaciones entre la columna de activos de datos y un activo.
Relaciones de activos	relaciones_entre_columnas	Las relaciones entre las columnas de los activos de datos.
Relaciones de activos	relaciones_entre_columnas_y_artefactos	Las relaciones entre las columnas de los activos de datos y los artefactos.
Relaciones de activos	columnas de clave primaria y clave externa de activos de datos	Las relaciones entre la columna «Activos de datos» y cualquier activo.
Relaciones de activos	columnas_de_referencia_de_la_clave_fortea_del_activo_de_datos	Las relaciones entre la columna de referencia de los activos de datos y cualquier activo.

relaciones_entre_activos_y_artefactos

Esta tabla contiene información sobre las relaciones entre los activos y los artefactos de gobernanza.

La tabla tiene las siguientes columnas:

end1_asset_id - El identificador del end1 activo.
end2_artifact_id - El ID del artefacto de destino de la relación entre el activo y el artefacto.
end1_container_id - El ID del contenedor del end1 activo.
end2_artifact_type - El tipo de artefacto de destino de la relación entre el activo y el artefacto.
end1_relationship_type - El tipo de relación identificado a partir del end1 activo.
end2_relationship_type - El tipo de relación identificado a partir del end2 activo.

PostgreSQL

Sentencia CREATE TABLE:

CREATE TABLE asset_artifact_relations(end1_asset_id varchar(128) NOT NULL,
end1_container_id varchar(36) NOT NULL,
end2_artifact_id varchar(128) NOT NULL,
end2_artifact_type varchar(128) NOT NULL,
end1_relationship_type varchar(256) NOT NULL,
end2_relationship_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(end1_asset_id,
end1_container_id,
end2_artifact_id,
end2_artifact_type,
end1_relationship_type))

Sentencias ALTER TABLE:

alter table asset_artifact_relations add constraint fk_asset_artifact_relations_container_assets_1 foreign key (end1_container_id,
end1_asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table asset_artifact_relations add constraint fk_asset_artifact_relations_governance_artifacts_2 foreign key (end2_artifact_id) references governance_artifacts(artifact_id) on
	delete
	cascade on
	update
	no action

Db2

Sentencia CREATE TABLE:

CREATE TABLE asset_artifact_relations(end1_asset_id varchar(128) NOT NULL,
end1_container_id varchar(36) NOT NULL,
end2_artifact_id varchar(128) NOT NULL,
end2_artifact_type varchar(128) NOT NULL,
end1_relationship_type varchar(256) NOT NULL,
end2_relationship_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(end1_asset_id,
end1_container_id,
end2_artifact_id,
end2_artifact_type,
end1_relationship_type),
PERIOD SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE BY ROW

Sentencias ALTER TABLE:

ALTER TABLE asset_artifact_relations ADD CONSTRAINT
fk_asset_artifact_relations_container_assets_1 FOREIGN KEY (end1_container_id,end1_asset_id)REFERENCES container_assets(container_id,asset_id) ON
	DELETE
	CASCADE  ON
	UPDATE
	NO ACTION

ALTER TABLE asset_artifact_relations ADD CONSTRAINT fk_asset_artifact_relations_governance_artifacts_2 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_id) ON
DELETE
	CASCADE ON
	UPDATE
	NO ACTION

Oracle

Sentencia CREATE TABLE:

CREATE TABLE asset_artifact_relations(end1_asset_id varchar(128) NOT NULL,
end1_container_id varchar(36) NOT NULL,
end2_artifact_id varchar(128) NOT NULL,
end2_artifact_type varchar(128) NOT NULL,
end1_relationship_type varchar(256) NOT NULL,
end2_relationship_type varchar(256) NOT NULL,
tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
PRIMARY KEY(end1_asset_id,
end1_container_id,
end2_artifact_id,
end2_artifact_type,
end1_relationship_type))

Sentencias ALTER TABLE:

ALTER TABLE asset_artifact_relations ADD CONSTRAINT fk_asset_artifact_relations_container_assets_1 FOREIGN KEY (end1_container_id,
end1_asset_id) REFERENCES container_assets(container_id,
asset_id) ON
	DELETE
	CASCADE

ALTER TABLE asset_artifact_relations ADD CONSTRAINT fk_asset_artifact_relations_governance_artifacts_2 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_id) ON
	DELETE
	CASCADE

tabla container_assets_associations

Esta tabla contiene información sobre las relaciones entre los activos de catálogo.

Esta tabla tiene las siguientes columnas:

end1_asset_id - El identificador del recurso de origen.
end2_asset_id - El identificador del activo de destino.
end1_container_id - El identificador del espacio de trabajo del recurso de origen.
end2_container_id - El identificador del espacio de trabajo del activo de destino.
end1_relationship_type - El tipo de relación identificado a partir del activo de origen.
end2_relationship_type - El tipo de relación identificado a partir del activo de destino.

PostgreSQL

Sentencia CREATE TABLE:

CREATE TABLE catalog_assets_associations(end1_asset_id varchar(128) NOT NULL,
end2_asset_id varchar(128) NOT NULL,
end1_container_id varchar(36) NOT NULL,
end2_container_id varchar(36) NOT NULL,
end1_relationship_type varchar(128) NOT NULL,
end2_relationship_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(end1_container_id,
end2_container_id,
end1_asset_id,
end2_asset_id,
end1_relationship_type));

Sentencias ALTER TABLE:

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_container_assets_7 foreign key (end1_container_id,
end1_asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_container_assets_8 foreign key (end2_container_id,
end2_asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_containers_10 foreign key (end1_container_id) references containers(container_id) on
delete
	cascade on
	update
	no action

Db2

Sentencia CREATE TABLE:

CREATE TABLE catalog_assets_associations(end1_asset_id varchar(128) NOT NULL,
end2_asset_id varchar(128) NOT NULL,
end1_container_id varchar(36) NOT NULL,
end2_container_id varchar(36) NOT NULL,
end1_relationship_type varchar(128) NOT NULL,
end2_relationship_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(end1_container_id,
end2_container_id,
end1_asset_id,
end2_asset_id,
end1_relationship_type),
PERIOD SYSTEM_TIME (tech_start,
tech_end) )

Sentencias ALTER TABLE:

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_container_assets_7 foreign key (end1_container_id,
end1_asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_container_assets_8 foreign key (end2_container_id,
end2_asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table catalog_assets_associations add constraint fk_catalog_assets_associations_containers_10 foreign key (end1_container_id) references containers(container_id) on
delete
	cascade on
	update
	no action

Oracle

Sentencia CREATE TABLE:

CREATE TABLE container_assets_associations(end1_asset_id varchar(128) NOT NULL,
	end2_asset_id varchar(128) NOT NULL,
	end1_container_id varchar(36) NOT NULL,
	end2_container_id varchar(36) NOT NULL,
	end1_relationship_type varchar(128) NOT NULL,
	end2_relationship_type varchar(128) NOT NULL,
	tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
	ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	PRIMARY KEY(end1_container_id,
	end2_container_id,
	end1_asset_id,
	end2_asset_id,
	end1_relationship_type))

Sentencias ALTER TABLE:

ALTER TABLE container_assets_associations ADD CONSTRAINT fk_container_assets_associations_container_assets_7 FOREIGN KEY (end1_container_id,
	end1_asset_id) REFERENCES container_assets(container_id,
	asset_id) ON
	DELETE
	CASCADE

ALTER TABLE container_assets_associations ADD CONSTRAINT fk_container_assets_associations_container_assets_8 FOREIGN KEY (end2_container_id,
	end2_asset_id) REFERENCES container_assets(container_id,
	asset_id) ON
	DELETE
	CASCADE

Sentencias ALTER TABLE:

ALTER TABLE container_assets_associations ADD CONSTRAINT fk_container_assets_associations_containers_10 FOREIGN KEY (end1_container_id) REFERENCES containers(container_id) ON
	DELETE
	CASCADE

tabla asset_tags

Esta tabla contiene información sobre las etiquetas asociadas con un activo.

Esta tabla tiene las siguientes columnas:

tag_name - El nombre de la etiqueta asociada.
asset_id - El identificador del activo.
container_id - El identificador del catálogo o del proyecto.

PostgreSQL

Sentencia CREATE TABLE:

create table asset_tags(asset_id varchar(128) not null,
container_id varchar(36) not null,
tag_name 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(container_id,
asset_id,
tag_name));

Sentencias ALTER TABLE:

alter table asset_tags add constraint fk_asset_tags_container_assets_3 foreign key (container_id,
asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table asset_tags add constraint fk_asset_tags_tags_4 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action

Db2

Sentencia CREATE TABLE:

create table asset_tags(asset_id varchar(128) not null,
container_id varchar(36) not null,
tag_name 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(container_id,
asset_id,
tag_name),
period SYSTEM_TIME (tech_start,
tech_end) )

Sentencias ALTER TABLE:

alter table asset_tags add constraint fk_asset_tags_container_assets_3 foreign key (container_id,
asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

alter table asset_tags add constraint fk_asset_tags_tags_4 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action

Oracle

Sentencia CREATE TABLE:

CREATE TABLE asset_tags(asset_id varchar(128) NOT NULL,
	container_id varchar(36) NOT NULL,
	tag_name varchar(256) NOT NULL,
	tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
	ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	PRIMARY KEY(container_id,
	asset_id,
	tag_name))

Sentencias ALTER TABLE:

ALTER TABLE asset_tags ADD CONSTRAINT fk_asset_tags_container_assets_3 FOREIGN KEY (container_id,
	asset_id) REFERENCES container_assets(container_id,
	asset_id) ON
	DELETE
	CASCADE

ALTER TABLE asset_tags ADD CONSTRAINT fk_asset_tags_tags_4 FOREIGN KEY (tag_name) REFERENCES tags(tag_name) ON
	DELETE
	CASCADE

tabla «governance_artifact_container_associations»

Esta tabla contiene información sobre los artefactos de gobierno, por ejemplo términos de negocio o clasificación, que están asociados con un activo de catálogo.

Esta tabla tiene las siguientes columnas:

asset_id - El identificador del activo.
container_id - El identificador del catálogo.
associated_artifact_id - El identificador del artefacto de gobernanza asociado.
associated_artifact_type - El tipo del artefacto de gobernanza asociado, por ejemplo, «glossary_term» o «classification».
system_id - El identificador del sistema o el identificador global del artefacto de gobernanza asociado.
assignment_state - El estado de asignación del artefacto con el activo.
assignment_date - La fecha de asignación del artefacto al activo.
assigned_by - La persona que asignó el artefacto a un activo.
confidence - El nivel de confianza en el artefacto asignado a un activo.
specification - El algoritmo se utiliza para asignar el artefacto.

PostgreSQL

Sentencia CREATE TABLE:

create table governance_artifact_container_associations(asset_id varchar(128) not null,
container_id varchar(36) not null,
associated_artifact_id varchar(128) not null,
associated_artifact_type varchar(128),
system_id varchar(128) not null,
assignment_state varchar(32),
assignment_date timestamp(6),
assigned_by varchar(128),
confidence float,
specification 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(asset_id,
container_id,
associated_artifact_id))

Sentencias ALTER TABLE:

alter table governance_artifact_catalog_associations add constraint fk_governance_artifact_catalog_associations_governance_artifacts_17 foreign key (associated_artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

alter table governance_artifact_catalog_associations add constraint fk_governance_artifact_catalog_associations_container_assets_9 foreign key (container_id,
asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

Db2

Sentencia CREATE TABLE:

create table governance_artifact_container_associations(asset_id varchar(128) not null,
container_id varchar(36) not null,
associated_artifact_id varchar(128) not null,
associated_artifact_type varchar(128),
system_id varchar(128) not null,
assignment_state varchar(32),
assignment_date timestamp(6),
assigned_by varchar(128),
confidence float,
specification 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(asset_id,
container_id,
associated_artifact_id))

Sentencias ALTER TABLE:

alter table governance_artifact_catalog_associations add constraint fk_governance_artifact_catalog_associations_governance_artifacts_17 foreign key (associated_artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

alter table governance_artifact_catalog_associations add constraint fk_governance_artifact_catalog_associations_container_assets_9 foreign key (container_id,
asset_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

Oracle

Sentencia CREATE TABLE:

CREATE TABLE governance_artifact_container_associations(asset_id varchar(128) NOT NULL,
	container_id varchar(36) NOT NULL,
	associated_artifact_id varchar(128) NOT NULL,
	associated_artifact_type varchar(128),
	system_id varchar(128) NOT NULL,
	assignment_state varchar(32),
	assignment_date timestamp(6),
	assigned_by varchar(128),
	confidence float,
	specification varchar(128),
	tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
	ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	PRIMARY KEY(asset_id,
	container_id,
	associated_artifact_id))

Sentencias ALTER TABLE:

ALTER TABLE governance_artifact_container_associations ADD CONSTRAINT fk_governance_artifact_container_associations_container_assets_9 FOREIGN KEY (container_id,
	asset_id) REFERENCES container_assets(container_id,
	asset_id) ON
	DELETE
	CASCADE

ALTER TABLE governance_artifact_container_associations ADD CONSTRAINT fk_governance_artifact_container_associations_governance_artifacts_17 FOREIGN KEY (associated_artifact_id) REFERENCES governance_artifacts(artifact_id) ON
	DELETE
	CASCADE

tabla «data_asset_column_artifact_associations»

Esta tabla contiene información sobre artefactos de gobierno, por ejemplo términos de negocio o clasificaciones, que están asociados con la columna del activo de datos.

Esta tabla tiene las siguientes columnas:

name - El nombre de la columna.
asset_id - El identificador del activo.
container_id - El identificador del catálogo.
associated_artifact_id - El identificador del artefacto de gobernanza asociado.
associated_artifact_type - El tipo del artefacto de gobernanza asociado, por ejemplo, «glossary_term» o «classification».
system_id - El identificador del sistema o el identificador global del artefacto de gobernanza asociado.
assignment_state - El estado de asignación del artefacto con la columna «asset».
assignment_date - La fecha de asignación del artefacto en la columna «activo».
assigned_by - La persona que asignó el artefacto al activo de la columna.
confidence - El nivel de confianza en el artefacto asignado a un activo.
specification - El algoritmo se utiliza para asignar el artefacto.

PostgreSQL

Sentencia CREATE TABLE:

create table data_asset_column_artifact_associations(asset_id varchar(128) not null,
container_id varchar(36) not null,
name varchar(256) not null,
associated_artifact_type varchar(128),
associated_artifact_id varchar(128) not null,
system_id varchar(128) not null,
assignment_state varchar(32),
assignment_date timestamp(6),
assigned_by varchar(128),
confidence float,
specification 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(container_id,
asset_id,
name,
associated_artifact_id))

Sentencias ALTER TABLE:

alter table data_asset_column_artifact_associations add constraint fk_data_asset_column_artifact_associations_governance_artifacts_16 foreign key (associated_artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

alter table data_asset_column_artifact_associations add constraint fk_data_asset_column_artifact_associations_catalog_data_asset_columns_14 foreign key (container_id,
asset_id,
name) references catalog_data_asset_columns(container_id,
asset_id,
name) on
delete
	cascade on
	update
	no action

Db2

Sentencia CREATE TABLE:

create table data_asset_column_artifact_associations(asset_id varchar(128) not null,
container_id varchar(36) not null,
name varchar(256) not null,
associated_artifact_type varchar(128),
associated_artifact_id varchar(128) not null,
system_id varchar(128) not null,
assignment_state varchar(32),
assignment_date timestamp(6),
assigned_by varchar(128),
confidence float,
specification 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(container_id,
asset_id,
name,
associated_artifact_id))

Sentencias ALTER TABLE:

alter table data_asset_column_artifact_associations add constraint fk_data_asset_column_artifact_associations_governance_artifacts_16 foreign key (associated_artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

alter table data_asset_column_artifact_associations add constraint fk_data_asset_column_artifact_associations_catalog_data_asset_columns_14 foreign key (container_id,
asset_id,
name) references catalog_data_asset_columns(container_id,
asset_id,
name) on
delete
	cascade on
	update
	no action

Oracle

Sentencia CREATE TABLE:

CREATE TABLE data_asset_column_artifact_associations(asset_id varchar(128) NOT NULL,
	container_id varchar(36) NOT NULL,
	name varchar(256) NOT NULL,
	associated_artifact_type varchar(128),
	associated_artifact_id varchar(128) NOT NULL,
	system_id varchar(128) NOT NULL,
	assignment_state varchar(32),
	assignment_date timestamp(6),
	assigned_by varchar(128),
	confidence float,
	specification varchar(128),
	tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
	ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
	PRIMARY KEY(container_id,
	asset_id,
	name,
	associated_artifact_id))

Sentencias ALTER TABLE:

ALTER TABLE data_asset_column_artifact_associations ADD CONSTRAINT fk_data_asset_column_artifact_associations_container_data_asset_columns_14 FOREIGN KEY (container_id,
	asset_id,
	name) REFERENCES container_data_asset_columns(container_id,
	asset_id,
	name) ON
	DELETE
	CASCADE

ALTER TABLE data_asset_column_artifact_associations ADD CONSTRAINT fk_data_asset_column_artifact_associations_governance_artifacts_16 FOREIGN KEY (associated_artifact_id) REFERENCES governance_artifacts(artifact_id) ON
	DELETE
	CASCADE

tabla «column_to_asset_relations»

Esta tabla contiene información sobre las columnas de los activos de datos asociadas a los activos.

Esta tabla tiene las siguientes columnas:

end1_container_id - Especifica el identificador del contenedor del activo end1.
end2_container_id - Especifica el identificador del contenedor del activo end2.
end1_asset_id -Especifica el identificador del activo end1.
end2_asset_id - Especifica el identificador del activo de end2.
end1_column_name - Especifica el identificador de la columna del activo de datos « end1 ».
end1_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end1.
end2_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end2.

PostgreSQL

Sentencia CREATE TABLE:

CREATE TABLE column_to_asset_relations (
	end1_asset_id varchar(128) NOT NULL,
	end1_container_id varchar(36) NOT NULL,
	end1_column_name varchar(256) NOT NULL,
	end2_container_id varchar(36) NOT NULL,
	end2_asset_id varchar(128) NOT NULL,
	end1_relationship_type varchar(256) NOT NULL,
	end2_relationship_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'::text, 'YYYY-MM-DD'::text),
	ts_id timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT column_to_asset_relations_pkey PRIMARY KEY (end1_asset_id, end1_container_id, end1_column_name, end2_container_id, end2_asset_id, end1_relationship_type)
);

Sentencias ALTER TABLE:

ALTER TABLE
  column_to_asset_relations
ADD
  CONSTRAINT fk_column_to_asset_relations_container_assets_2 FOREIGN KEY (
    end2_container_id, end2_asset_id
  ) REFERENCES container_assets(container_id, asset_id) ON DELETE CASCADE;

ALTER TABLE
  column_to_asset_relations
ADD
  CONSTRAINT fk_column_to_asset_relations_container_data_asset_columns_1 FOREIGN KEY (
    end1_container_id, end1_asset_id,
    end1_column_name
  ) REFERENCES container_data_asset_columns(container_id, asset_id, "name") ON DELETE CASCADE;

Db2

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_ASSET_RELATIONS"  (
		  "END1_ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END1_CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "END1_COLUMN_NAME" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "END2_ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END1_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) 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 ,
		 PERIOD SYSTEM_TIME ("TECH_START","TECH_END") )
		 IN "USERSPACE1"
		 ORGANIZE BY ROW;

Sentencias ALTER TABLE:

ALTER TABLE "COLUMN_TO_ASSET_RELATIONS"
	ADD PRIMARY KEY
		("END1_ASSET_ID",
		 "END1_CONTAINER_ID",
		 "END1_COLUMN_NAME",
		 "END2_CONTAINER_ID",
		 "END2_ASSET_ID",
		 "END1_RELATIONSHIP_TYPE")
	ENFORCED;

ALTER TABLE "COLUMN_TO_ASSET_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_ASSET_RELATIONS_CONTAINER_ASSETS_2" FOREIGN KEY
		("END2_CONTAINER_ID",
		 "END2_ASSET_ID")
	REFERENCES "CONTAINER_ASSETS"
		("CONTAINER_ID",
		 "ASSET_ID")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "COLUMN_TO_ASSET_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_ASSET_RELATIONS_CONTAINER_DATA_ASSET_COLUMNS_1" FOREIGN KEY
		("END1_CONTAINER_ID",
		 "END1_ASSET_ID",
		 "END1_COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

Oracle

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_ASSET_RELATIONS"
   (	"END1_ASSET_ID" VARCHAR2(128),
	"END1_CONTAINER_ID" VARCHAR2(36),
	"END1_COLUMN_NAME" VARCHAR2(256),
	"END2_CONTAINER_ID" VARCHAR2(36),
	"END2_ASSET_ID" VARCHAR2(128),
	"END1_RELATIONSHIP_TYPE" VARCHAR2(256),
	"END2_RELATIONSHIP_TYPE" VARCHAR2(256),
	"TECH_START" TIMESTAMP (6) NOT NULL ENABLE,
	"TECH_END" TIMESTAMP (6) NOT NULL ENABLE,
	"TS_ID" TIMESTAMP (6) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

tabla de relaciones columna a columna

Esta tabla contiene información sobre las columnas del conjunto de datos que están asociadas a otras columnas.

Esta tabla tiene las siguientes columnas:

end1_container_id - Especifica el identificador del contenedor del activo end1.
end2_container_id - Especifica el identificador del contenedor del activo end2.
end1_asset_id -Especifica el identificador del activo end1.
end2_asset_id - Especifica el identificador del activo de end2.
end1_column_name - Especifica el identificador de la columna del activo de datos « end1 ».
end2_column_name - Especifica el identificador de la columna del activo de datos « end2 ».
end1_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end1.
end2_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end2.

PostgreSQL

Sentencia CREATE TABLE:

CREATE TABLE column_to_column_relations (
	end1_asset_id varchar(128) NOT NULL,
	end1_container_id varchar(36) NOT NULL,
	end1_column_name varchar(256) NOT NULL,
	end2_container_id varchar(36) NOT NULL,
	end2_asset_id varchar(128) NOT NULL,
	end2_column_name varchar(256) NOT NULL,
	end1_relationship_type varchar(256) NOT NULL,
	end2_relationship_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'::text, 'YYYY-MM-DD'::text),
	ts_id timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT column_to_column_relations_pkey PRIMARY KEY (end1_asset_id, end1_container_id, end1_column_name, end2_container_id, end2_asset_id, end2_column_name, end1_relationship_type)
);

Sentencias ALTER TABLE:

ALTER TABLE
  column_to_column_relations
ADD
  CONSTRAINT fk_column_to_column_relations_container_data_asset_columns_5 FOREIGN KEY (
    end1_container_id, end1_asset_id,
    end1_column_name
  ) REFERENCES container_data_asset_columns(container_id, asset_id, "name") ON DELETE CASCADE;

ALTER TABLE
  column_to_column_relations
ADD
  CONSTRAINT fk_column_to_column_relations_container_data_asset_columns_6 FOREIGN KEY (
    end2_container_id, end2_asset_id,
    end2_column_name
  ) REFERENCES container_data_asset_columns(container_id, asset_id, "name") ON DELETE CASCADE;

Db2

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_COLUMN_RELATIONS"  (
		  "END1_ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END1_CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "END1_COLUMN_NAME" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "END2_ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END2_COLUMN_NAME" VARCHAR(256 OCTETS) NOT NULL ,
		  "END1_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) 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 ,
		 PERIOD SYSTEM_TIME ("TECH_START","TECH_END") )
		 IN "USERSPACE1"
		 ORGANIZE BY ROW;

Sentencias ALTER TABLE:

ALTER TABLE "COLUMN_TO_COLUMN_RELATIONS"
	ADD PRIMARY KEY
		("END1_ASSET_ID",
		 "END1_CONTAINER_ID",
		 "END1_COLUMN_NAME",
		 "END2_CONTAINER_ID",
		 "END2_ASSET_ID",
		 "END2_COLUMN_NAME",
		 "END1_RELATIONSHIP_TYPE")
	ENFORCED;

ALTER TABLE "COLUMN_TO_COLUMN_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_COLUMN_RELATIONS_CONTAINER_DATA_ASSET_COLUMNS_5" FOREIGN KEY
		("END1_CONTAINER_ID",
		 "END1_ASSET_ID",
		 "END1_COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "COLUMN_TO_COLUMN_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_COLUMN_RELATIONS_CONTAINER_DATA_ASSET_COLUMNS_6" FOREIGN KEY
		("END2_CONTAINER_ID",
		 "END2_ASSET_ID",
		 "END2_COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

Oracle

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_COLUMN_RELATIONS"
   (	"END1_ASSET_ID" VARCHAR2(128),
	"END1_CONTAINER_ID" VARCHAR2(36),
	"END1_COLUMN_NAME" VARCHAR2(256),
	"END2_CONTAINER_ID" VARCHAR2(36),
	"END2_ASSET_ID" VARCHAR2(128),
	"END2_COLUMN_NAME" VARCHAR2(256),
	"END1_RELATIONSHIP_TYPE" VARCHAR2(256),
	"END2_RELATIONSHIP_TYPE" VARCHAR2(256),
	"TECH_START" TIMESTAMP (6) NOT NULL ENABLE,
	"TECH_END" TIMESTAMP (6) NOT NULL ENABLE,
	"TS_ID" TIMESTAMP (6) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

relaciones_entre_columnas_y_artefactos

Esta tabla contiene información sobre las columnas de los activos de datos asociadas a los artefactos.

Esta tabla tiene las siguientes columnas:

end1_container_id - Especifica el identificador del contenedor del activo end1.
end2_artifact_id - Especifica el identificador del artefacto de destino en las relaciones entre artefactos de activos.
end1_asset_id -Especifica el identificador del activo end1.
end1_column_name - Especifica el identificador de la columna del activo de datos « end1 ».
end2_artifact_type - Especifica el tipo de artefacto de destino de las relaciones entre artefactos de activos.
end1_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end1.
end2_relationship_type - Especifica el tipo de relación tal como se ha identificado en el activo end2.

PostgreSQL

Sentencia CREATE TABLE:

CREATE TABLE column_to_artifact_relations (
	end1_asset_id varchar(128) NOT NULL,
	end1_container_id varchar(36) NOT NULL,
	end1_column_name varchar(256) NOT NULL,
	end2_artifact_id varchar(128) NOT NULL,
	end2_artifact_type varchar(128) NOT NULL,
	end1_relationship_type varchar(256) NOT NULL,
	end2_relationship_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'::text, 'YYYY-MM-DD'::text),
	ts_id timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT column_to_artifact_relations_pkey PRIMARY KEY (end1_asset_id, end1_container_id, end1_column_name, end2_artifact_type, end2_artifact_id, end1_relationship_type)
);

Sentencias ALTER TABLE:

ALTER TABLE
  column_to_artifact_relations
ADD
  CONSTRAINT fk_column_to_artifact_relations_container_data_asset_columns_3 FOREIGN KEY (
    end1_container_id, end1_asset_id,
    end1_column_name
  ) REFERENCES container_data_asset_columns(container_id, asset_id, "name") ON DELETE CASCADE;

ALTER TABLE
  column_to_artifact_relations
ADD
  CONSTRAINT fk_column_to_artifact_relations_governance_artifacts_4 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE;

Db2

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_ARTIFACT_RELATIONS"  (
		  "END1_ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END1_CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "END1_COLUMN_NAME" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_ARTIFACT_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "END2_ARTIFACT_TYPE" VARCHAR(128 OCTETS) NOT NULL ,
		  "END1_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) NOT NULL ,
		  "END2_RELATIONSHIP_TYPE" VARCHAR(256 OCTETS) 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 ,
		 PERIOD SYSTEM_TIME ("TECH_START","TECH_END") )
		 IN "USERSPACE1"
		 ORGANIZE BY ROW;

Sentencias ALTER TABLE:

ALTER TABLE "COLUMN_TO_ARTIFACT_RELATIONS"
	ADD PRIMARY KEY
		("END1_ASSET_ID",
		 "END1_CONTAINER_ID",
		 "END1_COLUMN_NAME",
		 "END2_ARTIFACT_TYPE",
		 "END2_ARTIFACT_ID",
		 "END1_RELATIONSHIP_TYPE")
	ENFORCED;

ALTER TABLE "COLUMN_TO_ARTIFACT_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_ARTIFACT_RELATIONS_CONTAINER_DATA_ASSET_COLUMNS_3" FOREIGN KEY
		("END1_CONTAINER_ID",
		 "END1_ASSET_ID",
		 "END1_COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "COLUMN_TO_ARTIFACT_RELATIONS"
	ADD CONSTRAINT "FK_COLUMN_TO_ARTIFACT_RELATIONS_GOVERNANCE_ARTIFACTS_4" FOREIGN KEY
		("END2_ARTIFACT_ID")
	REFERENCES "GOVERNANCE_ARTIFACTS"
		("ARTIFACT_ID")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

Oracle

Sentencia CREATE TABLE:

CREATE TABLE "COLUMN_TO_ARTIFACT_RELATIONS"
   (	"END1_ASSET_ID" VARCHAR2(128),
	"END1_CONTAINER_ID" VARCHAR2(36),
	"END1_COLUMN_NAME" VARCHAR2(256),
	"END2_ARTIFACT_ID" VARCHAR2(128),
	"END2_ARTIFACT_TYPE" VARCHAR2(128),
	"END1_RELATIONSHIP_TYPE" VARCHAR2(256),
	"END2_RELATIONSHIP_TYPE" VARCHAR2(256),
	"TECH_START" TIMESTAMP (6) NOT NULL ENABLE,
	"TECH_END" TIMESTAMP (6) NOT NULL ENABLE,
	"TS_ID" TIMESTAMP (6) NOT NULL ENABLE
   ) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

columnas de clave primaria y clave externa de activos de datos

Esta tabla contiene información sobre las relaciones entre las columnas de los activos de datos y cualquier activo.

Esta tabla tiene las siguientes columnas:

constraint_id - El identificador de la restricción definida para una tabla de activos de datos.
column_index - El identificador del índice de columna de un activo de datos.
container_id - El identificador del catálogo o proyecto en el que se encuentra el activo.
column_name - Especifica el identificador de la columna del activo de datos.
asset_id - El identificador del activo.
constraint_type - Especifica el tipo de restricción, que puede ser PRIMARY_KEY o FOREIGN_KEY.
constraint_name - Especifica el identificador de la columna del activo de datos « source/end1 ».

PostgreSQL

Sentencia CREATE TABLE:

create table data_asset_pk_fk_columns(
  constraint_id varchar(128) not null,
  column_index integer not null,
  container_id varchar(36) not null,
  column_name varchar(256) not null,
  asset_id varchar(128) not null,
  constraint_type varchar(32) not null,
  constraint_name 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(
    constraint_id, container_id, column_index
  )
)

Sentencias ALTER TABLE:

alter table
  data_asset_pk_fk_columns
add
  constraint fk_data_asset_pk_fk_columns_container_data_asset_columns_1 foreign key (
    container_id, asset_id, column_name
  ) references container_data_asset_columns(container_id, asset_id, name) on delete cascade on
update
  no action
alter table
  data_asset_pk_fk_columns
add
  constraint fk_data_asset_pk_fk_columns_container_assets_2 foreign key (container_id, constraint_id) references container_assets(container_id, asset_id) on delete cascade on
update
  no action

Db2

Sentencia CREATE TABLE:

CREATE TABLE "DATA_ASSET_PK_FK_COLUMNS"  (
		  "CONSTRAINT_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "COLUMN_INDEX" INTEGER NOT NULL ,
		  "CONTAINER_ID" VARCHAR(36 OCTETS) NOT NULL ,
		  "COLUMN_NAME" VARCHAR(256 OCTETS) NOT NULL ,
		  "ASSET_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "CONSTRAINT_TYPE" VARCHAR(32 OCTETS) NOT NULL ,
		  "CONSTRAINT_NAME" VARCHAR(256 OCTETS) 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 ,
		 PERIOD SYSTEM_TIME ("TECH_START","TECH_END") )
		 IN "USERSPACE1"
		 ORGANIZE BY ROW;

Sentencias ALTER TABLE:

ALTER TABLE "DATA_ASSET_PK_FK_COLUMNS"
	ADD PRIMARY KEY
		("CONSTRAINT_ID",
		 "CONTAINER_ID",
		 "COLUMN_INDEX")
	ENFORCED;

ALTER TABLE "DATA_ASSET_PK_FK_COLUMNS"
	ADD CONSTRAINT "FK_DATA_ASSET_PK_FK_COLUMNS_CONTAINER_ASSETS_2" FOREIGN KEY
		("CONTAINER_ID",
		 "CONSTRAINT_ID")
	REFERENCES "CONTAINER_ASSETS"
		("CONTAINER_ID",
		 "ASSET_ID")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "DATA_ASSET_PK_FK_COLUMNS"
	ADD CONSTRAINT "FK_DATA_ASSET_PK_FK_COLUMNS_CONTAINER_DATA_ASSET_COLUMNS_1" FOREIGN KEY
		("CONTAINER_ID",
		 "ASSET_ID",
		 "COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

Oracle

Sentencia CREATE TABLE:

CREATE TABLE data_asset_pk_fk_columns (
  constraint_id VARCHAR2(128) NOT NULL,
  column_index NUMBER(10) NOT NULL,
  container_id VARCHAR2(36) NOT NULL,
  column_name VARCHAR2(256) NOT NULL,
  asset_id VARCHAR2(128) NOT NULL,
  constraint_type VARCHAR2(32) NOT NULL,
  constraint_name VARCHAR2(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 (constraint_id, container_id, column_index)
);

Sentencias ALTER TABLE:

ALTER TABLE data_asset_pk_fk_columns
ADD CONSTRAINT fk_data_asset_pk_fk_columns_container_data_asset_columns_1
FOREIGN KEY (container_id, asset_id, column_name)
REFERENCES container_data_asset_columns(container_id, asset_id, name)
ON DELETE CASCADE
ON UPDATE NO ACTION;

ALTER TABLE data_asset_pk_fk_columns
ADD CONSTRAINT fk_data_asset_pk_fk_columns_container_assets_2
FOREIGN KEY (container_id, constraint_id)
REFERENCES container_assets(container_id, asset_id)
ON DELETE CASCADE
ON UPDATE NO ACTION;

columnas_de_referencia_de_la_clave_fortea_del_activo_de_datos

Esta tabla contiene información sobre las relaciones entre la columna de referencia de los activos de datos y cualquier activo.

Esta tabla tiene las siguientes columnas:

constraint_id - El identificador de la restricción definida para una tabla de activos de datos.
column_index - El identificador del índice de columna de un activo de datos.
container_id - El identificador del catálogo o proyecto en el que se encuentra el activo.
column_name - Especifica el identificador de la columna del activo de datos.
asset_id - El identificador del activo.

PostgreSQL

Sentencia CREATE TABLE:

create table data_asset_fk_ref_columns(
  constraint_id varchar(128) not null,
  column_index integer not null,
  container_id varchar(256) not null,
  column_name varchar(36) not null,
  asset_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(
    constraint_id, container_id, column_index
  )
)

Sentencias ALTER TABLE:

alter table
  data_asset_fk_ref_columns
add
  constraint fk_data_asset_fk_ref_columns_data_asset_pk_fk_columns_3 foreign key (
    container_id, constraint_id, column_index
  ) references data_asset_pk_fk_columns(
    container_id, constraint_id, column_index
  ) on delete cascade on
update
  no action

alter table
  data_asset_fk_ref_columns
add
  constraint fk_data_asset_fk_ref_columns_container_data_asset_columns_4 foreign key (
    container_id, asset_id, column_name
  ) references container_data_asset_columns(container_id, asset_id, name) on delete cascade on
update
  no action

Db2

Sentencia CREATE TABLE:

CREATE TABLE "DATA_ASSET_FK_REF_COLUMNS"  (
		  "CONSTRAINT_ID" VARCHAR(128 OCTETS) NOT NULL ,
		  "COLUMN_INDEX" INTEGER NOT NULL ,
		  "CONTAINER_ID" VARCHAR(256 OCTETS) NOT NULL ,
		  "COLUMN_NAME" VARCHAR(36 OCTETS) NOT NULL ,
		  "ASSET_ID" VARCHAR(128 OCTETS) 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 ,
		 PERIOD SYSTEM_TIME ("TECH_START","TECH_END") )
		 IN "USERSPACE1"
		 ORGANIZE BY ROW;

Sentencias ALTER TABLE:

ALTER TABLE "DATA_ASSET_FK_REF_COLUMNS"
	ADD PRIMARY KEY
		("CONSTRAINT_ID",
		 "CONTAINER_ID",
		 "COLUMN_INDEX")
	ENFORCED;

ALTER TABLE "DATA_ASSET_FK_REF_COLUMNS"
	ADD CONSTRAINT "FK_DATA_ASSET_FK_REF_COLUMNS_CONTAINER_DATA_ASSET_COLUMNS_4" FOREIGN KEY
		("CONTAINER_ID",
		 "ASSET_ID",
		 "COLUMN_NAME")
	REFERENCES "CONTAINER_DATA_ASSET_COLUMNS"
		("CONTAINER_ID",
		 "ASSET_ID",
		 "NAME")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

ALTER TABLE "DATA_ASSET_FK_REF_COLUMNS"
	ADD CONSTRAINT "FK_DATA_ASSET_FK_REF_COLUMNS_DATA_ASSET_PK_FK_COLUMNS_3" FOREIGN KEY
		("CONSTRAINT_ID",
		 "CONTAINER_ID",
		 "COLUMN_INDEX")
	REFERENCES "DATA_ASSET_PK_FK_COLUMNS"
		("CONSTRAINT_ID",
		 "CONTAINER_ID",
		 "COLUMN_INDEX")
	ON DELETE CASCADE
	ON UPDATE NO ACTION
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

Oracle

Sentencia CREATE TABLE:

CREATE TABLE data_asset_fk_ref_columns (
  constraint_id VARCHAR2(128) NOT NULL,
  column_index NUMBER(10) NOT NULL,
  container_id VARCHAR2(256) NOT NULL,
  column_name VARCHAR2(36) NOT NULL,
  asset_id VARCHAR2(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
  	(constraint_id,
	container_id,
	column_index)
);

Sentencias ALTER TABLE:

ALTER TABLE data_asset_fk_ref_columns
	ADD CONSTRAINT fk_data_asset_fk_ref_columns_data_asset_pk_fk_columns_3
	FOREIGN KEY
		(container_id,
		constraint_id,
		column_index)
	REFERENCES data_asset_pk_fk_columns
		(container_id,
		constraint_id,
		column_index)
	ON DELETE CASCADE
	ON UPDATE NO ACTION;

ALTER TABLE data_asset_fk_ref_columns
	ADD CONSTRAINT fk_data_asset_fk_ref_columns_container_data_asset_columns_4
	FOREIGN KEY
		(container_id,
		asset_id,
		column_name)
	REFERENCES container_data_asset_columns
		(container_id,
		asset_id,
		name)
	ON DELETE CASCADE
	ON UPDATE NO ACTION;

Tablas de informes sobre relaciones patrimoniales

relaciones_entre_activos_y_artefactos

tabla container_assets_associations

tabla asset_tags

tabla «governance_artifact_container_associations»

tabla «data_asset_column_artifact_associations»

tabla «column_to_asset_relations»

tabla de relaciones columna a columna

relaciones_entre_columnas_y_artefactos

columnas de clave primaria y clave externa de activos de datos

columnas_de_referencia_de_la_clave_fortea_del_activo_de_datos

Más información