Auditable Entity [BUG]

[Diyar]

I have discovered two issues with the "CreatedOn" and "LastModifiedOn" fields during updates:

1- Sometimes, when I update a single record, both "CreatedOn" and "LastModifiedOn" fields are updated for multiple records. However, the expected behavior is that only the "LastModifiedOn" field should be updated for the specific record being updated.

2- While creating a record, the "CreatedOn" field should be populated with the current time. However, when updating a record, the "CreatedOn" timestamp is being altered by several hours, which is not the intended behavior.

As I know the problem caused by time-zone during retrieving and saving data even we do not change anything in the record!

As a side note: I'm using PostgreSQL database