← Back to portfolio

CASE STUDY / WEB APPLICATION

Equipment Inspection Management System

A role-based operations platform for recording field inspections and giving administrators a clear, real-time view of equipment, assignments, and inspection history.

View source ↗Static portfolio preview — no real accounts or operational data are used.

ダッシュボード

全設備数
248
担当未登録数
12
点検期限超過
!8
点検期限間近
21
要修理数
5

▥ エリア別異常件数

東北関東中部関西九州

☷ 担当者別負荷

担当者担当拠点担当数期限超過
佐藤 花子東京422
鈴木 一郎大阪371
田中 美咲名古屋310

01

Project overview

EIMS turns equipment inspection work that is often fragmented across paper and spreadsheets into a traceable web workflow. Engineers record results in the field while administrators manage equipment, accounts, assignments, and audit history.

02

Core capabilities

  • Role-based authentication and authorization
  • Equipment, account, and inspection CRUD workflows
  • Inspection schedules, notifications, and recycle bin
  • Audit logs and soft deletion for traceability

03 / Architecture

01Presentation

Jinja templates · responsive UI

02Application

Flask views · DTO · service logic

03Data access

DAO · transactions · migrations

04Persistence

MySQL / TiDB Cloud

04

Engineering & quality

The project uses a modular Flask structure, schema migration scripts, Docker configuration, and pytest-based view and integration tests. Database credentials remain outside the repository through environment variables.

Technology

PythonFlaskMySQL / TiDBDockerpytestJinja
Explore the implementation on GitHub ↗