CREATE TABLE Postcodes_import
(
	i_FederalStates              TEXT NULL,
	i_AdministrativeDistricts    TEXT NULL,
	i_Counties                   TEXT NULL,
	i_PostCodes                  TEXT NULL,
    i_PostCodes_DialCode         TEXT NULL,
    i_PostCodes_GC_latitude      TEXT NULL,
    i_PostCodes_GC_longitude     TEXT NULL,
	i_CityNames_Official         TEXT NULL,
	i_CityNames_DE               TEXT NULL,
	i_CityNames_EN               TEXT NULL,	
	i_Streets_StreetName         TEXT NULL,
	i_Streets_GC_latitude        TEXT NULL,
    i_Streets_GC_longitude       TEXT NULL,	
	i_Housenumbers_Housenumber   TEXT NULL,
	i_Housenumbers_GC_latitude   TEXT NULL,
    i_Housenumbers_GC_longitude  TEXT NULL,
	i_PostBox_PostboxNrFrom      TEXT NULL,
	i_PostBox_PostboxNrTo        TEXT NULL,
	i_PostBox_CityPostCodeFrom   TEXT NULL,
	i_PostBox_CityPostCodeTo     TEXT NULL,
	i_PostBox_PostboxPostCode    TEXT NULL
);
-- "GC" refers to Geo-Coordinates

-- The folowing fields will be added to the table "Postcodes_import"
-- i_ID
-- i_PostCode_CenterPoint
-- i_Streets_CenterPoint
-- i_Housenumbers_CenterPoint
-- i_AdministrativeDistricts_unique
-- i_Counties_unique
-- i_FederalStateid
-- i_AdministrativeDistrictid
-- i_Countyid