Stop using Integer ID’s in your Database

The problem is that most companies don’t apply the required forethought to creating the right primary keys to allow data from different channels to be merged.

That brings us to this rule: Have only one copy of any given piece of data. Instead of copying data into two places on the system, instead link data from one part of the information system to the other.