Holds language specific store searchable
attributes.
Column Descriptions:
| Name | Type | Description |
| STLOCATTR_ID | INTEGER NOT NULL | Store searchable attribute ID. |
| LANGUAGE_ID | INTEGER NOT NULL | Language ID. Foreign key to
LANGUAGE.LANGUAGE_ID |
| STLOC_ID | INTEGER NOT NULL | Store location Id. Foreign key to
STLOC.STLOC_ID. |
| NAME | VARCHAR (64) NOT NULL | The name of the attribute. E.g. "Pharmacy". |
| DISPLAYNAME | VARCHAR (2000) | The display name of the attribute. |
| VALUE | VARCHAR (128) NOT NULL | The value of the attribute. E.g. "true". |
| DISPLAYVALUE | VARCHAR (2000) | The display value of the attribute. |
| IMAGE | VARCHAR (254) | The image location of the attribute. |
| DISPLAYABLE | SMALLINT NOT NULL DEFAULT 1 | A flag to indicate whether the attribute is
displayable. 1 when it is displayable; otherwise, 0. |
| SEQUENCE | DOUBLE | Display order sequence. |
| 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. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | STLOCATTR_ID | Primary Key |
| I0001212 | STLOC_ID+NAME+LANGUAGE_ID | Unique Index |
| I0001213 | VALUE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3570 | STLOC_ID | STLOC | STLOC_ID | Cascade |
| F_3571 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |