Diversity Gazetteer enumeration tables
Enumeration tables
The following objects are not included:
-
Logging tables
-
System objects
-
Objects marked as obsolete
-
Previous versions of objects
| Column | Data type | Description |
|---|---|---|
| Code | nvarchar (50) | - |
| Description | nvarchar (500) | - |
| DisplayText | nvarchar (50) | - |
| DisplayOrder | smallint | - |
| DisplayEnable | bit | - |
| ParentCode | nvarchar (50) | - |
| InternalNotes | nvarchar (500) | - |
| HierarchyPrefixUp | nvarchar (50) | - |
| HierarchyPrefixDown | nvarchar (50) | - |
| HierarchyPostfixUp | nvarchar (50) | - |
| HierarchyPostfixDown | nvarchar (50) | - |
Table LanguageCode_Enum
Dependent tables:
- GeoName
- GeoNameLanguage
Table PlaceType_Enum
Dependent tables:
- GeoPlace
- GeoPlaceType