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:
Name | Type | Description |
CATENTATTR_ID | BIGINT NOT NULL | Reserved for HCL internal use. |
LANGUAGE_ID | INTEGER NOT NULL | Reserved for HCL internal use. |
CATENTRY_ID | BIGINT NOT NULL | Reserved for HCL internal use. |
NAME | VARCHAR (254) NOT NULL | Reserved for HCL internal use. |
VALUE | VARCHAR (254) NOT NULL | Reserved for HCL internal use. |
DESCRIPTION | VARCHAR (254) | Reserved for HCL internal use. |
FIELD1 | INTEGER | Reserved for HCL internal use. |
FIELD2 | VARCHAR (254) | Reserved for HCL internal use. |
FIELD3 | VARCHAR (254) | Reserved for HCL internal use. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | Reserved for HCL 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 |