Building a Permission Binding System Between LINE Bot and In-House ERP via Phone Number Matching

Building a Permission Binding System Between LINE Bot and In-House ERP via Phone Number Matching We wanted staff to check inventory via LINE — but not let just anyone access it. That simple requirement led to what we built: a LINE × ERP permission binding system . Background At TechsFree, we develop and operate our own ERP for a food/produce wholesale business. Letting staff check inventory and sales figures directly via LINE Bot would make field operations much smoother — so we built a bridge between LINE Bot and the ERP backend. The problem: LINE's userId ( Uxxxxxxxx... ) and ERP's internal user accounts (email + password) are completely separate. Without knowing "who is this LINE user?", we can't enforce any permission checks. Solution: Phone Number Matching Our ERP user table already had a phone column. When someone messages the bot, we simply ask for their phone number, look up the matching ERP user, and bind them. -- Add LINE-related columns to users table ALTER TABLE users ADD C