Sales.Currency
| Documentation | AdventureWorks |
| Schema | Sales |
| Name | Currency |
| Module | Sales |
Lookup table containing standard ISO currencies.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | CurrencyCode | nchar(3) | The ISO code for the Currency. | |||||
| The ISO code for the Currency. |
||||||||
| 2 | Name | nvarchar(50) | Currency name. | |||||
| Currency name. |
||||||||
| 3 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| Sales.CountryRegionCurrency | Sales.Currency | Sales.CountryRegionCurrency.CurrencyCode = Sales.Currency.CurrencyCode | FK_CountryRegionCurrency_Currency_CurrencyCode Foreign key constraint referencing Currency.CurrencyCode. |
|
|
Sales.CountryRegionCurrency.CurrencyCode = Sales.Currency.CurrencyCode Name: FK_CountryRegionCurrency_Currency_CurrencyCodeForeign key constraint referencing Currency.CurrencyCode. |
||||
| Sales.CurrencyRate | Sales.Currency | Sales.CurrencyRate.FromCurrencyCode = Sales.Currency.CurrencyCode | FK_CurrencyRate_Currency_FromCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode. |
|
|
Sales.CurrencyRate.FromCurrencyCode = Sales.Currency.CurrencyCode Name: FK_CurrencyRate_Currency_FromCurrencyCodeForeign key constraint referencing Currency.FromCurrencyCode. |
||||
| Sales.CurrencyRate | Sales.Currency | Sales.CurrencyRate.ToCurrencyCode = Sales.Currency.CurrencyCode | FK_CurrencyRate_Currency_ToCurrencyCode Foreign key constraint referencing Currency.FromCurrencyCode. |
|
|
Sales.CurrencyRate.ToCurrencyCode = Sales.Currency.CurrencyCode Name: FK_CurrencyRate_Currency_ToCurrencyCodeForeign key constraint referencing Currency.FromCurrencyCode. |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_Currency_CurrencyCode | CurrencyCode | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_Currency_Name | Name | Unique nonclustered index. | |
| Unique nonclustered index. | |||
Used by
| Name |
|---|
|
Sales.Currency
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56