Partition `AuditLog` by month (native Postgres partitioning)

[kilodesodiq-arch]

Problem Statement. AuditLog will grow unbounded. Postgres native partition-by-range
keeps old months detached for archival.

Technical Context. Postgres 11+ supports declarative partitioning.

Expected Outcome. Schema rewrite uses a partitioned table with one partition per
month. A Prisma view presents the table for safety.

Acceptance Criteria.

• Test asserts that AUDIT rows from prior months still query, with the same Prisma
  client API.

Files or modules likely to be affected.
prisma/schema.prisma,
prisma/migrations/*,
docs/db/audit-partitioning.md.

Difficulty. Medium
Estimated effort. M

---

---

Backlog item #54 from `docs/maintainer-issue-backlog.md.

[Devadakene]

I am confident that i can work on this issue having worked on similar issues in the past

[grantfox-oss]

🦊 GrantFox — @Devadakene has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #262)
2. Your PR will be reviewed by the ChainForgee maintainers

Good luck! Track your progress on GrantFox.