3 ms·
Something like that should have a built in check "digit" if people are going to see it and possibly type it in. For numeric values, making them all a multiple
by phkahler 2y ago
Something like that should have a built in check "digit" if people are going to see it and possibly type it in.
For numeric values, making them all a multiple of 11 is a simple way to catch all single digit errors or single transpositions.
- chuckadams 2y agoThat's why VINs make a decent natural key, because they do have a check digit. Plus they're not opaque: if you look up the VIN and the make/model/year is completely different than the car in front of you, you know you either have the wrong VIN or the wrong car.