Table 'Production.BillOfMaterials', Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

Table 'Production.BillOfMaterials', Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

Property NameProperty Value
Records2679
Fields9
Record size (bytes) w/o BLOBs78

Field statistics for 'BillOfMaterialsID' int identity

Field propertyProperty Value
Minimum value1
Maximum value3482
Average value1760.2732362821948
Values variance1093902.4966359376
Unique values2679

Field statistics for 'ProductAssemblyID' int

Field propertyProperty Value
Minimum value3
Maximum value999
Average value837.68090062111798
Values variance12879.170369052608
Unique values238

Field statistics for 'ComponentID' int

Field propertyProperty Value
Minimum value1
Maximum value999
Average value701.77118327734229
Values variance57650.647772721786
Unique values325

Field statistics for 'StartDate' datetime

Field propertyProperty Value
Minimum value2000-04-04 00:00:00.000
Maximum value2001-01-23 00:00:00.000
Unique values19

Field statistics for 'EndDate' datetime

Field propertyProperty Value
Minimum value2000-06-03 00:00:00.000
Maximum value2000-12-15 00:00:00.000
Unique values8

Field statistics for 'UnitMeasureCode' nchar(3)

Field propertyProperty Value
Minimum valueEA
Maximum valueOZ
Unique values3

Field statistics for 'BOMLevel' smallint

Field propertyProperty Value
Minimum value0
Maximum value4
Average value1.3598357596117954
Values variance0.33947659736154923
Unique values5

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

Field propertyProperty Value
Minimum value1.00
Maximum value41.00
Average value2.0541246733855916
Values variance20.703193398939167
Unique values12

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2000-03-21 00:00:00.000
Maximum value2001-01-09 00:00:00.000
Unique values27