0 / 0
Description of Db2 SQL tables used for Watson Knowledge Catalog reporting
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

catalog_data_assets

This table contains information about the data assets that are defined in a catalog.

  • 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.

CREATE TABLE statement:

CREATE TABLE catalog_data_assets(asset_id varchar(128) NOT NULL,container_id varchar(36) NOT NULL,attachments clob,quality_score float,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 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

catalog_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.

CREATE TABLE statement:

CREATE TABLE catalog_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 clob,quality_score float,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,name), PERIOD SYSTEM_TIME (tech_start,tech_end) )

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

catalog_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_catalog_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.

CREATE TABLE statement:

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

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.

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,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,name,associated_artifact_id), PERIOD SYSTEM_TIME (tech_start,tech_end) )

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(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_category_id,end2_category_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE category_associations ADD CONSTRAINT fk_category_associations_categories_16 FOREIGN KEY (end1_category_id) REFERENCES categories(category_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE category_associations ADD CONSTRAINT fk_category_associations_categories_17 FOREIGN KEY (end2_category_id) REFERENCES categories(category_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(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(end1_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE governance_artifact_associations ADD CONSTRAINT fk_governance_artifact_associations_governance_artifacts_1 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE governance_artifact_associations ADD CONSTRAINT fk_governance_artifact_associations_governance_artifacts_2 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE business_term_associations ADD CONSTRAINT fk_business_term_associations_governance_artifacts_4 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE business_term_associations ADD CONSTRAINT fk_business_term_associations_governance_artifacts_5 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE data_class_associations ADD CONSTRAINT fk_data_class_associations_governance_artifacts_6 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE data_class_associations ADD CONSTRAINT fk_data_class_associations_governance_artifacts_7 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE policy_associations ADD CONSTRAINT fk_policy_associations_governance_artifacts_8 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE policy_associations ADD CONSTRAINT fk_policy_associations_governance_artifacts_9 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE reference_data_set_associations ADD CONSTRAINT fk_reference_data_set_associations_governance_artifacts_10 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE reference_data_set_associations ADD CONSTRAINT fk_reference_data_set_associations_governance_artifacts_11 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE classification_associations ADD CONSTRAINT fk_classification_associations_governance_artifacts_14 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE classification_associations ADD CONSTRAINT fk_classification_associations_governance_artifacts_15 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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(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_artifact_id,end2_artifact_id,relationship_type), PERIOD SYSTEM_TIME (tech_start,tech_end) )

ALTER TABLE statements:

ALTER TABLE governance_rule_associations ADD CONSTRAINT fk_governance_rule_associations_governance_artifacts_12 FOREIGN KEY (end1_artifact_id) REFERENCES governance_artifacts(artifact_id) ON DELETE CASCADE  ON UPDATE NO ACTION
ALTER TABLE governance_rule_associations ADD CONSTRAINT fk_governance_rule_associations_governance_artifacts_13 FOREIGN KEY (end2_artifact_id) REFERENCES governance_artifacts(artifact_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

Parent topic: Setting up reporting for Watson Knowledge Catalog