Report Ticket

Defines the structure of the report ticket table

Table

Name: report_tickets

Columns

id (Primary Key)

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

report_module_id (Foreign Key)

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

versioned_ticket

Description: Indicates the version of the ticket
Data Type: Integer
Nullable: No

Note

This is used to identify the latest report on the content, since some reports may be false flags and the content could be reported again.

status

Description: Indicates the status of the ticket
Data Type: Integer
Nullable: No Values:

• Open: 1
• Closed: 2

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