POINTOFINTEREST

Contains Point of Interest (POI) records.

Column Descriptions:

Name	Type	Description
POINTOFINTEREST_ID	BIGINT NOT NULL	Primary key of the POI.
IDENTIFIER	VARCHAR (256) NOT NULL	Name of the POI.
PROGRAM_ID	VARCHAR (64)	Reserved for HCL internal use. Identifies the external program that defines the POI.
STATUS	VARCHAR (16)	Reserved for HCL internal use. Used by the research prototypes to indicate whether the POI is new or has been updated.
POITYPE	VARCHAR (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_ID	INTEGER NOT NULL DEFAULT 0	Identifies the HCL Commerce store that defines the POI.
REGION_ID	VARCHAR (64)	Identifies the geographical region the POI represents or belongs to.
ZONE_ID	VARCHAR (64)	Identifies a sub-region within a region such as a physical store that the POI represents or belongs to.
CELL_ID	VARCHAR (64)	Identifies a subregion within a zone such as an aisle or department that the POI represents or belongs to.
POINT_ID	VARCHAR (64)	Identifies a point within a cell such as a kiosk or shelf that the POI represents or belongs to.
TAGS	VARCHAR (256)	Reserved for HCL internal use.
LATITUDE	DECIMAL (20,5)	Latitude (in degrees) of the POI.
LONGITUDE	DECIMAL (20,5)	Longitude (in degrees) of the POI.
ALTITUDE	DECIMAL (20,5)	Height (in meters) of the POI.
RADIUS	DECIMAL (20,5)	Radius (in meters) of the POI.
PRECEDENCE	DECIMAL (20,5) NOT NULL DEFAULT 0	Precedence of the POI.
FIELD1	BIGINT	Customizable field.
FIELD2	DECIMAL (20,5)	Customizable field.
FIELD3	VARCHAR (256)	Customizable field.
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>	POINTOFINTEREST_ID	Primary Key
I0001434	PROGRAM_ID+STORE_ID+IDENTIFIER	Unique Index
I0001436	PROGRAM_ID+STORE_ID+POITYPE+REGION_ID+ZONE_ID+CELL_ID+POINT_ID	Unique Index
I0001435	PROGRAM_ID+STORE_ID+POITYPE+LATITUDE+LONGITUDE+ALTITUDE	Non-Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3713	POINTOFINTEREST_ID	POIDESC	POINTOFINTEREST_ID	Cascade