dbo.FactSurveyResponse - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	FactSurveyResponse
Module	Surveys

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		SurveyResponseKey	int		Identity
Identity
	2		DateKey	int			dbo.DimDate
References: dbo.DimDate
	3		CustomerKey	int			dbo.DimCustomer
References: dbo.DimCustomer
	4		ProductCategoryKey	int
	5		EnglishProductCategoryName	nvarchar(50)
	6		ProductSubcategoryKey	int
	7		EnglishProductSubcategoryName	nvarchar(50)
	8		Date	datetime

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.FactSurveyResponse		dbo.DimCustomer	dbo.FactSurveyResponse.CustomerKey = dbo.DimCustomer.CustomerKey	FK_FactSurveyResponse_CustomerKey
dbo.FactSurveyResponse.CustomerKey = dbo.DimCustomer.CustomerKey Name: FK_FactSurveyResponse_CustomerKey
dbo.FactSurveyResponse		dbo.DimDate	dbo.FactSurveyResponse.DateKey = dbo.DimDate.DateKey	FK_FactSurveyResponse_DateKey
dbo.FactSurveyResponse.DateKey = dbo.DimDate.DateKey Name: FK_FactSurveyResponse_DateKey

Unique keys

	Key name	Columns	Description
	PK_FactSurveyResponse_SurveyResponseKey	SurveyResponseKey

Uses

Name
dbo.FactSurveyResponse
dbo.DimCustomer
dbo.DimDate

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