Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales CountryRegionCurrency (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:07


wikibot

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

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.

Primary Key

Primary KeyColumns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeCountryRegionCode, CurrencyCode

Indexes

IndexTypeColumns
IX_CountryRegionCurrency_CurrencyCode CurrencyCode

Foreign Keys

RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.CurrencyCurrencyCodeCurrencyCode

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales

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