Cadet Inventory Management System

Planning

An enterprise-grade inventory and supply management system built to streamline logistics and accountability for cadet units, featuring multi-tenant data isolation and role-based permissions.

Spring BootNext.jsNeonClerkDocker
Source Code

Overview

Quartermaster is an enterprise-grade inventory management system designed to solve the logistics challenges faced by cadet units. Currently in the planning and analysis phase, it aims to replace fragmented paper-based tracking with a robust, multi-tenant digital platform. By providing each unit with its own isolated data environment, Quartermaster ensures security and autonomy while offering powerful tools for tracking uniforms, equipment, and supplies. The system emphasizes accountability through digital audit trails and simplifies operations with role-based delegation, allowing senior cadets to assist with logistics under officer supervision.

Problem Domain

The Challenge: Logistics & Accountability
  • •Poor inventory visibility across units making resource allocation difficult.
  • •Reliance on manual or paper-based tracking which is prone to human error.
  • •Lack of clear audit trails and accountability for equipment issuance.
  • •Difficulty managing equipment distribution, returns, and maintenance schedules.
  • •No real-time insights into supply levels leading to shortages or overstocking.
  • •No system for delegating inventory tasks to senior cadets while maintaining oversight.

Our Solution

Our Solution: Centralized Supply Chain Management
  • •Multi-Tenant Design: Each unit maintains separate inventory data, users, and workflows.
  • •Real-Time Tracking: Centralized system showing current location and status of all assets.
  • •Role-Based Access Control: Granular permissions for Officers, Senior Cadets, and Junior Cadets.
  • •Digital Audit Trails: Complete accountability for every item movement.
  • •Automated Alerts: Low-stock warnings, overdue returns, and maintenance reminders.
  • •Check-In/Check-Out Workflows: Streamlined equipment sign-out with digital hand receipts.

Multi-Tenant Architecture

Isolated Inventory Systems
  • Unit: Oakville Sea Cadets (Pilot) - Equipment, Users, Audit Logs
  • Multi-Unit: Shared Platform Infrastructure

Technical Architecture

Frontend

Next.js, TypeScript, ShadCN/UI, GSAP

Backend

Spring Boot, Spring MVC/REST API

Database

Neon (Serverless PostgreSQL with multi-tenant schema)

Authentication

Clerk, Spring Security

Storage

Cloud Storage for asset documentation

Security

Row-level security, audit logging, role-based permissions

Role-Based Access

Junior Cadets

View-only access, ability to submit equipment requests

Senior Cadets

Limited admin access for day-to-day operations, equipment issue/return

Officers/Adult Staff

Full administrative access, reporting, system configuration

Key Features
  • Real-time Inventory Tracking
  • Role-Based Access Control
  • Digital Audit Trails
  • Automated Low-Stock Alerts
  • Equipment Maintenance Scheduling
  • Digital Hand Receipts
Project Timeline

  1. Q1 2026: Planning & Analysis

    • Survey existing inventory practices at Oakville Sea Cadets
    • Analyze pain points with current manual systems
    • Evaluate technical approaches and architecture options
    • Select best solution strategy (build vs. adapt)

  2. Q2 2026: Design & Validation

    • Finalize requirements and technical architecture
    • Approve database schema design
    • Create and validate UI/UX mockups with stakeholders
    • Establish development roadmap

  3. Q3 2026: Pre-Development

    • Refine multi-tenant isolation strategy
    • Validate cross-branch applicability (Sea vs. Army)
    • Begin preliminary development (Auth, CRUD)
    • Incorporate lessons from SignalsMaster release

  4. Active Development

    Target beta deployment to Oakville Sea Cadets

Back to All Projects