STLOCDS

Contains language specific store detailed descriptions.

Column Descriptions:

NameTypeDescription
STLOCDS_IDINTEGER NOT NULLStore description ID.
STLOC_IDINTEGER NOT NULLStore location Id. Foreign key to STLOC.STLOC_ID
LANGUAGE_IDINTEGER NOT NULLLanguage Id. Foreign key to LANGUAGE.LANGUAGE_ID
NAMEVARCHAR (128) NOT NULLName of the store.
DESCRIPTIONVARCHAR (2000)Store description.
IMAGE1VARCHAR (254)Store image1 location.
IMAGE2VARCHAR (254)Store image2 location.
FIELD1VARCHAR (2000)Store information body 1.
FIELD2VARCHAR (2000)Store information body 2.
FIELD3VARCHAR (2000)Store information body 3.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STLOCDS_IDPrimary Key
I0001214STLOC_ID+LANGUAGE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3572STLOC_IDSTLOCSTLOC_IDCascade
F_3573LANGUAGE_IDLANGUAGELANGUAGE_IDCascade