The first system I built was in university where my database professor taught us to use AUTO INCREMENT fields or IDENTITY columns.  These columns made excellent identifiers, starting at a number and counting up with each new row 100, 101, 102… This technique worked well into my professional career and