There are no notfications.

Database table of currencies

Database table of currencies
Initial release:
Current release:
Written in: SQL (UTF-8)
Size: 3027 bytes
Available in:
Licence: Database: ODbL
Database contents: DbCL
Documentation: CC BY 4.0
Download: Database-table-of-currencies.zip

The database table of currencies resource provides currency codes.

Tables

iso_4217

The iso_4217 table contains all codes (alphabetic and numeric) of countries and territories considered by the ISO 4217 standard.

Table columns
Name Type Content Reference
code char(2) ISO 4217 alphabetic code.
number char(3) ISO 4217 numeric code.
exponent tinyint(3) Subunit indicator.
country char(2) ISO 3166-1 alpha 2 code.

Directory contents

Directory listing
  • Database table of currencies directory
    • Data directory
      • Creation directory
        • iso_4217.sql file
      • Modification directory
        • iso_3166_1.sql file
    • Testing directory
      • iso_4217_iso_3166_1.sql file

Data (directory)

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

Creation (directory)

iso_4217.sql (file)

The iso_4217.sql file contains the iso_4217 table.

Modification (directory)

iso_3166_1.sql (file)

The iso_3166_1.sql file relates the country column of the iso_4217 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 currencies resource by eMedia Intellect is licensed under Open Database License. Any rights in individual contents of the database are licensed under Database Contents License.