Asset hierarchy, work orders and parts
Connects hierarchical assets with task staffing, consumed parts and independent inspection evidence. Original worked design example; adapt responsibilities, thresholds and assumptions to your system.
Rendering…
What this template contains
- Diagram type
- Entity-relationship diagram
- Source
- 47 lines
Make it your own.
erDiagram
ASSET o|--o{ ASSET : parent_of
ASSET ||--o{ WORK_ORDER : serviced_by
WORK_ORDER ||--o{ TASK : contains
TECHNICIAN ||--o{ TASK_ASSIGNMENT : assigned
TASK ||--o{ TASK_ASSIGNMENT : staffed_by
TASK ||--o{ PART_USAGE : consumes
PART ||--o{ PART_USAGE : used_in
WORK_ORDER ||--o{ INSPECTION : verified_by
ASSET {
string asset_id PK
string parent_asset_id FK
string serial
}
WORK_ORDER {
string order_id PK
string asset_id FK
string priority
}
TASK {
string task_id PK
string order_id FK
string status
}
TECHNICIAN {
string technician_id PK
string qualification
}
TASK_ASSIGNMENT {
string task_id FK
string technician_id FK
}
PART {
string part_id PK
string stock_code
}
PART_USAGE {
string usage_id PK
string task_id FK
string part_id FK
string quantity
}
INSPECTION {
string inspection_id PK
string order_id FK
string outcome
}