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