I'm storing the ID of the Salesforce records we have synced with our website. I am currently using an existing table to store the ID mappings for the records. The problem is that the existing field is BIGINT(19) and the ID I am getting is 18-digit alphanumeric.
I read that it is base-62 encoded, so I tried to convert it to base-10, but the length is too long to be stored in BigInt.
Can someone help me with this? I need to store the ID for updating the records on Salesforce. Is the entire ID a unique representation of the record? Is there a way to store a smaller part of the id and generate the rest to use it when updating the record through REST API.