Report Action Log

Defines the structure of the report action logs table

Note

This is used to log all actions taken by moderators on the reports.

Table

Name: report_action_logs

Columns

id (Primary Key)

Description: The unique identifier of the report action logs table
Data Type: Unsigned bigint
Nullable: No

user_id (Foreign Key)

Description: The unique identifier of the users table
Data Type: Unsigned bigint
Nullable: No

report_ticket_id (Foreign Key)

Description: The unique identifier of the report tickets table
Data Type: Unsigned bigint
Nullable: No

context_info

Description: Indicates the context of the content being reported
Data Type: Text
Nullable: No

Note

The content here is usually the name of the reported content, such as an event name.

resolution_reason

Description: The moderator’s resolution for the reported content
Data Type: Text
Nullable: No

resource_id

Description: The unique identifier of the reported content Data Type: Unsigned bigint
Nullable: No

created_at

Description: The timestamp when the record is created
Data Type: Timestamp
Nullable: Yes

updated_at

Description: The timestamp when the record is updated
Data Type: Timestamp
Nullable: Yes