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

Revision as of 12:33, 15 October 2016

Note.jpg 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

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