Fire door & Fire stopping asset management database

I run a UK fire safety & building services business (Phoenix Bespoke Solutions). I’m looking for an experienced developer to build a web-based fire door asset management system with a mobile-first inspection workflow, QR code door tagging, photo evidence, and audit-ready reporting.

The product must be suitable for UK compliance workflows (FRA support, audit trail, evidence retention). This will be used internally and potentially offered to clients as a managed platform.

Key Outcomes

A secure web app to manage a portfolio of buildings and fire doors

Mobile-friendly inspector workflow (phone/tablet)

Door-level inspections with pass/fail + defect severity + photos

Defect/action tracking through to completion

Dashboard + exportable reports (PDF/Excel)

Full audit trail (who/when/what changed)

Core Features (MVP)
1) Accounts & Roles

User login

Roles: Admin / Inspector / Client read-only

Basic permissions (client can only see their own sites)

2) Portfolio & Door Asset Register

Hierarchy:
Portfolio → Site → Building → Block/Core → Floor → Area → Door

Door fields (minimum):

Unique Door ID

Location fields above

Fire rating (FD30/FD60/etc.)

Door type (single/double/glazed/riser/etc.)

Certification status

Install date (optional)

Manufacturer (optional)

Ironmongery fields (closer/hinges/locks/seals/signage)

Notes

3) QR Code Door Tagging

Generate QR codes per door

QR scan opens the door record instantly on mobile

Option to download/print QR label sheet (PDF)

4) Inspections (Mobile-first)

Create inspection against a door

Inspection details: date/time, inspector, inspection type

Pass/Fail overall

Checklist sections:

Leaf condition

Frame condition

Gaps/alignment

Self-closing operation

Seals/smoke control

Ironmongery condition

Signage compliance

Defects can be raised during inspection with:

Severity: Critical / Major / Advisory

Notes

Photo evidence upload (multiple photos)

Recommended action

5) Defects / Actions Workflow

Defect register filtered by site/building/severity/status

Status: Open / In Progress / Complete / Deferred

Target rectification date

Works notes + completion photos

Cost capture (optional in MVP): CAPEX vs Reactive vs PPM

6) Reporting & Exports

Door inspection history report

Failed doors list

Outstanding actions report

Critical defects register

Export to PDF and Excel/CSV

7) Dashboard

Compliance overview by site/building

Pie/summary counts (pass/fail, defects by severity, overdue actions)

Non-Functional Requirements

Clean, modern UI (simple and fast)

Mobile responsive (inspector use on site is critical)

Secure file storage for photos (with door/inspection linkage)

Audit log for changes to doors/defects/inspections

GDPR-aware (UK/Europe hosting preferred)

Suggested Tech (Open to your recommendation)

Backend: Node.js/Express or Python (FastAPI/Django)

Database: PostgreSQL

Frontend: React/Next.js or similar

Storage: S3 compatible (AWS or similar)

Deployment: UK/EU region (can be AWS/DigitalOcean/etc.)

Deliverables

Working deployed MVP on my hosting or yours (with handover)

Source code + documentation

Admin guide + short video walkthrough (optional)

Basic automated backups instruction

Bug fix period after delivery (e.g., 14–30 days)

What to Include in Your Proposal

Examples of similar systems (asset mgmt / inspections / workflows)

Your recommended stack + why

Your estimated timeline split into milestones

Any questions/assumptions you have

Fixed price per milestone (preferred)

Milestones (Preferred)

Database + user roles + portfolio/doors CRUD

QR generation + door page + mobile layout

Inspections + defect creation + photo upload

Defect workflow + dashboard

Reporting exports + audit log + deployment + handover