Table: {$wpdb->prefix}clanbite_notifications
Columns
| Column | Type | Null | Default |
|---|---|---|---|
id | bigint(20) unsigned | No | auto-increment |
user_id | bigint(20) unsigned | No | |
type | varchar(64) | No | |
title | varchar(255) | No | |
message | text | Yes | |
url | varchar(2048) | Yes | |
actor_id | bigint(20) unsigned | Yes | |
object_type | varchar(64) | Yes | |
object_id | bigint(20) unsigned | Yes | |
data | longtext | Yes | |
actions | longtext | Yes | |
status | varchar(32) | No | pending |
is_read | tinyint(1) | No | 0 |
created_at | datetime | No | |
read_at | datetime | Yes | |
actioned_at | datetime | Yes |
Indexes
| Type | Name | Columns |
|---|---|---|
| primary key | PRIMARY | id |
| key | user_unread | user_id, is_read, created_at |
| key | user_status | user_id, status, created_at |
| key | user_created | user_id, created_at |
| key | type_created | type, created_at |
| key | actor_id | actor_id |
| key | object | object_type, object_id |
Defined in inc/extensions/notifications/class-notification-schema.php