0 / 0
Description of Db2 SQL tables used for Watson Knowledge Catalog reporting

Description of Db2 SQL tables used for Watson Knowledge Catalog reporting

The detailed descriptions of Db2 SQL tables help you to better understand the structure of the database where you send your Watson Knowledge Catalog data and generate more meaningful reports.

Each table description contains the list of table columns with short descriptions and the CREATE TABLE SQL statement. In some cases, ALTER TABLE and CREATE INDEX statements are provided.

Each of these tables has a history table that is associated with it. The name of a history table starts with the prefix hist_ followed by the table name.

For more information about statements specific to PostgreSQL database, see Description of PostgreSQL SQL tables used for Watson Knowledge Catalog reporting.

The list of tables:

containers

This table contains information about the catalogs and projects that are created on the platform.

  • container_id - Specifies the identifier of the catalog or project.
  • container_type - Specifies whether the type of the container is a catalog or project.
  • name - Specifies the name of the catalog or project.
  • description - Specifies the description of the container.
  • is_governed - Specifies whether the catalog is governed or not. Applicable to catalogs only.
  • created_by - Specifies the identifier of the user that created the container.
  • created_on - Specifies the timestamp when the container was created.

CREATE TABLE statement:

CREATE TABLE containers(container_id varchar(36) NOT NULL,container_type varchar(16) NOT NULL,name varchar(256) NOT NULL,description clob,is_governed boolean NOT NULL,created_by varchar(128) NOT NULL,created_on timestamp(12) 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), PERIOD SYSTEM_TIME (tech_start,tech_end) )

projects

This table contains information about a project and its members.

  • project_id - Specifies the identifier of the project.
  • project_name - Specifies the name of the project.
  • enforce_members - Specifies whether the project members are scoped to the account or SAML of the creator.

CREATE TABLE statement:

