Where Table For Customfields Value Save?

[ty0716]

for example ,I add a new customfields :avatar.  This use to save user's avatar url.

 

 

But this value save where? and how to query this like User model.

 

[activa]

normally it should be saved in the "values" field .

[Tyson]

The screenshot you included shows the record of your defined custom fields, not the values that clients have set. Those are stored in the `client_values` table. However, you need not be concerned with the table structure if you're writing a plugin that uses the API. Simply call the Clients model, which provides several methods for managing custom fields, e.g. Clients::getCustomFields, Clients::getCustomFieldValues