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 IBM internal use. Identifies the
external program that defines the POI. |
| STATUS | VARCHAR (16) | Reserved for IBM 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 WebSphere 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 IBM 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 |