UNUS London  —  Compliance Architecture Division  |  UNCLASSIFIED // REGULATED INDUSTRIES
Home Solutions Legal & Professional Financial Services Manufacturing Healthcare Academy Blogs Ebooks About Book Discovery Call UNUS Govern
Home › Solutions › 🏭 Manufacturing & Engineering › MS 04 — Planned Maintenance Schedule Register
04
🏭 Manufacturing & Engineering
← View All Solutions

Planned Maintenance. Scheduled, Evidenced, Never Missed.

The Planned Maintenance Schedule Register tracks every piece of equipment, its maintenance requirements, and the completion evidence for every maintenance event. ISO 9001 §7.1.3 requires infrastructure to be maintained — this system proves it is.

The Problem This Solves
Maintenance records held in paper-based job cards or maintenance management software that cannot produce a structured audit trail. During ISO audits, firms cannot demonstrate that planned maintenance was completed on schedule for specific pieces of equipment.
Regulatory Basis
ISO 9001:2015, §7.1.3
ISO 9001 §7.1.3 requires organisations to determine, provide, and maintain the infrastructure necessary for the operation of its processes and to achieve conformity of products and services.
📅 Book Discovery Call ↗ See What's Included Send Enquiry
🏭 Manufacturing & Engineering
MS 04
Planned Maintenance Schedule Register
£1,447
ONE-TIME · FULL CODE OWNERSHIP · NO LICENCE FEE
✓ Production-ready PostgreSQL schema
✓ n8n automation workflow (JSON export)
✓ HTML / JavaScript frontend
✓ Immutable audit trail built in
✓ Build guide — step-by-step setup
✓ Sub-30-second evidence retrieval
✓ ISO 9001:2015, §7.1.3 aligned
Book Discovery Call ↗ Send Enquiry
Delivered and live within 14 days or money back
What's Included

Six Production-Ready Deliverables

Every component is built, tested, and transferred to you on day one of deployment. No dependencies. No ongoing licence fees. Full code ownership from the moment it goes live.

🗄️
equipment_register table
Equipment table: equipment_id, name, location, equipment_type, manufacturer, model, serial_number, installation_date, criticality (critical/high/standard), active flag.
📋
maintenance_tasks table
Task definitions: task_description, frequency_days, responsible_team, estimated_duration_minutes, last_completed_at, next_due_at, task_type (preventive/calibration/inspection/statutory).
✅
maintenance_completions table
Completion records: completed_by, completion_timestamp, outcome (completed/deferred/part_completed), notes, next_due_override. Immutable — append-only.
⚡
Overdue Escalation Trigger
Trigger fires when a maintenance task passes its next_due_at without a completion record. Escalation email to maintenance manager with equipment ID, task description, and days overdue.
📊
vw_maintenance_status
Live view: every active equipment item with its pending tasks, days until next due, overdue tasks count, and last completion record. Filterable by location, type, and criticality.
🔄
Weekly Schedule Email
n8n Cron workflow runs Monday 06:00 and emails the maintenance team a structured schedule of tasks due in the current week, ordered by criticality and due date.
Technical Specification & Live View

Built to Run. Not to Demo.

Every UNUS London mini solution is a production system — not a prototype. The schema runs on PostgreSQL 17.4 with full referential integrity, Row-Level Security, and an immutable audit trail from day one. The n8n workflow handles every user interaction end-to-end.

The evidence view below is representative of the live data structure you will have in your system. Every record shown reflects the actual column names, data types, and status logic in the deployed schema.

DatabasePostgreSQL 17.4 (Supabase)
Tables3 (equipment_register, maintenance_tasks, maintenance_completions)
Views2 (maintenance_status, overdue_tasks)
StandardISO 9001:2015 §7.1.3
Schedule EmailWeekly — Monday 06:00
Code Ownership100% — transferred Day 1
manufacturing-maintenance-schedule — live data view
CNC-Mill-01 Lubrication check Weekly ✓ Completed 07 Mar 2026
Lathe-03 Calibration Quarterly ⚠ Due 15 Mar 2026 — 6 days
Press-02 Safety inspection Monthly 🔴 Overdue by 3 days
CMM-01 Certification service Annual ✓ Completed Jan 2026

Get the Planned Maintenance Schedule Register
live in your firm.

A 30-minute discovery call is enough to scope this system for your firm, walk through the schema live, and confirm the delivery timeline. No obligation. A genuine technical conversation.

📅 Book Discovery Call ↗ Send Enquiry