userprofilerecord.php

См. документацию.

<?php
 
namespace Bitrix\Main;

class UserProfileRecordTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_user_profile_record';
    }
 
    public static function getMap()
    {
        return array(
            new Entity\IntegerField("ID", array(
                'primary' => true,
                'autocomplete' => true,
            )),
            new Entity\IntegerField("HISTORY_ID", array(
                'required' => true,
            )),
            new Entity\StringField("FIELD"),
            new Entity\TextField('DATA', array(
                'serialized' => true
            )),
            new Entity\ReferenceField("HISTORY",
                '\Bitrix\Main\UserProfileHistoryTable',
                array('=this.HISTORY_ID' => 'ref.ID'),
                array('join_type' => 'INNER')
            ),
        );
    }
 
    public static function deleteByHistoryFilter($where)
    {
        if ($where == '')
        {
            throw new ArgumentException("Deleting by empty filter is not allowed, use truncate (b_user_profile_record).", "where");
        }
 
        $entity = static::getEntity();
        $conn = $entity->getConnection();
 
        $alias = ($conn instanceof DB\MysqlCommonConnection ? 'R' : '');
 
        $conn->queryExecute("
            DELETE {$alias} FROM b_user_profile_record R
            WHERE R.HISTORY_ID IN(
                SELECT ID FROM b_user_profile_history
                {$where}
            )
        ");
 
        $entity->cleanCache();
    }
}