Adventure Works DW - Table - dbo

Table properties

name	value
name	dbo_DimCustomer
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimCustomer
db schema name	dbo
db table name	DimCustomer
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
CustomerKey	False	CustomerKey	Int32	0	True	True	0	1				CustomerKey
GeographyKey	True	GeographyKey	Int32	1	False							GeographyKey
CustomerAlternateKey	False	CustomerAlternateKey	String	2	False					15		CustomerAlternateKey
FirstName	True	FirstName	String	3	False					50		FirstName
MiddleName	True	MiddleName	String	4	False					50		MiddleName
LastName	True	LastName	String	5	False					50		LastName
NameStyle	True	NameStyle	Boolean	6	False							NameStyle
BirthDate	True	BirthDate	DateTime	7	False				UnspecifiedLocal			BirthDate
MaritalStatus	True	MaritalStatus	String	8	False					1		MaritalStatus
Suffix	True	Suffix	String	9	False					10		Suffix
Gender	True	Gender	String	10	False					1		Gender
EmailAddress	True	EmailAddress	String	11	False					50		EmailAddress
YearlyIncome	True	YearlyIncome	Decimal	12	False							YearlyIncome
TotalChildren	True	TotalChildren	Byte	13	False							TotalChildren
NumberChildrenAtHome	True	NumberChildrenAtHome	Byte	14	False							NumberChildrenAtHome
HouseOwnerFlag	True	HouseOwnerFlag	String	15	False					1		HouseOwnerFlag
NumberCarsOwned	True	NumberCarsOwned	Byte	16	False							NumberCarsOwned
AddressLine1	True	AddressLine1	String	17	False					120		AddressLine1
AddressLine2	True	AddressLine2	String	18	False					120		AddressLine2
Phone	True	Phone	String	19	False					20		Phone
DateFirstPurchase	True	DateFirstPurchase	DateTime	20	False				UnspecifiedLocal			DateFirstPurchase
FullName	True	FullName	String	21	False					153	True		show/hide CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + '.' + ' ' + LastName END
MaritalStatusDesc	True	MaritalStatusDesc	String	22	False					7	True	MaritalStatusDesc	show/hide CASE WHEN MaritalStatus = 'S' THEN 'Single' ELSE 'Married' END
GenderDesc	True	GenderDesc	String	23	False					6	True	GenderDesc	show/hide CASE WHEN Gender = 'M' THEN 'Male' ELSE 'Female' END
HouseOwnerDesc	True	HouseOwnerDesc	String	24	False					3	True	HouseOwnerDesc	show/hide CASE WHEN HouseOwnerFlag = '1' THEN 'Yes' ELSE 'No' END
CommuteDistance	True	CommuteDistance	String	25	False					15		CommuteDistance
CommuteDistanceSort	True	CommuteDistanceSort	String	26	False					1	True	CommuteDistanceSort	show/hide CASE WHEN CommuteDistance= '0-1 Miles' THEN '1' WHEN CommuteDistance= '1-2 Miles' THEN '2' WHEN CommuteDistance= '2-5 Miles' THEN '3' WHEN CommuteDistance= '5-10 Miles' THEN '4' WHEN CommuteDistance= '10+ Miles' THEN '5' END
Title	True	Title	String	27	False					8		Title
EnglishEducation	True	EnglishEducation	String	28	False					40		EnglishEducation
SpanishEducation	True	SpanishEducation	String	29	False					40		SpanishEducation
FrenchEducation	True	FrenchEducation	String	30	False					40		FrenchEducation
EnglishOccupation	True	EnglishOccupation	String	31	False					100		EnglishOccupation
SpanishOccupation	True	SpanishOccupation	String	32	False					100		SpanishOccupation
FrenchOccupation	True	FrenchOccupation	String	33	False					100		FrenchOccupation
SimpleDateFirstPurchase	True	SimpleDateFirstPurchase	String	34	False					93	True	SimpleDateFirstPurchase	show/hide DATENAME(mm, DateFirstPurchase) + ' ' + DATENAME(dd, DateFirstPurchase) + ', ' + DATENAME(yy, DateFirstPurchase)

References

parent column	child column	relation name	nested
dbo_DimGeography.	dbo_DimCustomer.	FK_DimCustomer_DimGeography	False

Referenced by

parent column	child column	relation name	nested
dbo_DimGeography.	dbo_DimCustomer.	FK_DimCustomer_DimGeography	False

Foreign key graph

dbo_DimGeographydbo_DimCustomer dbo_FactInternetSales

Dependency graph

Adventure Works DWdbo_DimCustomer

Objects that dbo_DimCustomer depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_DimCustomer

Table properties

Columns

References

Referenced by

Foreign key graph

Dependency graph

Objects that dbo_DimCustomer depends on