Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GEONODE
Represents a geographical node in the geo tree.
Column Name Column Type Description GEONODE_ID INTEGER NOT NULL Geo node Id. IDENTIFIER VARCHAR(64) NOT NULL External identifier of the node. unique index TYPE CHAR(4) NOT NULL Type of the geographical location. e.g. "CNTY" (Country), "STAT" (State), OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001215 IDENTIFIER Unique Index SQL100520030338280 GEONODE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3574 GEONODE_ID GEONDDS GEONODE_ID Cascade F_3577 PARENT_GEONODE_ID GEOTREE GEONODE_ID Cascade F_3576 CHILD_GEONODE_ID GEOTREE GEONODE_ID Cascade F_3569 GEONODE_ID STLOC GEONODE_ID Cascade _vcc_freeselect_bottom_