There are no notfications.

Database table of country code top-level domains

Database table of country code top-level domains
Initial release: 22 August 2016
Current release: 22 August 2016
Written in: SQL (UTF-8)
Size: 3186 bytes
Available in:
Licence: Database: ODbL
Database contents: DbCL
Documentation: CC BY 4.0
Download: Database-table-of-country-code-top-level-domains.zip

The database table 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 table of countries resource.

Tables

country_domains

The country_domains table contains all the ccTLDs and indicates their activity status.

Table columns
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

Directory listing
  • Database table of countries directory
    • Data directory
      • Creation directory
        • country_domains.sql file
      • Modification directory
        • iso_3166_1.sql file
    • Testing directory
      • country_domains_iso_3166_1.sql file

Data (directory)

The Data directory contains all SQL scripts that create and modify the database tables.

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 table of countries resource.

Testing (directory)

The Testing directory contains files used for testing the solution during development.

Licence

The database table 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.