GEOFENCE

Description

This table stores information about geofences.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the geofence.
NAME varchar The name of the geofence.
TYPE varchar The type of the geofence.
CIRCLE_GEOFENCE_BASE_ID bigint The ID of the circle geofence base.
POLYGON_GEOFENCE_BASE_ID bigint The ID of the polygon geofence base.

Foreign Key Relationships

  • CIRCLE_GEOFENCE_BASE_ID references CIRCLE (ID)
  • POLYGON_GEOFENCE_BASE_ID references POLYGON (ID)