| Column | Data Type | Nullable | Default | Description |
| BillOfMaterialsID | int | not null | | Primary key for BillOfMaterials records. |
| ProductAssemblyID | int | null | | Parent product identification number. Foreign key to Product.ProductID. |
| ComponentID | int | not null | | Component identification number. Foreign key to Product.ProductID. |
| StartDate | datetime | not null | (getdate()) | Date the component started being used in the assembly item. |
| EndDate | datetime | null | | Date the component stopped being used in the assembly item. |
| UnitMeasureCode | nchar(3) | not null | | Standard code identifying the unit of measure for the quantity. |
| BOMLevel | smallint | not null | | Indicates the depth the component is from its parent (AssemblyID). |
| PerAssemblyQty | decimal(8, 2) | not null | ((1.00)) | Quantity of the component needed to create the assembly. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |