These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Machine Maintenance (CMMS)
- Maintenance data model
The tables behind Machine Maintenance (CMMS)
Machine Maintenance (CMMS) ships with 13 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 13
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Asset register
Assets identifies equipment and supplies the reference used by maintenance, purchasing, measurements and service outcomes.
Work order planning
Work orders links Asset and assigned to. People connects the acting person to Users through User.
Safety permits
Safety permits links work order and issued by and records valid from, valid to and Status.
Maintenance execution
Work logs and part usage link to work orders. Service history links both the completed work order and its Asset.
Preventive plans
Preventive plans links Asset, submitted by, Reviewer and a prior plan through Supersedes.
Condition monitoring
Condition readings associates recorded at, Metric, Value, Unit and action limit with its Asset.
Parts and purchasing
Spare parts supplies part usage.Part and purchase orders.spare part. Purchase orders requires Asset. Order master retains source record ID and optional work order, purchase order and Asset references.
Every table, by feature
- Asset register5
- Work order planning5
- Safety permits4
- Maintenance execution7
- Preventive plans5
- Condition monitoring4
- Parts and purchasing6
- Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - Condition readings
Condition monitoring measurements with action limits.
Linked to Assets - Preventive plans
Preventive maintenance schedules driven by day and hour intervals.
Linked to Assets, People, Preventive plans - Service history
Completed service outcomes per asset with next due date.
Linked to Assets, Work orders
- Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- People
Maintenance staff and reviewers referenced by work orders, logs and permits.
Linked to Users - Users
Users
Linked to Users - Safety permits
Permits to work with validity intervals and approval status.
Linked to Work orders, People
- Safety permits
Permits to work with validity intervals and approval status.
Linked to Work orders, People - Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - People
Maintenance staff and reviewers referenced by work orders, logs and permits.
Linked to Users - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - Work logs
Technician labour entries recorded against a work order.
Linked to Work orders, People - Part usage
Parts consumed against work orders.
Linked to Work orders, Spare parts - Safety permits
Permits to work with validity intervals and approval status.
Linked to Work orders, People - Service history
Completed service outcomes per asset with next due date.
Linked to Assets, Work orders - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- People
Maintenance staff and reviewers referenced by work orders, logs and permits.
Linked to Users
- Preventive plans
Preventive maintenance schedules driven by day and hour intervals.
Linked to Assets, People, Preventive plans - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- People
Maintenance staff and reviewers referenced by work orders, logs and permits.
Linked to Users - Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - Service history
Completed service outcomes per asset with next due date.
Linked to Assets, Work orders
- Condition readings
Condition monitoring measurements with action limits.
Linked to Assets - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
- People
Maintenance staff and reviewers referenced by work orders, logs and permits.
Linked to Users - Users
Users
Linked to Users
- Spare parts
Spare parts catalogue with on-hand quantity and reorder point.
- Part usage
Parts consumed against work orders.
Linked to Work orders, Spare parts - Purchase orders
Asset-linked procurement orders for maintenance work and spare parts.
Linked to Assets, Spare parts - Order master
Unified register of maintenance Work Orders and Purchase Orders, with source links and shared status, dates, asset, vendor, and amount fields.
Linked to Work orders, Purchase orders, Assets - Work orders
Maintenance work orders from request through planning, execution, inspection and closure.
Linked to Assets, People - Assets
Asset register of maintainable machines and equipment with location, warranty and status.
Keys and references
Preserve the source identifiers when matching imported records. Asset tag, serial number and part number help people check identity, but the reference links must point to the intended records. Do not assume a repeated display name identifies the same machine or person.
Resolve the signed-in account through People.User before comparing an assigned person with the current user. Keep the preventive plans.Supersedes chain intact when importing reviewed revisions. Newly created orders receive a linked order master entry through source-record matching; use work orders and purchase orders for subsequent operating changes.
Migration order
- Establish Users and People, verifying each User reference and active person.
- Import Assets and spare parts with checked equipment identities and part units.
- Import preventive plans and condition readings against the correct Asset, preserving plan revision links and measurement times.
- Import work orders and purchase orders with their required asset and person context.
- Attach safety permits, work logs, part usage and service history to the intended work orders and assets.
- Reconcile order master source links separately for historical orders before relying on the combined register.
Set up Machine Maintenance (CMMS) your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.