diff options
| author | Walter Pagani <paganiwalter@gmail.com> | 2021-01-12 07:06:34 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-12 11:06:34 +0100 |
| commit | 0f58858d1b12ebaf1c97c9444c33122b4c3b5643 (patch) | |
| tree | 1e172ce8127f93b11a4cc4269828c140a491073e | |
| parent | 58854d415c5ab6b19fcd530edd7726f35cc143f4 (diff) | |
| download | wiki-0f58858d1b12ebaf1c97c9444c33122b4c3b5643.tar.gz wiki-0f58858d1b12ebaf1c97c9444c33122b4c3b5643.tar.bz2 wiki-0f58858d1b12ebaf1c97c9444c33122b4c3b5643.zip | |
chore(ip2nationCountries): update ip2nationCountries.md (#346)
| -rw-r--r-- | docs/ip2nationCountries.md | 54 |
1 files 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 | |