Tables de génération de rapports d'artefacts de gouvernance

Retourner à la version anglaise de la documentation

Dernière mise à jour : 13 déc. 2024

Tables de génération de rapports d'artefacts de gouvernance

Vérifiez les instructions Postgres, Db2 pour les tables associées aux artefacts de gouvernance.

Domaine	Nom de la table	Descriptif
Artefacts de gouvernance	governance_artifacts	Artefacts de gouvernance définis dans le système qui sont à l'état publié.
Artefacts de gouvernance	governance_artifact_stewards	Liste des intendants affectés à un artefact publié.
Artefacts de gouvernance	governance_artifact_associations	Relations entre les artefacts de gouvernance.
Artefacts de gouvernance	artifact_tags	Etiquettes associées à un artefact.
Artefacts de gouvernance	abréviations des termes commerciaux	Abréviations attribuées aux artefacts de termes métier (de type glossary_term).

table gouvernance_artefacts

Ce tableau contient des informations sur les artefacts de gouvernance définis dans le système qui sont à l'état publié.

Cette table comporte les colonnes suivantes:

artifact_id -Identificateur de l'artefact.
version_id -Identificateur de version de l'artefact.
artifact_type -Type de l'artefact, par exemple glossary_term, classification, data_class, reference_data, rule ou policy.
name -Nom de l'artefact.
description -Description de l'artefact.
created_by -Identificateur de l'utilisateur qui a créé l'artefact.
created_on -Horodatage de la création de l'artefact.
modified_by -Identificateur de l'utilisateur qui a modifié l'artefact pour la dernière fois
modified_on -Horodatage de la dernière modification de l'artefact.
primary_category_id -Identificateur de la catégorie principale de l'artefact.
workflow_id -Identificateur de la configuration de flux de travaux qui a été utilisée pour publier l'artefact.
effective_start_date -Date de début d'effet affectée à l'artefact.
effective_end_date -Date de fin d'effet affectée à l'artefact.
system_id -Identificateur système ou identificateur global de l'artefact de gouvernance associé.
rds_values_total_counts - Nombre de valeurs de données de référence pour le type d'artefact de données de référence.

Postgres

Instruction 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)
)

Instruction CREATE INDEX :

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

Instruction 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

Instruction 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)
)

Instruction CREATE INDEX :

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

Instruction 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

Serveur MS SQL

Instruction 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
  )
)

table governance_artifact_stewards

Ce tableau contient une liste des responsables affectés à un artefact publié.

Cette table comporte les colonnes suivantes:

artifact_id -Identificateur de l'artefact.
user_id -Identificateur de l'utilisateur affecté en tant qu'intendant.

Postgres

Instruction 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));

Instruction 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

Instruction 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) )

Instruction 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

table governance_artifact_associations

Ce tableau contient des informations sur les relations entre les artefacts de gouvernance.

Cette table comporte les colonnes suivantes:

end1_artifact_id -Identificateur de l'artefact source.
end2_artifact_id -Identificateur de l'artefact cible.
end1_artifact_type -Type de l'artefact source.
end2_artifact_type -Type de l'artefact cible.
relationship_type -Type de relation.

Postgres

Instruction 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))

Instruction 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

Instruction 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

Instruction 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

Table artifact_tags

Ce tableau contient des informations sur les balises associées à un artefact.

Cette table comporte les colonnes suivantes:

tag_name -Nom de la balise associée.
artifact_id -Identificateur de l'artefact.
artifact_type -Type de l'artefact, par exemple glossary_term, classification, data_class, reference_data, rule ou policy.

Postgres

Instruction 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));

Instructions 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

Instruction 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) )

Instructions 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

table business_term_abbreviations

Cette table contient des informations sur les abréviations attribuées aux artefacts de termes métier (artefacts de type glossary_term).

Cette table comporte les colonnes suivantes:

artifact_id - L'identifiant de l'artefact glossary_term (terme commercial).
abbreviation - Abréviation de l'artefact.

Postgres

Instruction 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

Instruction 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)
)

Serveur MS SQL

Instruction 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
  )
)

En savoir plus

Rubrique parent: Tables de génération de rapports