POIS_TYPE
Description
Table for storing types of points of interest.
Columns
| Column Name | Data Type | Description |
| ID | bigint(20) NOT NULL |
Primary key for the table. |
| DISTANCE_IN_METERS | double NOT NULL |
Distance in meters for the point of interest. |
| SEARCH_SCOPE_POIS_TYPEID | bigint(20) DEFAULT NULL |
Foreign key referencing the ID column in the POISEARCH_SCOPE table. |
Foreign Key Relationships
- FOREIGN KEY ( SEARCH_SCOPE_POIS_TYPEID ) REFERENCES POISEARCH_SCOPE ( ID ): Establishes a foreign key relationship with the POISEARCH_SCOPE table.