CREATE TABLE projects(project_id varchar(36) NOT NULL,project_name varchar(256) NOT NULL,enforce_members boolean 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(project_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statement:

ALTER TABLE projects ADD CONSTRAINT fk_projects_containers_11 FOREIGN KEY (project_id) REFERENCES containers(container_id) ON DELETE CASCADE  ON UPDATE NO ACTION

container_assets

This table contains information about the assets that are defined in a container, which is a catalog or project.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog or project.
  • container_type - Specifies whether the type of the container is a catalog or project.
  • name - Specifies the name of the asset.
  • description - Specifies the description of the asset.
  • owner - Specifies the identifier of the user that owns the asset.
  • asset_type - Specifies the type of the asset.
  • created_on - Specifies the timestamp when the asset was created.
  • modified_on - Specifies the timestamp when the asset was last modified.
  • modified_by - Specifies the identifier of the user that last modified the asset.
  • rov - Specifies the rule of visibility of the asset. For more information, see Asset primary metadata document (or card).
  • asset_state - Specifies the current state of the asset, whether available or deleted.
  • source - Specifies the information about the source of the asset by providing the source system.
  • source_additional_info - Provides additional information that is related to the source of the asset.
  • resource_key - Specifies the unique identifier for an asset that is used for deduplication.
  • asset_category - Specifies the asset category, either a user asset or system asset.
  • rating - Specifies the average social rating of the asset.
  • total_ratings - Specifies the total number of ratings of the asset.
  • format - Specifies the format of the data that is associated with the asset, for example CSV, octet-stream, or PDF.
  • origin_country - Specifies the country from which the data originated in the format complaint with ISO 3166 Country Codes.
  • size - Specifies the size of the local asset.

CREATE TABLE statement:

CREATE TABLE container_assets(container_id varchar(36) NOT NULL,container_type varchar(16) NOT NULL,asset_id varchar(128) NOT NULL,name varchar(256) NOT NULL,description clob,asset_type varchar(128) NOT NULL,owner varchar(128) NOT NULL,source clob,source_additional_info clob,resource_key varchar(256),asset_category varchar(64),rov integer NOT NULL,asset_state varchar(32) NOT NULL,format varchar(128),size varchar(36) NOT NULL,created_on timestamp(12) NOT NULL,modified_by varchar(128),modified_on timestamp(12),origin_country varchar(128) NOT NULL,rating float,total_ratings integer,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), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statement:

ALTER TABLE container_assets ADD CONSTRAINT fk_container_assets_containers_2 FOREIGN KEY (container_id) REFERENCES containers(container_id) ON DELETE CASCADE  ON UPDATE NO ACTION

container_data_assets

This table contains information about the data assets that are defined in a container, which is a catalog or project.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog or project.
  • quality_score - Specifies the quality score of the asset as determined by profiling.
  • attachments - Specifies the additional information that is associated with the data asset, for example the connection information if there are connected assets.
  • metadata_import_id - Identifier for the metadata import.
  • metadata_enrichment_id - Identifier for the metadata enrichment.
  • reviewed_on - Specifies the assets on reviewed on data.
  • connection_path - Specifies the relative connection path.
  • published_to_container_id - Specifies the identifier of the target project.
  • source_container_id - Identifier of the source container.
  • source_asset_id - Identifier of the source asset.

CREATE TABLE statement:

CREATE TABLE container_data_assets(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,attachments text,quality_score float,metadata_enrichment_id varchar(128),metadata_import_id varchar(128),reviewed_on timestamp(6),connection_path varchar(256),published_to_container_id varchar(36),source_container_id varchar(36),source_asset_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(container_id,asset_id))

ALTER TABLE statement:

ALTER TABLE catalog_data_assets ADD CONSTRAINT fk_catalog_data_assets_container_assets_12 FOREIGN KEY (container_id,asset_id) REFERENCES container_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

container_data_asset_columns

This table contains information about the individual columns in a data asset.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog or project.
  • name - Specifies the name of the column.
  • column_id - Specifies the identifier that is associated with the column, when the identifier is available.
  • quality_score - Specifies the quality score of the column as determined by profiling.
  • description - Specifies the description of the column.
  • reviewed_on - Specifies the assets on reviewed on data.

CREATE TABLE statement:

CREATE TABLE container_data_asset_columns(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,column_id varchar(128),name varchar(256) NOT NULL,description text,quality_score float,reviewed_on timestamp(6),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))

ALTER TABLE statement:

ALTER TABLE catalog_data_asset_columns ADD CONSTRAINT fk_catalog_data_asset_columns_catalog_data_assets_13 FOREIGN KEY (container_id,asset_id) REFERENCES catalog_data_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

data_asset_column_tags

This table contains information about the tags that are associated with the columns.

  • column_name - Specifies the name of the column.
  • asset_id - Specifies the identifier of the data asset.
  • container_id - Specifies the identifier of the catalog or project.
  • tagname - Specifies the name of the associated tag.

CREATE TABLE statement:

CREATE TABLE data_asset_column_tags(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,tag_name varchar(256) NOT NULL,column_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,column_name,tag_name), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE data_asset_column_tags ADD CONSTRAINT fk_data_asset_column_tags_tags_5 FOREIGN KEY (tag_name) REFERENCES tags(tag_name) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE data_asset_column_tags ADD CONSTRAINT fk_data_asset_column_tags_catalog_data_asset_columns_15 FOREIGN KEY (container_id,asset_id,column_name) REFERENCES catalog_data_asset_columns(container_id,asset_id,name) ON DELETE CASCADE  ON UPDATE NO ACTION

asset_collaborators

This table contains a list of all collaborators of an asset.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog.
  • user_id - Specifies the identifier of the collaborator.

CREATE TABLE statement:

CREATE TABLE asset_collaborators(asset_id varchar(128) NOT NULL,container_id varchar(36) 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(container_id,asset_id,user_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statement:

ALTER TABLE asset_collaborators ADD CONSTRAINT fk_asset_collaborators_container_assets_6 FOREIGN KEY (container_id,asset_id) REFERENCES container_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

container_members

This table contains a list of all members of a container, which is a catalog or project.

  • container_id - Specifies the identifier of the catalog or project.
  • member_id - Specifies the identifier of the member or group.
  • is_group - Specifies whether the member is a group. If the value is true, the value of the member_id column is the identifier of the group.
  • role - Specifies the roles that are assigned to the user or user group, for example Admin, Editor or Viewer.

CREATE TABLE statement:

CREATE TABLE container_members(container_id varchar(36) NOT NULL,is_group boolean NOT NULL,member_id varchar(64) NOT NULL,role varchar(32) 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,member_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statement:

ALTER TABLE container_members ADD CONSTRAINT fk_container_members_containers_1 FOREIGN KEY (container_id) REFERENCES containers(container_id) ON DELETE CASCADE  ON UPDATE NO ACTION

container_assets_associations

This table contains information about the relationships between the catalog assets.

  • end1_asset_id - Specifies the identifier of the end1 asset.
  • end2_asset_id - Specifies the identifier of the end2 asset.
  • end1_container_id - Specifies the identifier of the container of the end1 asset.
  • end2_container_id - Specifies the identifier of the container of the end2 asset.
  • end1_relationship_type - Specifies the relationship type as identified from the end1 asset.
  • end2_relationship_type - Specifies the relationship type as identified from the end2 asset.

CREATE TABLE statement:

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

ALTER TABLE statements:

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

asset_tags

This table contains information about the tags that are associated with an asset.

  • tag_name - Specifies the name of the associated tag.
  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog or project.

CREATE TABLE statement:

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

ALTER TABLE statements:

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

governance_artifact_container_associations

This table contains information about governance artifacts, for example business terms or classification, which is associated with a catalog asset.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog.
  • associated_artifact_id - Specifies the identifier of the associated governance artifact.
  • associated_artifact_type - Specifies the type of the associated governance artifact, for example glossary_term, classification.
  • system_id - Specifies the system identifier or global identifier of the associated governance artifact.
  • assignment_state - Specifies the assignment state of the artifact with asset.- assignment_date - Specifies the assignment date of the artifact with asset.
  • assigned_by - Specifies the person who has assigned artifact to the asset.
  • confidence - Specifies the confidence on artifact has been assigned to asset.
  • specification - Specifies the algorithm uses to assign artifact.

CREATE TABLE statement:

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

ALTER TABLE statements:

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

data_asset_column_artifact_associations

This table contains information about governance artifacts, for example business terms or classifications, which are associated with the column of the data asset.

  • name - Specifies the name of the column.
  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the catalog.
  • associated_artifact_id - Specifies the identifier of the associated governance artifact.
  • associated_artifact_type - Specifies the type of the associated governance artifact, for example glossary_term, classification.
  • system_id - Specifies the system identifier or global identifier of the associated governance artifact.
  • assignment_state - Specifies the assignment state of the artifact with column asset.
  • assignment_date - Specifies the assignment date of the artifact with column asset.
  • assigned_by - Specifies the person who has assigned artifact to the column asset.
  • confidence - Specifies the confidence on artifact has been assigned to asset.
  • specification - Specifies the algorithm uses to assign artifact.

CREATE TABLE statement:

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

ALTER TABLE statements:

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

Tags

This table contains a list of tags that are defined on the Watson Knowledge Catalog platform.

  • tag_name - Specifies the name of the tag.

CREATE TABLE statement:

CREATE TABLE tags(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(tag_name), PERIOD SYSTEM_TIME (tech_start,tech_end) )

enforcement_rules

This table contains information about the enforcement rules (data protection rules) that are defined on the Watson Knowledge Catalog platform.

  • rule_id - Specifies the identifier of the rule.
  • rule_type - Specifies the type of the rule.
  • name - Specifies the name of the rule.
  • created_by - Specifies the identifier of the user that created the rule.
  • created_on - Specifies the timestamp when the rule was created.
  • modified_by - Specifies the identifier of the user that last modified the rule.
  • modified_on - Specifies the timestamp when the rule was last modified.
  • description - Specifies the description of the rule.
  • action_name - Specifies the type of the action that this rule enforces.
  • rule_json - Specifies the JSON representation of the defined rule.

CREATE TABLE statement:

CREATE TABLE enforcement_rules(rule_id varchar(36) NOT NULL,rule_type varchar(128) NOT NULL,name varchar(256) NOT NULL,description clob,action_name varchar(256) NOT NULL,created_on timestamp(12) NOT NULL,created_by varchar(128) NOT NULL,modified_on timestamp(12),modified_by varchar(128),rule_json clob 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(rule_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

categories

This table contains information about the governance categories that are defined on the Watson Knowledge Catalog platform.

  • category_id - Specifies the identifier of the category.
  • name - Specifies the name of the category.
  • description - Specifies the description of the category.
  • created_by - Specifies the identifier of the user that created the category.
  • created_on - Specifies the timestamp when the category was created.
  • modified_by - Specifies the identifier of the user that last modified the category.
  • modified_on - Specifies the timestamp when the category was last modified.

CREATE TABLE statement:

CREATE TABLE categories(category_id varchar(128) NOT NULL,name varchar(256) NOT NULL,description clob,created_by varchar(128) NOT NULL,created_on timestamp(12) NOT NULL,modified_by varchar(128),modified_on timestamp(12),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), PERIOD SYSTEM_TIME (tech_start,tech_end) )

category_collaborators

This table contains a list of all collaborators of a category.

  • category_id - Specifies the identifier of the category.
  • user_id - Specifies the identifier of the user.
  • role - Specifies the roles that are assigned to this user or user group, for example Owner, Admin, Editor, Reviewer, or Viewer.

CREATE TABLE statement:

CREATE TABLE category_collaborators(category_id varchar(128) NOT NULL,user_id varchar(128) NOT NULL,role varchar(128) NOT NULL,user_type varchar(16) 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,user_id,role), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE category_collaborators ADD CONSTRAINT fk_category_collaborators_categories_20 FOREIGN KEY (category_id) REFERENCES categories(category_id) ON DELETE CASCADE  ON UPDATE NO ACTION

category_tags

This table contains information about the tags that are associated with a category.

  • tag_name - Specifies the name of the associated tag.
  • category_id - Specifies the identifier of the category.

CREATE TABLE statement:

CREATE TABLE category_tags(tag_name varchar(256) NOT NULL,category_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(tag_name,category_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE category_tags ADD CONSTRAINT fk_category_tags_tags_27 FOREIGN KEY (tag_name) REFERENCES tags(tag_name) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE category_tags ADD CONSTRAINT fk_category_tags_categories_25 FOREIGN KEY (category_id) REFERENCES categories(category_id) ON DELETE CASCADE  ON UPDATE NO ACTION

category_associations

This table contains information about the relationships between categories.

  • end1_category_id - Specifies the identifier of the end1 category.
  • end2_category_id - Specifies the identifier of the end2 category.
  • relationship_type - Specifies the relationship type between the two categories, for example parent_category.

CREATE TABLE statement:

CREATE TABLE category_associations(end1_category_id varchar(128) NOT NULL,end2_category_id varchar(128) NOT NULL,relationship_type varchar(256) 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_category_id,end2_category_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statement:

ALTER TABLE category_associations ADD CONSTRAINT fk_category_associations_glossary_custom_relationship_def_7 FOREIGN KEY (cr_definition_id) REFERENCES glossary_custom_relationship_def(cr_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

governance_artifacts

This table contains information about the governance artifacts that are defined in the system that are in the published state.

  • artifact_id - Specifies the identifier of the artifact.
  • version_id - Specifies the version identifier of the artifact.
  • artifact_type - Specifies the type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.
  • name - Specifies the name of the artifact.
  • description - Specifies the description of the artifact.
  • created_by - Specifies the identifier of the user that created the artifact.
  • created_on - Specifies the timestamp when the artifact was created.
  • modified_by - Specifies the identifier of the user that last modified the artifact
  • modified_on - Specifies the timestamp when the artifact was last modified.
  • primary_category_id - Specifies the identifier of the primary category of the artifact.
  • workflow_id - Specifies the identifier of the workflow configuration that was used to publish the artifact.
  • effective_start_date - Specifies the effective start date that is assigned to the artifact.
  • effective_end_date - Specifies the effective end date that is assigned to the artifact.
  • system_id - Specifies the system identifier or global identifier of the associated governance artifact.

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

This table contains a list of stewards that are assigned to a published artifact.

  • artifact_id - Specifies the identifier of the artifact.
  • user_id - Specifies the identifier of the user that is assigned as a steward.

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

This table contains information about the relationships between the governance artifacts.

  • end1_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_artifact_id - Specifies the identifier of the end2 artifact.
  • end1_artifact_type - Specifies the type of the end1 artifact.
  • end2_artifact_type - Specifies the type of the end2 artifact.
  • relationship_type - Specifies the relationship type.

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

This table contains information about the tags that are associated with an artifact.

  • tag_name - Specifies the name of the associated tag.
  • artifact_id - Specifies the identifier of the artifact.
  • artifact_type - Specifies the type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.

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

secondary_category_associations

This table contains a list of secondary categories to which an artifact is assigned.

  • artifact_id - Specifies the identifier of the artifact.
  • category_id - Specifies the identifier of the secondary category of the specified artifact.

CREATE TABLE statement:

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 statements:

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_associations

This table contains information about the relationships between business terms.

  • end1_term_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_term_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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_associations

This table contains information about the relationships between data classes.

  • end1_data_class_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_data_class_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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 

policy_associations

This table contains information about the relationships between policies.

  • end1_policy_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_policy_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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_associations

This table contains information about the relationships between reference data sets.

  • end1_rds_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_rds_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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_associations

This table contains information about the relationships between classifications.

  • end1_classifiaction_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_classifiaction_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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 

governance_rule_associations

This table contains information about the relationships between governance rules.

  • end1_rule_artifact_id - Specifies the identifier of the end1 artifact.
  • end2_rule_artifact_id - Specifies the identifier of the end2 artifact.
  • relationship_type - Specifies the type of the relationship as identified from the end1 artifact to the end2 artifact.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the end2 artifact to the end1 artifact.

CREATE TABLE statement:

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 statement:

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_associations

This table contains information about the implicit relationships between a governance artifact and enforcement rules.

  • artifact_id - Specifies the identifier of the associated governance artifact.
  • rule_id - Specifies the identifier of the enforcement rule that the associated artifact is a part of.

CREATE TABLE statement:

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 statements:

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

asset_quality_score_problems

This table contains information about the quality problems for the data asset.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the project.
  • problem_id - Specifies the identifier of the problem.
  • num_of_findings : Specifies the number of data quality problems of the asset as determined by profiling.
  • percentage - Specifies the percentage of data quality problems of the asset as determined by profiling.

CREATE TABLE statement:

CREATE TABLE asset_quality_score_problems(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,problem_id varchar(128) NOT NULL,num_of_findings float NOT NULL,percentage float 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(asset_id,container_id,problem_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statements:

ALTER TABLE asset_quality_score_problems ADD CONSTRAINT fk_asset_quality_score_problems_container_data_assets_1 FOREIGN KEY (container_id,asset_id) REFERENCES container_data_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE asset_quality_score_problems ADD CONSTRAINT fk_asset_quality_score_problems_dq_problems_3 FOREIGN KEY (problem_id) REFERENCES dq_problems(problem_id) ON DELETE CASCADE  ON UPDATE NO ACTION

asset_columns_quality_score_problems

This table contains information about the quality problems for the data asset column.

  • asset_id - Specifies the identifier of the asset.
  • container_id - Specifies the identifier of the project.
  • column_name - Specifies the name of the column.
  • problem_id - Specifies the identifier of the problem.
  • num_of_findings - Specifies the number of data quality problems of the column as determined by profiling.
  • percentage - Specifies the percentage of data quality problems of the column as determined by profiling.

CREATE TABLE statement:

CREATE TABLE asset_columns_quality_score_problems(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,column_name varchar(256) NOT NULL,problem_id varchar(128) NOT NULL,num_of_findings float NOT NULL,percentage float 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(asset_id,container_id,column_name,problem_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statements:

ALTER TABLE asset_columns_quality_score_problems ADD CONSTRAINT fk_asset_columns_quality_score_problems_container_data_asset_columns_2 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 asset_columns_quality_score_problems ADD CONSTRAINT fk_asset_columns_quality_score_problems_dq_problems_4 FOREIGN KEY (problem_id) REFERENCES dq_problems(problem_id) ON DELETE CASCADE  ON UPDATE NO ACTION

metadata_imports

This table contains information about the metadata import.

  • metadata_import_id - Identifier for the metadata import.
  • container_id - Specifies the identifier of the project.
  • metadata_import_name - Specifies the name of the metadata import.
  • target_container_id - Specifies the identifier of the target project.
  • connection_id - Specifies the identifier of the connection on which import has been created.

CREATE TABLE statement:

CREATE TABLE metadata_imports(metadata_import_id varchar(128) NOT NULL,container_id varchar(128) NOT NULL,metadata_import_name varchar(256) NOT NULL,target_container_id varchar(128),connection_id varchar(128),metadata_enrichment_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(container_id,metadata_import_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE metadata_imports ADD CONSTRAINT fk_metadata_imports_container_assets_2 FOREIGN KEY (container_id,metadata_import_id) REFERENCES container_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

metadata_import_executions

This table contains information about the Metadata Import Execution.

  • metadata_import_id - Identifier for the metadata import.
  • container_id - Specifies the identifier of the project.
  • job_run_id - Specifies the identifier of the job run.
  • invoked_by - Specifies the ID of the person who invoked it.
  • is_scheduled_run - Specifies the scheduled time of the job for metadata import execution.
  • start_time - Specifies the start time of the job for metadata import execution.
  • end_time - Specifies the end time of the job for metadata import execution.
  • state - Specifies the state of the metadata import job.
  • count_discovered - Specifies the count of num of assets has been discovered.
  • count_discovered_with_children - Specifies the count of num of assets with children has been discovered.
  • count_submitted - Specifies the count of num of assets has been discovered.
  • count_succeeded - Specifies the num of assets imported successfully.
  • count_succedded_with_children - Specifies the num of assets with children imported successfully.
  • count_new_assets - Specifies the num of new assets.
  • count_updated_assets - Specifies the num of updated assets.
  • count_deleted_assets - Specifies the num of deleted assets.

CREATE TABLE statement:

CREATE TABLE metadata_import_executions(metadata_import_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,job_run_id varchar(128) NOT NULL,invoked_by varchar(128) NOT NULL,is_scheduled_run boolean NOT NULL,start_time timestamp(12) NOT NULL,end_time timestamp(12),state varchar(32) NOT NULL,count_discovered bigint DEFAULT 0 NOT NULL,count_discovered_with_children bigint DEFAULT 0 NOT NULL,count_submitted bigint DEFAULT 0 NOT NULL,count_succeeded bigint DEFAULT 0 NOT NULL,count_succedded_with_children bigint DEFAULT 0 NOT NULL,count_new_assets bigint DEFAULT 0 NOT NULL,count_updated_assets bigint DEFAULT 0 NOT NULL,count_deleted_assets bigint DEFAULT 0 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,metadata_import_id,job_run_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statements:

ALTER TABLE metadata_import_executions ADD CONSTRAINT fk_metadata_import_executions_metadata_imports_3 FOREIGN KEY (container_id,metadata_import_id) REFERENCES metadata_imports(container_id,metadata_import_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE metadata_import_executions ADD CONSTRAINT fk_metadata_import_executions_container_assets_4 FOREIGN KEY (container_id,job_run_id) REFERENCES container_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

metadata_enrichments

This table contains information about the metadata enrichments.

  • metadata_enrichment_id - Identifier for the metadata enrichment.
  • container_id - Specifies the identifier of the project.
  • metadata_enrichment_name - Specifies the name of the metadata enrichment.

CREATE TABLE statement:

CREATE TABLE metadata_enrichments(metadata_enrichment_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,metadata_enrichment_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,metadata_enrichment_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE metadata_enrichments ADD CONSTRAINT fk_metadata_enrichments_container_assets_1 FOREIGN KEY (container_id,metadata_enrichment_id) REFERENCES container_assets(container_id,asset_id) ON DELETE CASCADE  ON UPDATE NO ACTION

dq_problems

This table contains information about all the quality problems defined for a project.

  • problem_id - Specifies the identifier of the problem.
  • name - Specifies the name of the problem.
  • description - Specifies the description of the problem.

CREATE TABLE statement:

CREATE TABLE dq_problems(problem_id varchar(128) NOT NULL,name varchar(256) NOT NULL,description text,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(problem_id))

dq_dimensions

This table contains information about the quality dimensions for the rule.

  • dimension_id - Specifies the identifier of the data quality dimension.
  • container_id - Specifies the identifier of the catalog or project.
  • name - Specifies the name of the data quality dimension.
  • description - Specifies the description of the data quality dimension.

CREATE TABLE statement:

CREATE TABLE dq_dimensions(dimension_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,name varchar(256) NOT NULL,description 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(dimension_id,container_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statement:

ALTER TABLE dq_dimensions ADD CONSTRAINT fk_dq_dimensions_containers_1 FOREIGN KEY (container_id) REFERENCES containers(container_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

dq_rule_definitions

This table contains information about the data quality rule definition.

  • rule_definition_id - Specifies the identifier of the data quality rule definition.
  • container_id - Specifies the identifier of the catalog or project.
  • expression - Specifies the expression of the data quality rule definition.
  • dq_dimension_id - Specifies the identifier of the data quality dimension.
  • name - Specifies the name of the data quality definition.

CREATE TABLE statement:

CREATE TABLE dq_rule_definitions(rule_definition_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,expression clob NOT NULL,dq_dimension_id varchar(128),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(rule_definition_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statements:

ALTER TABLE dq_rule_definitions ADD CONSTRAINT fk_dq_rule_definitions_containers_2 FOREIGN KEY (container_id) REFERENCES containers(container_id) ON DELETE CASCADE  ON UPDATE NO ACTION 
ALTER TABLE dq_rule_definitions ADD CONSTRAINT fk_dq_rule_definitions_dq_dimensions_3 FOREIGN KEY (dq_dimension_id,container_id) REFERENCES dq_dimensions(dimension_id,container_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

dq_rules

This table contains information about the data quality rule.

  • rule_id - Specifies the identifier of the data quality rule.
  • container_id - Specifies the identifier of the catalog or project.
  • rule_definition_id - Specifies the identifier of the data quality rule definition.
  • dq_dimension_id - Specifies the identifier of the data quality rule dimension.
  • name - Specifies the name of the data quality rule.
  • output_asset_id - Specifies the identifier of the output asset.
  • output_asset_container_id - Specifies the identifier of the output catalog or project.

CREATE TABLE statement:

CREATE TABLE dq_rules(rule_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,rule_definition_id varchar(128) NOT NULL,dq_dimension_id varchar(128),name varchar(256) NOT NULL,output_asset_id varchar(128),output_asset_container_id varchar(36),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(rule_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statements:

ALTER TABLE dq_rules ADD CONSTRAINT fk_dq_rules_dq_rule_definitions_4 FOREIGN KEY (rule_definition_id) REFERENCES dq_rule_definitions(rule_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION 
ALTER TABLE dq_rules ADD CONSTRAINT fk_dq_rules_dq_dimensions_5 FOREIGN KEY (dq_dimension_id,container_id) REFERENCES dq_dimensions(dimension_id,container_id) ON DELETE CASCADE  ON UPDATE NO ACTION

dq_rule_bindings

This table contains information about the rule bindings for the data quality rule.

  • rule_id - Specifies the identifier of the data quality rule.
  • variable_name - Specifies the identifier of the variable which bind to column for data quality rule.
  • column_name - Specifies the name of the column.
  • container_id - Specifies the identifier of the catalog or project.
  • asset_id - Specifies the identifier of the asset.

CREATE TABLE statement:

CREATE TABLE dq_rule_bindings(rule_id varchar(128) NOT NULL,variable_name varchar(256) NOT NULL,column_name varchar(256) NOT NULL,container_id varchar(36) NOT NULL,asset_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(rule_id,variable_name,column_name), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statements:

ALTER TABLE dq_rule_bindings ADD CONSTRAINT fk_dq_rule_bindings_dq_rules_6 FOREIGN KEY (rule_id) REFERENCES dq_rules(rule_id) ON DELETE CASCADE  ON UPDATE NO ACTION 
ALTER TABLE dq_rule_bindings ADD CONSTRAINT fk_dq_rule_bindings_container_data_asset_columns_7 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

dq_rule_execution

This table contains information about the rule execution for the data quality rule.

  • dq_rule_id - Specifies the identifier of the data quality rule.
  • job_run_id - Specifies the identifier of the job for data quality rule execution.
  • start_time - Specifies the start time of the job for data quality rule execution.
  • end_time - Specifies the end time of the job for data quality rule execution.
  • nb_tested_rows - Specifies the number of tested rows for the executed data quality rule.
  • nb_passing_rows - Specifies the number of passing rows for the executed data quality rule.
  • nb_failing_rows - Specifies the number of failing rows for the executed data quality rule.
  • percent_passing_rows - Specifies the percentage of passing rows for the executed data quality rule.
  • percent_failing_rows - Specifies the percentage of failing rows for the executed data quality rule.
  • sampling_used - Specifies whether the sampling is used for the data quality rule.
  • sample_size - Specifies the sampling size for the data quality rule.
  • sample_type - Specifies the sampling type for the data quality rule.

CREATE TABLE statement:

CREATE TABLE dq_rule_execution(dq_rule_id varchar(128) NOT NULL,job_run_id varchar(256) NOT NULL,start_time timestamp(12) NOT NULL,end_time timestamp(12) NOT NULL,nb_tested_rows bigint NOT NULL,nb_passing_rows bigint NOT NULL,nb_failing_rows bigint NOT NULL,percent_passing_rows float NOT NULL,percent_failing_rows float NOT NULL,sampling_used boolean NOT NULL,sample_size bigint,sample_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(dq_rule_id,job_run_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statement:

ALTER TABLE dq_rule_execution ADD CONSTRAINT fk_dq_rule_execution_dq_rules_8 FOREIGN KEY (dq_rule_id) REFERENCES dq_rules(rule_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

category_custom_roles

This table contains information about the custom category roles.

  • role_id - Specifies the identifier of the category custom role.
  • role_name - Specifies the name of the category custom role.

CREATE TABLE statement:

CREATE TABLE category_custom_roles(role_id varchar(32) NOT NULL,role_name varchar(128) NOT NULL, PRIMARY KEY(role_id)) ORGANIZE BY ROW 

glossary_custom_relationship_def

This table contains information about the custom relationship definitions.

  • cr_definition_id - Specifies the identifier of the custom relationship definition.
  • artifact_id -  Specifies the identifier of the custom relationship definition.
  • name - Specifies the name of the custom relationship definition.
  • created_on - Specifies the creation date of the custom relationship definition.
  • created_by - Specifies the person who has created custom relationship definition.
  • modified_on - Specifies the modification date of the custom relationship definition.
  • modified_by - Specifies the person who has modified custom relationship definition.
  • system_id - Specifies the system identified where custom relationship definition has been created.
  • type - Specifies the type of custom relationship definition.
  • reverse_name - Specifies the reverse relationship name of custom relationship definition.
  • description - Specifies the desciption of the custom relationship definition.
  • read_only - Specifies if custom relationship definition is read_only or not.
  • default_value - Specifies the default value of custom relationship definition.
  • multiple_values - Specifies if custom relationship definition can have multiple_values or not.

CREATE TABLE statement:

CREATE TABLE glossary_custom_relationship_def(cr_definition_id varchar(128) NOT NULL,artifact_id varchar(128) NOT NULL,name varchar(256) NOT NULL,created_on timestamp(12) NOT NULL,created_by varchar(128) NOT NULL,modified_on timestamp(12),modified_by varchar(128),system_id varchar(128),type varchar(128) NOT NULL,reverse_name varchar(256) NOT NULL,description varchar(256),read_only boolean NOT NULL,default_value clob(128),multiple_values boolean 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(cr_definition_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

glossary_ca_attr_artifact_type_assoc

This table contains information about the supported artifact types for custom attribute definition.

  • ca_definition_id - Specifies the identifier of the custom attribute definition.
  • artifact_type - Specifies the artifact type for which custom relationship definition is applicable.

CREATE TABLE statement:

CREATE TABLE glossary_ca_attr_artifact_type_assoc(ca_definition_id varchar(128) NOT NULL,artifact_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(ca_definition_id,artifact_type), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statement:

ALTER TABLE "BITNT2DBSAVIKASH1".glossary_ca_attr_artifact_type_assoc ADD CONSTRAINT fk_glossary_ca_attr_artifact_type_assoc_glossary_custom_attr_def_1 FOREIGN KEY (ca_definition_id) REFERENCES "BITNT2DBSAVIKASH1".glossary_custom_attr_def(ca_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

glossary_custom_relationship_nodes

This table contains information about the  source and target artifact type for custom relationship definitions.

  • cr_definition_id - Specifies the identifier of the custom relationship definition.
  • end1_artifact_type - Specifies the source artifact type of the custom relationships.
  • end2_artifact_type - Specifies the target artifact type of the custom relationships.

CREATE TABLE statement:

CREATE TABLE glossary_custom_relationship_nodes(cr_definition_id varchar(128) NOT NULL,end1_artifact_type varchar(128) NOT NULL,end2_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(cr_definition_id,end1_artifact_type,end2_artifact_type), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement

ALTER TABLE "BITNT2DBSAVIKASH1".glossary_custom_relationship_nodes ADD CONSTRAINT fk_glossary_custom_relationship_nodes_glossary_custom_relationship_def_3 FOREIGN KEY (cr_definition_id) REFERENCES "BITNT2DBSAVIKASH1".glossary_custom_relationship_def(cr_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

glossary_custom_attr_def

This table contains information about the custom attribute definitions.

  • ca_definition_id - Specifies the identifier of the custom attribute definition.
  • global_id - Specifies the global identifier of the custom attribute definition.
  • name - Specifies the name of the custom attribute definition.
  • created_on - Specifies the creation date of the custom attribute definition.
  • created_by - Specifies the person who has created custom attribute definition.
  • modified_on - Specifies the modification date of the custom attribute definition.
  • modified_by - Specifies the person who has modified custom attribute definition.
  • system_id - Specifies the system identified where custom attribute definition has been created.
  • type - Specifies the type of custom attribute definition.
  • read_only - Specifies if custom attribute definition is read_only or not.
  • default_value - Specifies the default value of custom attribute definition.
  • multiple_values - Specifies if custom attribute definition can have multiple_values or not.

CREATE TABLE statement:

CREATE TABLE glossary_custom_attr_def(ca_definition_id varchar(128) NOT NULL,global_id varchar(256) NOT NULL,name varchar(256) NOT NULL,created_on timestamp(12) NOT NULL,created_by varchar(128) NOT NULL,modified_on timestamp(12),modified_by varchar(128),system_id varchar(128),type varchar(128) NOT NULL,read_only boolean NOT NULL,default_value clob,multiple_values boolean 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(ca_definition_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

glossary_ca_enum_list

This table contains information about the  custom attribute definitions of ENUM type.

  • ca_definition_id - Specifies the identifier of the custom attribute definition of enum type.
  • value - Specifies the value of the custom attribute definition of enum type.
  • description - Specifies the description of the custom attribute definition.

CREATE TABLE statement:

CREATE TABLE glossary_ca_enum_list(ca_definition_id varchar(128) NOT NULL,value varchar(128) NOT NULL,description 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(ca_definition_id,value), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE "BITNT2DBSAVIKASH1".glossary_ca_enum_list ADD CONSTRAINT fk_glossary_ca_enum_list_glossary_custom_attr_def_2 FOREIGN KEY (ca_definition_id) REFERENCES "BITNT2DBSAVIKASH1".glossary_custom_attr_def(ca_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION 

governance_artifact_custom_attr_values

This table contains information about the custom attribute values.

  • artifact_id - Specifies the identifier of the custom relationship definition.
  • ca_definition_id - Specifies the identifier of the custom attribute definition.
  • value_id - Specifies the identifier of the custom attribute value.
  • text_value - Specifies the text value of custom attribute.
  • num_value - Specifies the numerical value of custom attribute.
  • date_value - Specifies the date value of custom attribute.

CREATE TABLE statement:

CREATE TABLE governance_artifact_custom_attr_values(artifact_id varchar(128) NOT NULL,ca_definition_id varchar(128) NOT NULL,value_id varchar(128) NOT NULL,text_value clob,num_value double,date_value timestamp(12),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,ca_definition_id,value_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW 

ALTER TABLE statement:

ALTER TABLE governance_artifact_custom_attr_values ADD CONSTRAINT fk_governance_artifact_custom_attr_values_glossary_custom_attr_def_12 FOREIGN KEY (ca_definition_id) REFERENCES glossary_custom_attr_def(ca_definition_id) ON DELETE CASCADE  ON UPDATE NO ACTION

artifact_category_associations

This table contains information about the association betweekn governance artifact and category.

  • category_id- Specifies the identifier of the category of the artifact.
  • artifact_id - Specifies the identifier of the custom relationship definition.
  • relationship_type - Specifies the type of the relationship as identified from the artifact to category.
  • cr_definition_id - Specifies the identifier of the custom relationship definition.
  • reverse_relationship_type - Specifies the type of the relationship as identified from the category to artifact.

CREATE TABLE statement:

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 statement:

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

workflow_types

This table contains information about workflow types.

  • type_id - Identifier for the workflow type.
  • name - Specifies name of the workflow type.
  • type - Specifies the type(governanance_artifacts, etc).

CREATE TABLE statement:

CREATE TABLE workflow_types(type_id varchar(128) NOT NULL,name varchar(256) NOT NULL,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(type_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

workflow_templates

This table contains information about the workflow templates.

  • template_key - Identifier of the workflow template.
  • type_id - Identifier of the workflow type this template belongs to.
  • name - Specifies the name of the workflow template.
  • is_suspended - Specifies whether the workflow template is suspended or active(boolean).

CREATE TABLE statement:

CREATE TABLE workflow_templates(template_key varchar(128) NOT NULL,type_id varchar(128) NOT NULL,name varchar(256) NOT NULL,is_suspended boolean 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(template_key), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE workflow_templates ADD CONSTRAINT fk_workflow_templates_workflow_types_1 FOREIGN KEY (type_id) REFERENCES workflow_types(type_id) ON DELETE CASCADE  ON UPDATE NO ACTION

workflow_configurations

This table contains information about the workflow configurations.

  • configuration_id - Specifies the identifier of the workflow configuration
  • name - Specifies the name of the workflow configuration
  • template_key - specifies the identifier of the template to which the workflow belongs
  • state - Specifies if the configuration is active or inactive.

CREATE TABLE statement:

CREATE TABLE workflow_configurations(configuration_id varchar(128) NOT NULL,name varchar(256) NOT NULL,template_key varchar(128) NOT NULL,state 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(configuration_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE workflow_configurations ADD CONSTRAINT fk_workflow_configurations_workflow_templates_2 FOREIGN KEY (template_key) REFERENCES workflow_templates(template_key) ON DELETE CASCADE  ON UPDATE NO ACTION

workflows

This table contains information about the workflows.

  • workflow_id - Specifies the identifier of the workflow.
  • configuration_id - Specifies the identifier of the configuration under which the workflow is created.
  • instance_state - Specifies the state of the instance, whether completed or failed.
  • workflow_state - Specifies the state of workflow (published, etc).
  • created_by - Specifies the person who created the workflow.
  • start_time - Specifies the time at which the workflow started.
  • end_time- Specifies the time at which the workflow was completed.

CREATE TABLE statement:

CREATE TABLE workflows(workflow_id varchar(128) NOT NULL,configuration_id varchar(128),instance_state varchar(256),workflow_state varchar(256),created_by varchar(128) NOT NULL,start_time timestamp(12),end_time timestamp(12),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(workflow_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE workflows ADD CONSTRAINT fk_workflows_workflow_configurations_3 FOREIGN KEY (configuration_id) REFERENCES workflow_configurations(configuration_id) ON DELETE CASCADE  ON UPDATE NO ACTION

workflow_tasks

This table contains information about the workflow tasks.

  • task_id - Specifies the identifier of the Workflow task
  • key - Specifies the current step of the workflow task (authoring, approval, review, publishing)
  • workflow_id - Specifies the identifier of the workflow under which the task belongs.
  • state - Specifies the state of workflow task (created, etc)
  • assignee - Specifies the person who is assigned to this task.
  • create_time - Specifies the creation time of the workflow.
  • due_time - Specifies the due time of the workflow.
  • claim_time - Specifies the time at which the task was claimed.
  • end_time - Specifies the time at which the task ended.

CREATE TABLE statement:

CREATE TABLE workflow_tasks(task_id varchar(128) NOT NULL,key varchar(256),workflow_id varchar(128),state varchar(256),assignee varchar(128),create_time timestamp(12) NOT NULL,due_time timestamp(12),claim_time timestamp(12),end_time timestamp(12),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(task_id), PERIOD SYSTEM_TIME (tech_start,tech_end) ) ORGANIZE BY ROW

ALTER TABLE statement:

ALTER TABLE workflow_tasks ADD CONSTRAINT fk_workflow_tasks_workflows_4 FOREIGN KEY (workflow_id) REFERENCES workflows(workflow_id) ON DELETE CASCADE  ON UPDATE NO ACTION

Learn more

Parent topic: Setting up reporting for Watson Knowledge Catalog

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