Table 'Production.ProductInventory', Product inventory information.

Table 'Production.ProductInventory', Product inventory information.

Property NameProperty Value
Records1069
Fields7
Record size (bytes) w/o BLOBs61

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value1
Maximum value999
Average value611.96258185219835
Values variance57301.371257747269
Unique values432

Field statistics for 'LocationID' smallint

Field propertyProperty Value
Minimum value1
Maximum value60
Average value23.684752104770816
Values variance553.41831597313455
Unique values14

Field statistics for 'Shelf' nvarchar(10)

Field propertyProperty Value
Minimum valueA
Maximum valueY
Unique values21

Field statistics for 'Bin' tinyint

Field propertyProperty Value
Minimum value0
Maximum value61
Average value8.8999064546304965
Values variance128.21188201371299
Unique values62

Field statistics for 'Quantity' smallint

Field propertyProperty Value
Minimum value0
Maximum value924
Average value314.28811973807296
Values variance36043.235261348942
Unique values343

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values1069

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value1998-05-02 00:00:00.000
Maximum value2004-09-12 00:00:00.000
Unique values24