STLOCDS

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