← All tables and views
AdventureWorks OLTP table
Production.BillOfMaterials
Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
2,679rows
9 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BillOfMaterialsID | INTEGER | no | PK | — |
ProductAssemblyID | INTEGER | yes | — | Production.Product.ProductID |
ComponentID | INTEGER | no | — | Production.Product.ProductID |
StartDate | TEXT | no | — | — |
EndDate | TEXT | yes | — | — |
UnitMeasureCode | TEXT | no | — | Production.UnitMeasure.UnitMeasureCode |
BOMLevel | INTEGER | no | — | — |
PerAssemblyQty | NUMERIC | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Production_BillOfMaterials_AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDateProductAssemblyID + ComponentID + StartDate1 unique index inspected
Production_BillOfMaterials_AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDateProductAssemblyID + ComponentID + StartDateCREATE UNIQUE INDEX "Production_BillOfMaterials_AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate" ON "Production.BillOfMaterials" ("ProductAssemblyID", "ComponentID", "StartDate")Data preview
Sample records
| BillOfMaterialsID | ProductAssemblyID | ComponentID | StartDate | EndDate | UnitMeasureCode | BOMLevel |
|---|---|---|---|---|---|---|
| 1 | 807 | 1 | 2021-03-03 00:00:00.000 | NULL | EA | 2 |
| 2 | 782 | 995 | 2021-03-03 00:00:00.000 | NULL | EA | 1 |
| 3 | NULL | 989 | 2021-03-03 00:00:00.000 | NULL | EA | 0 |
| 4 | NULL | 785 | 2021-03-03 00:00:00.000 | NULL | EA | 0 |
| 5 | NULL | 775 | 2021-03-03 00:00:00.000 | NULL | EA | 0 |
| 6 | 950 | 322 | 2021-03-03 00:00:00.000 | NULL | EA | 2 |
| 7 | 984 | 949 | 2021-03-03 00:00:00.000 | NULL | EA | 1 |
| 8 | 775 | 951 | 2021-03-03 00:00:00.000 | NULL | EA | 1 |
Interactive explorer