Ian Timothy ianthrive
fiee
/ laenderinfos.sql
Last active
July 17, 2023 14:04
table of information about all countries of the world (German names)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE adressen.land | |
| ( | |
| isocode_2 character(2) not null, -- ISO 3166 ALPHA-2 | |
| isocode_3 character(3) not null, -- ISO 3166 ALPHA-3 | |
| name character varying not null, -- deutscher Name des Landes (international besser via ISO-Code ankoppeln!) // German name of the country | |
| vorwahl integer default null, -- internationale Vorwahl // international phone code | |
| null_bei_vorwahl boolean default FALSE, -- muss man die Null der Ortsvorwahl auch nach der internationalen Vorwahl wählen? // must one dial zero between international and local phone code? | |
| vorwahl_lokal boolean default FALSE, -- muss man vor Ort die Vorwahl wählen? // must one dial the local phone code also locally? | |
| tld character varying default NULL, -- Top Level Domain | |
| kfz character varying default NULL, -- KFZ-Kennzeichen // car code |
NewerOlder