POINTOFINTEREST

Contains Point of Interest (POI) records.

Column Descriptions:

NameTypeDescription
POINTOFINTEREST_IDBIGINT NOT NULLPrimary key of the POI.
IDENTIFIERVARCHAR (256) NOT NULLName of the POI.
PROGRAM_IDVARCHAR (64)Reserved for HCL internal use. Identifies the external program that defines the POI.
STATUSVARCHAR (16)Reserved for HCL internal use. Used by the research prototypes to indicate whether the POI is new or has been updated.
POITYPEVARCHAR (64)The POI type. Specifically, a POI representing a geographic region should have the POI type "Region" and a POI representing a physical store should have the POI type "Store".
STORE_IDINTEGER NOT NULL DEFAULT 0Identifies the HCL Commerce store that defines the POI.
REGION_IDVARCHAR (64)Identifies the geographical region the POI represents or belongs to.
ZONE_IDVARCHAR (64)Identifies a sub-region within a region such as a physical store that the POI represents or belongs to.
CELL_IDVARCHAR (64)Identifies a subregion within a zone such as an aisle or department that the POI represents or belongs to.
POINT_IDVARCHAR (64)Identifies a point within a cell such as a kiosk or shelf that the POI represents or belongs to.
TAGSVARCHAR (256)Reserved for HCL internal use.
LATITUDEDECIMAL (20,5)Latitude (in degrees) of the POI.
LONGITUDEDECIMAL (20,5)Longitude (in degrees) of the POI.
ALTITUDEDECIMAL (20,5)Height (in meters) of the POI.
RADIUSDECIMAL (20,5)Radius (in meters) of the POI.
PRECEDENCEDECIMAL (20,5) NOT NULL DEFAULT 0Precedence of the POI.
FIELD1BIGINTCustomizable field.
FIELD2DECIMAL (20,5)Customizable field.
FIELD3VARCHAR (256)Customizable field.
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>POINTOFINTEREST_IDPrimary Key
I0001434PROGRAM_ID+STORE_ID+IDENTIFIERUnique Index
I0001436 PROGRAM_ID+STORE_ID+POITYPE+REGION_ID+ZONE_ID+CELL_ID+POINT_IDUnique Index
I0001435 PROGRAM_ID+STORE_ID+POITYPE+LATITUDE+LONGITUDE+ALTITUDENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3713POINTOFINTEREST_IDPOIDESCPOINTOFINTEREST_IDCascade