ScrewTurn Wiki

Edit

wikibot

TableSales.CountryRegionCurrency
DescriptionCross-reference table mapping ISO currency codes to a country or region.

Edit

Columns

ColumnData TypeNullableDefaultDescription
CountryRegionCodenvarchar(3)not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCodenchar(3)not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeCountryRegionCode, CurrencyCode

Edit

Indexes

IndexTypeColumns
IX_CountryRegionCurrency_CurrencyCode CurrencyCode

Edit

Foreign Keys

RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.CurrencyCurrencyCodeCurrencyCode

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales

Edit

automatically generated

TableSales.CountryRegionCurrency
DescriptionCross-reference table mapping ISO currency codes to a country or region.

ColumnData TypeNullableDefaultDescription / PK / Index
CountryRegionCodenvarchar(3)not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCodenchar(3)not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.CurrencyCurrencyCodeCurrencyCode

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.