Skip to content

Database: CountryCurrencies Table

Jump to bottom
Fifteen 15 Studios edited this page Jan 7, 2023 · 5 revisions

Description

Links a country to a currency. Used to create a list of currencies which were used by each country, and a time period during which each currency was used by that country.

Fields

  • ID - Unsinged BigInt (Primary key)
  • CountryName - Varchar(100)
  • CurrencyAbbr - VarChar(10)
  • YrStart - int(10) (UNSIGNED) (NOT NULL) (DEFAULT 9999)
  • YrEnd - int(10) (UNSIGNED) (DEFAULT NULL)

Field Descriptions

  • ID - Unique identifier for this entry
  • CountryName - String value of the name of the country
  • CurrencyAbbr - Unique abbreviation for the currency
    • REFERENCES: Currencies.Abbreviation
  • YrStart - Year this country started using this currency
  • YrEnd - Year this country stopped using this currency

Related Tables

Countries - Which country was using the currency

Currencies - Which currency was in use

Clone this wiki locally