AmoAdventureWorks - Table

Table properties

name	value
name	DimProduct
data source view	AdventureWorksDW
case sensitive	False
display expression
friendly name	DimProduct
db schema name	dbo
db table name	DimProduct
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
ProductKey	False	ProductKey	Int32	0	True	True	0	1
ProductAlternateKey	True	ProductAlternateKey	String	1	False					25
ProductSubcategoryKey	True	ProductSubcategoryKey	Int32	2	False
WeightUnitMeasureCode	True	WeightUnitMeasureCode	String	3	False					3
SizeUnitMeasureCode	True	SizeUnitMeasureCode	String	4	False					3
EnglishProductName	False	EnglishProductName	String	5	False					50
SpanishProductName	False	SpanishProductName	String	6	False					50
FrenchProductName	False	FrenchProductName	String	7	False					50
StandardCost	True	StandardCost	Decimal	8	False
FinishedGoodsFlag	False	FinishedGoodsFlag	Boolean	9	False
Color	False	Color	String	10	False					15
SafetyStockLevel	True	SafetyStockLevel	Int16	11	False
ReorderPoint	True	ReorderPoint	Int16	12	False
ListPrice	True	ListPrice	Decimal	13	False
Size	True	Size	String	14	False					50
SizeRange	True	SizeRange	String	15	False					50
Weight	True	Weight	Double	16	False
DaysToManufacture	True	DaysToManufacture	Int32	17	False
ProductLine	True	ProductLine	String	18	False					2
DealerPrice	True	DealerPrice	Decimal	19	False
Class	True	Class	String	20	False					2
Style	True	Style	String	21	False					2
ModelName	True	ModelName	String	22	False					50
LargePhoto	True	LargePhoto	Byte[]	23	False
EnglishDescription	True	EnglishDescription	String	24	False					400
FrenchDescription	True	FrenchDescription	String	25	False					400
ChineseDescription	True	ChineseDescription	String	26	False					400
ArabicDescription	True	ArabicDescription	String	27	False					400
HebrewDescription	True	HebrewDescription	String	28	False					400
ThaiDescription	True	ThaiDescription	String	29	False					400
StartDate	True	StartDate	DateTime	30	False				UnspecifiedLocal
EndDate	True	EndDate	DateTime	31	False				UnspecifiedLocal
Status	True	Status	String	32	False					7
ProductLineName	True	ProductLineName	String	33	False					10	True	ProductLineName	show/hide CASE ProductLine WHEN 'M' THEN 'Mountain' WHEN 'R' THEN 'Road' WHEN 'S' THEN 'Accessory' WHEN 'T' THEN 'Touring' ELSE 'Components' END

References

parent column	child column	relation name	nested
DimProductSubcategory.	DimProduct.	FK_DimProduct_ProductSubcategoryKey	False

Referenced by

parent column	child column	relation name	nested
DimProductSubcategory.	DimProduct.	FK_DimProduct_ProductSubcategoryKey	False

Objects that DimProduct depends on

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2

Table - DimProduct

Table properties

Columns

References

Referenced by

Objects that DimProduct depends on