From 0f58858d1b12ebaf1c97c9444c33122b4c3b5643 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Tue, 12 Jan 2021 07:06:34 -0300 Subject: chore(ip2nationCountries): update ip2nationCountries.md (#346) --- docs/ip2nationCountries.md | 54 ++++++++++++++++++++++++++++++++++++++-------- 1 file changed, 45 insertions(+), 9 deletions(-) diff --git a/docs/ip2nationCountries.md b/docs/ip2nationCountries.md index 763e8ef..e4d217d 100644 --- a/docs/ip2nationCountries.md +++ b/docs/ip2nationCountries.md @@ -4,12 +4,48 @@ **The \`ip2nationCountries\` table** -Column | Type | Description ---- | --- | --- -Code | varchar(4) | -Iso_code_2 | varchar(2) | -Iso_code_3 | varchar(3) | -Iso_country | varchar(255) | -Country | varchar(255) | -Lat | float | -Lon | float | \ No newline at end of file +## Structure + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|---------| +| [code][1] | varchar(4) | | PRI | NO | | | | +| [iso_code_2][2] | varchar(2) | | | NO | | | | +| [iso_code_3][3] | varchar(3) | | | YES | | | | +| [iso_country][4] | varchar(255) | | | NO | | | | +| [country][5] | varchar(255) | | | NO | | | | +| [lat][6] | float | | | NO | 0 | | | +| [lon][7] | float | | | NO | 0 | | | + +[1]: #code +[2]: #iso_code_2 +[3]: #iso_code_3 +[4]: #iso_country +[5]: #country +[6]: #lat +[7]: #lon + +## Description of the fields + +### code + +### iso_code_2 + +### iso_code_3 + +### iso_country + +### country + +### lat + +### lon + +### Example + +| code | iso_code_2 | iso_code_3 | iso_country | country | lat | lon | +|------|------------|------------|----------------------|----------------------|-------|--------| +| 01 | | | | Private | 0 | 0 | +| ad | AD | AND | Andorra | Andorra | 42.3 | 1.3 | +| ae | AE | ARE | United Arab Emirates | United Arab Emirates | 24 | 54 | +| af | AF | AFG | Afghanistan | Afghanistan | 33 | 65 | +| ag | AG | ATG | Antigua and Barbuda | Antigua and Barbuda | 17.03 | -61.48 | -- cgit