Reference > Database > WebSphere Commerce database tables > G
WebSphere Commerce database table: GEONDDS
Holds geo node description.
Column Name Column Type Description GEONDDS_ID INTEGER NOT NULL Geo node description Id. GEONODE_ID INTEGER NOT NULL Geo node Id. Foreign key to GEONODE.GEONODE_ID LANGUAGE_ID INTEGER NOT NULL Language Id. Foreign key to LANGUAGE.LANGUAGE_ID NAME VARCHAR(128) NOT NULL The name of the node. E.g. Canada. DESCRIPTION VARCHAR(254) The description of the geo node. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001216 GEONODE_ID+LANGUAGE_ID Unique Index SQL100520030338150 GEONDDS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3574 GEONODE_ID GEONODE GEONODE_ID Cascade F_3575 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade _vcc_freeselect_bottom_