Table: {$wpdb->prefix}clanbite_forum_reports
Columns
| Column | Type | Null | Default |
|---|---|---|---|
id | bigint(20) unsigned | No | auto-increment |
target_type | varchar(20) | No | |
target_id | bigint(20) unsigned | No | |
forum_id | bigint(20) unsigned | No | |
topic_id | bigint(20) unsigned | No | |
reporter_id | bigint(20) unsigned | No | |
reason | longtext | No | |
status | varchar(20) | No | pending |
moderator_response | longtext | Yes | |
handled_by_user_id | bigint(20) unsigned | No | 0 |
handled_at | datetime | Yes | |
created_at | datetime | No | |
updated_at | datetime | No |
Indexes
| Type | Name | Columns |
|---|---|---|
| primary key | PRIMARY | id |
| unique key | reporter_target | reporter_id, target_type, target_id |
| key | forum_id | forum_id |
| key | topic_id | topic_id |
| key | status_created | status, created_at |
| key | target | target_type, target_id |
Defined in inc/Database/Schema.php