Back to ER Diagram
Plant Maintenance

Plant Maintenance Logic

Plant asset register, preventive maintenance scheduling, breakdown management, spare parts inventory, utilization tracking, and costing.

PostgreSQL
8 Tables
Schema: plant
Maintenance Scheduling

Overview

Plant Maintenance manages batching plants, crushing plants, RMC plants, and other fixed plant assets at construction sites. Preventive maintenance schedules based on operating hours or calendar intervals. Breakdown maintenance tracked with root cause analysis. Spare parts inventory maintained for critical components. Plant utilization and production output tracked for cost-per-unit analysis.


Register Plant

Schedule PM

Execute Maint

Track Breakdown

Analyze Cost
8
Plant Tables
Preventive
Maintenance
Spare Parts
Inventory
₹/unit
Production Cost

Status States

StatusDescriptionAllowed ActionsNext States
OperationalPlant running and producingLog Production, Schedule PMUnder Maintenance
Under MaintenanceScheduled or corrective maintenanceComplete, ReturnOperational
BreakdownUnplanned stoppageDiagnose, RepairUnder Maintenance
StandbyPlant idle, availableMobilizeOperational
DecommissionedPlant retiredDispose

Database Schema

plant.plant_asset

  • plant_id — PK
  • project_id — FK → project.project
  • plant_code, plant_name, plant_type — Identification
  • capacity, capacity_uom — Production capacity
  • commission_date, operating_hours — Lifecycle tracking
  • status — Operational state

plant.preventive_maintenance

  • pm_id — PK
  • plant_id — FK → plant.plant_asset
  • pm_type — daily | weekly | monthly | overhaul
  • scheduled_date, actual_date — Planning vs execution
  • checklist_json — Maintenance checklist items
  • performed_by, cost — Execution details

plant.breakdown_maintenance

  • bm_id — PK
  • plant_id — FK → plant.plant_asset
  • reported_date, resolved_date — Breakdown duration
  • failure_component, root_cause — Analysis
  • downtime_hours, production_loss — Impact
  • repair_cost — Financial impact

plant.spare_parts

  • part_id — PK
  • plant_id — FK → plant.plant_asset
  • part_name, part_number — Spare identification
  • min_stock, current_stock — Inventory levels
  • lead_time_days — Procurement lead time
  • unit_cost — Replacement cost

Plant Maintenance Process

1

Plant Registration

Register plant with specifications, capacity, and commissioning date. Create maintenance schedule based on manufacturer recommendations.

2

Preventive Maintenance

Auto-generated PM work orders based on schedule. Checklists specific to plant type. Completed PMs update next due date.

3

Breakdown Management

Operator reports breakdown. Maintenance team diagnoses and repairs. Root cause analysis documented. Parts replaced from spare inventory.

4

Spare Parts Management

Critical spares maintained at minimum stock levels. Reorder triggered when stock falls below minimum. Lead time tracked for planning.

5

Production & Cost Analysis

Daily production output logged. Cost per unit = (fuel + maintenance + spares + labour) / total production. Benchmarked against industry standards.

Plant Queries

Plant Availability

SELECT pa.plant_name,
       SUM(pu.production_hours) AS running_hours,
       SUM(bm.downtime_hours) AS breakdown_hours,
       ROUND(SUM(pu.production_hours) / (SUM(pu.production_hours) + COALESCE(SUM(bm.downtime_hours), 0)) * 100, 1) AS availability_pct
FROM plant.plant_asset pa
LEFT JOIN plant.plant_utilization pu ON pu.plant_id = pa.plant_id
LEFT JOIN plant.breakdown_maintenance bm ON bm.plant_id = pa.plant_id
GROUP BY pa.plant_id;

Validation Rules

Business Rules

  • PM Overdue: PM overdue by >7 days triggers escalation to Plant Manager
  • Spare Stock: Critical spare below minimum triggers auto purchase request
  • Breakdown Reporting: Breakdown must be reported within 30 minutes of occurrence
  • Production Log: Daily production log mandatory for all operational plants

Integration Points

Connected Modules

  • Equipment: Plants with mobile components linked to equipment module
  • Inventory: Spare parts inventory synced with main inventory
  • Finance: Plant operating costs allocated to project cost codes
  • Project: Plant production output feeds DPR activity progress

Best Practices

Recommended

  • Follow OEM-recommended PM schedules strictly
  • Maintain 2-week buffer stock of critical spares
  • Analyze breakdown patterns using Pareto analysis
  • Track MTBF (Mean Time Between Failures) and MTTR (Mean Time To Repair)