dbo.DimReseller - AdventureWorksDW

Columns

		Name	Data type	Attributes	References
	1	ResellerKey	int	Identity
Identity
	2	GeographyKey	int		dbo.DimGeography
References: dbo.DimGeography
	3	ResellerAlternateKey	nvarchar(15)
	4	Phone	nvarchar(25)
	5	BusinessType	varchar(20)
	6	ResellerName	nvarchar(50)
	7	NumberEmployees	int
	8	OrderFrequency	char(1)
	9	OrderMonth	tinyint
	10	FirstOrderYear	int
	11	LastOrderYear	int
	12	ProductLine	nvarchar(50)
	13	AddressLine1	nvarchar(60)
	14	AddressLine2	nvarchar(60)
	15	AnnualSales	money
	16	BankName	nvarchar(50)
	17	MinPaymentType	tinyint
	18	MinPaymentAmount	money
	19	AnnualRevenue	money
	20	YearOpened	int

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.DimReseller	dbo.DimGeography	dbo.DimReseller.GeographyKey = dbo.DimGeography.GeographyKey	FK_DimReseller_DimGeography
dbo.DimReseller.GeographyKey = dbo.DimGeography.GeographyKey Name: FK_DimReseller_DimGeography
dbo.FactResellerSales	dbo.DimReseller	dbo.FactResellerSales.ResellerKey = dbo.DimReseller.ResellerKey	FK_FactResellerSales_DimReseller
dbo.FactResellerSales.ResellerKey = dbo.DimReseller.ResellerKey Name: FK_FactResellerSales_DimReseller

Unique keys

	Key name	Columns	Description
	PK_DimReseller_ResellerKey	ResellerKey
	AK_DimReseller_ResellerAlternateKey	ResellerAlternateKey

Uses

Name
dbo.DimReseller
dbo.DimGeography

Used by

Name
dbo.DimReseller
dbo.FactResellerSales

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