Workspaces reporting tables

Check the Postgres, Db2 statements for the tables that are related to your workspaces.

Subject area	Table name	Description
Workspaces	containers	Catalogs and projects that are created.
Workspaces	projects	A project and its members.
Workspaces	container_assets	The assets that are defined in a catalog or project.
Workspaces	container_data_assets	The data assets that are defined in a catalog or project.
Workspaces	container_data_asset_columns	The columns in a data asset.
Workspaces	data_asset_column_tags	The tags that are associated with the columns.
Workspaces	asset_collaborators	A list of all the members of an asset.
Workspaces	container_members	A list of all the members of a catalog or project.
Workspaces	data_asset_column_class_distribution	Suggested data classes for a column with confidence.
Workspaces	data_asset_column_prop_values	Custom attribute column values.

containers table

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

This table has the following columns:

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

Postgres

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

Db2

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 table

This table contains information about a project and its members.

This table has the following columns:

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

Postgres

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(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(project_id));

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 ;

Db2

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 table

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

This table has the following columns:

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

Postgres

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 text,
asset_type varchar(128) not null,
owner varchar(128) not null,
source text,
source_additional_info text,
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(6) not null,
modified_by varchar(128),
modified_on timestamp(6),
origin_country varchar(128) not null,
rating float,
total_ratings integer,
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 container_assets add constraint fk_container_assets_containers_2 foreign key (container_id) references containers(container_id) on
delete
	cascade on
	update
	no action

Db2

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

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 table

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

This table has the following columns:

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

Postgres

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

Db2

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 table

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

This table has the following columns:

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

Postgres

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) null,
	"name" varchar(256) not null,
	description text null,
	quality_score float8 null,
	reviewed_on timestamp(6) null,
	source_data_type varchar(32) null,
	distinct_count int8 not null default 0,
	unique_count int8 not null default 0,
	null_count int8 not null default 0,
	empty_count int8 not null default 0,
	min_length int8 not null default 0,
	max_length int8 not null default 0,
	mean_length int8 not null default 0,
	std_deviation float8 not null default 0,
	is_nullable numeric(1) not null default 1,
	tech_start timestamp(6) not null default CURRENT_TIMESTAMP,
	tech_end timestamp(6) not null default to_timestamp('9999-12-30'::text,
'YYYY-MM-DD'::text),
	ts_id timestamp(6) not null default CURRENT_TIMESTAMP,
	constraint container_data_asset_columns_is_nullable_check check ((is_nullable = any (array[(0)::numeric,
(1)::numeric]))),
	constraint container_data_asset_columns_pkey 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

Db2

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 clob,
quality_score float,
reviewed_on timestamp(12),
source_data_type varchar(32),
distinct_count bigint DEFAULT 0 NOT NULL,
unique_count bigint DEFAULT 0 NOT NULL,
null_count bigint DEFAULT 0 NOT NULL,
empty_count bigint DEFAULT 0 NOT NULL,
min_length bigint DEFAULT 0 NOT NULL,
max_length bigint DEFAULT 0 NOT NULL,
mean_length bigint DEFAULT 0 NOT NULL,
std_deviation float DEFAULT 0 NOT NULL,
is_nullable decimal(1) CHECK (is_nullable IN (0, 1)) DEFAULT 1 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),
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 table

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

This table has the following columns:

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

Postgres

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(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,
column_name,
tag_name));

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

Db2

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 table

This table contains a list of all the members of an asset.

This table has the following columns:

asset_id - The identifier of the asset.
container_id - The identifier of the catalog.
user_id - The identifier of the collaborator.

Postgres

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(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,
user_id));

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

Db2

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 table

This table contains a list of all members of a catalog or project.

This table has the following columns:

container_id - The identifier of the catalog or project.
member_id - 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 - The roles that are assigned to the user or user group, for example Admin, Editor or Viewer.

Postgres

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(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,
member_id));

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

Db2

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

data_asset_column_class_distribution table

This table has the following columns:

issue_id - The identifier for the asset issue.
asset_id - The asset identifier.
container_id - The identifier of the project.
column_name - The name of the column for which you are running the data quality rules and analysis.
data_class_artifact_id - The identifier of the data class artifact.

Postgres

CREATE TABLE statement:

