Difference between revisions of "Country Structure Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{Note | The Country structure table is called ''gazetteer'' and the entity is called ''Gazetteer''. The Alternative names table is called ''gazetteeralternativenames'' and th...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Note | The Country structure table is called ''gazetteer'' and the entity is called ''Gazetteer''.
+
{{Note | The Country structure table is called ''gazetteer'', the entity is called ''Gazetteer'', the target is called ''Gazetteer'' and the maXML artifact is [[Country Structure Artifact|Gazetteer]].
The Alternative names table is called ''gazetteeralternativenames'' and the level table is called ''gazetteerlevel''}}
+
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''.}}
  
 
{|
 
{|
Line 12: Line 12:
 
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 
|-
 
|-
| -||String|| Gazetteer_GUID||||Guid
+
| -||String|| gazetteer_guid||||Guid
 
|-
 
|-
| Local ID||String|| Gazetteer_LocalID||||LocalId
+
| Local ID||String|| gazetteer_localid||||LocalId
 
|-
 
|-
| Name||String|| GazetteerName||||Name
+
| Name||String|| gazetteername||||Name
 
|-
 
|-
| Country Structure Level||Level|| GazLevel_GUID||||Gazetteerlevel
+
| Country Structure Level||Level|| gazlevel_guid||||Gazetteerlevel
 
|-
 
|-
 
| -||Numeric|| lowerrightx||||LowerRightX
 
| -||Numeric|| lowerrightx||||LowerRightX
Line 24: Line 24:
 
| -||Numeric|| lowerrighty||||LowerRightY
 
| -||Numeric|| lowerrighty||||LowerRightY
 
|-
 
|-
| Parent||Parent|| ParentGazetteer_GUID||||ParentGazetteer
+
| Parent||Parent|| parentgazetteer_guid||||ParentGazetteer
 
|-
 
|-
 
| -||Numeric|| upperleftx||||UpperLeftX
 
| -||Numeric|| upperleftx||||UpperLeftX
Line 67: Line 67:
 
|}
 
|}
 
|}
 
|}
 +
 +
{{Note | 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.}}
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 16:38, 14 July 2021

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.