Implement centralized system logging and observability for APIs

[mohammadumar-dev]

Description

Implement a centralized system logging mechanism to capture
API activity, security events, errors, and performance metrics
across the backend.

System logs will be persisted in the system_logs table and
used for auditing, debugging, security monitoring, and future
observability tooling.

Goals

• Provide a single source of truth for system and API events
• Enable request-level traceability and audit trails
• Capture security-relevant actions and failures
• Support performance and error analysis

Scope

• API request and response logging
• Authentication and authorization events
• Error and exception logging
• Execution time measurement
• Correlation via request_id and trace_id