pub(crate) const AVATAR_REF_CLAUSE: &str = "(EXISTS (SELECT 1 FROM user_avatar_asset_refs r WHERE r.asset_id = a.id) \ OR EXISTS (SELECT 1 FROM friend_avatar_asset_refs r WHERE r.asset_id = a.id))";
用户头像与友链头像引用判定,供单删接口区分评论引用。