🏭 Manufacturing · Database ERD
Bill of Materials Database Schema
A schema for multi-level bills of materials: items, BOM headers and lines, routings and work centres.
Drawing diagram…
What this diagram shows
- A BOM line can point to another assembly (multi-level)
- BOMs have versions with effective dates
- Routings define the operations and work centres
Prompt used
ERD for a bill of materials: Item (raw material, sub-assembly or finished good), BomHeader for a parent Item with version and effective date, BomLine linking the header to a component Item with quantity and unit, Routing for an Item with RoutingOperations performed at WorkCentres with setup and run times.
Mermaid code
erDiagram
ITEM ||--o{ BOM_HEADER : "has BOM"
BOM_HEADER ||--|{ BOM_LINE : contains
ITEM ||--o{ BOM_LINE : "used as component"
ITEM ||--o{ ROUTING : "made by"
ROUTING ||--|{ ROUTING_OPERATION : steps
WORK_CENTRE ||--o{ ROUTING_OPERATION : performs
ITEM {
int id PK
string code
string type
string uom
}
BOM_HEADER {
int id PK
int item_id FK
string version
date effective_from
}
BOM_LINE {
int id PK
int bom_id FK
int component_id FK
decimal quantity
}
ROUTING_OPERATION {
int id PK
int routing_id FK
int work_centre_id FK
int seq
decimal run_minutes
}Related templates
Production Order Lifecycle
The states a production order goes through on the shop floor, from release by planning to closure, including material shortages, rework and scrap.
Quality Inspection Workflow
An incoming and in-process quality inspection flow: sampling, measurement against the spec, and what happens to a batch that fails.
Smart Factory (Industry 4.0) Architecture
A connected factory: machines and sensors on the shop floor, an edge layer, MES and ERP, and cloud analytics for OEE and predictive maintenance.
MES–ERP Integration Sequence
How production orders flow from ERP planning to the shop floor MES and how confirmations, goods movements and scrap flow back.
Predictive Maintenance Pipeline
How vibration and temperature data from machines becomes a maintenance work order before the machine fails.
Manufacturing Supply Chain Flow
How materials flow from suppliers to customers in a manufacturing business: purchasing, inbound quality, production, warehousing and distribution.