Project Overview

Oracle Database Design

Comprehensive database schema with 17 tables, indexes, sequences, and triggers optimized for Oracle.

View Schema

ERP Integration

Seamless integration with existing ERP system including authentication, workflows, and shared services.

View Architecture

REST API Endpoints

Complete API specification with 50+ endpoints for equipment, projects, subcontractors, and more.

View API

Authentication & Security

Enterprise-grade security with SSO, RBAC, and comprehensive permission management.

View Security

Form Specifications

Detailed form field specifications for all UI components with validation rules and business logic.

View Forms

Multi-Country Support

Built for operations across Libya, Tunisia, and Iraq with localized features and compliance.

Learn More

Technical Stack

Frontend

  • React 18 + TypeScript
  • Vite Build Tool
  • Ant Design + Tailwind CSS

Backend

  • Spring Boot (Java)
  • Spring Security
  • Spring Data JPA

Database

  • Oracle Database
  • Shared with ERP
  • Real-time Sync

Integration

  • SSO/LDAP/OAuth
  • ERP Notifications
  • File Storage

Key Features

Equipment Lifecycle Management

Track equipment from acquisition to disposal with comprehensive maintenance scheduling.

Rental & Subcontractor Management

Manage rental contracts and evaluate subcontractor performance with detailed metrics.

Project Equipment Allocation

Assign and track equipment across multiple projects with real-time status updates.

Inspection Management

Equipment inspection checklists and compliance tracking with automated workflows.

Approval Workflows

Multi-level approval processes for requests and extensions with role-based permissions.

Reporting & Analytics

Comprehensive reporting on equipment utilization, costs, and performance metrics.

Quick Start Guide

1

Review Module Overview

Understand the module purpose, stakeholders, and key features.

Read Overview
2

Study ERP Architecture

Learn about the integration points and system architecture.

View Architecture
3

Implement Database Schema

Set up Oracle database tables, indexes, and triggers.

Database Schema
4

Develop API Endpoints

Implement REST API endpoints following the specifications.

API Reference