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, such as
"Pharmacy". |
DISPLAYNAME | VARCHAR (2000) | The display name of the attribute. |
VALUE | VARCHAR (128) NOT NULL | The value of the attribute, such as "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 |