Database reference - Adventure Works DW

Table - dbo_FactFinance

Table properties

namevalue
namedbo_FactFinance 
data source viewAdventure Works DW 
case sensitiveFalse 
display expression 
friendly nameFactFinance 
db schema namedbo 
db table nameFactFinance  
typeTable  

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed column expression
TimeKey  True  TimeKey  Int32  0  False              TimeKey   
OrganizationKey  True  OrganizationKey  Int32  1  False              OrganizationKey   
DepartmentGroupKey  True  DepartmentGroupKey  Int32  2  False              DepartmentGroupKey   
ScenarioKey  True  ScenarioKey  Int32  3  False              ScenarioKey   
AccountKey  False  AccountKey  Int32  4  False              AccountKey   
Amount  True  Amount  Double  5  False              Amount   

References

parent columnchild columnrelation namenested
dbo_DimAccount.  dbo_FactFinance.  FK_FactFinance_DimAccount  False 
dbo_DimDepartmentGroup.  dbo_FactFinance.  FK_FactFinance_DimDepartmentGroup  False 
dbo_DimOrganization.  dbo_FactFinance.  FK_FactFinance_DimOrganization  False 
dbo_DimScenario.  dbo_FactFinance.  FK_FactFinance_DimScenario  False 
dbo_DimTime.  dbo_FactFinance.  FK_FactFinance_DimTime  False 

Foreign key graph

dbo_DimAccountdbo_DimDepartmentGroupdbo_DimOrganizationdbo_DimScenariodbo_DimTimedbo_FactFinance

Dependency graph

Adventure Works DWdbo_FactFinance

Objects that dbo_FactFinance depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec