Move all triggers to erc schma

[Sepehr-Sobhani]

Description of the Tech Debt

Currently, all of our triggers reside in the public schema. As a result, we had to grant certain permissions to all our app roles in order to handle triggers (PR: #2904). We should consider moving the triggers to the erc schema and revoking these permissions to minimize access to the public schema.

This could be helpful: https://django-pgtrigger.readthedocs.io/en/4.13.3/settings/?h=pgtrigger_schema#pgtrigger_schema

Tech Debt Triage

The purpose of our technical debt triage process is to analyze technical debt to determine risk level of the technical debt and the value in tackling that technical debt.

Risk Value Scoring:

Level	Value
High	3
Medium	2
Low	1

Technical Debt - Risk Types	Level	Value
Business Area Risk - Risk of business area visibility / damage to user experience	0	0
Developer Fault Risk - How likely will this tech debt cause a future error related to coding on top of it	0	0
System Fault Risk - Risk of system errors or application downtime	0	0
Time Scale Risk - Compound risk effect if left alone. How much more difficult to fix or dangerous will this become over time?	0	0
Time Sink Risk - How much will this tech debt slow the development process down	0	0
TOTAL SCORE:	0	0

Development Checklist:

• Checklist item
• Checklist item
• Checklist item

[patrickisaac]

Refinement Notes:

• Low priority -> does not need to be addressed before Reg2 launch