Audit fields in tables are not referencing users table

[mahalakshme]

Details:

Audit fields: created_by, last_modified_by, filled_by

AC:

• The above is the case in program encounters and encounters table.
• Make sure it is fixed in other tables as well.

[Jayesh445]

Hi, I’m Jayesh Gupta, a Full-Stack Developer with experience in React Native, React.js, Java, Spring Boot, PostgreSQL, and Generative AI.

I’ve already addressed the created_by, last_modified_by, and filled_by fields in the program_encounters and encounters tables and am reviewing others for consistency.

Having explored the avni-server and avni-client repositories, I’m excited to contribute and implement clean solutions with my backend skills. Looking forward to collaborating! 🚀

Thanks,
Jayesh Gupta

[mitrathotamalla]

Hi .
I would like to work on this issue.
Please assign it to me. Thank you.

[mitrathotamalla]

Hi 👋
I’ve submitted a pull request to fix this issue by adding foreign key references to the audit fields.

PR: #949

Please let me know if any changes are needed. Thanks!

[MohammedGhallab]

Hi @avni-team,

I would like to be assigned to this issue. I have extensive experience with Spring Boot and Bean Validation (Jakarta Validation), and I've recently worked on similar validation improvements in other Spring-based projects.

My plan is to:

Identify all endpoints in ClientController and SyncController that receive @RequestBody.

Add @Valid annotations to the controller methods and define proper constraints (@NotNull, @notempty, etc.) in the corresponding DTOs/Entities.

Ensure that validation errors are handled gracefully (e.g., via existing or new Exception Handlers) to return meaningful 400 Bad Request responses to the client.

I'm familiar with Gradle and I'm ready to start. Could you please assign this to me?