GEONDDS

Holds geo node description.

Column Descriptions:

NameTypeDescription
GEONDDS_IDINTEGER NOT NULLGeo node description Id.
GEONODE_IDINTEGER NOT NULLGeo node Id. Foreign key to GEONODE.GEONODE_ID
LANGUAGE_IDINTEGER NOT NULLLanguage Id. Foreign key to LANGUAGE.LANGUAGE_ID
NAMEVARCHAR (128) NOT NULLThe name of the node. E.g. Canada.
DESCRIPTIONVARCHAR (254)The description of the geo node.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>GEONDDS_IDPrimary Key
I0001216GEONODE_ID+LANGUAGE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3574GEONODE_IDGEONODEGEONODE_IDCascade
F_3575LANGUAGE_IDLANGUAGELANGUAGE_IDCascade