Database of country code top-level domains
| Initial release: | |
|---|---|
| Current release: | |
| Written in: | SQL (UTF-8) |
| Size: | 3164 bytes |
| Available in: | — |
| Licence: | Database: ODbL Database contents: DbCL Documentation: CC BY 4.0 |
| Download: | Database-of-country-code-top-level-domains.zip |
The database of country code top-level domains (ccTLDs) resource provides the top-level domains of countries and the possibility to relate them to their respective ISO 3166-1 country codes of the database of countries resource.
Tables
country_domains
The country_domains table contains all the ccTLDs and indicates their activity status.
| Name | Type | Content | Reference |
|---|---|---|---|
| domain | char(2) | RFC 1591 ccTLDs. | – |
| country | char(2) | ISO 3166-1 alpha 2 code. | – |
| active | tinyint(1) | Boolean indicating activity. | – |
Directory contents
- Database of countries directory
- Data directory
- Creation directory
- country_domains.sql file
- Modification directory
- iso_3166_1.sql file
- Creation directory
- Testing directory
- country_domains_iso_3166_1.sql file
- Data directory
Data (directory)
The Data directory contains all SQL scripts that create and modify the databases.
Creation (directory)
country_domains.sql (file)
The country_domains.sql file contains the country_domains table.
Modification (directory)
iso_3166_1.sql (files)
The iso_3166_1.sql file relates the country column of the country_domains table to the alpha_2_code column of the iso_3166_1 table which is provided by the database of countries resource.
Testing (directory)
The Testing directory contains files used for testing the solution during development.
Licence
The database of country code top-level domains resource by eMedia Intellect is licensed under Open Database License. Any rights in individual contents of the database are licensed under Database Contents License.