3 ms·
For one of our customers we integrate heavily with their ERP system. They had nice sub-10 million integers as order numbers, so we used that as primary key for
by magicalhippo 4y ago
For one of our customers we integrate heavily with their ERP system.
They had nice sub-10 million integers as order numbers, so we used that as primary key for the order table (and as fk for 10+ child tables). Last year they changed ERP system, and now order numbers are much longer and can contain dashes.
Not the worst change, as converting integer to varchar is lossless, but we had to go over all the views and our code to make sure it could handle it.