Country Structure Uncategorised

From IMSMA Wiki
Revision as of 16:38, 14 July 2021 by Alnaucler (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Note.jpg 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.

Uncategorised.png

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

Uncategorised.png

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

Uncategorised.png

gazetteerlevel
DIM Label Data type Database column name Enumcategory Pojo name
- String gazlevel_guid Guid
- String level level
- Integer seqno seqNo
Note.jpg 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.