Friends database tables

When first activated, the Friends component creates a table to store users friendships ({$table_prefix}bp_friends).

[!NOTE]
The {$table_prefix} value is wp_ by default but it can be customized within the WordPress wp-config.php file.

`{$table_prefix}bp_friends`

This table stores the friendship connections between users.

Name	Type	Description
`id`	`BIGINT`	Unique ID for each friendship connection.
`initiator_user_id`	`BIGINT`	The user ID who sent the friend request.
`friend_user_id`	`BIGINT`	The user ID who received the friend request.
`is_confirmed`	`TINYINT`	Whether the friendship has been confirmed (1) or is pending (0).
`is_limited`	`TINYINT`	Whether the friendship has any limitations [^1].
`date_created`	`DATETIME`	When the friendship was initiated.

[^1]: Not used anymore. Kept for backwards compatibility reasons.

这篇文档对你有帮助吗？