Country Structure Uncategorised - Revision history

Alnaucler at 15:38, 14 July 2021

2021-07-14T15:38:43Z

← Older revision		Revision as of 17:38, 14 July 2021
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]]

Alnaucler at 08:58, 1 November 2018

2018-11-01T08:58:27Z

← Older revision		Revision as of 10:58, 1 November 2018
Line 1:		Line 1:
	{{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]].		{{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''.}}

	{\|		{\|

Alnaucler at 08:54, 1 November 2018

2018-11-01T08:54:44Z

← Older revision		Revision as of 10:54, 1 November 2018
Line 1:		Line 1:
	{{Note \| The Country structure table is called ''gazetteer'', the entity is called ''Gazetteer'' and the maXML artifact is [[Country Structure Artifact\|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'' and the level table is called ''gazetteerlevel''}}

Alnaucler at 19:52, 19 June 2017

2017-06-19T19:52:33Z

← Older revision		Revision as of 21:52, 19 June 2017
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'' 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'' and the level table is called ''gazetteerlevel''}}

Alnaucler at 11:33, 15 October 2016

2016-10-15T11:33:27Z

← Older revision		Revision as of 13:33, 15 October 2016
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

Alnaucler: 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..."

2016-02-02T21:03:47Z

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..."

New page

{{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]]