Database reference - AmoAdventureWorks

Table - FactCurrencyRate

Table properties

name	value
name	FactCurrencyRate
data source view	AdventureWorksDW
case sensitive	False
display expression
friendly name	FactCurrencyRate
db schema name	dbo
db table name	FactCurrencyRate
type	Table

Columns

name	nulls	caption	data type	ordinal	unique	auto increment	auto increment seed	auto increment step	datetime mode	max length	is logical	db column name	computed column expression
CurrencyKey	False	CurrencyKey	Int32	0	False
TimeKey	False	TimeKey	Int32	1	False
AverageRate	False	AverageRate	Double	2	False
EndOfDayRate	False	EndOfDayRate	Double	3	False

References

parent column	child column	relation name	nested
DimCurrency.	FactCurrencyRate.	FK_FactCurrencyRate_CurrencyKey	False
DimTime.	FactCurrencyRate.	FK_FactCurrencyRate_TimeKey	False

Objects that FactCurrencyRate depends on

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2

Documentation generated by SqlSpec