STLOC

Represents store location information.

Column Descriptions:

NameTypeDescription
STLOC_IDINTEGER NOT NULLStore location ID.
IDENTIFIERVARCHAR (128) NOT NULLStore location external identifier. (unique index)
PHONECHAR (32)Store location phone number.
FAXCHAR (32)Store location fax number.
ADDRESS1VARCHAR (128)Store location address line 1.
ADDRESS2VARCHAR (64)Store location address line 2.
ADDRESS3VARCHAR (64)Store location address line 3
CITYVARCHAR (128)The city that the store locates.
STATEVARCHAR (128)The state or province of the store location.
COUNTRYVARCHAR (128)The country or region of the store location.
ZIPCODECHAR (40)The zip or postal code of the store location.
ACTIVESMALLINT NOT NULL DEFAULT 11 if the store is active. Otherwise, 0.
LATITUDEDECIMAL (20,5) NOT NULLLatitude of the store in degrees north or south of the equator.
LONGITUDEDECIMAL (20,5) NOT NULLLongitude of the store in degrees east or west of the Greenwich meridian.
GEONODE_IDINTEGERThe ID of the geo node that the store locates. Foreign key to GEONODE.GEONODE_ID.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The reference number of the store.
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>STLOC_IDPrimary Key
I0001460STOREENT_ID+IDENTIFIERUnique Index
I0001210LATITUDE+LONGITUDENon-Unique Index
I0001211GEONODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3569GEONODE_IDGEONODEGEONODE_IDCascade
F_3731STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3570STLOC_IDSTLOCATTRSTLOC_IDCascade
F_3572STLOC_IDSTLOCDSSTLOC_IDCascade
F_3578STLOC_IDSTLFFMRELSTLOC_IDCascade
F_3583STLOC_IDINVAVLSTLOC_IDCascade
F_3588STLOC_IDINVCNFRELSTLOC_IDCascade