Country Structure Uncategorised: Difference between revisions

Latest revision as of 16:38, 14 July 2021

	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.

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|<td class="navbox-image " style="width:0%;padding:0px 2px 0px 0px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form · Attachments|+2}}{{#if:Point Types

Geospatial · Geopoint|+2}}{{#if:Task · Work item · Task Child Tables|+2}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|+2}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>

{{{imageleft}}}

}}{{#if:Item Data|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|<td class="navbox-image " style="width:0%;padding:0px 0px 0px 2px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form · Attachments|+2}}{{#if:Point Types

Geospatial · Geopoint|+2}}{{#if:Task · Work item · Task Child Tables|+2}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|+2}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>

{{{image}}}

}}}}{{#if: Overview DEF
Data Entry Form · Attachments|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:country structure uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if: DEFs| DEFs<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Overview DEF

Data Entry Form · Attachments

}}{{#if:Point Types
Geospatial · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:country structure uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF

Data Entry Form · Attachments|}}{{#if: Geo data| Geo data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Point Types

Geospatial · Geopoint

}}{{#if:Task · Work item · Task Child Tables|{{#if: Task | Task <td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Task · Work item · Task Child Tables

}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|{{#if:Auxiliary Data|Auxiliary Data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places

}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|{{#if:Other|Other<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Enumeration categories · Other tables · Table differences between migrated and non-migrated databases

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:country structure uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF
Data Entry Form · Attachments Point Types

Geospatial · Geopoint|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:country structure uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

@@ 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 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}}
 [[Category:NAA]]

Country Structure Uncategorised: Difference between revisions

Latest revision as of 16:38, 14 July 2021

Navigation menu

Search