dbo.DimAccount - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimAccount
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		AccountKey	int		Identity
Identity
	2		ParentAccountKey	int			dbo.DimAccount
References: dbo.DimAccount
	3		AccountCodeAlternateKey	int
	4		ParentAccountCodeAlternateKey	int
	5		AccountDescription	nvarchar(50)
	6		AccountType	nvarchar(50)
	7		Operator	nvarchar(50)
	8		CustomMembers	nvarchar(300)
	9		ValueType	nvarchar(50)
	10		CustomMemberOptions	nvarchar(200)

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.DimAccount		dbo.DimAccount	dbo.DimAccount.ParentAccountKey = dbo.DimAccount.AccountKey	FK_DimAccount_DimAccount
dbo.DimAccount.ParentAccountKey = dbo.DimAccount.AccountKey Name: FK_DimAccount_DimAccount
dbo.DimAccount		dbo.DimAccount	dbo.DimAccount.ParentAccountKey = dbo.DimAccount.AccountKey	FK_DimAccount_DimAccount
dbo.DimAccount.ParentAccountKey = dbo.DimAccount.AccountKey Name: FK_DimAccount_DimAccount
dbo.FactFinance		dbo.DimAccount	dbo.FactFinance.AccountKey = dbo.DimAccount.AccountKey	FK_FactFinance_DimAccount
dbo.FactFinance.AccountKey = dbo.DimAccount.AccountKey Name: FK_FactFinance_DimAccount

Unique keys

	Key name	Columns	Description
	PK_DimAccount	AccountKey

Uses

Name
dbo.DimAccount
dbo.DimAccount

Used by

Name
dbo.DimAccount
dbo.DimAccount
dbo.FactFinance

Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58