Reference field column are of varchar type.

Ref: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/2025-July/041575.html

• Users reports_to_id
• Tickets parent_id

Are defined as varchar instead of int and indexed.