CREATE TABLE IF NOT EXISTS data_asset_column_class_distribution (
  asset_id character varying(36) COLLATE pg_catalog.default NOT NULL,
  container_id character varying(36) COLLATE pg_catalog.default NOT NULL,
  column_name character varying(256) COLLATE pg_catalog.default NOT NULL,
  data_class_artifact_id character varying(128) COLLATE pg_catalog.default NOT NULL,
  confidence double precision,
  count bigint NOT NULL DEFAULT 0,
  tech_start timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tech_end timestamp(6) without time zone NOT NULL DEFAULT to_timestamp('9999-12-30' :: text, 'YYYY-MM-DD' :: text),
  ts_id timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT data_asset_column_class_distribution_pkey PRIMARY KEY (
    asset_id,
    container_id,
    column_name,
    data_class_artifact_id
  ),
  CONSTRAINT fk_data_asset_column_class_distribution_container_data_asset_co FOREIGN KEY (container_id, asset_id, column_name) REFERENCES container_data_asset_columns (container_id, asset_id, name) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT fk_data_asset_column_class_distribution_governance_artifacts_8 FOREIGN KEY (data_class_artifact_id) REFERENCES governance_artifacts (artifact_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
)

Db2

CREATE TABLE statement:

CREATE TABLE DATA_ASSET_COLUMN_CLASS_DISTRIBUTION (
  ASSET_ID VARCHAR(36 OCTETS) NOT NULL,
  CONTAINER_ID VARCHAR(36 OCTETS) NOT NULL,
  COLUMN_NAME VARCHAR(256 OCTETS) NOT NULL,
  DATA_CLASS_ARTIFACT_ID VARCHAR(128 OCTETS) NOT NULL,
  CONFIDENCE DOUBLE,
  COUNT BIGINT NOT NULL WITH DEFAULT 0,
  TECH_START TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW BEGIN,
  TECH_END TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW END,
  TS_ID TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS TRANSACTION START ID,
  PERIOD SYSTEM_TIME (TECH_START, TECH_END)
) IN USERSPACE1 ORGANIZE BY ROW;

ALTER TABLE statements:

ALTER TABLE
  DATA_ASSET_COLUMN_CLASS_DISTRIBUTION
ADD
  PRIMARY KEY (
    ASSET_ID,
    CONTAINER_ID,
    COLUMN_NAME,
    DATA_CLASS_ARTIFACT_ID
  ) ENFORCED;

ALTER TABLE
  DATA_ASSET_COLUMN_CLASS_DISTRIBUTION
ADD
  VERSIONING USE HISTORY TABLE HIST_DATA_ASSET_COLUMN_CLASS_DISTRIBUTION;

ALTER TABLE
  DATA_ASSET_COLUMN_CLASS_DISTRIBUTION
ADD
  CONSTRAINT FK_DATA_ASSET_COLUMN_CLASS_DISTRIBUTION_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 ENFORCED ENABLE QUERY OPTIMIZATION;

ALTER TABLE
  DATA_ASSET_COLUMN_CLASS_DISTRIBUTION
ADD
  CONSTRAINT FK_DATA_ASSET_COLUMN_CLASS_DISTRIBUTION_GOVERNANCE_ARTIFACTS_8 FOREIGN KEY (DATA_CLASS_ARTIFACT_ID) REFERENCES GOVERNANCE_ARTIFACTS (ARTIFACT_ID) ON DELETE CASCADE ON UPDATE NO ACTION ENFORCED ENABLE QUERY OPTIMIZATION;

data_asset_column_prop_values table

This table has the following columns:

column_name -
container_id - Specifies the identifier of the catalog/project.
asset_id - The identifier for an asset to which the custom property is associated with.
property_id - The identifier for a custom property.
property_group_id - The identifier for the group that has a property defined below it.
value_id - The value identifier for a given column property.
asset_type - The type of asset for which the custom property is applicable to.
property_text_value - The value of the text custom property.
property_num_value - The value of the number custom property.
property_date_value - The value of the date custom property.

Postgres

CREATE TABLE statement:

CREATE TABLE data_asset_column_prop_values (
	column_name varchar(256) NOT NULL,
	container_id varchar(36) NOT NULL,
	asset_id varchar(128) NOT NULL,
	property_id varchar(256) NOT NULL,
	property_group_id varchar(256) NOT NULL,
	value_id varchar(256) NOT NULL,
	asset_type varchar(256) NOT NULL,
	property_text_value text NULL,
	property_num_value float8 NULL,
	property_date_value timestamp(6) NULL,
	tech_start timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
	tech_end timestamp(6) NOT NULL DEFAULT to_timestamp('9999-12-30'::text, 'YYYY-MM-DD'::text),
	ts_id timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT data_asset_column_prop_values_pkey PRIMARY KEY (column_name, container_id, asset_id, property_id, property_group_id, value_id, asset_type)
);

Db2

CREATE TABLE statement:

CREATE TABLE data_asset_column_prop_values(column_name varchar(256) NOT NULL,
container_id varchar(36) NOT NULL,
asset_id varchar(128) NOT NULL,
property_id varchar(256) NOT NULL,
property_group_id varchar(256) NOT NULL,
value_id varchar(256) NOT NULL,
asset_type varchar(256) NOT NULL,
property_text_value clob,
property_num_value double,
property_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(column_name,
container_id,
asset_id,
property_id,
property_group_id,
value_id,
asset_type),
period SYSTEM_TIME (tech_start,
tech_end) )

ALTER TABLE statements:

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

ALTER TABLE data_asset_column_prop_values ADD CONSTRAINT fk_data_asset_column_prop_values_asset_type_custom_properties_2 FOREIGN KEY (property_id,
property_group_id,
asset_type) REFERENCES asset_type_custom_properties(property_id,
property_group_id,
asset_type) ON
DELETE
	CASCADE ON
	UPDATE
	NO ACTION

Learn more

Parent topic: Reporting tables