Contains language specific store detailed
descriptions.
Column Descriptions:
| Name | Type | Description |
| STLOCDS_ID | INTEGER NOT NULL | Store description ID. |
| STLOC_ID | INTEGER NOT NULL | Store location Id. Foreign key to
STLOC.STLOC_ID |
| LANGUAGE_ID | INTEGER NOT NULL | Language Id. Foreign key to
LANGUAGE.LANGUAGE_ID |
| NAME | VARCHAR (128) NOT NULL | Name of the store. |
| DESCRIPTION | VARCHAR (2000) | Store description. |
| IMAGE1 | VARCHAR (254) | Store image1 location. |
| IMAGE2 | VARCHAR (254) | Store image2 location. |
| FIELD1 | VARCHAR (2000) | Store information body 1. |
| FIELD2 | VARCHAR (2000) | Store information body 2. |
| FIELD3 | VARCHAR (2000) | Store information body 3. |
| 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> | STLOCDS_ID | Primary Key |
| I0001214 | STLOC_ID+LANGUAGE_ID | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3572 | STLOC_ID | STLOC | STLOC_ID | Cascade |
| F_3573 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |