GEOTREE

Represents a tree of geographic locations. This is a relationship table of GEONODE, such as country -> state -> city

Column Descriptions:

NameTypeDescription
GEOTREE_IDINTEGER NOT NULLGeo tree Id.
CHILD_GEONODE_IDINTEGER NOT NULLChild geo node. Foreign key to GEONODE.GEONODE_ID.
PARENT_GEONODE_IDINTEGERParent geo node Id. Foreign key to GEONODE.GEONODE_ID. if this column is null, the child geo node is the root node of the tree.
SEQUENCEDOUBLEThe display sequence.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>GEOTREE_IDPrimary Key
I0001217CHILD_GEONODE_ID+PARENT_GEONODE_IDUnique Index
I0001218PARENT_GEONODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3576CHILD_GEONODE_IDGEONODEGEONODE_IDCascade
F_3577PARENT_GEONODE_IDGEONODEGEONODE_IDCascade