Database reference - Adventure Works DW

Table - dbo_FactCurrencyRate

Table properties

namevalue
namedbo_FactCurrencyRate 
data source viewAdventure Works DW 
case sensitiveFalse 
display expression 
friendly nameFactCurrencyRate 
db schema name 
db table nameFactCurrencyRate  
typeView  

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed column expression
CurrencyKey  False  CurrencyKey  Int32  0  True              CurrencyKey   
TimeKey  True  TimeKey  Int32  1  False              TimeKey   
AverageRate  True  AverageRate  Double  2  False              AverageRate   
EndOfDayRate  True  EndOfDayRate  Double  3  False              EndOfDayRate   

References

parent columnchild columnrelation namenested
dbo_DimCurrency.  dbo_FactCurrencyRate.  FK_FactCurrencyRate_DimCurrency  False 
dbo_DimTime.  dbo_FactCurrencyRate.  FK_FactCurrencyRate_DimTime  False 
DimDestinationCurrency.  dbo_FactCurrencyRate.  FactCurrencyRate-DimDestinationCurrency  False 

Foreign key graph

dbo_DimCurrencydbo_DimTimeDimDestinationCurrencydbo_FactCurrencyRate

Dependency graph

Adventure Works DWdbo_FactCurrencyRate

Objects that dbo_FactCurrencyRate depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec