Clanbite Database

Table: {$wpdb->prefix}clanbite_notifications

Columns

ColumnTypeNullDefault
idbigint(20) unsignedNo auto-increment
user_idbigint(20) unsignedNo
typevarchar(64)No
titlevarchar(255)No
messagetextYes
urlvarchar(2048)Yes
actor_idbigint(20) unsignedYes
object_typevarchar(64)Yes
object_idbigint(20) unsignedYes
datalongtextYes
actionslongtextYes
statusvarchar(32)Nopending
is_readtinyint(1)No0
created_atdatetimeNo
read_atdatetimeYes
actioned_atdatetimeYes

Indexes

TypeNameColumns
primary keyPRIMARYid
keyuser_unreaduser_id, is_read, created_at
keyuser_statususer_id, status, created_at
keyuser_createduser_id, created_at
keytype_createdtype, created_at
keyactor_idactor_id
keyobjectobject_type, object_id

Defined in inc/extensions/notifications/class-notification-schema.php