GEONODE

Represents a geographical node in the GEO tree.

Column Descriptions:

Name	Type	Description
GEONODE_ID	INTEGER NOT NULL	The GEO node ID.
IDENTIFIER	VARCHAR (64) NOT NULL	The external identifier of the node unique index.
TYPE	CHAR (4) NOT NULL	The type of the geographical location. For example, "CNTY" (Country) or "STAT" (State).
STOREENT_ID	INTEGER NOT NULL DEFAULT 0	The reference number of the store.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	GEONODE_ID	Primary Key
I0001459	STOREENT_ID+IDENTIFIER	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3730	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3569	GEONODE_ID	STLOC	GEONODE_ID	Cascade
F_3574	GEONODE_ID	GEONDDS	GEONODE_ID	Cascade
F_3576	GEONODE_ID	GEOTREE	CHILD_GEONODE_ID	Cascade
F_3577	GEONODE_ID	GEOTREE	PARENT_GEONODE_ID	Cascade