Report

Defines the structure of the report table

Table

Name: report

Columns

id (Primary Key)

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

report_module_reason_id (Foreign Key)

Description: The unique identifier of the report module reasons 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

user_reason

Description: The reason provided by the user
Data Type: Text
Nullable: No

Note

This will have a value if the user selects ‘Others’ when reporting content.

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