CATENTATTR

This table is deprecated and is 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 targt ATTRIBUTE table should not be 'null', '0' or '1' (recommended value is '2').

Column Descriptions:

NameTypeDescription
CATENTATTR_IDBIGINT NOT NULLReserved for IBM internal use.
LANGUAGE_IDINTEGER NOT NULLReserved for IBM internal use.
CATENTRY_IDBIGINT NOT NULLReserved for IBM internal use.
NAMEVARCHAR (254) NOT NULLReserved for IBM internal use.
VALUEVARCHAR (254) NOT NULLReserved for IBM internal use.
DESCRIPTIONVARCHAR (254)Reserved for IBM internal use.
FIELD1INTEGERReserved for IBM internal use.
FIELD2VARCHAR (254)Reserved for IBM internal use.
FIELD3VARCHAR (254)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTATTR_IDPrimary Key
I0000063CATENTRY_ID+LANGUAGE_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_194CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_195LANGUAGE_IDLANGUAGELANGUAGE_IDCascade