The ISO_3166 country codes will be used to
Three tables were extracted from Wikipedia,
The standard form for static representation is a single table;
name | value | description |
---|---|---|
country_code_id | char(4) | identifier |
alpha-2 | char(2) | alpha-2 version |
alpha-3 | char(3) | alpha-3 version |
numeric | integer | numeric version |
start | intger | Year that this became valid |
end | integer | Year this became inactive |