Database: CountryCurrencies Table

Description

Links a country to a currency. This is 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.

Using this table instead of explicitly linking a country and currency in their own tables allows a currency to be linked to multiple countries. For example, multiple countries use the Euro. So connecting the Euro to a specific country would create issues.

It also allows a country to be assigned multiple currencies. For example, Italy used the Lira for a long time, but then switched to the Euro. If Italy was connected to a single currency, you would only be able to enter one of these currencies.

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