GEONDDS

Holds GEO node descriptions.

Column Descriptions:

Name	Type	Description
GEONDDS_ID	INTEGER NOT NULL	The GEO node description ID.
GEONODE_ID	INTEGER NOT NULL	The GEO node ID. Foreign key to GEONODE.GEONODE_ID.
LANGUAGE_ID	INTEGER NOT NULL	The language ID. Foreign key to LANGUAGE.LANGUAGE_ID.
NAME	VARCHAR (128) NOT NULL	The name of the node. For example, Canada.
DESCRIPTION	VARCHAR (254)	The description of the GEO node.
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>	GEONDDS_ID	Primary Key
I0001216	GEONODE_ID+LANGUAGE_ID	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3574	GEONODE_ID	GEONODE	GEONODE_ID	Cascade
F_3575	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade