POIGENERATED_GEOFENCE
Description
This table stores information about generated geofences for points of interest (POI).
Columns
| Column Name | Data Type | Description |
| ID | bigint(20) | Primary key. Unique identifier each for geofence. |
| NAME | varchar(255) | Name of the geofence. Cannot be null. Must be unique. |
| TYPE | varchar(255) | Type of the geofence. Cannot be null. |
| CIRCLE_GEOFENCE_BASE_ID | bigint(20) | Foreign key referencing the ID column of the CIRCLE table. Can be null. |
| POLYGON_GEOFENCE_BASE_ID | bigint(20) | Foreign key referencing the ID column of the POLYGON table. Can be null. |
Foreign Key Relationships
- CIRCLE: The CIRCLE table is referenced by the CIRCLE_GEOFENCE_BASE_ID foreign key.
- POLYGON: The POLYGON table is referenced by the POLYGON_GEOFENCE_BASE_ID foreign key.