POI
Description
This table stores points of interest (POIs).
Columns
| Column Name | Data Type | Description |
| ID | bigint | The unique identifier of the POI. |
| NAME | varchar | The name of the POI. |
| AREA_POI_ID | bigint | The foreign key referencing the ID column of the POLYGON table. |
| CHAIN_BRAND_POI_ID | bigint | The foreign key referencing the ID column of the CHAIN_BRAND table. |
| PRODUCT_TYPEPOI_ID | bigint | The foreign key referencing the ID column of the PRODUCT_TYPE table. |
Foreign Key Relationships
- AREA_POI_ID references POLYGON (ID)
- CHAIN_BRAND_POI_ID references CHAIN_BRAND (ID)
- PRODUCT_TYPEPOI_ID references PRODUCT_TYPE (ID)