AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.CountryRegionCurrency
Description:Cross-reference table mapping ISO currency codes to a country or region.
Primary Keys:CountryRegionCode
CurrencyCode
FieldTypeDefaultsNulls?Comments
CountryRegionCodenvarchar (3)NoneNoISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCodenchar (3)NoneNoISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeYesYesCountryRegionCode
CurrencyCode
IX_CountryRegionCurrency_CurrencyCodeNoNoCurrencyCode

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_CountryRegionCurrency_CountryRegion_CountryRegionCodeCountryRegionCodePerson.CountryRegion
FK_CountryRegionCurrency_Currency_CurrencyCodeCurrencyCodeSales.Currency

No primary keys as foreign key constraints
No triggers