NoPublic, bureaucrat, administrator
6,632
edits
Changes
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..."
{{Note | 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''}}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | 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
|}
|}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | 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
|}
|}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | gazetteerlevel
|-
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
| -||String||gazlevel_guid||||Guid
|-
| -||String||level||||level
|-
| -||Integer||seqno||||seqNo
|}
|}
{{NavBox Data Dictionary}}
[[Category:NAA]]
The Alternative names table is called ''gazetteeralternativenames'' and the level table is called ''gazetteerlevel''}}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | 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
|}
|}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | 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
|}
|}
{|
|- valign="top"
|
[[Image:Uncategorised.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | gazetteerlevel
|-
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
| -||String||gazlevel_guid||||Guid
|-
| -||String||level||||level
|-
| -||Integer||seqno||||seqNo
|}
|}
{{NavBox Data Dictionary}}
[[Category:NAA]]
