Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GEOTREE
Represents a tree of geographic locations. This is a relationship table of GEONODE, such as country -> state -> city
Column Name Column Type Description GEOTREE_ID INTEGER NOT NULL Geo tree Id. CHILD_GEONODE_ID INTEGER NOT NULL Child geo node. Foreign key to GEONODE.GEONODE_ID. PARENT_GEONODE_ID INTEGER Parent 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. SEQUENCE DOUBLE The display sequence. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001217 CHILD_GEONODE_ID+PARENT_GEONODE_ID Unique Index SQL100520030338430 GEOTREE_ID Primary Key I0001218 PARENT_GEONODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3576 CHILD_GEONODE_ID GEONODE GEONODE_ID Cascade F_3577 PARENT_GEONODE_ID GEONODE GEONODE_ID Cascade _vcc_freeselect_bottom_