myINFRA
ACTIVITY LOG MODULE
An administrative activity tracking module developed for the myINFRA enterprise platform.
Platform Auditing & Operational Transparency
myINFRA is an enterprise platform managing digital infrastructure assets. In a multi-user enterprise environment where administrative personnel mutate states and adjust service configurations, comprehensive activity auditing is critical for accountability.
The Activity Log module was created to provide a centralized, real-time audit record capturing all operational events with full traceability.
Full-Stack Engineering Across Frontend & Backend
Developed interactive audit log tables with faceted multi-parameter filters (administrator, date range, action type, IP address) and expandable event payload diffs.
Engineered API controllers, event listeners, and Eloquent queries to serialize and persist structured audit records with minimal query overhead.
Assisted in implementing and validating authentication workflows for MyDigital ID verification and testing security token lifecycles.
Maintained local multi-container development environments with Docker Compose and managed version-controlled branches in GitLab.
System Architecture Flow
A clean separation of concerns between client visualization, REST API routing, backend event serialization, and PostgreSQL database storage:
Structured REST Endpoints
page, limit, event_type, user_id, from_date, to_date. Returns paginated collection with total records count. PostgreSQL Audit Log Schema
| COLUMN | DATA TYPE | DESCRIPTION |
|---|---|---|
| id | BIGSERIAL / PRIMARY KEY | Unique sequential record identifier |
| user_id | FOREIGN KEY (users.id) | Identifier of administrator performing action (indexed) |
| event_type | VARCHAR(64) | Categorized event (e.g. AUTH_LOGIN, INFRA_UPDATE) |
| payload | JSONB | Immutable before/after state diff and input arguments |
| created_at | TIMESTAMPTZ | UTC timestamp indexed for chronological ordering |
Postman & Containerized Testing
Postman test collections were authored to validate all CRUD endpoints, response schemas, pagination boundaries, and security headers. Workflows were run against containerized PostgreSQL and Laravel services in Docker to mirror staging environments accurately.
Delivered Reliable Administrative Visibility
The Activity Log module was successfully delivered with clear documentation, clean codebase compliance with team standards, and full GitLab CI pipeline passes.