Country Structure Uncategorised

The Country structure table is called gazetteer and the entity is called Gazetteer. The Alternative names table is called gazetteeralternativenames and the level table is called gazetteerlevel

gazetteer DIM Label Data type Database column name Enumcategory Pojo name - String gazetteer_guid Guid Local ID String gazetteer_localid LocalId Name String gazetteername Name Country Structure Level Level gazlevel_guid Gazetteerlevel - Numeric lowerrightx LowerRightX - Numeric lowerrighty LowerRightY Parent Parent parentgazetteer_guid ParentGazetteer - Numeric upperleftx UpperLeftX - Numeric upperlefty UpperLeftY

gazetteeralternativenames DIM Label Data type Database column name Enumcategory Pojo name - String alternativename alternativename - Parent gazetteer_guid gazetteer_guid - String gazetteeralternativename_guid gazetteeralternativename_guid - Integer sequence_number sequence_number

gazetteerlevel DIM Label Data type Database column name Enumcategory Pojo name - String gazlevel_guid Guid - String level level - Integer seqno seqNo