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

Column Descriptions:

NameTypeDescription
CATENTATTR_IDBIGINT NOT NULLReserved for HCL internal use.
LANGUAGE_IDINTEGER NOT NULLReserved for HCL internal use.
CATENTRY_IDBIGINT NOT NULLReserved for HCL internal use.
NAMEVARCHAR (254) NOT NULLReserved for HCL internal use.
VALUEVARCHAR (254) NOT NULLReserved for HCL internal use.
DESCRIPTIONVARCHAR (254)Reserved for HCL internal use.
FIELD1INTEGERReserved for HCL internal use.
FIELD2VARCHAR (254)Reserved for HCL internal use.
FIELD3VARCHAR (254)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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