Skip to content

Implement Event Sourcing for Audit Trail #1146

Description

@grantfox-oss

Type: Architecture | Priority: HIGH | Effort: 16 hours
Component: backend/src/services/audit.service.ts, Database schema

Problem:
Current system uses only database snapshots (current state). For regulatory compliance and fraud investigation, we need immutable event log.

Acceptance Criteria:

  • Create events table with immutable event log
  • Schema includes: eventId, streamId, eventType, payload, timestamp, hash, previousHash
  • Implement EventSourceService for appending events
  • Write hash chain verification utility
  • Migrate existing streams to event log
  • Add test verifying hash chain integrity for 100 events

Metadata

Metadata

Assignees

Labels

GrantFox OSSIssue tracked in GrantFox OSSMaybe RewardedIssue may be eligible for a GrantFox rewardOfficial CampaignCampaign: Official CampaignStellar WaveIssues in the Stellar wave program

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions