[BE-05] Create AuditLog entity with TypeORM in opsce module

[yusuftomilola]

Problem

There is no audit trail for any actions performed in the system. When an asset is created, updated, or transferred, there is no record of who made the change or when.

Proposed Solution

Create backend/src/opsce/audit/entities/audit-log.entity.ts. This should be a write-once, append-only entity. Create an AuditService with a log() method injected by other services.

Acceptance Criteria

• Entity has fields: id (UUID), userId, action (string), resourceType (string), resourceId (string), oldValue (JSON), newValue (JSON), ipAddress, userAgent, createdAt
• No updatedAt or deletedAt (audit logs are immutable)
• @Index() on userId, resourceType, resourceId, createdAt
• AuditService.log(dto) method created for use by other modules
• Module registered in OpsceModule

[itzabdoull]

@itzabdoull has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi maintainer, can i work on this issues?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @itzabdoull to this issue.

[Ellaisbae]

@Ellaisbae has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Good Morning, Maintainer. How are you doing? I'm interested in this issue, and I can solve it.

Thank you in advance!

Please Again!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Ellaisbae to this issue.

[tolulopedd26]

@tolulopedd26 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Can i work on this?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @tolulopedd26 to this issue.

[drips-wave]

Congratulations, @tolulopedd26! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @tolulopedd26: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[drips-wave]

This issue has been completed by @tolulopedd26 as part of the Stellar Wave Program's 5th Wave 🥳

😎 @tolulopedd26: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.