SRCHATTRDESC

Language-sensitive display name for a search column.

Column Descriptions:

Name	Type	Description
SRCHATTR_ID	BIGINT NOT NULL	Generated Primary Key
LANGUAGE_ID	INTEGER NOT NULL	The Language ID that identifies the Language.
DISPLAYNAME	VARCHAR (256)	The search attribute name to be displayed.
DESCRIPTION	VARCHAR (512)	The search attribute description.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
UP_DISPLAYNAME	VARCHAR (256)	The equivalent value of the DISPLAYNAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from the Management Center.
UP_DESCRIPTION	VARCHAR (512)	The equivalent value of the DESCRIPTION column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from the Management Center.

Indexes:

Name	Column Names	Type
P_0017	SRCHATTR_ID+LANGUAGE_ID	Primary Key
I0001487	LANGUAGE_ID	Non-Unique Index
IPF00034	UP_DISPLAYNAME	Non-Unique Index
IPF00035	UP_DESCRIPTION	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3744	SRCHATTR_ID	SRCHATTR	SRCHATTR_ID	Cascade
F_3745	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade