Database Table: CATGRPATTR

This table holds descriptive Attributes for CatalogGroups. These Attributes are only used for descriptive purposes.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NOT NULL
The CatalogEntryGroup described by this Attribute.
CATGRPATTR_ID BIGINT
NOT NULL
The internal reference number of this CatalogGroup Attribute.
DESCRIPTION VARCHAR (254)
NULL
The description of this CatalogGroup Attribute.
LANGUAGE_ID INTEGER
NOT NULL
The language that this CatalogGroup Attribute relates to. For a list of language components, see the LANGUAGE table.
NAME VARCHAR (254)
NOT NULL
The language-dependent name of this CatalogGroup Attribute.
OID CHARACTER (32)
NULL
Reserved for IBM internal use.
SEQUENCE DOUBLE
NULL
The sequence number that is used to determine the display order.
Indexes:
Index Name Indexed Column Names Index Type
I0000068 CATGROUP_ID, LANGUAGE_ID, NAME Unique Index
SQL030416034903880 LANGUAGE_ID, CATGRPATTR_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_217 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_218 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable