π id
Unique identifier for each log entry (uses BigInteger for large scale logs).
π€ user_id
Foreign key to the user who performed the action (required).
π― object_user_id
Optional foreign key to the target user affected by the action (if applicable).
ποΈ project_id
Optional foreign key to the related project.
β task_id
Optional foreign key to the related task.
π microtask_id
Optional foreign key to the related microtask.
π file_id
Optional foreign key to the file involved in the action.
π¬ groupchat_id
Optional foreign key to the group chat related to the action.
β° timestamp
When the action occurred (required).
π οΈ action
The type of action (e.g., "created", "edited", "deleted") β required. Has a defined set of options, which can be found here. Enum type helps keep this consistent
π changes
Optional text field to describe details of the modification (e.g., "title changed from A to B").