Table 'Production.Product', Products sold or used in the manfacturing of sold products.

Table 'Production.Product', Products sold or used in the manfacturing of sold products.

Property NameProperty Value
Records504
Fields25
Record size (bytes) w/o BLOBs368

Field statistics for 'ProductID' int identity

Field propertyProperty Value
Minimum value1
Maximum value999
Average value673.03968253968253
Values variance52612.038183596807
Unique values504

Field statistics for 'Name' Name

Field propertyProperty Value
Minimum valueAdjustable Race
Maximum valueWomen's Tights, S
Unique values504

Field statistics for 'ProductNumber' nvarchar(25)

Field propertyProperty Value
Minimum valueAR-5381
Maximum valueWB-H098
Unique values504

Field statistics for 'MakeFlag' Flag

Field propertyProperty Value
Unique values2

Field statistics for 'FinishedGoodsFlag' Flag

Field propertyProperty Value
Unique values2

Field statistics for 'Color' nvarchar(15)

Field propertyProperty Value
Minimum valueBlack
Maximum valueYellow
Unique values9

Field statistics for 'SafetyStockLevel' smallint

Field propertyProperty Value
Minimum value4
Maximum value1000
Average value535.15079365079362
Values variance139960.50206696329
Unique values6

Field statistics for 'ReorderPoint' smallint

Field propertyProperty Value
Minimum value3
Maximum value750
Average value401.36309523809524
Values variance78727.782412666871
Unique values6

Field statistics for 'StandardCost' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value2171.2942
Average value258.60296130952383
Values variance213104.84913476012
Unique values114

Field statistics for 'ListPrice' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value3578.2700
Average value438.66624999999937
Values variance598461.35812596942
Unique values103

Field statistics for 'Size' nvarchar(5)

Field propertyProperty Value
Minimum value38
Maximum valueXL
Unique values18

Field statistics for 'SizeUnitMeasureCode' nchar(3)

Field propertyProperty Value
Minimum valueCM
Maximum valueCM
Unique values1

Field statistics for 'WeightUnitMeasureCode' nchar(3)

Field propertyProperty Value
Minimum valueG
Maximum valueLB
Unique values2

Field statistics for 'Weight' decimal(8,2)

Field propertyProperty Value
Minimum value2.12
Maximum value1050.00
Average value74.069219512195119
Values variance33184.665869976074
Unique values127

Field statistics for 'DaysToManufacture' int

Field propertyProperty Value
Minimum value0
Maximum value4
Average value1.1031746031746033
Values variance2.2279024267095835
Unique values4

Field statistics for 'ProductLine' nchar(2)

Field propertyProperty Value
Minimum valueM
Maximum valueT
Unique values4

Field statistics for 'Class' nchar(2)

Field propertyProperty Value
Minimum valueH
Maximum valueM
Unique values3

Field statistics for 'Style' nchar(2)

Field propertyProperty Value
Minimum valueM
Maximum valueW
Unique values3

Field statistics for 'ProductSubcategoryID' int

Field propertyProperty Value
Minimum value1
Maximum value37
Average value12.294915254237289
Values variance97.222252968984208
Unique values37

Field statistics for 'ProductModelID' int

Field propertyProperty Value
Minimum value1
Maximum value128
Average value37.44406779661017
Values variance1157.7307044851839
Unique values119

Field statistics for 'SellStartDate' datetime

Field propertyProperty Value
Minimum value1998-06-01 00:00:00.000
Maximum value2003-07-01 00:00:00.000
Unique values4

Field statistics for 'SellEndDate' datetime

Field propertyProperty Value
Minimum value2002-06-30 00:00:00.000
Maximum value2003-06-30 00:00:00.000
Unique values2

Field statistics for 'DiscontinuedDate' datetime

Field propertyProperty Value
Unique values0

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values504

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2004-03-11 10:01:36.827
Maximum value2004-03-11 10:03:55.510
Unique values2