Country Structure Uncategorised

The Country structure table is called gazetteer, the entity is called Gazetteer, the target is called Gazetteer and the maXML artifact is Gazetteer. The Alternative names table is called gazetteeralternativenames (there is no target for alternative name). The level table is called gazetteerlevel and the target 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

There is an inactive table called contact which has Fkey to gazetteer. If a Village is referenced from here it cannot delete until table contact is updated.