mirror of
https://github.com/buddypress/buddypress.git
synced 2026-07-23 21:06:56 +08:00
8f0a23595b
Props vapvarun See https://github.com/buddypress/bp-documentation/issues/272 Closes https://github.com/buddypress/buddypress/pull/375 git-svn-id: https://buddypress.svn.wordpress.org/trunk@14046 cdf35c40-ae34-48e0-9cc9-0c9da1808c22
1.6 KiB
1.6 KiB
Notifications database tables
When first activated, the Notifications component creates 2 tables. One to store user notifications ({$table_prefix}bp_notifications), the other to store metadata about notifications ({$table_prefix}bp_notifications_meta).
Note
The
{$table_prefix}value iswp_by default but it can be customized within the WordPress wp-config.php file.
{$table_prefix}bp_notifications
This table stores notifications about user interactions.
| Name | Type | Description |
|---|---|---|
id |
BIGINT |
Unique notification ID. |
user_id |
BIGINT |
The ID of the user receiving the notification. |
item_id |
BIGINT |
Primary item related to the notification. |
secondary_item_id |
BIGINT |
Secondary item, if applicable. |
component_name |
VARCHAR |
Name of the BuddyPress component (e.g.: groups, messages). |
component_action |
VARCHAR |
Action triggering the notification (e.g., group invite, message received). |
date_notified |
DATETIME |
When the notification was created. |
is_new |
TINYINT |
Whether the notification is new. |
{$table_prefix}bp_notifications_meta
Stores metadata associated with notifications.
| Name | Type | Description |
|---|---|---|
id |
BIGINT |
Meta ID |
notifiction_id |
BIGINT |
The ID of the associated notification. |
meta_key |
VARCHAR |
Metadata key. |
meta_value |
LONGTEXT |
Metadata value1. |
-
Arrays or Objects are stored as serialized data. ↩︎
