CATENTATTR

Deprecated. Provided for backward compatibility only. Attributes in this table should be migrated to the ATTRIBUTE and ATTRVALUE tables as descriptive attributes. The USAGE column in the target ATTRIBUTE table should not be 'null', '0' or '1' (recommended value is '2').

Column Descriptions:

Name	Type	Description
CATENTATTR_ID	BIGINT NOT NULL	Reserved for IBM internal use.
LANGUAGE_ID	INTEGER NOT NULL	Reserved for IBM internal use.
CATENTRY_ID	BIGINT NOT NULL	Reserved for IBM internal use.
NAME	VARCHAR (254) NOT NULL	Reserved for IBM internal use.
VALUE	VARCHAR (254) NOT NULL	Reserved for IBM internal use.
DESCRIPTION	VARCHAR (254)	Reserved for IBM internal use.
FIELD1	INTEGER	Reserved for IBM internal use.
FIELD2	VARCHAR (254)	Reserved for IBM internal use.
FIELD3	VARCHAR (254)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CATENTATTR_ID	Primary Key
I0000063	CATENTRY_ID+LANGUAGE_ID+NAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_194	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_195	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade

Related reference
Catalog entry data model