Region Table – Denormalized Model
The following table defines the columns, explanations, and data types for the Regions table within the Postal Database denormalized data schema.
|
Column Name |
Description |
Example (DE) |
Data Type |
|---|---|---|---|
|
ISO |
ISO 3166-1 Country code (alpha-2) defining a unique code for the name of each country. |
DE |
CHAR(2) |
|
Country |
Country name. |
Germany |
VARCHAR(50) |
|
Language |
Language code; allows selection of a specific version when names are provided in different languages due to multiple official languages or non-Latin alphabets. |
DE |
CHAR(2) |
|
Level |
Administrative level; a value ranked from 0 (country/largest division) to 4 (smallest division). |
1 |
INTEGER |
|
Type |
The type of the administrative division (e.g., State, Province, District, Commune). |
Gemeindeverband |
VARCHAR(50) |
|
Name |
The name of the administrative division. |
Aachen |
VARCHAR(80) |
|
Region1 |
Administrative division level 1 name. |
Nordrhein-Westfalen |
VARCHAR(80) |
|
Region2 |
Administrative division level 2 name. |
Köln |
VARCHAR(80) |
|
Region3 |
Administrative division level 3 name. |
Städteregion Aachen |
VARCHAR(80) |
|
Region4 |
Administrative division level 4 name. |
Aachen |
VARCHAR(80) |
|
ISO2 |
ISO 3166-2 Region code; defines codes for the names of the principal subdivisions. |
DE-NW |
VARCHAR(10) |
|
FIPS |
NGA Geopolitical code (Formerly FIPS PUB 10-4). |
GM07 |
VARCHAR(10) |
|
NUTS |
European statistical division code. |
DEA2D |
VARCHAR(10) |
|
HASC |
Hierarchical administrative subdivision code. |
DE.NW.KL |
VARCHAR(12) |
|
STAT |
National statistics/census code. |
053340002 |
VARCHAR(20) |