Skip to main content

AVATAR_REF_CLAUSE

Constant AVATAR_REF_CLAUSE 

Source
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))";
Expand description

用户头像与友链头像引用判定,供单删接口区分评论引用。