RELATIONSHIP

Description

This table stores the relationship information between points of interest.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the relationship.
POI_ID bigint The ID of the point of interest.
TYPE varchar The type of relationship.
RELATIONSHIPS_POI_ID bigint The ID of the related point of interest.
RELATIONSHIPS_HJORDER int The HJORDER value of the relationship.

Primary Key

  • ID

Foreign Key Relationships

  • RELATIONSHIPS_POI_ID references POI(ID)