Business 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. |
DE |
CHAR(2) |
|
Country |
Country name. |
Germany |
VARCHAR(50) |
|
Language |
Language code. |
DE |
CHAR(2) |
|
ID |
Record identifier. |
3005491779 |
INTEGER |
|
Region1 |
Administrative division level 1. |
Baden-Württemberg |
VARCHAR(80) |
|
Region2 |
Administrative division level 2. |
Freiburg |
VARCHAR(80) |
|
Region3 |
Administrative division level 3. |
Breisgau-Hochschwarzwald |
VARCHAR(80) |
|
Region4 |
Administrative division level 4. |
Bad Krozingen |
VARCHAR(80) |
|
Entity |
Name of the entity to which the Business & Administrative postal code has been attributed. |
UTP Schweißmaterial GmbH u. Co. KG |
VARCHAR(100) |
|
Postcode |
ZIP / Postal code. |
79188 |
VARCHAR(15) |
|
Info |
Additional address information such as PO Boxes or address details. |
Bad Krozingen |
VARCHAR(100) |