SRCHATTRDESC

Language-sensitive display name for a search column.

Column Descriptions:

NameTypeDescription
SRCHATTR_IDBIGINT NOT NULLGenerated Primary Key
LANGUAGE_IDINTEGER NOT NULLThe Language ID that identifies the Language.
DISPLAYNAMEVARCHAR (256)The search attribute name to be displayed.
DESCRIPTIONVARCHAR (512)The search attribute description.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
UP_DISPLAYNAMEVARCHAR (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_DESCRIPTIONVARCHAR (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:

NameColumn NamesType
P_0017SRCHATTR_ID+LANGUAGE_IDPrimary Key
I0001487LANGUAGE_IDNon-Unique Index
IPF00034UP_DISPLAYNAMENon-Unique Index
IPF00035UP_DESCRIPTIONNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3744SRCHATTR_IDSRCHATTRSRCHATTR_IDCascade
F_3745LANGUAGE_IDLANGUAGELANGUAGE_IDCascade