dbo.FactCurrencyRate
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | FactCurrencyRate |
| Module | Currency Rates |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | CurrencyKey | int | dbo.DimCurrency | |||||
| References: dbo.DimCurrency | ||||||||
| 2 | DateKey | int | dbo.DimDate | |||||
| References: dbo.DimDate | ||||||||
| 3 | AverageRate | float | ||||||
| 4 | EndOfDayRate | float | ||||||
| 5 | Date | datetime | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactCurrencyRate | dbo.DimCurrency | dbo.FactCurrencyRate.CurrencyKey = dbo.DimCurrency.CurrencyKey | FK_FactCurrencyRate_DimCurrency | |
|
dbo.FactCurrencyRate.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactCurrencyRate_DimCurrency |
||||
| dbo.FactCurrencyRate | dbo.DimDate | dbo.FactCurrencyRate.DateKey = dbo.DimDate.DateKey | FK_FactCurrencyRate_DimDate | |
|
dbo.FactCurrencyRate.DateKey = dbo.DimDate.DateKey Name: FK_FactCurrencyRate_DimDate |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_FactCurrencyRate_CurrencyKey_DateKey | CurrencyKey, DateKey |
Uses
| Name |
|---|
|
dbo.FactCurrencyRate
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58