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 |