Adventure Works DW - Table - dbo

Table properties

name	value
name	dbo_DimPromotion
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimPromotion
db schema name	dbo
db table name	DimPromotion
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
PromotionKey	False	PromotionKey	Int32	0	True	True	0	1				PromotionKey
PromotionAlternateKey	True	PromotionAlternateKey	Int32	1	False							PromotionAlternateKey
DiscountPct	True	DiscountPct	Double	2	False							DiscountPct
StartDate	False	StartDate	DateTime	3	False				UnspecifiedLocal			StartDate
EndDate	True	EndDate	DateTime	4	False				UnspecifiedLocal			EndDate
MinQty	True	MinQty	Int32	5	False							MinQty
MaxQty	True	MaxQty	Int32	6	False							MaxQty
EnglishPromotionName	True	EnglishPromotionName	String	7	False					255		EnglishPromotionName
SpanishPromotionName	True	SpanishPromotionName	String	8	False					255		SpanishPromotionName
FrenchPromotionName	True	FrenchPromotionName	String	9	False					255		FrenchPromotionName
EnglishPromotionType	True	EnglishPromotionType	String	10	False					50		EnglishPromotionType
SpanishPromotionType	True	SpanishPromotionType	String	11	False					50		SpanishPromotionType
FrenchPromotionType	True	FrenchPromotionType	String	12	False					50		FrenchPromotionType
EnglishPromotionCategory	True	EnglishPromotionCategory	String	13	False					50		EnglishPromotionCategory
SpanishPromotionCategory	True	SpanishPromotionCategory	String	14	False					50		SpanishPromotionCategory
FrenchPromotionCategory	True	FrenchPromotionCategory	String	15	False					50		FrenchPromotionCategory
DiscountPctDesc	True	DiscountPctDesc	Double	16	False						True	DiscountPctDesc	show/hide DiscountPct * 100
MaxQtyDesc	True	MaxQtyDesc	Int32	17	False						True	MaxQtyDesc	show/hide CASE WHEN MaxQty IS NULL THEN '0' ELSE MaxQty END
SimpleEndDate	True	SimpleEndDate	String	18	False					93	True	SimpleEndDate	show/hide DATENAME(mm, EndDate) + ' ' + DATENAME(dd, EndDate) + ', ' + DATENAME(yy, EndDate)
SimpleStartDate	True	SimpleStartDate	String	19	False					93	True	SimpleStartDate	show/hide DATENAME(mm, StartDate) + ' ' + DATENAME(dd, StartDate) + ', ' + DATENAME(yy, StartDate)

Referenced by

parent column	child column	relation name	nested

Foreign key graph

dbo_DimPromotion dbo_FactInternetSalesdbo_FactResellerSalesFactSalesSummary

Dependency graph

Adventure Works DWdbo_DimPromotion

Objects that dbo_DimPromotion depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_DimPromotion

Table properties

Columns

Referenced by

Foreign key graph

Dependency graph

Objects that dbo_DimPromotion depends on